Connexion LinkyFlow pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

141

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 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

Formule Excel: =LF.linkyflow.currentReconciliations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	No	Which agent — its id from the Agents page. The first agent of a type has the type's id. Default: shopify_stripe_reconciliation Values: shopify_stripe_reconciliation, inventory_stock_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
`actualAmount` default	string	—	-
`currency` default	string	—	-
`expectedAmount` default	string	—	-
`feeAmount` default	string	—	-
`netAmount` default	string	—	-
`reconciliationStatus` default	string	—	-
`shopifyOrderName` 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

Formule Excel: =LF.linkyflow.currentInventorySync("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	No	Which agent — its id from the Agents page. The first agent of a type has the type's id. Default: shopify_stripe_reconciliation Values: shopify_stripe_reconciliation, inventory_stock_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.
`limit`	number	No	Rows per page (max 1000). Default: 100

Donnees retournees dans Excel

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

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

Formule Excel: =LF.linkyflow.runDetails("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	No	Which agent — its id from the Agents page. The first agent of a type has the type's id. Default: shopify_stripe_reconciliation Values: shopify_stripe_reconciliation, inventory_stock_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
`actualAmount` default	string	—	-
`currency` default	string	—	-
`desiredQuantity` default	number	—	-
`expectedAmount` default	string	—	-
`explanation` default	string	—	-
`feeAmount` default	string	—	-
`masterQuantity` default	number	—	-
`netAmount` default	string	—	-
`reason` default	string	—	-
`reconciliationStatus` default	string	—	-
`runId` default	string	—	-
`runType` default	string	—	-
`shopifyOrderName` default	string	—	-
`sku` default	string	—	-
`syncStatus` default	string	—	-
`targetConnectionName` default	string	—	-
`targetQuantityAfter` default	number	—	-
`targetQuantityBefore` default	number	—	-

Open exceptions

The cases that need attention, of either agent: a sale that did not reconcile, or a SKU a stock sync could not settle. A case resolved by the next run disappears from this view when you refresh.

Lecture

Open exceptions

The cases that need attention, of either agent: a sale that did not reconcile, or a SKU a stock sync could not settle. A case resolved by the next run disappears from this view when you refresh.

Route: GET /openExceptions

Formule Excel: =LF.linkyflow.openExceptions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`agentId`	enum	No	Which agent — its id from the Agents page. The first agent of a type has the type's id. Default: shopify_stripe_reconciliation Values: shopify_stripe_reconciliation, inventory_stock_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
`actualAmount` default	string	—	-
`currency` default	string	—	-
`desiredQuantity` default	number	—	-
`expectedAmount` default	string	—	-
`explanation` default	string	—	-
`masterQuantity` default	number	—	-
`reason` default	string	—	-
`shopifyOrderName` default	string	—	-
`sku` default	string	—	-
`state` default	string	—	-
`status` default	string	—	-
`targetConnectionName` default	string	—	-
`targetQuantityAfter` default	number	—	-
`targetQuantityBefore` 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

Formule Excel: =LF.linkyflow.runs("selection", "fields")

Entrees configurables

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

Donnees retournees dans Excel

Field	Type	Relations	Description
`currency` default	string	—	-
`exceptions` default	number	—	-
`fees` default	string	—	-
`inSync` default	number	—	-
`outOfSync` default	number	—	-
`processed` default	number	—	-
`reconciled` default	number	—	-
`runId` default	string	—	-
`runType` default	string	—	-
`startedAt` default	date	—	-
`status` default	string	—	-
`updated` default	number	—	-