shopifyGetOrders

ext. Version: GraphQL

Bestellungen abrufen

Retrieves orders. The retrieval of orders can be limited by specifying the statuses as well as the creation time and the update time of the orders.

Über Synesty Studio

Mit Synesty als No Code Middleware verbinden Sie Ihre Systeme, Schnittstellen und APIs ohne Programmierung per Drag&Drop. Automatisieren Sie Geschäftsprozesse und Integrationen wie EDI Datenimport / Export oder eine einmalige Daten-Migration.

Wir unterstützen Datenformate wie CSV, Excel (XLS/XLSX), XML oder JSON und ermöglichen auch HTTP-Konnektoren zu REST- oder GraphQL-APIs. Kunden nutzen es auch für Auswertungen, ETL-Aufgaben oder Feed-Optimierung.
Unser No Code Flow-Editor und unsere Low Code Scripting Tools ermöglichen kreative Anpassungen für jede Art von Integration.

Jetzt registrieren und zeitlich unbegrenzt testen

Über Synesty Studio

Jetzt registrieren und zeitlich unbegrenzt testen

Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	shopify Account	Ja
limit	STRING		Nein	Standardwert:
status	STRING	Filter orders by their status. Only orders in the selected status will be retrieved. This status can be combined with the other statuses.	Nein	any (Standardwert) open closed cancelled not_closed
financial_status	STRING	Filter orders by their financial status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses.	Nein	any (Standardwert) paid pending authorized partially paid partially refunded refunded voided expired
fulfillment_status	STRING	Filter orders by their fulfillment status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses.	Nein	any (Standardwert) unshipped shipped fulfilled partially shipped scheduled on_hold unfulfilled request_declined
return_status	STRING	Filter orders by their return status. Only orders in the selected return status will be retrieved. This status can be combined with the other statuses.	Nein	any (Standardwert) return requested return in progress return closed
ids	STRING	A comma-separated list of order ids	Nein	Standardwert:
sales_channel	STRING	Filter Shopify orders by sales channel.	Nein	Standardwert:
tag	STRING	Filter Shopify Orders by Tag.	Nein	Standardwert:
fulfillments	STRING	Additional: Calls the fulfillments of an order.	Nein	no (Standardwert) yes
created_at_from	DATETIME	Creation time of orders. All orders in the specified status that were created on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:
created_at_to	DATETIME	Creation time of orders. All orders in the specified status that were created until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:
updated_at_from	DATETIME	Update time of orders. All orders in the specified status that were updated on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:
updated_at_to	DATETIME	Update time of orders. All orders in the specified status that were updated until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:
processed_at_from	DATETIME	Processed time of orders. All orders in the specified status that were processsed on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:
processed_at_to	DATETIME	Processed time of orders. All orders in the specified status that were processsed until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status.	Nein	Standardwert:

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

Name

Datentyp

Beschreibung

Orders

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
identifier		Text
parent_identifier		Text
id		Text
name		Text
cancelledAt		Text
cancelReason		Text
closed		Text
confirmationNumber		Text
createdAt		Text
updatedAt		Text
currencyCode		Text
currentTotalWeight		Text
discountCodes		Text
displayFinancialStatus		Text
displayFulfillmentStatus		Text
email		Text
fulfillable		Text
fullyPaid		Text
note		Text
paymentGatewayNames		Text
processedAt		Text
tags		Text
totalPriceSet		Text
line_items_currentQuantity		Text
line_items_customAttributes		Text
line_items_discountAllocations		Text
line_items_id		Text
line_items_order_id		Text
line_items_name		Text
line_items_product		Text
line_items_quantity		Text
line_items_sku		Text
line_items_title		Text
line_items_variantTitle		Text
billing_address_firstName		Text
billing_address_lastName		Text
billing_address_name		Text
billing_address_address1		Text
billing_address_address2		Text
billing_address_city		Text
billing_address_country		Text
billing_address_company		Text
billing_address_phone		Text
billing_address_province		Text
billing_address_provinceCode		Text
billing_address_zip		Text
billing_address_countryCodeV2		Text
fulfillment_orders_channelId		Text
fulfillment_orders_createdAt		Text
fulfillment_orders_fulfillAt		Text
fulfillment_orders_fulfillBy		Text
fulfillment_orders_id		Text
fulfillment_orders_order_id		Text
shipping_address_firstName		Text
shipping_address_lastName		Text
shipping_address_name		Text
shipping_address_address1		Text
shipping_address_address2		Text
shipping_address_city		Text
shipping_address_country		Text
shipping_address_company		Text
shipping_address_phone		Text
shipping_address_province		Text
shipping_address_provinceCode		Text
shipping_address_zip		Text
shipping_address_countryCodeV2		Text

OrderHeaderData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
identifier		Text
id		Text
name		Text
cancelledAt		Text
cancelReason		Text
closed		Text
confirmationNumber		Text
createdAt		Text
updatedAt		Text
currencyCode		Text
currentTotalWeight		Text
discountCodes		Text
displayFinancialStatus		Text
displayFulfillmentStatus		Text
email		Text
fulfillable		Text
fullyPaid		Text
note		Text
paymentGatewayNames		Text
processedAt		Text
tags		Text
totalPriceSet		Text
billing_address_firstName		Text
billing_address_lastName		Text
billing_address_name		Text
billing_address_address1		Text
billing_address_address2		Text
billing_address_city		Text
billing_address_country		Text
billing_address_company		Text
billing_address_phone		Text
billing_address_province		Text
billing_address_provinceCode		Text
billing_address_zip		Text
billing_address_countryCodeV2		Text
fulfillment_orders_channelId		Text
fulfillment_orders_createdAt		Text
fulfillment_orders_fulfillAt		Text
fulfillment_orders_fulfillBy		Text
fulfillment_orders_id		Text
fulfillment_orders_order_id		Text
shipping_address_firstName		Text
shipping_address_lastName		Text
shipping_address_name		Text
shipping_address_address1		Text
shipping_address_address2		Text
shipping_address_city		Text
shipping_address_country		Text
shipping_address_company		Text
shipping_address_phone		Text
shipping_address_province		Text
shipping_address_provinceCode		Text
shipping_address_zip		Text
shipping_address_countryCodeV2		Text

OrderItemData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
identifier		Text
parent_identifier		Text
line_items_currentQuantity		Text
line_items_customAttributes		Text
line_items_discountAllocations		Text
line_items_id		Text
line_items_order_id		Text
line_items_name		Text
line_items_product		Text
line_items_quantity		Text
line_items_sku		Text
line_items_title		Text
line_items_variantTitle		Text

OrderFulfillments

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
identifier		Text
parent_identifier		Text
fulfillment_orders_id		Text
fulfillment_orders_order_id		Text
fulfillment_orders_channelId		Text
fulfillment_orders_createdAt		Text
fulfillment_orders_fulfillBy		Text
fulfillment_orders_fulfillAt		Text

Hilfe oder Projektsupport gewünscht?

Wenn Sie Unterstützung oder Beratung für Ihr Vorhaben benötigen, begleiten wir Sie mit gezielten Workshops und Trainings auf dem Weg zum erfolgreichen Einsatz von Synesty.
Weitere Informationen

shopifyGetOrders wird oft in Verbindung mit folgenden Steps verwendet:

Name	Version	Beschreibung	Anwendungsfall
Mapper Mapper	-	Wandelt ein Spreadsheet in ein anderes um.
ExcelWriter ExcelWriter	-	Kann ein SPREADSHEET in eine Excel-Datei schreiben.	Dateien hochladen
Filter Filter	-	Kann ein Spreadheet nach einem bestimmten Ausdruck in der Freemarker-Syntax filtern und gibt nur Zeilen zurück, die der Filterbedingung entsprechen. Es wird auch ein zweites SPREADSHEET ausgegeben, das das negative Ergebnis enthält (Zeilen, die nicht der Filterbedingung entsprechen).
StopFlowIf StopFlowIf	-	Stoppt den Flow, wenn eine Bedingung wahr (TRUE) ist.
shopifyGetProductsQL (ext. Version: GraphQL) shopifyGetProductsQL (ext. Version: GraphQL)	GraphQL	This is the actual step which will be published in your Add-On. Typically it will consist of Flow-Variables, steps for the execution logic and Output-Variables. The corresponding Test-Flow TestFlow-shopifyGetProductsQL will then use this step and see the input and outputs.	Produktdaten abrufen