← Billbee Add-On Übersicht
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 | Werte |
| OrderData | SPREADSHEET | | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | identifier | SINGLE | | | | parent_identifier | SINGLE | | | | BillBeeOrderId | SINGLE | | | | BillBeeParentOrderId | SINGLE | | | | OrderNumber | SINGLE | | | | Id | SINGLE | | | | RebateDifference | SINGLE | | | | ShippingIds | SINGLE | | | | AcceptLossOfReturnRight | SINGLE | | | | State | SINGLE | | | | VatMode | SINGLE | | | | CreatedAt | SINGLE | | | | ShippedAt | SINGLE | | | | ConfirmedAt | SINGLE | | | | PayedAt | SINGLE | | | | SellerComment | SINGLE | | | | Comments | SINGLE | | | | InvoiceNumberPrefix | SINGLE | | | | InvoiceNumberPostfix | SINGLE | | | | InvoiceNumber | SINGLE | | | | InvoiceDate | SINGLE | | | | PaymentMethod | SINGLE | | | | ShippingCost | SINGLE | | | | TotalCost | SINGLE | | | | AdjustmentCost | SINGLE | | | | AdjustmentReason | SINGLE | | | | Currency | SINGLE | | | | Buyer | SINGLE | | | | UpdatedAt | SINGLE | | | | TaxRate1 | SINGLE | | | | TaxRate2 | SINGLE | | | | VatId | SINGLE | | | | Tags | SINGLE | | | | ShipWeightKg | SINGLE | | | | LanguageCode | SINGLE | | | | PaidAmount | SINGLE | | | | ShippingProfileId | SINGLE | | | | ShippingProviderId | SINGLE | | | | ShippingProviderProductId | SINGLE | | | | ShippingProviderName | SINGLE | | | | ShippingProviderProductName | SINGLE | | | | ShippingProfileName | SINGLE | | | | PaymentInstruction | SINGLE | | | | IsCancelationFor | SINGLE | | | | PaymentTransactionId | SINGLE | | | | DistributionCenter | SINGLE | | | | DeliverySourceCountryCode | SINGLE | | | | CustomInvoiceNote | SINGLE | | | | CustomerNumber | SINGLE | | | | PaymentReference | SINGLE | | | | ShippingServices | SINGLE | | | | Payments | SINGLE | | | | LastModifiedAt | SINGLE | | | | ApiAccountId | SINGLE | | | | ApiAccountName | SINGLE | | | | MerchantVatId | SINGLE | | | | CustomerVatId | SINGLE | | | | IsFromBillbeeApi | SINGLE | | | | InvoiceAddress_BillbeeId | SINGLE | | | | InvoiceAddress_FirstName | SINGLE | | | | InvoiceAddress_LastName | SINGLE | | | | InvoiceAddress_Company | SINGLE | | | | InvoiceAddress_NameAddition | SINGLE | | | | InvoiceAddress_Street | SINGLE | | | | InvoiceAddress_HouseNumber | SINGLE | | | | InvoiceAddress_Zip | SINGLE | | | | InvoiceAddress_City | SINGLE | | | | InvoiceAddress_CountryISO2 | SINGLE | | | | InvoiceAddress_Country | SINGLE | | | | InvoiceAddress_Line2 | SINGLE | | | | InvoiceAddress_Email | SINGLE | | | | InvoiceAddress_State | SINGLE | | | | InvoiceAddress_Phone | SINGLE | | | | ShippingAddress_BillbeeId | SINGLE | | | | ShippingAddress_FirstName | SINGLE | | | | ShippingAddress_LastName | SINGLE | | | | ShippingAddress_Company | SINGLE | | | | ShippingAddress_NameAddition | SINGLE | | | | ShippingAddress_Street | SINGLE | | | | ShippingAddress_HouseNumber | SINGLE | | | | ShippingAddress_Zip | SINGLE | | | | ShippingAddress_City | SINGLE | | | | ShippingAddress_CountryISO2 | SINGLE | | | | ShippingAddress_Country | SINGLE | | | | ShippingAddress_Line2 | SINGLE | | | | ShippingAddress_Email | SINGLE | | | | ShippingAddress_State | SINGLE | | | | ShippingAddress_Phone | SINGLE | | | | Seller_Platform | SINGLE | | | | Seller_BillbeeShopName | SINGLE | | | | Seller_BillbeeShopId | SINGLE | | | | Seller_Id | SINGLE | | | | Seller_Nick | SINGLE | | | | Seller_FirstName | SINGLE | | | | Seller_LastName | SINGLE | | | | Seller_FullName | SINGLE | | | | Seller_Email | SINGLE | | | | Customer_Id | SINGLE | | | | Customer_Name | SINGLE | | | | Customer_Email | SINGLE | | | | Customer_Tel1 | SINGLE | | | | Customer_Tel2 | SINGLE | | | | Customer_Number | SINGLE | | | | Customer_PriceGroupId | SINGLE | | | | Customer_LanguageId | SINGLE | | | | Customer_DefaultMailAddress | SINGLE | | | | Customer_DefaultCommercialMailAddress | SINGLE | | | | Customer_DefaultStatusUpdatesMailAddress | SINGLE | | | | Customer_DefaultPhone1 | SINGLE | | | | Customer_DefaultPhone2 | SINGLE | | | | Customer_DefaultFax | SINGLE | | | | Customer_VatId | SINGLE | | | | Customer_Type | SINGLE | | | | Customer_MetaData | SINGLE | | | | History_Created | SINGLE | | | | History_EventTypeName | SINGLE | | | | History_Text | SINGLE | | | | History_EmployeeName | SINGLE | | | | History_TypeId | SINGLE | | | | OrderItems_BillBeeOrderId | SINGLE | | | | OrderItems_BillbeeId | SINGLE | | | | OrderItems_TransactionId | SINGLE | | | | OrderItems_Quantity | SINGLE | | | | OrderItems_TotalPrice | SINGLE | | | | OrderItems_TaxAmount | SINGLE | | | | OrderItems_TaxIndex | SINGLE | | | | OrderItems_Discount | SINGLE | | | | OrderItems_Attributes | SINGLE | | | | OrderItems_GetPriceFromArticleIfAny | SINGLE | | | | OrderItems_IsCoupon | SINGLE | | | | OrderItems_ShippingProfileId | SINGLE | | | | OrderItems_DontAdjustStock | SINGLE | | | | OrderItems_UnrebatedTotalPrice | SINGLE | | | | OrderItems_SerialNumber | SINGLE | | | | OrderItems_InvoiceSKU | SINGLE | | | | OrderItems_Product_OldId | SINGLE | | | | OrderItems_Product_Id | SINGLE | | | | OrderItems_Product_Title | SINGLE | | | | OrderItems_Product_Weight | SINGLE | | | | OrderItems_Product_SKU | SINGLE | | | | OrderItems_Product_SkuOrId | SINGLE | | | | OrderItems_Product_IsDigital | SINGLE | | | | OrderItems_Product_Images | SINGLE | | | | OrderItems_Product_EAN | SINGLE | | | | OrderItems_Product_PlatformData | SINGLE | | | | OrderItems_Product_TARICCode | SINGLE | | | | OrderItems_Product_CountryOfOrigin | SINGLE | | | | OrderItems_Product_BillbeeId | SINGLE | | | |
| OrderHead | SPREADSHEET | | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | identifier | SINGLE | | | | BillBeeOrderId | SINGLE | | | | BillBeeParentOrderId | SINGLE | | | | OrderNumber | SINGLE | | | | Id | SINGLE | | | | RebateDifference | SINGLE | | | | ShippingIds | SINGLE | | | | AcceptLossOfReturnRight | SINGLE | | | | State | SINGLE | | | | VatMode | SINGLE | | | | CreatedAt | SINGLE | | | | ShippedAt | SINGLE | | | | ConfirmedAt | SINGLE | | | | PayedAt | SINGLE | | | | SellerComment | SINGLE | | | | Comments | SINGLE | | | | InvoiceNumberPrefix | SINGLE | | | | InvoiceNumberPostfix | SINGLE | | | | InvoiceNumber | SINGLE | | | | InvoiceDate | SINGLE | | | | PaymentMethod | SINGLE | | | | ShippingCost | SINGLE | | | | TotalCost | SINGLE | | | | AdjustmentCost | SINGLE | | | | AdjustmentReason | SINGLE | | | | Currency | SINGLE | | | | Buyer | SINGLE | | | | UpdatedAt | SINGLE | | | | TaxRate1 | SINGLE | | | | TaxRate2 | SINGLE | | | | VatId | SINGLE | | | | Tags | SINGLE | | | | ShipWeightKg | SINGLE | | | | LanguageCode | SINGLE | | | | PaidAmount | SINGLE | | | | ShippingProfileId | SINGLE | | | | ShippingProviderId | SINGLE | | | | ShippingProviderProductId | SINGLE | | | | ShippingProviderName | SINGLE | | | | ShippingProviderProductName | SINGLE | | | | ShippingProfileName | SINGLE | | | | PaymentInstruction | SINGLE | | | | IsCancelationFor | SINGLE | | | | PaymentTransactionId | SINGLE | | | | DistributionCenter | SINGLE | | | | DeliverySourceCountryCode | SINGLE | | | | CustomInvoiceNote | SINGLE | | | | CustomerNumber | SINGLE | | | | PaymentReference | SINGLE | | | | ShippingServices | SINGLE | | | | Payments | SINGLE | | | | LastModifiedAt | SINGLE | | | | ApiAccountId | SINGLE | | | | ApiAccountName | SINGLE | | | | MerchantVatId | SINGLE | | | | CustomerVatId | SINGLE | | | | IsFromBillbeeApi | SINGLE | | | | InvoiceAddress_BillbeeId | SINGLE | | | | InvoiceAddress_FirstName | SINGLE | | | | InvoiceAddress_LastName | SINGLE | | | | InvoiceAddress_Company | SINGLE | | | | InvoiceAddress_NameAddition | SINGLE | | | | InvoiceAddress_Street | SINGLE | | | | InvoiceAddress_HouseNumber | SINGLE | | | | InvoiceAddress_Zip | SINGLE | | | | InvoiceAddress_City | SINGLE | | | | InvoiceAddress_CountryISO2 | SINGLE | | | | InvoiceAddress_Country | SINGLE | | | | InvoiceAddress_Line2 | SINGLE | | | | InvoiceAddress_Email | SINGLE | | | | InvoiceAddress_State | SINGLE | | | | InvoiceAddress_Phone | SINGLE | | | | ShippingAddress_BillbeeId | SINGLE | | | | ShippingAddress_FirstName | SINGLE | | | | ShippingAddress_LastName | SINGLE | | | | ShippingAddress_Company | SINGLE | | | | ShippingAddress_NameAddition | SINGLE | | | | ShippingAddress_Street | SINGLE | | | | ShippingAddress_HouseNumber | SINGLE | | | | ShippingAddress_Zip | SINGLE | | | | ShippingAddress_City | SINGLE | | | | ShippingAddress_CountryISO2 | SINGLE | | | | ShippingAddress_Country | SINGLE | | | | ShippingAddress_Line2 | SINGLE | | | | ShippingAddress_Email | SINGLE | | | | ShippingAddress_State | SINGLE | | | | ShippingAddress_Phone | SINGLE | | | | Seller_Platform | SINGLE | | | | Seller_BillbeeShopName | SINGLE | | | | Seller_BillbeeShopId | SINGLE | | | | Seller_Id | SINGLE | | | | Seller_Nick | SINGLE | | | | Seller_FirstName | SINGLE | | | | Seller_LastName | SINGLE | | | | Seller_FullName | SINGLE | | | | Seller_Email | SINGLE | | | | Customer_Id | SINGLE | | | | Customer_Name | SINGLE | | | | Customer_Email | SINGLE | | | | Customer_Tel1 | SINGLE | | | | Customer_Tel2 | SINGLE | | | | Customer_Number | SINGLE | | | | Customer_PriceGroupId | SINGLE | | | | Customer_LanguageId | SINGLE | | | | Customer_DefaultMailAddress | SINGLE | | | | Customer_DefaultCommercialMailAddress | SINGLE | | | | Customer_DefaultStatusUpdatesMailAddress | SINGLE | | | | Customer_DefaultPhone1 | SINGLE | | | | Customer_DefaultPhone2 | SINGLE | | | | Customer_DefaultFax | SINGLE | | | | Customer_VatId | SINGLE | | | | Customer_Type | SINGLE | | | | Customer_MetaData | SINGLE | | | | History_Created | SINGLE | | | | History_EventTypeName | SINGLE | | | | History_Text | SINGLE | | | | History_EmployeeName | SINGLE | | | | History_TypeId | SINGLE | | | |
| OrderItems | SPREADSHEET | | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | identifier | SINGLE | | | | OrderItems_BillBeeOrderId | SINGLE | | | | OrderItems_BillbeeId | SINGLE | | | | OrderItems_TransactionId | SINGLE | | | | OrderItems_Quantity | SINGLE | | | | OrderItems_TotalPrice | SINGLE | | | | OrderItems_TaxAmount | SINGLE | | | | OrderItems_TaxIndex | SINGLE | | | | OrderItems_Discount | SINGLE | | | | OrderItems_Attributes | SINGLE | | | | OrderItems_GetPriceFromArticleIfAny | SINGLE | | | | OrderItems_IsCoupon | SINGLE | | | | OrderItems_ShippingProfileId | SINGLE | | | | OrderItems_DontAdjustStock | SINGLE | | | | OrderItems_UnrebatedTotalPrice | SINGLE | | | | OrderItems_SerialNumber | SINGLE | | | | OrderItems_InvoiceSKU | SINGLE | | | | OrderItems_Product_OldId | SINGLE | | | | OrderItems_Product_Id | SINGLE | | | | OrderItems_Product_Title | SINGLE | | | | OrderItems_Product_Weight | SINGLE | | | | OrderItems_Product_SKU | SINGLE | | | | OrderItems_Product_SkuOrId | SINGLE | | | | OrderItems_Product_IsDigital | SINGLE | | | | OrderItems_Product_Images | SINGLE | | | | OrderItems_Product_EAN | SINGLE | | | | OrderItems_Product_PlatformData | SINGLE | | | | OrderItems_Product_TARICCode | SINGLE | | | | OrderItems_Product_CountryOfOrigin | SINGLE | | | | OrderItems_Product_BillbeeId | SINGLE | | | |