Connexion Square pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

124

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.

Business

Locations

The places your business sells from: each has its own orders, payments and currency.

Utilise comme filtre par

Stock · location_id

Locations · id

Orders · location_id

Payments · location_id

Refunds · location_id

Lecture

Locations

The places your business sells from: each has its own orders, payments and currency.

Route: GET /locations

Formule Excel: =LF.square.locations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`business_name`	string	—	-
`status` default	string	—	-
`type`	string	—	-
`currency` default	string	—	-
`country` default	string	—	-
`timezone`	string	—	-
`language_code`	string	—	-
`address`	string	—	-
`locality`	string	—	-
`postal_code`	string	—	-
`merchant_id`	string	—	-
`created_at`	date	—	-

Catalog

Catalog Items

The items of your catalogue. Their SKUs and prices are on their variations.

Utilise comme filtre par

Catalog Items · id

Lecture

Catalog Items

The items of your catalogue. Their SKUs and prices are on their variations.

Route: GET /catalogItems

Formule Excel: =LF.square.catalogItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`item_data`	string	—	-
`name` default	string	—	-
`description_plaintext`	string	—	-
`product_type` default	string	—	-
`is_archived` default	boolean	—	-
`is_taxable`	boolean	—	-
`is_deleted`	boolean	—	-
`present_at_all_locations`	boolean	—	-
`version`	number	—	-
`created_at`	date	—	-
`updated_at` default	date	—	-

Modification

Update Item

Route: PATCH /mutation/catalogItems

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`item_data.is_archived`	boolean	No	-
`item_data.is_taxable`	boolean	No	-
`item_data.name`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Catalog Variations

The variations of your items: each SKU and its price.

Utilise comme filtre par

Catalog Variations · id

Catalog Variations · sku

Stock · catalog_object_id

Lecture

Catalog Variations

The variations of your items: each SKU and its price.

Route: GET /catalogVariations

Formule Excel: =LF.square.catalogVariations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`sku`	string	No	Only the variations of this whole SKU. Square ignores case here: mug-1 finds MUG-1.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`item_variation_data`	string	—	-
`item_id` default	string	→ catalogItems	-
`name` default	string	—	-
`sku` default	string	—	-
`upc`	string	—	-
`pricing_type`	string	—	-
`price_money`	string	—	-
`sellable`	boolean	—	-
`stockable`	boolean	—	-
`track_inventory`	boolean	—	-
`location_overrides`	string	—	-
`is_deleted`	boolean	—	-
`present_at_all_locations`	boolean	—	-
`present_at_location_ids`	string	—	-
`absent_at_location_ids`	string	—	-
`version`	number	—	-
`created_at`	date	—	-
`updated_at` default	date	—	-

Modification

Update Variation

Route: PATCH /mutation/catalogVariations

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`item_variation_data.name`	string	No	-
`item_variation_data.price_money.amount`	number	No	-
`item_variation_data.price_money.currency`	string	No	-
`item_variation_data.sku`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Stock

How many of each variation are in stock at each location. Only variations with a tracked count have a row.

Lecture

Stock

How many of each variation are in stock at each location. Only variations with a tracked count have a row.

Route: GET /inventoryCounts

Formule Excel: =LF.square.inventoryCounts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`catalog_object_id`	id	No	Only the stock of these variations, their ids separated by commas.
`location_id`	id	No	Only the records of this location.
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`catalog_object_id` default	string	—	-
`location_id` default	string	→ locations	-
`state`	string	—	-
`quantity` default	string	—	-
`calculated_at` default	date	—	-

Modification

Set Stock

Route: PATCH /mutation/inventoryCounts

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`quantity`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Orders

The orders of a location, latest updated first: their state, their totals and their lines.

Lecture

Orders

The orders of a location, latest updated first: their state, their totals and their lines.

Route: GET /orders

Formule Excel: =LF.square.orders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`location_id`	id	Yes	The location whose records are read.
`state`	enum	No	Only the orders in this state. Values: OPEN, COMPLETED, CANCELED, DRAFT
`updated_from`	string	No	Updated at or after this moment (RFC 3339, 2026-01-31T00:00:00Z).
`updated_to`	string	No	Updated before this moment (RFC 3339, 2026-01-31T00:00:00Z).
`sort_order`	enum	No	Oldest first, or latest first. Values: ASC, DESC
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`location_id` default	string	→ locations	-
`state` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`updated_at` default	date	—	-

Payments

The payments of your business: their amount, status, card and order.

Utilise comme filtre par

Payments · id

Lecture

Payments

The payments of your business: their amount, status, card and order.

Route: GET /payments

Formule Excel: =LF.square.payments("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`location_id`	id	No	Only the records of this location.
`begin_time`	string	No	Created at or after this moment; a year ago when empty (RFC 3339, 2026-01-31T00:00:00Z).
`end_time`	string	No	Created before this moment; now when empty (RFC 3339, 2026-01-31T00:00:00Z).
`sort_order`	enum	No	Oldest first, or latest first. Values: ASC, DESC
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	string	—	-
`source_type` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`created_at` default	date	—	-

Refunds

The refunds of your payments: their amount, status and payment.

Utilise comme filtre par

Refunds · id

Lecture

Refunds

The refunds of your payments: their amount, status and payment.

Route: GET /refunds

Formule Excel: =LF.square.refunds("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. An unknown id is Square’s refusal.
`location_id`	id	No	Only the records of this location.
`begin_time`	string	No	Created at or after this moment; a year ago when empty (RFC 3339, 2026-01-31T00:00:00Z).
`end_time`	string	No	Created before this moment; now when empty (RFC 3339, 2026-01-31T00:00:00Z).
`sort_order`	enum	No	Oldest first, or latest first. Values: ASC, DESC
`limit`	number	No	Rows per page (max 100). Default: 100
`cursor`	string	No	The cursor the previous page answered. It lives 5 minutes: after that, start the list again.

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`payment_id` default	string	→ payments	-
`updated_at` default	date	—	-

Creation

Refund a Payment

Route: POST /mutation/refunds

Entrees configurables

Name	Type	Required	Description
`amount_money.amount`	number	Yes	-
`amount_money.currency`	string	Yes	-
`payment_id`	id	Yes	-
`reason`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

← PrécédentConfiguration de la connexion Square Suivant →LinkyFlow pour Wix