Connexion Shopify pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

73660

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.

B2B

Company

Companies data in Shopify.

Lecture

List Companies

Fetch companies from Shopify.

Route: GET /companies

Formule Excel: =LF.shopify.companies("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: CREATED_AT, ID, NAME, ORDER_COUNT, SINCE_DATE
`query.active_customers_count`	number	No	-

+9 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`contactCount` default	number	-
`contactRoles.nodes.id` default	id	-
`contactRoles.nodes.name` default	string	-
`contactRoles.nodes.note` default	string	-
`contacts.nodes.createdAt` default	date	-
`contacts.nodes.id` default	id	-
`contacts.nodes.isMainContact` default	boolean	-
`contacts.nodes.lifetimeDuration` default	string	-
`contacts.nodes.locale` default	string	-
`contacts.nodes.title` default	string	-

+196 champs supplementaires disponibles dans cette connexion

Company Location

Company Locations data in Shopify.

Lecture

List Company Locations

Fetch company locations from Shopify.

Route: GET /companyLocations

Formule Excel: =LF.shopify.companyLocations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: COMPANY_AND_LOCATION_NAME, COMPANY_ID, CREATED_AT, ID, NAME
`query.company_id`	id	No	-

+8 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`billingAddress.address1` default	string	-
`billingAddress.address2` default	string	-
`billingAddress.city` default	string	-
`billingAddress.companyName` default	string	-
`billingAddress.country` default	string	-
`billingAddress.countryCode` default	enum	-
`billingAddress.createdAt` default	date	-
`billingAddress.firstName` default	string	-
`billingAddress.formattedArea` default	string	-
`billingAddress.id` default	id	-

+229 champs supplementaires disponibles dans cette connexion

Catalog

Catalogs data in Shopify.

Lecture

List Catalogs

Fetch catalogs from Shopify.

Route: GET /catalogs

Formule Excel: =LF.shopify.catalogs("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`type`	enum	No	The type of the catalogs to be returned. Values: NONE, APP, COMPANY_LOCATION, MARKET
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, RELEVANCE, TITLE, TYPE

+9 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`apps.nodes.apiKey` default	string	-
`apps.nodes.appStoreAppUrl` default	string	-
`apps.nodes.appStoreDeveloperUrl` default	string	-
`apps.nodes.description` default	string	-
`apps.nodes.developerName` default	string	-
`apps.nodes.developerType` default	enum	-
`apps.nodes.developerUrl` default	string	-
`apps.nodes.embedded` default	boolean	-
`apps.nodes.features` default	string[]	-
`apps.nodes.handle` default	string	-

+29 champs supplementaires disponibles dans cette connexion

Modification

Delete Catalog

Delete an existing catalog in Shopify.

Route: DELETE /catalogs/{id}

Entrees configurables

Name	Type	Required	Description
`deleteDependentResources`	boolean	No	-
`id`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Collection

Collections data in Shopify.

Lecture

List Collections

Fetch collections from Shopify.

Route: GET /collections

Formule Excel: =LF.shopify.collections("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, RELEVANCE, TITLE, UPDATED_AT
`query.collection_type`	enum	No	Values: custom, smart

+11 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`availablePublicationsCount.count` default	number	-
`availablePublicationsCount.precision` default	enum	-
`descriptionHtml` default	string	-
`events.nodes.action` default	string	-
`events.nodes.additionalContent` default	string	-
`events.nodes.additionalData` default	string	-
`events.nodes.appTitle` default	string	-
`events.nodes.arguments` default	string	-
`events.nodes.attributeToApp` default	boolean	-
`events.nodes.attributeToUser` default	boolean	-

+111 champs supplementaires disponibles dans cette connexion

Creation

Create Collection

Create a new collection in Shopify.

Route: POST /collections

Entrees configurables

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+15 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Collection

Update an existing collection in Shopify.

Route: PATCH /collections/{id}

Entrees configurables

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+15 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Collection

Delete an existing collection in Shopify.

Route: DELETE /collections/{id}

Entrees configurables

Name	Type	Required	Description
`input.id`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Price List

Price Lists data in Shopify.

Lecture

List Price Lists

Fetch price lists from Shopify.

Route: GET /priceLists

Formule Excel: =LF.shopify.priceLists("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, NAME

Donnees retournees dans Excel

Field	Type	Description
`catalog.id` default	id	-
`catalog.status` default	enum	-
`catalog.title` default	string	-
`currency` default	enum	-
`fixedPricesCount` default	number	-
`id` default	id	-
`name` default	string	-
`prices.nodes.originType` default	enum	-
`quantityRules.nodes.increment` default	number	-
`quantityRules.nodes.isDefault` default	boolean	-

+3 champs supplementaires disponibles dans cette connexion

Creation

Create Price List

Create a new price list in Shopify.

Route: POST /priceLists

Entrees configurables

Name	Type	Required	Description
`input.catalogId`	string	No	-
`input.currency`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.name`	string	Yes	-
`input.parent.adjustment.type`	enum	Yes	Values: PERCENTAGE_DECREASE, PERCENTAGE_INCREASE
`input.parent.adjustment.value`	number	Yes	-
`input.parent.settings.compareAtMode`	enum	Yes	Values: ADJUSTED, NULLIFY

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Price List

Update an existing price list in Shopify.

Route: PATCH /priceLists/{id}

Entrees configurables

Name	Type	Required	Description
`id`	string	Yes	-
`input.catalogId`	string	No	-
`input.currency`	enum	No	Values: USD, EUR, GBP, CAD, AFN
`input.name`	string	No	-
`input.parent.adjustment.type`	enum	Yes	Values: PERCENTAGE_DECREASE, PERCENTAGE_INCREASE
`input.parent.adjustment.value`	number	Yes	-
`input.parent.settings.compareAtMode`	enum	Yes	Values: ADJUSTED, NULLIFY

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Price List

Delete an existing price list in Shopify.

Route: DELETE /priceLists/{id}

Entrees configurables

Name	Type	Required	Description
`id`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product

Products in Shopify catalog.

Lecture

List Products

Fetch products from Shopify.

Route: GET /products

Formule Excel: =LF.shopify.products("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, INVENTORY_TOTAL, PRODUCT_TYPE, PUBLISHED_AT
`query.barcode`	string	No	Filter by the product variant barcode field. Example:...

+36 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`availablePublicationsCount.count` default	number	-
`availablePublicationsCount.precision` default	enum	-
`bodyHtml` default	string	-
`bundleComponents.nodes.quantity` default	number	-
`bundleConsolidatedOptions.name` default	string	-
`category.ancestorIds` default	string[]	-
`category.childrenIds` default	string[]	-
`category.fullName` default	string	-
`category.id` default	id	-
`category.isArchived` default	boolean	-

+226 champs supplementaires disponibles dans cette connexion

Creation

Create Product

Create a new product in Shopify.

Route: POST /products

Entrees configurables

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.claimOwnership.bundles`	boolean	No	-
`product.collectionsToJoin`	string[]	No	-
`product.combinedListingRole`	enum	No	Values: PARENT, CHILD
`product.descriptionHtml`	string	No	-

+24 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Update an existing product in Shopify.

Route: PATCH /products/{id}

Entrees configurables

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.collectionsToJoin`	string[]	No	-
`product.collectionsToLeave`	string[]	No	-
`product.deleteConflictingConstrainedMetafields`	boolean	No	-
`product.descriptionHtml`	string	No	-

+18 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product

Delete an existing product in Shopify.

Route: DELETE /products/{id}

Entrees configurables

Name	Type	Required	Description
`input.id`	string	Yes	-
`synchronous`	boolean	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Option

Product Options data in Shopify.

Creation

Create Product Option

Create a new product option in Shopify.

Route: POST /productOptions

Entrees configurables

Name	Type	Required	Description
`options.linkedMetafield.key`	string	Yes	-
`options.linkedMetafield.namespace`	string	Yes	-
`options.linkedMetafield.values`	string[]	No	-
`options.name`	string	No	-
`options.position`	number	No	-
`options.values.linkedMetafieldValue`	string	No	-
`options.values.name`	string	No	-
`productId`	string	Yes	-

+1 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Set

Products managed through Shopify productSet mutation.

Creation

Create Product Set

Create a new product set in Shopify.

Route: POST /productSets

Entrees configurables

Name	Type	Required	Description
`identifier.customId.key`	string	Yes	-
`identifier.customId.namespace`	string	No	-
`identifier.customId.value`	string	Yes	-
`identifier.handle`	string	No	-
`identifier.id`	string	No	-
`input.category`	string	No	-
`input.claimOwnership.bundles`	boolean	No	-
`input.collections`	string[]	No	-

+81 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Variant

Product Variants data in Shopify.

Lecture

List Product Variants

Fetch product variants from Shopify.

Route: GET /productVariants

Formule Excel: =LF.shopify.productVariants("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: FULL_TITLE, ID, INVENTORY_LEVELS_AVAILABLE, INVENTORY_MANAGEMENT, INVENTORY_POLICY
`query.barcode`	string	No	Filter by the product variant barcode field. Example:...

+30 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`availableForSale` default	boolean	-
`barcode` default	string	-
`compareAtPrice` default	string	-
`createdAt` default	date	-
`deliveryProfile.activeMethodDefinitionsCount` default	number	-
`deliveryProfile.default` default	boolean	-
`deliveryProfile.id` default	id	-
`deliveryProfile.legacyMode` default	boolean	-
`deliveryProfile.locationsWithoutRatesCount` default	number	-
`deliveryProfile.name` default	string	-

+180 champs supplementaires disponibles dans cette connexion

Creation

Create Product Variant

Create a new product variant in Shopify.

Route: POST /productVariants

Entrees configurables

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`productId`	string	Yes	-
`strategy`	enum	No	Values: DEFAULT, REMOVE_STANDALONE_VARIANT, PRESERVE_STANDALONE_VARIANT
`variants.barcode`	string	No	-
`variants.compareAtPrice`	string	No	-
`variants.id`	string	No	-

+39 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Publication

Publications data in Shopify.

Lecture

List Publications

Fetch publications from Shopify.

Route: GET /publications

Formule Excel: =LF.shopify.publications("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`catalogType`	enum	No	Filter publications by catalog type. Values: NONE, APP, COMPANY_LOCATION, MARKET
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Donnees retournees dans Excel

Field	Type	Description
`app.apiKey` default	string	-
`app.appStoreAppUrl` default	string	-
`app.appStoreDeveloperUrl` default	string	-
`app.description` default	string	-
`app.developerName` default	string	-
`app.developerType` default	enum	-
`app.developerUrl` default	string	-
`app.embedded` default	boolean	-
`app.features` default	string[]	-
`app.handle` default	string	-

+97 champs supplementaires disponibles dans cette connexion

Selling Plan Group

Selling Plan Groups data in Shopify.

Lecture

List Selling Plan Groups

Fetch selling plan groups from Shopify.

Route: GET /sellingPlanGroups

Formule Excel: =LF.shopify.sellingPlanGroups("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, NAME, UPDATED_AT
`query.app_id`	enum	No	Default: CURRENT Values: CURRENT, ALL, * (numeric app ID)

+7 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`appId` default	string	-
`createdAt` default	date	-
`description` default	string	-
`id` default	id	-
`merchantCode` default	string	-
`name` default	string	-
`options` default	string[]	-
`position` default	number	-
`products.nodes.bodyHtml` default	string	-
`products.nodes.combinedListingRole` default	enum	-

+64 champs supplementaires disponibles dans cette connexion

Customers

Segment

Segments data in Shopify.

Lecture

List Segments

Fetch segments from Shopify.

Route: GET /segments

Formule Excel: =LF.shopify.segments("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: CREATION_DATE, ID, LAST_EDIT_DATE, RELEVANCE
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie

+2 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`creationDate` default	date	-
`id` default	id	-
`lastEditDate` default	date	-
`name` default	string	-
`query` default	string	-

Inventory

Inventory Item

Inventory Items data in Shopify.

Lecture

List Inventory Items

Fetch inventory items from Shopify.

Route: GET /inventoryItems

Formule Excel: =LF.shopify.inventoryItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`query.created_at`	date	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234

+2 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`countryCodeOfOrigin` default	enum	-
`countryHarmonizedSystemCodes.nodes.countryCode` default	enum	-
`countryHarmonizedSystemCodes.nodes.harmonizedSystemCode` default	string	-
`createdAt` default	date	-
`duplicateSkuCount` default	number	-
`harmonizedSystemCode` default	string	-
`id` default	id	-
`inventoryHistoryUrl` default	string	-
`inventoryLevel.canDeactivate` default	boolean	-
`inventoryLevel.createdAt` default	date	-

+60 champs supplementaires disponibles dans cette connexion

Location

Locations data in Shopify.

Lecture

List Locations

Fetch locations from Shopify.

Route: GET /locations

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, NAME, RELEVANCE
`query.active`	string	No	-

+16 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`activatable` default	boolean	-
`address.address1` default	string	-
`address.address2` default	string	-
`address.city` default	string	-
`address.country` default	string	-
`address.countryCode` default	string	-
`address.formatted` default	string[]	-
`address.latitude` default	number	-
`address.longitude` default	number	-
`address.phone` default	string	-

+80 champs supplementaires disponibles dans cette connexion

Logistics

Delivery Customization

Delivery Customizations data in Shopify.

Lecture

List Delivery Customizations

Fetch delivery customizations from Shopify.

Route: GET /deliveryCustomizations

Formule Excel: =LF.shopify.deliveryCustomizations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`query.enabled`	boolean	No	-
`query.function_id`	string	No	-

+1 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`enabled` default	boolean	-
`errorHistory.errorsFirstOccurredAt` default	date	-
`errorHistory.firstOccurredAt` default	date	-
`errorHistory.hasBeenSharedSinceLastError` default	boolean	-
`errorHistory.hasSharedRecentErrors` default	boolean	-
`functionId` default	string	-
`id` default	id	-
`metafield.compareDigest` default	string	-
`metafield.createdAt` default	date	-
`metafield.description` default	string	-

+38 champs supplementaires disponibles dans cette connexion

Delivery Profile

Delivery Profiles data in Shopify.

Lecture

List Delivery Profiles

Fetch delivery profiles from Shopify.

Route: GET /deliveryProfiles

Formule Excel: =LF.shopify.deliveryProfiles("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`merchantOwnedOnly`	boolean	No	If true, returns only delivery profiles that were created by the merchant.
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Donnees retournees dans Excel

Field	Type	Description
`activeMethodDefinitionsCount` default	number	-
`default` default	boolean	-
`id` default	id	-
`legacyMode` default	boolean	-
`locationsWithoutRatesCount` default	number	-
`name` default	string	-
`originLocationCount` default	number	-
`productVariantsCount.count` default	number	-
`productVariantsCount.precision` default	enum	-
`productVariantsCountV2.capped` default	boolean	-

+45 champs supplementaires disponibles dans cette connexion

Marketing

Marketing Activity

Marketing Activities data in Shopify.

Lecture

List Marketing Activities

Fetch marketing activities from Shopify.

Route: GET /marketingActivities

Formule Excel: =LF.shopify.marketingActivities("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`marketingActivityIds`	string[]	No	The list of marketing activity IDs to filter by.
`remoteIds`	string[]	No	The list of remote IDs associated with marketing activities to filter by.
`utm`	string	No	The UTM parameters associated with marketing activities to filter by.
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.

+14 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`activityListUrl` default	string	-
`adSpend.amount` default	number	-
`adSpend.currencyCode` default	enum	-
`app.apiKey` default	string	-
`app.appStoreAppUrl` default	string	-
`app.appStoreDeveloperUrl` default	string	-
`app.description` default	string	-
`app.developerName` default	string	-
`app.developerType` default	enum	-
`app.developerUrl` default	string	-

+63 champs supplementaires disponibles dans cette connexion

Markets

Market

Markets data in Shopify.

Lecture

List Markets

Fetch markets from Shopify.

Route: GET /markets

Formule Excel: =LF.shopify.markets("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`type`	enum	No	Filters markets by type. Values: NONE, REGION, LOCATION, COMPANY_LOCATION
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, MARKET_CONDITION_TYPES, MARKET_TYPE, NAME

+7 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`catalogs.nodes.id` default	id	-
`catalogs.nodes.status` default	enum	-
`catalogs.nodes.title` default	string	-
`catalogsCount.count` default	number	-
`catalogsCount.precision` default	enum	-
`conditions.conditionTypes` default	string	-
`currencySettings.localCurrencies` default	boolean	-
`currencySettings.roundingEnabled` default	boolean	-
`enabled` default	boolean	-
`handle` default	string	-

+49 champs supplementaires disponibles dans cette connexion

Sales

Draft Order

Draft Orders data in Shopify.

Lecture

List Draft Orders

Fetch draft orders from Shopify.

Route: GET /draftOrders

Formule Excel: =LF.shopify.draftOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CUSTOMER_NAME, ID, NUMBER, RELEVANCE, STATUS
`query.created_at`	date	No	-

+8 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`acceptAutomaticDiscounts` default	boolean	-
`allowDiscountCodesInCheckout` default	boolean	-
`allVariantPricesOverridden` default	boolean	-
`anyVariantPricesOverridden` default	boolean	-
`appliedDiscount.amount` default	string	-
`appliedDiscount.description` default	string	-
`appliedDiscount.title` default	string	-
`appliedDiscount.value` default	number	-
`appliedDiscount.valueType` default	enum	-
`billingAddress.address1` default	string	-

+298 champs supplementaires disponibles dans cette connexion

Modification

Update Draft Order

Update an existing draft order in Shopify.

Route: PATCH /draftOrders/{id}

Entrees configurables

Name	Type	Required	Description
`id`	string	Yes	-
`input.acceptAutomaticDiscounts`	boolean	No	-
`input.allowDiscountCodesInCheckout`	boolean	No	-
`input.appliedDiscount.amountWithCurrency.amount`	number	Yes	-
`input.appliedDiscount.amountWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.appliedDiscount.description`	string	No	-
`input.appliedDiscount.title`	string	No	-
`input.appliedDiscount.value`	number	Yes	-

+80 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Draft Order

Delete an existing draft order in Shopify.

Route: DELETE /draftOrders/{id}

Entrees configurables

Name	Type	Required	Description
`input.id`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Fulfillment Order

Fulfillment Orders data in Shopify.

Lecture

List Fulfillment Orders

Fetch fulfillment orders from Shopify.

Route: GET /fulfillmentOrders

Formule Excel: =LF.shopify.fulfillmentOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`includeClosed`	boolean	No	Whether to include closed fulfillment orders. Default: false
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, UPDATED_AT

+5 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`assignedLocation.address1` default	string	-
`assignedLocation.address2` default	string	-
`assignedLocation.city` default	string	-
`assignedLocation.countryCode` default	enum	-
`assignedLocation.name` default	string	-
`assignedLocation.phone` default	string	-
`assignedLocation.province` default	string	-
`assignedLocation.zip` default	string	-
`channelId` default	id	-
`createdAt` default	date	-

+147 champs supplementaires disponibles dans cette connexion

Manual Holds Fulfillment Order

Manual Holds Fulfillment Orders data in Shopify.

Lecture

List Manual Holds Fulfillment Orders

Fetch manual holds fulfillment orders from Shopify.

Route: GET /manualHoldsFulfillmentOrders

Formule Excel: =LF.shopify.manualHoldsFulfillmentOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`query`	string	No	The query conditions used to filter fulfillment orders. Only fulfillment orders corresponding to orders matching the query will be counted....
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Donnees retournees dans Excel

Field	Type	Description
`assignedLocation.address1` default	string	-
`assignedLocation.address2` default	string	-
`assignedLocation.city` default	string	-
`assignedLocation.countryCode` default	enum	-
`assignedLocation.name` default	string	-
`assignedLocation.phone` default	string	-
`assignedLocation.province` default	string	-
`assignedLocation.zip` default	string	-
`channelId` default	id	-
`createdAt` default	date	-

+147 champs supplementaires disponibles dans cette connexion

Order

Orders in Shopify checkout flow.

Lecture

List Orders

Fetch orders from Shopify.

Route: GET /orders

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, CURRENT_TOTAL_PRICE, CUSTOMER_NAME, DESTINATION, FINANCIAL_STATUS
`query.cart_token`	string	No	Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart t...

+41 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Field	Type	Description
`additionalFees.id` default	id	-
`additionalFees.name` default	string	-
`agreements.nodes.happenedAt` default	date	-
`agreements.nodes.id` default	id	-
`agreements.nodes.reason` default	enum	-
`alerts.content` default	string	-
`alerts.dismissibleHandle` default	string	-
`alerts.icon` default	enum	-
`alerts.severity` default	enum	-
`alerts.title` default	string	-

+491 champs supplementaires disponibles dans cette connexion

Modification

Update Order

Update an existing order in Shopify.

Route: PATCH /orders/{id}

Entrees configurables

Name	Type	Required	Description
`input.customAttributes.key`	string	Yes	-
`input.customAttributes.value`	string	Yes	-
`input.email`	string	No	-
`input.id`	string	Yes	-
`input.localizedFields.key`	enum	Yes	Values: TAX_CREDENTIAL_BR, SHIPPING_CREDENTIAL_BR, TAX_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CN
`input.localizedFields.value`	string	Yes	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+17 entrees supplementaires disponibles dans cette connexion

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Order

Delete an existing order in Shopify.

Route: DELETE /orders/{id}

Entrees configurables

Name	Type	Required	Description
`orderId`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.