This step receives all your Billbee order data.
Das sind die Optionen, mit denen man den Step konfigurieren kann.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
account | ACCOUNT | billbee account data | Nein | |
orderID | STRING | The internal billbee id of the order. | Nein | |
minOrderDate | DATETIME | Specifies the oldest order date to include in the response. | Nein | |
maxOrderDate | DATETIME | Specifies the newest order date to include in the response | Nein | |
shopId | STRING | Specifies a comma separated list of shop ids for which invoices should be included | Nein | |
orderStateId | STRING | Specifies a comma separated list of state ids to include in the response | Nein | |
tag | STRING | Specifies a comma separated list of filtered orders to include in the response | Nein | |
minimumBillBeeOrderId | STRING | If given, all delivered orders have an Id greater than or equal to the given minimumOrderId | Nein | |
modifiedAtMin | DATETIME | If given, the last modification has to be newer than the given date | Nein | |
modifiedAtMax | DATETIME | If given, the last modification has to be older or equal than the given date. | Nein | |
Outputs
Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
OrderData | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | parent_identifier | SINGLE | | Nein | | BillBeeOrderId | SINGLE | | Nein | | BillBeeParentOrderId | SINGLE | | Nein | | OrderNumber | SINGLE | | Nein | | Id | SINGLE | | Nein | | RebateDifference | SINGLE | | Nein | | ShippingIds | SINGLE | | Nein | | AcceptLossOfReturnRight | SINGLE | | Nein | | State | SINGLE | | Nein | | VatMode | SINGLE | | Nein | | CreatedAt | SINGLE | | Nein | | ShippedAt | SINGLE | | Nein | | ConfirmedAt | SINGLE | | Nein | | PayedAt | SINGLE | | Nein | | SellerComment | SINGLE | | Nein | | Comments | SINGLE | | Nein | | InvoiceNumberPrefix | SINGLE | | Nein | | InvoiceNumberPostfix | SINGLE | | Nein | | InvoiceNumber | SINGLE | | Nein | | InvoiceDate | SINGLE | | Nein | | PaymentMethod | SINGLE | | Nein | | ShippingCost | SINGLE | | Nein | | TotalCost | SINGLE | | Nein | | AdjustmentCost | SINGLE | | Nein | | AdjustmentReason | SINGLE | | Nein | | Currency | SINGLE | | Nein | | Buyer | SINGLE | | Nein | | UpdatedAt | SINGLE | | Nein | | TaxRate1 | SINGLE | | Nein | | TaxRate2 | SINGLE | | Nein | | VatId | SINGLE | | Nein | | Tags | SINGLE | | Nein | | ShipWeightKg | SINGLE | | Nein | | LanguageCode | SINGLE | | Nein | | PaidAmount | SINGLE | | Nein | | ShippingProfileId | SINGLE | | Nein | | ShippingProviderId | SINGLE | | Nein | | ShippingProviderProductId | SINGLE | | Nein | | ShippingProviderName | SINGLE | | Nein | | ShippingProviderProductName | SINGLE | | Nein | | ShippingProfileName | SINGLE | | Nein | | PaymentInstruction | SINGLE | | Nein | | IsCancelationFor | SINGLE | | Nein | | PaymentTransactionId | SINGLE | | Nein | | DistributionCenter | SINGLE | | Nein | | DeliverySourceCountryCode | SINGLE | | Nein | | CustomInvoiceNote | SINGLE | | Nein | | CustomerNumber | SINGLE | | Nein | | PaymentReference | SINGLE | | Nein | | ShippingServices | SINGLE | | Nein | | Payments | SINGLE | | Nein | | LastModifiedAt | SINGLE | | Nein | | ApiAccountId | SINGLE | | Nein | | ApiAccountName | SINGLE | | Nein | | MerchantVatId | SINGLE | | Nein | | CustomerVatId | SINGLE | | Nein | | IsFromBillbeeApi | SINGLE | | Nein | | InvoiceAddress_BillbeeId | SINGLE | | Nein | | InvoiceAddress_FirstName | SINGLE | | Nein | | InvoiceAddress_LastName | SINGLE | | Nein | | InvoiceAddress_Company | SINGLE | | Nein | | InvoiceAddress_NameAddition | SINGLE | | Nein | | InvoiceAddress_Street | SINGLE | | Nein | | InvoiceAddress_HouseNumber | SINGLE | | Nein | | InvoiceAddress_Zip | SINGLE | | Nein | | InvoiceAddress_City | SINGLE | | Nein | | InvoiceAddress_CountryISO2 | SINGLE | | Nein | | InvoiceAddress_Country | SINGLE | | Nein | | InvoiceAddress_Line2 | SINGLE | | Nein | | InvoiceAddress_Email | SINGLE | | Nein | | InvoiceAddress_State | SINGLE | | Nein | | InvoiceAddress_Phone | SINGLE | | Nein | | ShippingAddress_BillbeeId | SINGLE | | Nein | | ShippingAddress_FirstName | SINGLE | | Nein | | ShippingAddress_LastName | SINGLE | | Nein | | ShippingAddress_Company | SINGLE | | Nein | | ShippingAddress_NameAddition | SINGLE | | Nein | | ShippingAddress_Street | SINGLE | | Nein | | ShippingAddress_HouseNumber | SINGLE | | Nein | | ShippingAddress_Zip | SINGLE | | Nein | | ShippingAddress_City | SINGLE | | Nein | | ShippingAddress_CountryISO2 | SINGLE | | Nein | | ShippingAddress_Country | SINGLE | | Nein | | ShippingAddress_Line2 | SINGLE | | Nein | | ShippingAddress_Email | SINGLE | | Nein | | ShippingAddress_State | SINGLE | | Nein | | ShippingAddress_Phone | SINGLE | | Nein | | Seller_Platform | SINGLE | | Nein | | Seller_BillbeeShopName | SINGLE | | Nein | | Seller_BillbeeShopId | SINGLE | | Nein | | Seller_Id | SINGLE | | Nein | | Seller_Nick | SINGLE | | Nein | | Seller_FirstName | SINGLE | | Nein | | Seller_LastName | SINGLE | | Nein | | Seller_FullName | SINGLE | | Nein | | Seller_Email | SINGLE | | Nein | | Customer_Id | SINGLE | | Nein | | Customer_Name | SINGLE | | Nein | | Customer_Email | SINGLE | | Nein | | Customer_Tel1 | SINGLE | | Nein | | Customer_Tel2 | SINGLE | | Nein | | Customer_Number | SINGLE | | Nein | | Customer_PriceGroupId | SINGLE | | Nein | | Customer_LanguageId | SINGLE | | Nein | | Customer_DefaultMailAddress | SINGLE | | Nein | | Customer_DefaultCommercialMailAddress | SINGLE | | Nein | | Customer_DefaultStatusUpdatesMailAddress | SINGLE | | Nein | | Customer_DefaultPhone1 | SINGLE | | Nein | | Customer_DefaultPhone2 | SINGLE | | Nein | | Customer_DefaultFax | SINGLE | | Nein | | Customer_VatId | SINGLE | | Nein | | Customer_Type | SINGLE | | Nein | | Customer_MetaData | SINGLE | | Nein | | History_Created | SINGLE | | Nein | | History_EventTypeName | SINGLE | | Nein | | History_Text | SINGLE | | Nein | | History_EmployeeName | SINGLE | | Nein | | History_TypeId | SINGLE | | Nein | | OrderItems_BillBeeOrderId | SINGLE | | Nein | | OrderItems_BillbeeId | SINGLE | | Nein | | OrderItems_TransactionId | SINGLE | | Nein | | OrderItems_Quantity | SINGLE | | Nein | | OrderItems_TotalPrice | SINGLE | | Nein | | OrderItems_TaxAmount | SINGLE | | Nein | | OrderItems_TaxIndex | SINGLE | | Nein | | OrderItems_Discount | SINGLE | | Nein | | OrderItems_Attributes | SINGLE | | Nein | | OrderItems_GetPriceFromArticleIfAny | SINGLE | | Nein | | OrderItems_IsCoupon | SINGLE | | Nein | | OrderItems_ShippingProfileId | SINGLE | | Nein | | OrderItems_DontAdjustStock | SINGLE | | Nein | | OrderItems_UnrebatedTotalPrice | SINGLE | | Nein | | OrderItems_SerialNumber | SINGLE | | Nein | | OrderItems_InvoiceSKU | SINGLE | | Nein | | OrderItems_Product_OldId | SINGLE | | Nein | | OrderItems_Product_Id | SINGLE | | Nein | | OrderItems_Product_Title | SINGLE | | Nein | | OrderItems_Product_Weight | SINGLE | | Nein | | OrderItems_Product_SKU | SINGLE | | Nein | | OrderItems_Product_SkuOrId | SINGLE | | Nein | | OrderItems_Product_IsDigital | SINGLE | | Nein | | OrderItems_Product_Images | SINGLE | | Nein | | OrderItems_Product_EAN | SINGLE | | Nein | | OrderItems_Product_PlatformData | SINGLE | | Nein | | OrderItems_Product_TARICCode | SINGLE | | Nein | | OrderItems_Product_CountryOfOrigin | SINGLE | | Nein | | OrderItems_Product_BillbeeId | SINGLE | | Nein | | |
OrderHead | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | BillBeeOrderId | SINGLE | | Nein | | BillBeeParentOrderId | SINGLE | | Nein | | OrderNumber | SINGLE | | Nein | | Id | SINGLE | | Nein | | RebateDifference | SINGLE | | Nein | | ShippingIds | SINGLE | | Nein | | AcceptLossOfReturnRight | SINGLE | | Nein | | State | SINGLE | | Nein | | VatMode | SINGLE | | Nein | | CreatedAt | SINGLE | | Nein | | ShippedAt | SINGLE | | Nein | | ConfirmedAt | SINGLE | | Nein | | PayedAt | SINGLE | | Nein | | SellerComment | SINGLE | | Nein | | Comments | SINGLE | | Nein | | InvoiceNumberPrefix | SINGLE | | Nein | | InvoiceNumberPostfix | SINGLE | | Nein | | InvoiceNumber | SINGLE | | Nein | | InvoiceDate | SINGLE | | Nein | | PaymentMethod | SINGLE | | Nein | | ShippingCost | SINGLE | | Nein | | TotalCost | SINGLE | | Nein | | AdjustmentCost | SINGLE | | Nein | | AdjustmentReason | SINGLE | | Nein | | Currency | SINGLE | | Nein | | Buyer | SINGLE | | Nein | | UpdatedAt | SINGLE | | Nein | | TaxRate1 | SINGLE | | Nein | | TaxRate2 | SINGLE | | Nein | | VatId | SINGLE | | Nein | | Tags | SINGLE | | Nein | | ShipWeightKg | SINGLE | | Nein | | LanguageCode | SINGLE | | Nein | | PaidAmount | SINGLE | | Nein | | ShippingProfileId | SINGLE | | Nein | | ShippingProviderId | SINGLE | | Nein | | ShippingProviderProductId | SINGLE | | Nein | | ShippingProviderName | SINGLE | | Nein | | ShippingProviderProductName | SINGLE | | Nein | | ShippingProfileName | SINGLE | | Nein | | PaymentInstruction | SINGLE | | Nein | | IsCancelationFor | SINGLE | | Nein | | PaymentTransactionId | SINGLE | | Nein | | DistributionCenter | SINGLE | | Nein | | DeliverySourceCountryCode | SINGLE | | Nein | | CustomInvoiceNote | SINGLE | | Nein | | CustomerNumber | SINGLE | | Nein | | PaymentReference | SINGLE | | Nein | | ShippingServices | SINGLE | | Nein | | Payments | SINGLE | | Nein | | LastModifiedAt | SINGLE | | Nein | | ApiAccountId | SINGLE | | Nein | | ApiAccountName | SINGLE | | Nein | | MerchantVatId | SINGLE | | Nein | | CustomerVatId | SINGLE | | Nein | | IsFromBillbeeApi | SINGLE | | Nein | | InvoiceAddress_BillbeeId | SINGLE | | Nein | | InvoiceAddress_FirstName | SINGLE | | Nein | | InvoiceAddress_LastName | SINGLE | | Nein | | InvoiceAddress_Company | SINGLE | | Nein | | InvoiceAddress_NameAddition | SINGLE | | Nein | | InvoiceAddress_Street | SINGLE | | Nein | | InvoiceAddress_HouseNumber | SINGLE | | Nein | | InvoiceAddress_Zip | SINGLE | | Nein | | InvoiceAddress_City | SINGLE | | Nein | | InvoiceAddress_CountryISO2 | SINGLE | | Nein | | InvoiceAddress_Country | SINGLE | | Nein | | InvoiceAddress_Line2 | SINGLE | | Nein | | InvoiceAddress_Email | SINGLE | | Nein | | InvoiceAddress_State | SINGLE | | Nein | | InvoiceAddress_Phone | SINGLE | | Nein | | ShippingAddress_BillbeeId | SINGLE | | Nein | | ShippingAddress_FirstName | SINGLE | | Nein | | ShippingAddress_LastName | SINGLE | | Nein | | ShippingAddress_Company | SINGLE | | Nein | | ShippingAddress_NameAddition | SINGLE | | Nein | | ShippingAddress_Street | SINGLE | | Nein | | ShippingAddress_HouseNumber | SINGLE | | Nein | | ShippingAddress_Zip | SINGLE | | Nein | | ShippingAddress_City | SINGLE | | Nein | | ShippingAddress_CountryISO2 | SINGLE | | Nein | | ShippingAddress_Country | SINGLE | | Nein | | ShippingAddress_Line2 | SINGLE | | Nein | | ShippingAddress_Email | SINGLE | | Nein | | ShippingAddress_State | SINGLE | | Nein | | ShippingAddress_Phone | SINGLE | | Nein | | Seller_Platform | SINGLE | | Nein | | Seller_BillbeeShopName | SINGLE | | Nein | | Seller_BillbeeShopId | SINGLE | | Nein | | Seller_Id | SINGLE | | Nein | | Seller_Nick | SINGLE | | Nein | | Seller_FirstName | SINGLE | | Nein | | Seller_LastName | SINGLE | | Nein | | Seller_FullName | SINGLE | | Nein | | Seller_Email | SINGLE | | Nein | | Customer_Id | SINGLE | | Nein | | Customer_Name | SINGLE | | Nein | | Customer_Email | SINGLE | | Nein | | Customer_Tel1 | SINGLE | | Nein | | Customer_Tel2 | SINGLE | | Nein | | Customer_Number | SINGLE | | Nein | | Customer_PriceGroupId | SINGLE | | Nein | | Customer_LanguageId | SINGLE | | Nein | | Customer_DefaultMailAddress | SINGLE | | Nein | | Customer_DefaultCommercialMailAddress | SINGLE | | Nein | | Customer_DefaultStatusUpdatesMailAddress | SINGLE | | Nein | | Customer_DefaultPhone1 | SINGLE | | Nein | | Customer_DefaultPhone2 | SINGLE | | Nein | | Customer_DefaultFax | SINGLE | | Nein | | Customer_VatId | SINGLE | | Nein | | Customer_Type | SINGLE | | Nein | | Customer_MetaData | SINGLE | | Nein | | History_Created | SINGLE | | Nein | | History_EventTypeName | SINGLE | | Nein | | History_Text | SINGLE | | Nein | | History_EmployeeName | SINGLE | | Nein | | History_TypeId | SINGLE | | Nein | | |
OrderItems | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | OrderItems_BillBeeOrderId | SINGLE | | Nein | | OrderItems_BillbeeId | SINGLE | | Nein | | OrderItems_TransactionId | SINGLE | | Nein | | OrderItems_Quantity | SINGLE | | Nein | | OrderItems_TotalPrice | SINGLE | | Nein | | OrderItems_TaxAmount | SINGLE | | Nein | | OrderItems_TaxIndex | SINGLE | | Nein | | OrderItems_Discount | SINGLE | | Nein | | OrderItems_Attributes | SINGLE | | Nein | | OrderItems_GetPriceFromArticleIfAny | SINGLE | | Nein | | OrderItems_IsCoupon | SINGLE | | Nein | | OrderItems_ShippingProfileId | SINGLE | | Nein | | OrderItems_DontAdjustStock | SINGLE | | Nein | | OrderItems_UnrebatedTotalPrice | SINGLE | | Nein | | OrderItems_SerialNumber | SINGLE | | Nein | | OrderItems_InvoiceSKU | SINGLE | | Nein | | OrderItems_Product_OldId | SINGLE | | Nein | | OrderItems_Product_Id | SINGLE | | Nein | | OrderItems_Product_Title | SINGLE | | Nein | | OrderItems_Product_Weight | SINGLE | | Nein | | OrderItems_Product_SKU | SINGLE | | Nein | | OrderItems_Product_SkuOrId | SINGLE | | Nein | | OrderItems_Product_IsDigital | SINGLE | | Nein | | OrderItems_Product_Images | SINGLE | | Nein | | OrderItems_Product_EAN | SINGLE | | Nein | | OrderItems_Product_PlatformData | SINGLE | | Nein | | OrderItems_Product_TARICCode | SINGLE | | Nein | | OrderItems_Product_CountryOfOrigin | SINGLE | | Nein | | OrderItems_Product_BillbeeId | SINGLE | | Nein | | |