Connexion LinkyFlow pour LinkyFlow

LinkyFlow ramene les donnees LinkyFlow dans Excel avec 8 workflows pour analyser les marches, suivre les wallets et preparer vos reportings sans changer d outil.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

313

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.

Agents

Current order lines

Every order line an Omnichannel Sales agent has seen, as it stands today: the channel and the order, the units it holds, whether the master already counted it, and what it moved the master by — one row per master SKU it moves. Changes after every run, every five minutes — refresh to see the latest state.

Lecture

Current order lines

Route: GET /currentOmnichannelSales

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`status`	enum	No	Only order lines in this status. Values: APPLIED, NOTHING_TO_APPLY, COUNTED_BY_MASTER, BASELINE, PENDING
`channelConnectionId`	string	No	Only one channel, by its connection id.
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`channelProvider` default	string	—	-
`orderReference` default	string	—	-
`sku` default	string	—	-
`committedQuantity` default	number	—	-
`omnichannelStatus` default	string	—	-
`reason` default	string	—	-
`explanation` default	string	—	-
`masterSku` default	string	—	-
`masterApplied` default	number	—	-

Current price sync

Where every SKU of a price sync stands today, per target store: the master price, what the target was priced, whether the two matched, differed, could not be matched or could not be compared, and whether the price was set. Changes after every hourly run — refresh to see the latest state.

Lecture

Current price sync

Route: GET /currentPriceSync

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`status`	enum	No	Only SKUs in this status. Values: SYNCED, OUT_OF_SYNC, UPDATED, WRITE_BLOCKED, WRITE_FAILED
`targetConnectionId`	string	No	Only one target store, by its connection id.
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`sku` default	string	—	-
`targetConnectionName` default	string	—	-
`masterPrice` default	string	—	-
`targetPriceBefore` default	string	—	-
`desiredPrice` default	string	—	-
`targetPriceAfter` default	string	—	-
`currency` default	string	—	-
`priceSyncStatus` default	string	—	-
`outcome` default	string	—	-
`reason` default	string	—	-
`explanation` default	string	—	-

Current reconciliations

Where every Shopify sale paid through Stripe stands today: the payment, the fee, the net, and whether it reconciled. Changes after every hourly run — refresh to see the latest state.

Lecture

Current reconciliations

Where every Shopify sale paid through Stripe stands today: the payment, the fee, the net, and whether it reconciled. Changes after every hourly run — refresh to see the latest state.

Route: GET /currentReconciliations

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`status`	enum	No	Only sales in this status. Values: RECONCILED, PENDING, NOT_FOUND, AMOUNT_MISMATCH, CURRENCY_MISMATCH
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`shopifyOrderName` default	string	—	-
`expectedAmount` default	string	—	-
`actualAmount` default	string	—	-
`currency` default	string	—	-
`feeAmount` default	string	—	-
`netAmount` default	string	—	-
`reconciliationStatus` default	string	—	-

Current Shopify finance rows

Every finance row a Shopify Finance Sync agent holds, as it stands today: orders, transactions, refunds, Shopify Payments payouts and movements, disputes — gross, tax, fee and net apart, in the currency the source states, with the ids that tie each to the others. A column the source does not state stays empty. Changes...

Lecture

Current Shopify finance rows

Route: GET /currentShopifyFinance

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`source`	enum	No	Only the rows of one source. Values: orders, orderTransactions, orderRefunds, shopifyPaymentsPayouts, shopifyPaymentsBalanceTransactions
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`source` default	string	—	-
`occurredAt` default	date	—	-
`kind` default	string	—	-
`status` default	string	—	-
`currency` default	string	—	-
`tax` default	string	—	-
`fee` default	string	—	-
`orderReference` default	string	—	-

Current stock sync

Where every SKU of a stock sync stands today, per target store: the master quantity, what the target held, what it should hold, and whether it was set. Changes after every hourly run — refresh to see the latest state.

Lecture

Current stock sync

Route: GET /currentInventorySync

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`status`	enum	No	Only SKUs in this status. Values: SYNCED, OUT_OF_SYNC, UPDATE_PROPOSED, UPDATED, WRITE_BLOCKED
`targetConnectionId`	string	No	Only one target store, by its connection id.
`targetLocationId`	string	No	With a target connection: only one of its locations, by the location id the target is configured with.
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`sku` default	string	—	-
`targetConnectionName` default	string	—	-
`masterQuantity` default	number	—	-
`targetQuantityBefore` default	number	—	-
`desiredQuantity` default	number	—	-
`targetQuantityAfter` default	number	—	-
`syncStatus` default	string	—	-
`reason` default	string	—	-
`explanation` default	string	—	-

Historical run detail

What LinkyFlow concluded during ONE run, row by row. Immutable: refreshing it a month later shows the same rows. Detailed run data is kept for 30 days; an older run answers no rows and says why.

Lecture

Historical run detail

What LinkyFlow concluded during ONE run, row by row. Immutable: refreshing it a month later shows the same rows. Detailed run data is kept for 30 days; an older run answers no rows and says why.

Route: GET /runDetails

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`runId`	string	Yes	The run to read — from the Runs dataset, or from Settings.
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`runId` default	string	—	-
`runType` default	string	—	-
`shopifyOrderName` default	string	—	-
`expectedAmount` default	string	—	-
`actualAmount` default	string	—	-
`currency` default	string	—	-
`feeAmount` default	string	—	-
`netAmount` default	string	—	-
`reconciliationStatus` default	string	—	-
`sku` default	string	—	-
`targetConnectionName` default	string	—	-
`masterQuantity` default	number	—	-
`targetQuantityBefore` default	number	—	-
`desiredQuantity` default	number	—	-
`targetQuantityAfter` default	number	—	-
`syncStatus` default	string	—	-
`reason` default	string	—	-
`explanation` default	string	—	-
`masterPrice` default	string	—	-
`targetPriceBefore` default	string	—	-
`desiredPrice` default	string	—	-
`targetPriceAfter` default	string	—	-
`priceSyncStatus` default	string	—	-
`outcome` default	string	—	-
`channelProvider` default	string	—	-
`orderReference` default	string	—	-
`committedQuantity` default	number	—	-
`omnichannelStatus` default	string	—	-
`masterSku` default	string	—	-
`masterDelta` default	number	—	-
`source` default	string	—	-
`occurredAt` default	date	—	-
`kind` default	string	—	-
`status` default	string	—	-
`tax` default	string	—	-
`fee` default	string	—	-

Open exceptions

The cases that need attention, of any agent: a sale that did not reconcile, a SKU a stock or price sync could not settle, or a master movement an Omnichannel Sales agent could not make. A case resolved by the next run disappears from this view when you refresh.

Lecture

Open exceptions

Route: GET /openExceptions

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`state`	enum	No	OPEN needs you; PENDING is a payment still in flight; RESOLVED closed itself. Default: OPEN Values: OPEN, PENDING, RESOLVED
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`state` default	string	—	-
`status` default	string	—	-
`shopifyOrderName` default	string	—	-
`expectedAmount` default	string	—	-
`actualAmount` default	string	—	-
`currency` default	string	—	-
`explanation` default	string	—	-
`sku` default	string	—	-
`targetConnectionName` default	string	—	-
`masterQuantity` default	number	—	-
`targetQuantityBefore` default	number	—	-
`desiredQuantity` default	number	—	-
`targetQuantityAfter` default	number	—	-
`reason` default	string	—	-
`outcome` default	string	—	-
`masterPrice` default	string	—	-
`targetPriceBefore` default	string	—	-
`desiredPrice` default	string	—	-
`targetPriceAfter` default	string	—	-
`orderReference` default	string	—	-
`masterDelta` default	number	—	-

Runs

One row per run, newest first: what it read, what it concluded, and what it cost in Stripe fees.

Lecture

Runs

One row per run, newest first: what it read, what it concluded, and what it cost in Stripe fees.

Route: GET /runs

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	Yes	Which agent — its id from the Agents page. The first agent of a type has the type's id. Values: shopify_stripe_reconciliation, inventory_stock_sync, price_sync, omnichannel_sales, shopify_finance_sync
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`runId` default	string	—	-
`startedAt` default	date	—	-
`runType` default	string	—	-
`status` default	string	—	-
`processed` default	number	—	-
`reconciled` default	number	—	-
`exceptions` default	number	—	-
`fees` default	string	—	-
`currency` default	string	—	-
`inSync` default	number	—	-
`outOfSync` default	number	—	-
`updated` default	number	—	-
`different` default	number	—	-
`notMatched` default	number	—	-
`linesApplied` default	number	—	-
`movementsApplied` default	number	—	-
`unitsApplied` default	number	—	-
`newRows` default	number	—	-
`changedRows` default	number	—	-
`sourceStatuses` default	string	—	-

← PrécédentConnexion HTX pour LinkyFlow Suivant →Connexion MEXC pour LinkyFlow