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

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

Orders · location_id

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

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

Catalog Variations

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

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.
`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	—	-
`is_deleted`	boolean	—	-
`present_at_all_locations`	boolean	—	-
`version`	number	—	-
`created_at`	date	—	-
`updated_at` default	date	—	-

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.

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