WebHook Customer Address (V5.3)

Résumé

Manipulation de l'entité CustomerAddress (Adresses des clients) en lecture/écriture/suppression via un objet métier depuis une application externe.

Tables

Les tables utilisées sont :

sw_data_customeraddress : Table des adresses des tiers

Les tables liées sont :

sw_data_customerbilling : Table des tiers facturés

Critères d'activation

WHK_CustomerAddress est défini dans la gestion des webhooks du studio.

Fonctionnement

verb: GET
resultType: simple

  "customeraddress":{
    "codecustomeraddress":"C0000001-BDX",
    "customer_ID":"C0000001",
    "name":"ENTREPÔT GUICHARD",
    "address1":"15 Avenue Champollion",
    "address2":"",
    "address3":"",
    "postalCode":"21000 ",
    "city":"Dijon",
    "phoneNumber":"03 90 22 75 45",
    "faxNumber":"03 90 22 75 40",
    "mobilePhoneNumber":"",
    "email":"",
    "generictype_ID_country":"FR",
    "generictype_ID_province":"",
    "baseculture_ID":"",
    "branchoffice_ID":"",
    "site":"1",
    "siteCode": "BDX",
    "siteName": "Entrepôt Dijon"
  }

verb: GET
resultType: extended

  "customeraddress":{
    "codecustomeraddress":"C0000001-BDX",
    "customer_ID":"C0000001",
    "name":"ENTREPÔT GUICHARD",
    "address1":"15 Avenue Champollion",
    "address2":"",
    "address3":"",
    "postalCode":"21000 ",
    "city":"Dijon",
    "phoneNumber":"03 90 22 75 45",
    "faxNumber":"03 90 22 75 40",
    "mobilePhoneNumber":"",
    "email":"",
    "generictype_ID_country":"FR",
    "generictype_ID_province":"",
    "baseculture_ID":"",
    "branchoffice_ID":"",
    "site":"1",
    "siteCode": "BDX",
    "siteName": "Entrepôt Dijon",    
    "areaCode":"",
    "contact":"",
    "gpsLongitude":"5.06764",
    "gpsLatitude":"47.33379",    
    "billingAddress":"",
    "defaultBillingAddress":"",
    "deliveryAddress":"",
    "defaultDeliveryAddress":"",
    "accessCode":"",
    "floor":"",
    "apartment":"",
    "miscInfos":"",
    "baseuser_ID_favoriteTechnician":"",
    "erpAddressID":"BDX",
    "bankholidayparamheader_ID":"",
    "customercontact_ID": "C0000001-DJ"
  }

verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables customer, generictype_country, generictype_province, baseculture, branchoffice, baseuser_favoriteTechnician et customercontact

"related":[
{
  "customer":{
    "codecustomer":"C0000001",
    "name":"ENTREPRISE DIJON GUICHARD",
    "baseuser_ID":"",
    "address1":"33 Avenue du Drapeau",
    "address2":"",
    "address3":"",
    "postalCode":"21000",
    "city":"DIJON",
    "phoneNumber":"03 90 11 22 33",
    "faxNumber":"03 90 11 22 44",
    "mobilePhoneNumber":"06 90 11 22 33",
    "email":"contact@guichard.com",
    "deliveryDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "openingDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "siretNumber":"",
    "vatIntra":"",
    "apeCode":"516K",
    "comment":"",
    "blocked":"0",
    "blockedComment":"",
    "message":"",
    "vacationStart":"",
    "vacationEnd":"",
    "gpsLongitude":"5.04372",
    "gpsLatitude":"47.33222",    
    "accountNumber":"C0000001",
    "contactName":"",
    "currency_ID":"",
    "authorizedCredit":"0",
    "risk":"1",
    "language":"",
    "underSurveillance":"",
    "workforce":"25",
    "customer_ID_paying":"",
    "pricecategory_ID":"",
    "discountRate":"0",
    "website":"https://www.guichard.com",
    "legalStatus":"Société Anonyme avec Directoire",
    "generictype_ID_brand":"",
    "generictype_ID_deliveryMode":"",
    "generictype_ID_paymentMean":"",
    "generictype_ID_country":"FR",
    "generictype_ID_province":"",
    "generictype_ID_customerType":"CTC",
    "generictype_ID_customerFamily":"",
    "confirmationEmail":"contact@guichard.com",
    "confirmationFax":"03 90 11 22 44",
    "generictype_ID_taxCode":"",
    "productdepot_ID":"",
    "generictype_ID_accountingCategory":"",
    "generictype_ID_customerPotential":"B",
    "generictype_ID_civility":"",
    "skype":"contact@guichard.com",
    "generictype_ID_role":"",
    "unused":"0",
    "customergroup_ID":"",
    "generictype_ID_referencing":"2",
    "generictype_ID_distribution":"SELF",
    "generictype_ID_market":"BIG",
    "area":"",
    "baseculture_ID":"FR-FR",
    "baseuser_ID_favoriteTechnician":"TECH-01",
    "branchoffice_ID":"SXB",
    "emailFormat":"",
    "isIndividual":"0",
    "facebook":"https://www.facebook.com/guichard/",
    "twitter":"https://twitter.com/guichard",
    "youtube":"https://www.youtube.com/watch?v=6jGbnEwQJ54",
    "linkedin":"https://www.linkedin.com/company/guichard",
    "activity":""
  },
  "generictype_country": {
    "codegenerictype": "COUNTRY-FR",
    "label": "FRANCE",
    "originalCode": "FR",
    "dataType": "COUNTRY",
    "description": "",
    "translationKey": "GenType_COUNTRY-FR",
    "generictype_ID_parent": "",
    "tag": "",
    "orderNumber": ""
  },
  "generictype_province": {
    "codegenerictype": "",
    "label": "",
    "originalCode": "",
    "dataType": "",
    "description": "",
    "translationKey": "",
    "generictype_ID_parent": "",
    "tag": "",
    "orderNumber": ""
  },
  "baseculture": {
    "codebaseculture": "FR-FR",
    "label": "French - France",
    "codelanguage": "FR"
  },
  "branchoffice": {
    "codebranchoffice": "",
    "name": "",
    "address1": "",
    "address2": "",
    "postalCode": "",
    "city": "",
    "generictype_ID_country": "",
    "phoneNumber": "",
    "faxNumber": "",
    "email": "",
    "website": "",
    "bankholidayparamheader_ID": "",
    "gpsLongitude": "",
    "gpsLatitude": "",
    "baseusergroup_ID": "",
    "interventionTeamLifetime": ""
  },
  "baseuser_favoriteTechnician": {
    "codebaseuser": "TECH-01",
    "lastName": "TECH-01",
    "firstName": "Tango",
    "initials": "",
    "email": "tech01@test.fr",
    "phoneNumber": "",
    "faxNumber": "",
    "address1": "2 Allée de Strasbourg",
    "address2": "",
    "postalCode": "91300",
    "city": "Massy",
    "position": "",
    "department": "",
    "generictype_ID_country": "",
    "generictype_ID_province": "",
    "baseculture_ID": "FR-FR",
    "branchoffice_ID": "Agence-01",
    "resourcetype_ID": "",
    "supervisor": "",
    "useMileageRate": "",
    "account": "",
    "analyticSection": "",
    "productdepot_ID": "",
    "lastGPSDate": "",
    "gpsLongitude": "2.2922000000000353",
    "gpsLatitude": "48.73596000000003",
    "fullView": "",
    "changeAuthorization": "",
    "productdepot_ID_current": "",
    "techSyncRule": "0",
    "homePage": "",
    "teamtype_ID": "",
    "customer_ID_subcontractor": "",
    "techIsSedentary": ""
  },
  "customercontact": {
    "codecustomercontact": "C0000001-DJ",
    "customer_ID": "C0000001",
    "generictype_ID_civility": "Monsieur",
    "lastName": "DENEIR",
    "firstName": "Jacques",
    "address1": "1b rue Darwin",
    "address2": "",
    "postalCode": "21000",
    "city": "DIJON",
    "phoneNumber": "05 55 79 56 92",
    "mobilePhoneNumber": "06 07 08 09 10",
    "faxNumber": "05 55 79 56 11",
    "email": "jrr@nebout.div",
    "address3": "",
    "generictype_ID_country": "FR",
    "generictype_ID_province": "",
    "baseculture_ID": "",
    "description": "Acheteur direct",
    "generictype_ID_position": "Direction",
    "birthday": "1980-09-18 00:00:00",
    "gpsLongitude": "",
    "gpsLatitude": "",
    "mainContact": "0",
    "generictype_ID_service": "Direction",
    "skype": "",
    "bouncedEmailDetected": "",
    "closedDate": "",
    "twitter": "",
    "linkedIn": "",
    "decisionMaker": "",
    "prospectcontact_ID_superior": "",
    "topFlowchartLevel": "",
  }
}]

verb: PUT

verb: LIST
resultType: simple, extended reprendre les définitions du GET

Valeurs possibles pour le tri "orderBy" :

nameAsc : par nom ascendant
siteCodeAsc : par code site ascendant
siteNameAsc : par nom de site ascendant