LinkyFlow connection for LinkyFlow

LinkyFlow brings LinkyFlow data into Excel with 5 workflows for market analysis, wallet monitoring, and reporting without switching tools.

Resources

Read requests

Write actions

Documented fields

141

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.

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.

Read

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

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

Inputs you can set

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

Data returned in 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.

Read

Current stock sync

Route: GET /currentInventorySync

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

Inputs you can set

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

Data returned in 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.

Read

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

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

Inputs you can set

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

Data returned in 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.

Read

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

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

Inputs you can set

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

Data returned in 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.

Read

Runs

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

Route: GET /runs

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

Inputs you can set

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

Data returned in 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	—	-