Résumé
Manipulation de l'entité ProspectAddress (Adresses des prospects) 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_ProspectAddress est défini dans la gestion des webhooks du studio.
Fonctionnement
verb: GET
resultType: simple
...
Bloc de code | ||
---|---|---|
| ||
"related":[ { "prospect":{ "codeprospect":"P0000001", "name":"CHEZ SOI", "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", "customerprospect_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_prospectType":"CTC", "generictype_ID_prospectFamily":"", "confirmationEmail":"contact@guichard.com", "confirmationFax":"03 90 11 22 44", "generictype_ID_taxCode":"", "productdepot_ID":"", "generictype_ID_accountingCategory":"", "generictype_ID_prospectPotential":"B", "generictype_ID_civility":"", "skype":"contact@guichard.com", "generictype_ID_role":"", "unused":"0", "prospectgroup_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": "" }, "prospectcontact": { "codeprospectcontact": "P0000001-DJ", "prospect_ID": "P0000001", "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": "", } }] |
...
Bloc de code | ||
---|---|---|
| ||
{ "prospectaddress": { "codeprospectaddress": "P0000001-SXB", /* Code globalement unique d'adresse prospect (Varchar (255))*/ "prospect_ID": "P0000001", /* Code prospect (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)*/ "prospectcontact_ID": "P0000001-DJ", /* Code contact prospect (ForeignKey () - sw_data_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", /* Nom du site (Varchar (255))*/ "internalcodeprospectaddress": null /* CodeProspectaddress original de weavy s'il y a eu transcodage (Varchar (255)) */ } } |
verb: LIST
resultType: simple, extended reprendre les définitions du GET
...