CUSTOMERS - ReadCustomer
Cette requête permet de lire les données d’un client pour le créer ou le modifier dans la boutique. Pour chaque code client retourné par la requête Csutomers Atoo-Sync crée une requête. C’est cette requête qui permet d’envoyer les données du client dans la boutique.
Champs obligatoires
La requête doit retourner obligatoirement les champs suivants :
- CustomerKey String le code unique du client dans l'ERP (exemple: C0001)
- PriceGroupKey String le code unique du groupe de tarifs dans l'ERP (exemple: TARIF1)
- CustomerCompany String la société du client dans l'ERP (exemple: ATOO NEXT)
- Customerfirstname String le prénom du client dans l'ERP (exemple: Jean)
- CustomerLastname String le nom du client dans l'ERP (exemple: DUPONT)
- CustomerEmail String l'adresse email client dans l'ERP (exemple: jean.dupont@atoo-next.com)
- CustomerSiret String le numéro de SIRET du client dans l'ERP (exemple: 425499428)
- CustomerApe String le numéro d'APE du client dans l'ERP (exemple: 6021Z)
- CustomerVatNumber String le numéro de TVA du client dans l'ERP (exemple: FR41458745962)
- CustomerSiret String le numéro de SIRET du client dans l'ERP (exemple: 425499428)
- CustomerWebsite String l'URL du site web du client dans l'ERP (exemple: https://www.atoo-next.net)
- CustomerNote String les notes du client dans l'ERP
- CustomerInvoiceName String le nom de l'adresse de facturation dans l'ERP (exemple: Facturation)
- CustomerInvoiceAddress1 String l'adresse 1 de l'adresse de facturation
- CustomerInvoiceAddress2 String l'adresse 2 de l'adresse de facturation
- CustomerInvoicePostcode String le code postal de l'adresse de facturation
- CustomerInvoiceCity String la ville de l'adresse de facturation
- CustomerInvoicePhone String le numéro de téléphone de l'adresse de facturation
- CustomerInvoiceState String le département de l'adresse de facturation
- CustomerInvoiceCountry String le pays de l'adresse de facturation
- CustomerDeliveryName String le nom de l'adresse de livraison dans l'ERP (exemple: Livraison)
- CustomerDeliveryAddress1 String l'adresse 1 de l'adresse de livraison
- CustomerDeliveryAddress2 String l'adresse 2 de l'adresse de livraison
- CustomerDeliveryPostcode String le code postal de l'adresse de livraison
- CustomerDeliveryCity String la ville de l'adresse de livraison
- CustomerDeliveryPhone String le numéro de téléphone de l'adresse de livraison
- CustomerDeliveryState String le département de l'adresse de livraison
- CustomerDeliveryCountry 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
CustomerKey as 'CustomerKey' /* Type: String */,
PriceGroupKey as 'PriceGroupKey' /* Type: String */,
CustomerCompany as 'CustomerCompany' /* Type: String */,
Customerfirstname as 'Customerfirstname' /* Type: String */,
CustomerLastname as 'CustomerLastname' /* Type: String */,
CustomerEmail as 'CustomerEmail' /* Type: String */,
CustomerSiret as 'CustomerSiret' /* Type: String */,
CustomerApe as 'CustomerApe' /* Type: String */,
CustomerVatNumber as 'CustomerVatNumber' /* Type: String */,
CustomerWebsite as 'CustomerWebsite' /* Type: String */,
CustomerNote as 'CustomerNote' /* Type: String */,
CustomerInvoiceName as 'CustomerInvoiceName' /* Type: String */,
CustomerInvoiceAddress1 as 'CustomerInvoiceAddress1' /* Type: String */,
CustomerInvoiceAddress2 as 'CustomerInvoiceAddress2' /* Type: String */,
CustomerInvoicePostcode as 'CustomerInvoicePostcode' /* Type: String */,
CustomerInvoiceCity as 'CustomerInvoiceCity' /* Type: String */,
CustomerInvoicePhone as 'CustomerInvoicePhone' /* Type: String */,
CustomerInvoiceState as 'CustomerInvoiceState' /* Type: String */,
CustomerInvoiceCountry as 'CustomerInvoiceCountry' /* Type: String */,
CustomerDeliveryName as 'CustomerDeliveryName' /* Type: String */,
CustomerDeliveryAddress1 as 'CustomerDeliveryAddress1' /* Type: String */,
CustomerDeliveryAddress2 as 'CustomerDeliveryAddress2' /* Type: String */,
CustomerDeliveryPostcode as 'CustomerDeliveryPostcode' /* Type: String */,
CustomerDeliveryCity as 'CustomerDeliveryCity' /* Type: String */,
CustomerDeliveryPhone as 'CustomerDeliveryPhone' /* Type: String */,
CustomerDeliveryState as 'CustomerDeliveryState' /* Type: String */,
CustomerDeliveryCountry as 'CustomerDeliveryCountry' /* Type: String */
FROM TABLE
WHERE
CustomerKey = '{0}' /* Type: String, Format: */
CustomerKey as 'CustomerKey' /* Type: String */,
PriceGroupKey as 'PriceGroupKey' /* Type: String */,
CustomerCompany as 'CustomerCompany' /* Type: String */,
Customerfirstname as 'Customerfirstname' /* Type: String */,
CustomerLastname as 'CustomerLastname' /* Type: String */,
CustomerEmail as 'CustomerEmail' /* Type: String */,
CustomerSiret as 'CustomerSiret' /* Type: String */,
CustomerApe as 'CustomerApe' /* Type: String */,
CustomerVatNumber as 'CustomerVatNumber' /* Type: String */,
CustomerWebsite as 'CustomerWebsite' /* Type: String */,
CustomerNote as 'CustomerNote' /* Type: String */,
CustomerInvoiceName as 'CustomerInvoiceName' /* Type: String */,
CustomerInvoiceAddress1 as 'CustomerInvoiceAddress1' /* Type: String */,
CustomerInvoiceAddress2 as 'CustomerInvoiceAddress2' /* Type: String */,
CustomerInvoicePostcode as 'CustomerInvoicePostcode' /* Type: String */,
CustomerInvoiceCity as 'CustomerInvoiceCity' /* Type: String */,
CustomerInvoicePhone as 'CustomerInvoicePhone' /* Type: String */,
CustomerInvoiceState as 'CustomerInvoiceState' /* Type: String */,
CustomerInvoiceCountry as 'CustomerInvoiceCountry' /* Type: String */,
CustomerDeliveryName as 'CustomerDeliveryName' /* Type: String */,
CustomerDeliveryAddress1 as 'CustomerDeliveryAddress1' /* Type: String */,
CustomerDeliveryAddress2 as 'CustomerDeliveryAddress2' /* Type: String */,
CustomerDeliveryPostcode as 'CustomerDeliveryPostcode' /* Type: String */,
CustomerDeliveryCity as 'CustomerDeliveryCity' /* Type: String */,
CustomerDeliveryPhone as 'CustomerDeliveryPhone' /* Type: String */,
CustomerDeliveryState as 'CustomerDeliveryState' /* Type: String */,
CustomerDeliveryCountry as 'CustomerDeliveryCountry' /* Type: String */
FROM TABLE
WHERE
CustomerKey = '{0}' /* Type: String, Format: */