LinkyFlow connection for LinkyFlow

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

Resources

Read requests

Write actions

Documented fields

184

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

Read

Current price sync

Route: GET /currentPriceSync

Inputs you can set

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

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

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

Inputs you can set

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
`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
`shopifyOrderName` default	string	—	-
`expectedAmount` default	string	—	-
`actualAmount` default	string	—	-
`currency` default	string	—	-
`feeAmount` default	string	—	-
`netAmount` default	string	—	-
`reconciliationStatus` 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

Inputs you can set

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

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

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

Inputs you can set

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

Open exceptions

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

Read

Open exceptions

Route: GET /openExceptions

Inputs you can set

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

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

Inputs you can set

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
`limit`	number	No	Rows per page (max 1000). Default: 100

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