Résumé
Manipulation de l'entité ProspectContact (Contacts des prospects) en lecture/écriture/suppression via un objet métier depuis une application externe.
Tables
Les tables utilisées sont :
sw_data_customercontact : Table des contacts des tiers
Critères d'activation
WHK_ProspectContact est défini dans la gestion des webhooks du studio.
Fonctionnement
verb: GET
resultType: simple
| Bloc de code | ||
|---|---|---|
| ||
"prospectcontact":{
"codeprospectcontact":"P0000001-DJ",
"prospect_ID":"P0000001",
"generictype_ID_civility":"M",
"lastName":"DENEIR",
"firstName":"Jacques",
"address1":"1b rue Darwin",
"address2":"",
"address3":"",
"postalCode":"21000",
"city":"DIJON",
"phoneNumber":"05 55 79 56 92",
"faxNumber":"05 55 79 56 11",
"mobilePhoneNumber":"06 07 08 09 10",
"email":"jdeneir@nebout.div",
"generictype_ID_country":"FR",
"generictype_ID_province":"",
"baseculture_ID":"",
} |
verb: GET
resultType: extended
| Bloc de code | ||
|---|---|---|
| ||
"prospectcontact":{
"codeprospectcontact":"P0000001-DJ",
"prospect_ID":"P0000001",
"generictype_ID_civility":"M",
"lastName":"DENEIR",
"firstName":"Jacques",
"address1":"1b rue Darwin",
"address2":"",
"address3":"",
"postalCode":"21000",
"city":"DIJON",
"phoneNumber":"05 55 79 56 92",
"faxNumber":"05 55 79 56 11",
"mobilePhoneNumber":"06 07 08 09 10",
"email":"jdeneir@nebout.div",
"generictype_ID_country":"FR",
"generictype_ID_province":"",
"baseculture_ID":"FR-FR",
"gpsLongitude":"",
"gpsLatitude":"",
"description":"Acheteur direct",
"generictype_ID_position":"Responsable commercial",
"birthday":"1980-09-18",
"mainContact":"0",
"generictype_ID_service":"Commercial",
"skype":"",
"bouncedEmailDetected":"",
"closedDate":"",
"twitter":"",
"linkedin":"",
"decisionMaker":"",
"prospectcontact_ID_superior":"",
"topFlowchartLevel": "",
"erpContactID":""
} |
verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables generictype_civility, prospect, generictype_position, generictype_country, generictype_ID_province, generictype_service et baseculture
...
| Bloc de code | ||
|---|---|---|
| ||
{
"prospectcontact": {
"codeprospectcontact": "P0000001-DJ", /* Code globalement unique de contact prospect (Varchar (255))*/
"prospect_ID": "P0000001", /* Code prospect (ForeignKey () - sw_data_customer.codecustomer)*/
"generictype_ID_civility": "CIVILITY-Mr", /* Code civilité (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/
"lastName": "DENEIR", /* Nom (Varchar (255))*/
"firstName": "Jacques", /* Prénom (Varchar (255))*/
"address1": "1b rue Darwin", /* Adresse 1 (Varchar (255))*/
"address2": null, /* Adresse 2 (Varchar (255))*/
"address3": null, /* Adresse 3 (Varchar (255))*/
"postalCode": "21000", /* Code postal (Varchar (16))*/
"city": "DIJON", /* Ville (Varchar (64))*/
"phoneNumber": "05 55 79 56 92", /* N° de téléphone (Varchar (64))*/
"mobilePhoneNumber": "06 07 08 09 10", /* N° de portable (Varchar (64))*/
"faxNumber": "05 55 79 56 11", /* N° de télécopie (Varchar (64))*/
"email": "jdeneir@nebout.div", /* Email (Varchar (255))*/
"description": "Acheteur direct", /* Description (Varchar (255))*/
"generictype_ID_position": "CONTACT_POSITION-rcom", /* Code fonction (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITION)*/
"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)*/
"generictype_ID_service": "SERVICE-CIAL", /* Code service(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = SERVICE)*/
"birthday": "1980-09-18", /* Date d'anniversaire (DateTime ())*/
"mainContact": "0", /* Contact principal (Valeurs possibles : 0,1) (Bool ())*/
"baseculture_ID": "", /* Code culture (ForeignKey () - sw_data_baseculture.codebaseculture)*/
"bouncedEmailDetected": "", /* Date email NPAI (N'habite Pas/Plus à l’Adresse Indiquée) (DateTime ())*/
"closedDate": "", /* Date d'archivage (DateTime ())*/
"skype": "", /* Skype (Varchar (255))*/
"twitter": "", /* Twitter (Varchar (255))*/
"linkedin": "", /* LinkedIn (Varchar (255))*/
"internalcodeprospectcontactdecisionMaker":, null"0" /* CodeProspectContact original de weavy s'il y a eu transcodage (Varchar (255))*/
}
} |
verb: LIST
resultType: simple, extended reprendre les définitions du GET
| Bloc de code | ||
|---|---|---|
| ||
"filters:" { "codeProspectContactDécideur (Valeurs possibles : 0,1) (Bool ())*/ "prospectcontact_ID_superior": "", /* Supérieur hiérarchique (ForeignKey () - sw_data_customercontact.codecustomercontact)*/ "topFlowchartLevel": "0", /* Niveau supérieur de l'organigramme (Valeurs possibles : 0,1) (Bool ())*/ "erpContactID": "", /* ID contact ERP (Varchar (255))*/ "internalcodeprospectcontact": null /* CodeProspectContact original de weavy s'il y a eu transcodage (Varchar (255))*/ } } |
verb: LIST
resultType: simple, extended reprendre les définitions du GET
| Bloc de code | ||
|---|---|---|
| ||
"filters:" { "codeProspectContact": "value", filter is equal "codeProspect": "value", filter is equal "lastName": "value", filter is contains "firstName": "value", filter is equalcontains "codeProspectbirthday": "value", filter is greater or equal to "lastNamebirthdayBetween": "valuevalue1|value2", filter is between containsvalue1 and value2 "firstNamecodeCountry": "value", filter is containsequal "birthdayemail": "value", filter is greater or equal to "birthdayBetweenemailDomain": "value1|value2value", filter is betweenendswith value1 and value2(ie "emailDomain": "@domaine.extension") "codeCountrynotClosedBefore": "value", filter is equal(closedDate is null OR closedDate > value) "emailclosedAfter": "value", filter is closedDate > equalvalue "emailDomainclosedBefore": "value" filter is closedDate < endswithvalue }, "orderBy": "value" |
Valeurs possibles pour le tri "orderBy" :
...