Shopify Partner connection for LinkyFlow

LinkyFlow brings Shopify Partner ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

120

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

API

API Versions

The versions of the Partner API Shopify publishes, and which it still supports.

Read

API Versions

The versions of the Partner API Shopify publishes, and which it still supports.

Route: GET /publicApiVersions

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-

Data returned in Excel

Field	Type	Relations	Description
`handle` default	id	—	-
`displayName` default	string	—	-
`supported` default	boolean	—	-

Apps

Active Subscription

The Shopify App Pricing subscription one shop holds on one of your public apps: its billing period and cycle, its items, its pending update. No row when it holds none. Needs the Manage apps permission.

Read

Active Subscription

Route: GET /activeSubscription

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`appId`	id	Yes	A public app, e.g. gid://shopify/App/1234.
`shopId`	id	Yes	The shop, e.g. gid://shopify/Shop/1234.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`id` default	id	—	-
`myshopifyDomain` default	string	—	-
`billingPeriod` default	string	—	-
`cancelAtEndOfCycle` default	boolean	—	-

App

One of your apps, by its ID. The Partner API lists none: you name it. Needs the Manage apps permission.

Read

App

One of your apps, by its ID. The Partner API lists none: you name it. Needs the Manage apps permission.

Route: GET /app

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	Yes	The app, e.g. gid://partners/App/1234. Answers one row, or none.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`apiKey`	string	—	-

Cancel Subscription

Cancels this shop’s subscription to your app — at the end of the billing cycle unless you say otherwise. It cannot be undone from LinkyFlow. Needs the View financials permission.

Create

Cancel Subscription

Route: POST /mutation/appSubscriptionCancel

Inputs you can set

Name	Type	Required	Description
`appId`	id	Yes	-
`deferCancellation`	boolean	No	-
`prorate`	boolean	No	-
`shopId`	id	Yes	-
`skipFinalUsageCharge`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Events

The timeline of your apps: installs and uninstalls, charges, earnings, subscription changes, credits. The last 30 days unless a window is named, 365 days at most. Needs the Manage apps permission.

Read

Events

The timeline of your apps: installs and uninstalls, charges, earnings, subscription changes, credits. The last 30 days unless a window is named, 365 days at most. Needs the Manage apps permission.

Route: GET /events

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`subjectId`	id	No	One app, e.g. gid://shopify/App/1234.
`subjectType`	enum	No	Apps unless stated. Shopify’s guide says only APP is supported today. Values: APP, THEME
`shopId`	id	No	One shop, e.g. gid://shopify/Shop/1234. Requires an app.
`eventTypes`	enum	No	The events to read — empty means all. Values: CHARGE_ONE_TIME, CHARGE_RECURRING, CHARGE_USAGE, CREDIT_APPLIED, CREDIT_FAILED
`occurredAtMin`	date	No	On or after this time.
`occurredAtMax`	date	No	On or before this time.
`orderBy`	enum	No	Newest first unless stated. Default: OCCURRED_AT_DESC Values: OCCURRED_AT_ASC, OCCURRED_AT_DESC
`first`	number	No	Rows per page, from the start (max 100) Default: 100
`after`	string	No	The cursor of the row this page follows
`last`	number	No	Rows per page, from the end (max 100)
`before`	string	No	The cursor of the row this page precedes

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`occurredAt` default	date	—	-
`eventType` default	string	—	-
`subject`	string	—	-
`id`	id	—	-
`name` default	string	—	-
`shop`	string	—	-
`id`	id	—	-
`myshopifyDomain` default	string	—	-
`name`	string	—	-
`state`	string	—	-
`reason`	string	—	-
`reasonDescription`	string	—	-
`cancelEffectiveOn`	date	—	-
`plan`	string	—	-
`handle`	string	—	-
`billingPeriod`	string	—	-
`chargeId`	string	—	-
`chargeType`	string	—	-
`planHandle`	string	—	-
`usageQuantity`	string	—	-
`balanceUsed`	number	—	-
`amount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`earningType`	string	—	-
`grossAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`netAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`shopifyFee`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`settlementDate`	date	—	-
`status`	string	—	-
`money`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`description`	string	—	-

Earnings

Transaction

One Partner transaction, by its ID. Needs the View financials permission.

Read

Transaction

One Partner transaction, by its ID. Needs the View financials permission.

Route: GET /transaction

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	Yes	The transaction, e.g. gid://partners/ThemeSale/1234. Answers one row, or none.

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`type` default	string	—	-
`createdAt` default	date	—	-
`app`	string	—	-
`id`	id	—	-
`name` default	string	—	-
`shop`	string	—	-
`id`	id	—	-
`myshopifyDomain` default	string	—	-
`name`	string	—	-
`grossAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`netAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`shopifyFee`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`amount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`chargeId`	string	—	-
`billingInterval`	string	—	-
`category`	string	—	-
`theme`	string	—	-
`name`	string	—	-

Transactions

What impacts your Partner earnings: app, service and theme sales, their adjustments, referrals, taxes. Needs the View financials permission.

Read

Transactions

What impacts your Partner earnings: app, service and theme sales, their adjustments, referrals, taxes. Needs the View financials permission.

Route: GET /transactions

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`appId`	id	No	One app, e.g. gid://partners/App/1234.
`shopId`	id	No	One shop, e.g. gid://partners/Shop/1234.
`myshopifyDomain`	string	No	One shop by its domain, e.g. example.myshopify.com.
`types`	enum	No	The kinds of transaction to read — empty means all. Values: APP_ONE_TIME_SALE, APP_SALE_ADJUSTMENT, APP_SALE_CREDIT, APP_SUBSCRIPTION_SALE, APP_USAGE_SALE
`createdAtMin`	date	No	On or after this time.
`createdAtMax`	date	No	On or before this time.
`first`	number	No	Rows per page, from the start (max 100) Default: 100
`after`	string	No	The cursor of the row this page follows
`last`	number	No	Rows per page, from the end (max 100)
`before`	string	No	The cursor of the row this page precedes

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`type` default	string	—	-
`createdAt` default	date	—	-
`app`	string	—	-
`id`	id	—	-
`name` default	string	—	-
`shop`	string	—	-
`id`	id	—	-
`myshopifyDomain` default	string	—	-
`name`	string	—	-
`grossAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`netAmount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`shopifyFee`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`amount`	string	—	-
`amount`	number	—	-
`currencyCode`	string	—	-
`chargeId`	string	—	-
`billingInterval`	string	—	-
`category`	string	—	-
`theme`	string	—	-
`name`	string	—	-