CUSTOMERS - ReadCustomerContacts
Cette requête permet de lire les contacts d’un client pour les créer ou les modifier dans la boutique. Pour chaque code client retourné par la requête Customers Atoo-Sync crée une requête. C’est cette requête qui permet d’envoyer les contacts du client dans la boutique.
Champs obligatoires
La requête doit retourner obligatoirement les champs suivants :
- ContactKey String le code unique du contact dans l'ERP (exemple: CC0001)
- ContactCompany String la société du contact dans l'ERP (exemple: ATOO NEXT)
- ContactFirstname String le prénom du contact dans l'ERP (exemple: Jean)
- ContactLastname String le nom du contact dans l'ERP (exemple: DUPONT)
- ContactEmail String l'adresse email contact dans l'ERP (exemple: jean.dupont@atoo-next.com)
- ContactPhone String le numéro de téléphone du contact dans l'ERP
- ContactPhoneMobile String le numéro de téléphone portable du contact dans l'ERP
- ContactInvoiceName String le nom de l'adresse de facturation dans l'ERP (exemple: Facturation)
- ContactInvoiceAddress1 String l'adresse 1 de l'adresse de facturation
- ContactInvoiceAddress2 String l'adresse 2 de l'adresse de facturation
- ContactInvoicePostcode String le code postal de l'adresse de facturation
- ContactInvoiceCity String la ville de l'adresse de facturation
- ContactInvoicePhone String le numéro de téléphone de l'adresse de facturation
- ContactInvoiceState String le département de l'adresse de facturation
- ContactInvoiceCountry String le pays de l'adresse de facturation
- ContactDeliveryName String le nom de l'adresse de livraison dans l'ERP (exemple: Livraison)
- ContactDeliveryAddress1 String l'adresse 1 de l'adresse de livraison
- ContactDeliveryAddress2 String l'adresse 2 de l'adresse de livraison
- ContactDeliveryPostcode String le code postal de l'adresse de livraison
- ContactDeliveryCity String la ville de l'adresse de livraison
- ContactDeliveryPhone String le numéro de téléphone de l'adresse de livraison
- ContactDeliveryState String le département de l'adresse de livraison
- ContactDeliveryCountry String le pays de l'adresse de livraison
Argument obligatoire
- {0} spécifie le code unique du client (exemple: C0001)
Exemple de requête
SELECT
ContactKey as 'ContactKey' /* Type: String */,
ContactCompany as 'ContactCompany' /* Type: String */,
ContactFirstname as 'ContactFirstname' /* Type: String */,
ContactLastname as 'ContactLastname' /* Type: String */,
ContactEmail as 'ContactEmail' /* Type: String */,
ContactPhone as 'ContactPhone' /* Type: String */,
ContactPhoneMobile as 'ContactPhoneMobile' /* Type: String */,
ContactInvoiceName as 'ContactInvoiceName' /* Type: String */,
ContactInvoiceAddress1 as 'ContactInvoiceAddress1' /* Type: String */,
ContactInvoiceAddress2 as 'ContactInvoiceAddress2' /* Type: String */,
ContactInvoicePostcode as 'ContactInvoicePostcode' /* Type: String */,
ContactInvoiceCity as 'ContactInvoiceCity' /* Type: String */,
ContactInvoicePhone as 'ContactInvoicePhone' /* Type: String */,
ContactInvoiceState as 'ContactInvoiceState' /* Type: String */,
ContactInvoiceCountry as 'ContactInvoiceCountry' /* Type: String */,
ContactDeliveryName as 'ContactDeliveryName' /* Type: String */,
ContactDeliveryAddress1 as 'ContactDeliveryAddress1' /* Type: String */,
ContactDeliveryAddress2 as 'ContactDeliveryAddress2' /* Type: String */,
ContactDeliveryPostcode as 'ContactDeliveryPostcode' /* Type: String */,
ContactDeliveryCity as 'ContactDeliveryCity' /* Type: String */,
ContactDeliveryPhone as 'ContactDeliveryPhone' /* Type: String */,
ContactDeliveryState as 'ContactDeliveryState' /* Type: String */,
ContactDeliveryCountry as 'ContactDeliveryCountry' /* Type: String */
FROM TABLE
WHERE
CustomerKey = '{0}' /* Type: String, Format: */
ContactKey as 'ContactKey' /* Type: String */,
ContactCompany as 'ContactCompany' /* Type: String */,
ContactFirstname as 'ContactFirstname' /* Type: String */,
ContactLastname as 'ContactLastname' /* Type: String */,
ContactEmail as 'ContactEmail' /* Type: String */,
ContactPhone as 'ContactPhone' /* Type: String */,
ContactPhoneMobile as 'ContactPhoneMobile' /* Type: String */,
ContactInvoiceName as 'ContactInvoiceName' /* Type: String */,
ContactInvoiceAddress1 as 'ContactInvoiceAddress1' /* Type: String */,
ContactInvoiceAddress2 as 'ContactInvoiceAddress2' /* Type: String */,
ContactInvoicePostcode as 'ContactInvoicePostcode' /* Type: String */,
ContactInvoiceCity as 'ContactInvoiceCity' /* Type: String */,
ContactInvoicePhone as 'ContactInvoicePhone' /* Type: String */,
ContactInvoiceState as 'ContactInvoiceState' /* Type: String */,
ContactInvoiceCountry as 'ContactInvoiceCountry' /* Type: String */,
ContactDeliveryName as 'ContactDeliveryName' /* Type: String */,
ContactDeliveryAddress1 as 'ContactDeliveryAddress1' /* Type: String */,
ContactDeliveryAddress2 as 'ContactDeliveryAddress2' /* Type: String */,
ContactDeliveryPostcode as 'ContactDeliveryPostcode' /* Type: String */,
ContactDeliveryCity as 'ContactDeliveryCity' /* Type: String */,
ContactDeliveryPhone as 'ContactDeliveryPhone' /* Type: String */,
ContactDeliveryState as 'ContactDeliveryState' /* Type: String */,
ContactDeliveryCountry as 'ContactDeliveryCountry' /* Type: String */
FROM TABLE
WHERE
CustomerKey = '{0}' /* Type: String, Format: */