Square connection for LinkyFlow
LinkyFlow brings Square ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.
Resources
7
Read requests
7
Write actions
4
Documented fields
124
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.
Business
Locations
The places your business sells from: each has its own orders, payments and currency.
Used as filter by
Locations
The places your business sells from: each has its own orders, payments and currency.
Route: GET /locations
Excel formula: =LF.square.locations("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
business_name | string | — | - |
statusdefault | string | — | - |
type | string | — | - |
currencydefault | string | — | - |
countrydefault | 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.
Used as filter by
Catalog Items
The items of your catalogue. Their SKUs and prices are on their variations.
Route: GET /catalogItems
Excel formula: =LF.square.catalogItems("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
item_data | string | — | - |
namedefault | string | — | - |
description_plaintext | string | — | - |
product_typedefault | string | — | - |
is_archiveddefault | boolean | — | - |
is_taxable | boolean | — | - |
is_deleted | boolean | — | - |
present_at_all_locations | boolean | — | - |
version | number | — | - |
created_at | date | — | - |
updated_atdefault | date | — | - |
Update Item
Update Item
Route: PATCH /mutation/catalogItems
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Catalog Variations
The variations of your items: each SKU and its price.
Catalog Variations
The variations of your items: each SKU and its price.
Route: GET /catalogVariations
Excel formula: =LF.square.catalogVariations("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
item_variation_data | string | — | - |
item_iddefault | string | → catalogItems | - |
namedefault | string | — | - |
skudefault | 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_atdefault | date | — | - |
Update Variation
Update Variation
Route: PATCH /mutation/catalogVariations
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Stock
How many of each variation are in stock at each location. Only variations with a tracked count have a row.
Stock
How many of each variation are in stock at each location. Only variations with a tracked count have a row.
Route: GET /inventoryCounts
Excel formula: =LF.square.inventoryCounts("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
catalog_object_iddefault | string | — | - |
location_iddefault | string | → locations | - |
state | string | — | - |
quantitydefault | string | — | - |
calculated_atdefault | date | — | - |
Set Stock
Set Stock
Route: PATCH /mutation/inventoryCounts
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Sales
Orders
The orders of a location, latest updated first: their state, their totals and their lines.
Orders
The orders of a location, latest updated first: their state, their totals and their lines.
Route: GET /orders
Excel formula: =LF.square.orders("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
location_iddefault | string | → locations | - |
statedefault | string | — | - |
amountdefault | number | — | - |
currencydefault | string | — | - |
updated_atdefault | date | — | - |
Payments
The payments of your business: their amount, status, card and order.
Used as filter by
Payments
The payments of your business: their amount, status, card and order.
Route: GET /payments
Excel formula: =LF.square.payments("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
statusdefault | string | — | - |
source_typedefault | string | — | - |
amountdefault | number | — | - |
currencydefault | string | — | - |
created_atdefault | date | — | - |
Refunds
The refunds of your payments: their amount, status and payment.
Used as filter by
Refunds
The refunds of your payments: their amount, status and payment.
Route: GET /refunds
Excel formula: =LF.square.refunds("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
statusdefault | string | — | - |
amountdefault | number | — | - |
currencydefault | string | — | - |
payment_iddefault | string | → payments | - |
updated_atdefault | date | — | - |
Refund a Payment
Refund a Payment
Route: POST /mutation/refunds
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.