PlentyGetCustomers - PlentyONE

Version: REST 1.0

← PlentyONE Add-On Übersicht

Ruft eine Liste mit Kontakten / Kunden aus PlentyONE ab.

Inputs

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

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	Ihre PlentyONE Verbindung	Ja
limitItems	STRING	Schränkt die Anzahl der Kontakte ein.	Nein
lastUpdateFrom	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, die nach dem angegebenen Datum aktualisiert wurden z.B: 18.12.2012 16:00.	Nein
lastUpdateTo	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, die vor dem angegebenen Datum aktualisiert wurden z.B. 20.12.2012 16:00.	Nein
createdAtFrom	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, die nach dem angegebenen Datum erstellt wurden z.B: 18.12.2012 16:00.	Nein
createdAtTo	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, die vor dem angegebenen Datum erstellt wurden z.B. 20.12.2012 16:00.	Nein
lastOrderFrom	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, deren letzte Bestellung nach dem angegebenen Datum erstellt wurde z.B: 18.12.2012 16:00.	Nein
lastOrderTo	DATETIME	Dieser Filter beschränkt den Abruf auf Kontakte, deren letzte Bestellung nach dem angegebenen Datum erstellt wurde z.B: 18.12.2012 16:00.	Nein
customerID	STRING	ID des Kontakts	Nein
plentyID	STRING	Filtert die PlentyONE Mandaten ID des Kontakts	Nein
email	STRING	E-Mail-Adresse des Kontakts.	Nein
zip	STRING	Filtert die PLZ des Kontakts	Nein
customerType	STRING	Kontakt Typ	Nein	Alle Kunde Interessent Handelsvertreter Lieferant Hersteller Partner Benutzerdefinierte Typ ID
customTypeId	STRING	Benutzerdefinierte Typ ID	Nein
enableCustomerNotes	BOOLEAN	Wenn diese Option aktiviert ist, werden die Notizen zum Kontakts abgerufen	Nein	Ja Nein
enableBankData	BOOLEAN	Wenn diese Option aktiviert ist, wird die erste Bankverbindung des Kontakts abgerufen.	Nein	Ja Nein

Outputs

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

Name	Datentyp	Beschreibung	Werte
customers	SPREADSHEET	Ein SPREADSHEET mit den abgerufenen Kontaktdaten
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert identifier SINGLE The identifier column to import Spreadsheet into a Datastore. CustomerID SINGLE The ID of the contact. ExternalCustomerID SINGLE The external ID of the contact. CustomerNumber SINGLE The number of the contact. Type SINGLE The ID of the contact type (see PlentyONE CRM - types settings). FirstName SINGLE The first name of the contact. Surname SINGLE The last name of the contact. FullName SINGLE The full name of the contact. A concatenation of first and last name. Email SINGLE The private email address of the contact. SecondaryEmail SINGLE The secondary private email address of the contact. Gender SINGLE The gender of the contact or interested party FormOfAddress SINGLE The form of address for the contact. Newsletter SINGLE The time the contact registered for the newsletter. CustomerClass SINGLE The ID of the contact class. IsBlocked SINGLE The blocked status of the contact. Contacts can be blocked for a specific client (store). CustomerRating SINGLE The rating of the contact. This rating is for internal use only. 5 red stars are for the worst and 5 yellow stars for the best rating. DebitorAccount SINGLE The book account (debitor account) of the contact. An additional, separate number that generally corresponds to the customer number or the debtor number in your financial accounting. Language SINGLE The language of the contact. ReferrerID SINGLE The origin of the contact. PlentyID SINGLE The client (store ID) that is assigned to the contact. ResponsibleID SINGLE The owner ID (user ID) of the contact. DateOfBirth SINGLE The date of birth of the contact. LastLogin SINGLE The date of the last login of the contact. LastSalesOrder SINGLE The date of the last order. CreatedAt SINGLE The date the contact was created. UpdatedAt SINGLE The date the contact was last updated. Telephone SINGLE The private phone number of the contact. Fax SINGLE The private fax number of the contact. Mobile SINGLE The private mobile phone number of the contact. EbayName SINGLE The eBay account name of the contact. PaypalEmail SINGLE The email address of the PayPal account of the contact. PaypalPayerId SINGLE The PayPal payer id of the contact. KlarnaPersonalId SINGLE The Klarna personal id of the contact. Postident SINGLE The DHL PostIdent of the contact. ForumUsername SINGLE The user name of the contact in the forum. ForumGroupId SINGLE The ID of the forum group that is assigned to the contact. SingleAccess SINGLE The access type of the contact. ContactPerson SINGLE The contact person of the contact. MarketplacePartner SINGLE The marketplace partner status of the contact. SalesRepresentativeContactID SINGLE The salesRepresentative ID of the contact InvoiceAllowed SINGLE True, if invoice payment is allowed. DebitAllowed SINGLE True, if debit payment is allowed. AllowedMethodsOfPayment MULTIPLEVALUE Semicolon separated list of all allowed payment method IDs VAT_ID SINGLE The vat number of the contact. BillingAddress_ID SINGLE ID of Address for update. Leave empty to create a new address (CustomerID required). BillingAddress_TypeID SINGLE TypeID can only be used for new addresses ('ID' column is empty) BillingAddress_Gender SINGLE The gender BillingAddress_Company SINGLE The name 1 field (defaults to: company name). BillingAddress_FirstName SINGLE The name 2 field (defaults to: first name). BillingAddress_Surname SINGLE The name 3 field (defaults to: last name). BillingAddress_AdditionalName SINGLE The name 4 field (defaults to: c/o). BillingAddress_Street SINGLE The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') BillingAddress_HouseNumber SINGLE The address 2 field (defaults to: houseNumber, packstationNo) BillingAddress_AdditionalAddress3 SINGLE The address 3 field (defaults to: additional) BillingAddress_AdditionalAddress4 SINGLE The address 4 field is currently undefined and can be freely used. BillingAddress_ZIP SINGLE The postcode. BillingAddress_City SINGLE The town. BillingAddress_CountryID SINGLE The ID of the country. BillingAddress_StateID SINGLE The ID of the state. BillingAddress_ReadOnly SINGLE Flag that indicates if the data record is read only. BillingAddress_ContactPerson SINGLE The contact person option (alias for option with typeId 12). BillingAddress_VATNumber SINGLE The tax id number (VAT number) option (alias for option with typeId 1). BillingAddress_ExternalAddressID SINGLE The external ID option (alias for option with typeId 2). BillingAddress_EntryCertificate SINGLE The entry certificate (bool) option (alias for option with typeId 3). BillingAddress_Telephone SINGLE The phone number option (alias for option with typeId 4). BillingAddress_Email SINGLE The email option (alias for option with typeId 5). BillingAddress_Postnumber SINGLE The post number option (alias for option with typeId 6). BillingAddress_PersonalID SINGLE The personal ID option (alias for option with typeId 7). BillingAddress_BBFC SINGLE The BBFC/FSK option (alias for option with typeId 8). BillingAddress_Birthday SINGLE The birthday option (alias for option with typeId 9). BillingAddress_SessionID SINGLE The frontend session ID (alias for option with typeId 10). BillingAddress_Title SINGLE The title/salutation (alias for option with typeId 11). BillingAddress_CheckedAt SINGLE The time the address was checked. BillingAddress_CreatedAt SINGLE The time the address was created. BillingAddress_UpdatedAt SINGLE The time the address was updated. DeliveryAddress_ID SINGLE ID of Address for update. Leave empty to create a new address (CustomerID required). DeliveryAddress_TypeID SINGLE TypeID can only be used for new addresses ('ID' column is empty) DeliveryAddress_Gender SINGLE The gender DeliveryAddress_Company SINGLE The name 1 field (defaults to: company name). DeliveryAddress_FirstName SINGLE The name 2 field (defaults to: first name). DeliveryAddress_Surname SINGLE The name 3 field (defaults to: last name). DeliveryAddress_AdditionalName SINGLE The name 4 field (defaults to: c/o). DeliveryAddress_Street SINGLE The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') DeliveryAddress_HouseNumber SINGLE The address 2 field (defaults to: houseNumber, packstationNo) DeliveryAddress_AdditionalAddress3 SINGLE The address 3 field (defaults to: additional) DeliveryAddress_AdditionalAddress4 SINGLE The address 4 field is currently undefined and can be freely used. DeliveryAddress_ZIP SINGLE The postcode. DeliveryAddress_City SINGLE The town. DeliveryAddress_CountryID SINGLE The ID of the country. DeliveryAddress_StateID SINGLE The ID of the state. DeliveryAddress_ReadOnly SINGLE Flag that indicates if the data record is read only. DeliveryAddress_ContactPerson SINGLE The contact person option (alias for option with typeId 12). DeliveryAddress_VATNumber SINGLE The tax id number (VAT number) option (alias for option with typeId 1). DeliveryAddress_ExternalAddressID SINGLE The external ID option (alias for option with typeId 2). DeliveryAddress_EntryCertificate SINGLE The entry certificate (bool) option (alias for option with typeId 3). DeliveryAddress_Telephone SINGLE The phone number option (alias for option with typeId 4). DeliveryAddress_Email SINGLE The email option (alias for option with typeId 5). DeliveryAddress_Postnumber SINGLE The post number option (alias for option with typeId 6). DeliveryAddress_PersonalID SINGLE The personal ID option (alias for option with typeId 7). DeliveryAddress_BBFC SINGLE The BBFC/FSK option (alias for option with typeId 8). DeliveryAddress_Birthday SINGLE The birthday option (alias for option with typeId 9). DeliveryAddress_SessionID SINGLE The frontend session ID (alias for option with typeId 10). DeliveryAddress_Title SINGLE The title/salutation (alias for option with typeId 11). DeliveryAddress_CheckedAt SINGLE The time the address was checked. DeliveryAddress_CreatedAt SINGLE The time the address was created. DeliveryAddress_UpdatedAt SINGLE The time the address was updated. Account_Id SINGLE The ID of the account. Account_Number SINGLE The number of the account. Account_CompanyName SINGLE The company name. Account_TaxIdNumber SINGLE The ID of the tax number Account_Valuta SINGLE The valuta date in days specified for the account. Account_DiscountDays SINGLE The early payment discount period in days specified for the account. Account_DiscountPercent SINGLE The early payment discount in percent specified for the account. Account_TimeForPaymentAllowedDays SINGLE The payment due date in days specified for the account. Account_SalesRepresentativeContactId SINGLE The contact ID of the sales representative. Account_UserId SINGLE The (user) ID of the account owner. Account_DeliveryTime SINGLE The delivery time for the supplier. Account_DealerMinOrderValue SINGLE The minimum order value for the supplier. Account_SupplierCurrency SINGLE The currency used by a supplier. Account_CreatedAt SINGLE The time the account was created. Account_UpdatedAt SINGLE The time the account was updated. BankAccount_ContactID SINGLE The ID of the contact the bank account belongs to. BankAccount_OrderID SINGLE The ID of the order the bank account belongs to. BankAccount_AccountOwner SINGLE The owner of the bank account. BankAccount_BankName SINGLE The name of the bank. BankAccount_BankAddress SINGLE The address of the bank. BankAccount_BankPostalCodeTown SINGLE The postcode and town of the bank. BankAccount_BankCountry SINGLE The country of the bank. BankAccount_AccountNumber SINGLE The account number of the bank account. BankAccount_SortCode SINGLE The sort code of the bank account. BankAccount_IBAN SINGLE The IBAN of the bank account. BankAccount_BIC SINGLE The BIC of the bank account. BankAccount_DirectDebitMandateAvailable SINGLE Flag that indicates if a direct debit mandate is available. BankAccount_DirectDebitMandateAt SINGLE The time the direct debit mandate was created. BankAccount_DirectDebitMethod SINGLE The direct debit method. BankAccount_DirectDebitType SINGLE The direct debit type. BankAccount_PaymentMethod SINGLE The payment method. BankAccount_LastUpdateBy SINGLE The source of the last change. import CustomerNotes MAP