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
Critères d'activation
WHK_CustomerAddress
...
est défini dans la gestion des webhooks du studio.
Fonctionnement
verb: GET
resultType: simple
Info | ||
---|---|---|
Bloc de code | ||
| ||
"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
Bloc de code | |
---|---|
| |
| |
"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": "P0000001-DJ" } |
Verbverb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables la table customer, generictype_country, generictype_ID_province, baseculture, branchoffice, baseuser_favoriteTechnician et branchoffice
...
customercontact
Bloc de code | ||
---|---|---|
| ||
"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":"" },}] |
verb: PUT
"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
Bloc de code | ||
---|---|---|
| ||
{ "customeraddress": { "codecustomeraddress": "C0000001-SXB", /* Code globalement unique d'adresse client (Varchar (255))*/ "customer_ID": "C0000001", /* Code client (ForeignKey () - sw_data_customer.codecustomer)*/ "name": "ENTREPÔT GUICHARD stras", /* Nom de l'adresse client (Varchar (255))*/ "address1": "15 Avenue Champollion", /* Adresse 1 (Varchar (255))*/ "address2": null, /* Adresse 2 (Varchar (255))*/ "address3": null, /* Adresse 3 (Varchar (255))*/ "postalCode": "67000", /* Code postal (Varchar (16))*/ "city": "Strasbourg", /* Ville (Varchar (64))*/ "phoneNumber": "03 90 22 75 45", /* N° de téléphone (Varchar (64))*/ "faxNumber": "03 90 22 75 40", /* N° de télécopie (Varchar (64))*/ "mobilePhoneNumber": null, /* N° de portable (Varchar (64))*/ "email": null, /* Email (Varchar (255))*/ "generictype_ID_country": "COUNTRY-FR", /* Code pays (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/ "generictype_ID_province": null, /* Code province (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE)*/ "customercontact_ID": "P0000001-DJ", /* Code contactprovince client (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE customercontact.codecustomercontact)*/ "billingAddress": "1", /* Adresse de facturation (Valeurs possibles : 0,1) (Bool ()) */ "defaultBillingAddress": "0", /* Adresse de facturation par défaut (Valeurs possibles : 0,1) (Bool ()) */ "deliveryAddress": "1", /* Adresse de livraison (Valeurs possibles : 0,1) (Bool ()) */ "defaultDeliveryAddress": "0", /* Adresse de livraison par défaut (Valeurs possibles : 0,1) (Bool ()) */ "site": "1", /* Site (Valeurs possibles : 0,1) (Bool ())*/ "areaCode": "", /* Code région (Varchar (64))*/ "contact": "M. James", /* Contact (Varchar (64))*/ "accessCode": "", /* Code d'accès (Varchar (64))*/ "floor": "", /* Etage (Varchar (64))*/ "apartment": "", /* Appartement(Varchar (64))*/ "miscInfos": "", /* Informations diverses (Text (65535))*/ "baseuser_ID_favoriteTechnician": "TECH-01", /* Code technicien préféré (ForeignKey () - sw_data_baseuser.codebaseuser)*/ "erpAddressID": "SXB", /* ID adresse ERP (Varchar (255))*/ "branchoffice_ID": "", /* Code de l'agence de rattachement (ForeignKey () - sw_data_branchoffice.codebranchoffice)*/ "bankholidayparamheader_ID": "", /* Code entête paramétrage jours fériés (ForeignKey () - sw_data_bankholidayparamheader.codebankholidayparamheader)*/ "baseculture_ID": "", /* Code culture (ForeignKey () - sw_data_baseculture.codebaseculture)*/ "siteCode": "SXB", /* Code du site (Varchar (255))*/ "siteName": "Entrepôt Strasbourg", /* Nomdu site (Varchar (255))*/ "internalCodeCustomeraddress": null, /* CodeCustomeraddress original de weavy s'il y a eu transcodage du site (Varchar (255)) */ "internalcustomer_ID internalcodecustomeraddress": null /*CodeCustomer CodeCustomeraddress original de weavy s'il y a eu transcodage (Varchar (255)) */
}
} |
verb: LIST
resultType: simple, extended , extendedRelated reprendre les définitions du GET
Bloc de code | |
---|---|
| |
| |
"filters:" { "codeCustomerAddress": "value", filter is equal "codeCustomer": "value", filter is equal "name": "value", filter is contains "site": "value", filter is equal "siteCode": "value", filter is equal "siteName": "value", filter is contains "codeBranchoffice": "value", filter is equal "codeCountry": "value" filter is equal }, "orderBy": "value" |
Valeurs possibles pour le tri "orderBy" :
nameAsc : par nom ascendant
siteCodeAsc : par code site ascendant
siteNameAsc : par nom de site ascendant