Connexion Shopify Partner pour LinkyFlow

LinkyFlow connecte Excel a Shopify Partner pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

120

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

API

API Versions

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

Lecture

API Versions

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

Route: GET /publicApiVersions

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-

Donnees retournees dans 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.

Lecture

Active Subscription

Route: GET /activeSubscription

Entrees configurables

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.

Donnees retournees dans 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.

Lecture

App

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

Route: GET /app

Entrees configurables

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

Donnees retournees dans 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.

Creation

Cancel Subscription

Route: POST /mutation/appSubscriptionCancel

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

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.

Lecture

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

Entrees configurables

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

Donnees retournees dans 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.

Lecture

Transaction

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

Route: GET /transaction

Entrees configurables

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

Donnees retournees dans 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.

Lecture

Transactions

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

Route: GET /transactions

Entrees configurables

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

Donnees retournees dans 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	—	-