Skip to content

billbeeUpdateCustomers - Billbee

← Billbee Add-On Übersicht

This step updates customer information.


Inputs

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

NameDatentypBeschreibungPflichtfeldWerte
accountACCOUNTNein
limitSTRINGLimits the number of rows used by the input SPREADSHEET. Use small values for testing.Nein
inputSPREADSHEETSpreadsheet mit den Daten.Nein
mappingdefinitionSTRINGThe mapping definition JSON StringNein
Folgende Felder sind zu konfigurieren:

FeldDatentypBeschreibungPflichtfeldStandardwert
Customer_IdSINGLEInternal billbee Customer_IdJa
NameSINGLENein
EmailSINGLENein
Tel1SINGLENein
Tel2SINGLENein
CustomerNumberSINGLENein
PriceGroupIdSINGLENein
LanguageIdSINGLENein
Address_IdSINGLENein
Address_AddressTypeSINGLENein
Address_CustomerIdSINGLENein
Address_CompanySINGLENein
Address_FirstNameSINGLENein
Address_LastNameSINGLENein
Address_Name2SINGLENein
Address_StreetSINGLENein
Address_HousenumberSINGLENein
Address_ZipSINGLENein
Address_CitySINGLENein
Address_StateSINGLENein
Address_CountryCodeSINGLENein
Address_EmailSINGLENein
Address_Tel1SINGLENein
Address_Tel2SINGLENein
Address_FaxSINGLENein
Address_AddressAdditionSINGLENein
Address_ArchivedAtSINGLENein
Address_RestoredAtSINGLENein
DefaultMailAddress_IdSINGLENein
DefaultMailAddress_TypeIdSINGLENein
DefaultMailAddress_SubTypeSINGLENein
DefaultMailAddress_ValueSINGLENein
DefaultCommercialMailAddress_IdSINGLENein
DefaultCommercialMailAddress_TypeIdSINGLENein
DefaultCommercialMailAddress_SubTypeSINGLENein
DefaultCommercialMailAddress_ValueSINGLENein
DefaultStatusUpdatesMailAddress_IdSINGLENein
DefaultStatusUpdatesMailAddress_TypeIdSINGLENein
DefaultStatusUpdatesMailAddress_SubTypeSINGLENein
DefaultStatusUpdatesMailAddress_ValueSINGLENein
DefaultPhone1_IdSINGLENein
DefaultPhone1_TypeIdSINGLENein
DefaultPhone1_SubTypeSINGLENein
DefaultPhone1_ValueSINGLENein
DefaultPhone2_IdSINGLENein
DefaultPhone2_TypeIdSINGLENein
DefaultPhone2_SubTypeSINGLENein
DefaultPhone2_ValueSINGLENein
DefaultFax_IdSINGLENein
DefaultFax_TypeIdSINGLENein
DefaultFax_SubTypeSINGLENein
DefaultFax_ValueSINGLENein
VatIdSINGLENein
TypeSINGLENein
ArchivedAtSINGLENein
RestoredAtSINGLENein

Outputs

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

NameDatentypBeschreibungWerte
UpdatedCustomersSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
idSINGLE
Customer_IdSINGLE
NameSINGLE
EmailSINGLE
Tel1SINGLE
Tel2SINGLE
NumberSINGLE
PriceGroupIdSINGLE
LanguageIdSINGLE
DefaultMailAddressSINGLE
DefaultCommercialMailAddressSINGLE
DefaultStatusUpdatesMailAddressSINGLE
DefaultPhone1SINGLE
DefaultPhone2SINGLE
DefaultFaxSINGLE
VatIdSINGLE
TypeSINGLE
MetaDataSINGLE
ArchivedAtSINGLE
RestoredAtSINGLE
invalidInputSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
idSINGLE
NameSINGLE
EmailSINGLE
Tel1SINGLE
Tel2SINGLE
CustomerNumberSINGLE
PriceGroupIdSINGLE
LanguageIdSINGLE
Address_IdSINGLE
Address_AddressTypeSINGLE
Address_CustomerIdSINGLE
Address_CompanySINGLE
Address_FirstNameSINGLE
Address_LastNameSINGLE
Address_Name2SINGLE
Address_StreetSINGLE
Address_HousenumberSINGLE
Address_ZipSINGLE
Address_CitySINGLE
Address_StateSINGLE
Address_CountryCodeSINGLE
Address_EmailSINGLE
Address_Tel1SINGLE
Address_Tel2SINGLE
Address_FaxSINGLE
Address_AddressAdditionSINGLE
Address_ArchivedAtSINGLE
Address_RestoredAtSINGLE
DefaultMailAddress_IdSINGLE
DefaultMailAddress_TypeIdSINGLE
DefaultMailAddress_SubTypeSINGLE
DefaultMailAddress_ValueSINGLE
DefaultCommercialMailAddress_IdSINGLE
DefaultCommercialMailAddress_TypeIdSINGLE
DefaultCommercialMailAddress_SubTypeSINGLE
DefaultCommercialMailAddress_ValueSINGLE
DefaultStatusUpdatesMailAddress_IdSINGLE
DefaultStatusUpdatesMailAddress_TypeIdSINGLE
DefaultStatusUpdatesMailAddress_SubTypeSINGLE
DefaultStatusUpdatesMailAddress_ValueSINGLE
DefaultPhone1_IdSINGLE
DefaultPhone1_TypeIdSINGLE
DefaultPhone1_SubTypeSINGLE
DefaultPhone1_ValueSINGLE
DefaultPhone2_IdSINGLE
DefaultPhone2_TypeIdSINGLE
DefaultPhone2_SubTypeSINGLE
DefaultPhone2_ValueSINGLE
DefaultFax_IdSINGLE
DefaultFax_TypeIdSINGLE
DefaultFax_SubTypeSINGLE
DefaultFax_ValueSINGLE
VatIdSINGLE
TypeSINGLE
ArchivedAtSINGLE
RestoredAtSINGLE
Customer_IdSINGLE
failedRequestsSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
idSINGLE
source_Customer_IdSINGLE
errorMessageSINGLE