Comparaison de pages

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

language	json

  "prospectcontact":{
    "codeprospectcontact":"C0000001P0000001-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

language	json

  "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":"",
   }

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

"related":[
{
  "prospect":{ "decisionMaker":"",
    "prospectcontact_ID_superior":"",
    "codeprospecttopFlowchartLevel": "P0000001",
    "nameerpContactID":"CHEZ SOI",
    "baseuser_ID":"",
    "address1":"33 Avenue du Drapeau}

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

language	json

"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",
    "address2openingDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "address3siretNumber":"",
    "postalCodevatIntra":"21000",
    "cityapeCode":"DIJON516K",
    "phoneNumbercomment":"03 90 11 22 33",
    "faxNumberblocked":"03 90 11 22 44"0",
    "mobilePhoneNumberblockedComment":""06,
 90 11 22 33"message":"",
    "emailvacationStart":"contact@guichard.com",
    "deliveryDaysvacationEnd":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "openingDaysgpsLongitude":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B"5.04372",
    "gpsLatitude":"47.33222",
    "siretNumbergpsPrecision":"8",
    "vatIntragpsUpdateDate":"2020-09-03 23:02:12",
    "apeCodegpsManual":"516K",
    "commentaccountNumber":"C0000001",
    "blockedcontactName":"0",
    "blockedCommentcurrency_ID":"",
    "messageauthorizedCredit":"0",
    "vacationStartrisk":"1",
    "vacationEndlanguage":"",
    "gpsLongitudeunderSurveillance":"5.04372",
    "gpsLatitudeworkforce":"47.3322225",
    "gpsPrecisionprospect_ID_paying":"8",
    "gpsUpdateDatepricecategory_ID":"2020-09-03 23:02:12",
    "gpsManualdiscountRate":"0",
    "accountNumberwebsite":"C0000001https://www.guichard.com",
    "contactNamelegalStatus":"Société Anonyme avec Directoire",
    "currencygenerictype_ID_brand":"",
    "authorizedCreditgenerictype_ID_deliveryMode":"0",
     "risk""generictype_ID_paymentMean":"1",
    "languagegenerictype_ID_country":"FR",
    "underSurveillancegenerictype_ID_province":"",
    "workforcegenerictype_ID_prospectType":"25CTP",
    "prospectgenerictype_ID_payingprospectFamily":"",
    "pricecategory_IDconfirmationEmail":"contact@guichard.com",
    "discountRateconfirmationFax":"003 90 11 22 44",
    "websitegenerictype_ID_taxCode":"https://www.guichard.com",
    "legalStatusproductdepot_ID":"Société Anonyme avec Directoire",
    "generictype_ID_brandaccountingCategory":"",
    "generictype_ID_deliveryModeprospectPotential":"B",
    "generictype_ID_paymentMeancivility":"",
    "skype":"contact@guichard.com",
    "generictype_ID_countryrole":"",
    "unused":"FR0",
    "generictypeprospectgroup_ID_province":"",
    "generictype_ID_prospectTypereferencing":"CTP2",
    "generictype_ID_prospectFamilydistribution":"SELF",
    "confirmationEmailgenerictype_ID_market":"contact@guichard.comBIG",
    "confirmationFaxarea":"03 90 11 22 44",
    "generictypebaseculture_ID_taxCode":"FR-FR",
    "productdepotbaseuser_ID_favoriteTechnician":"TECH-01",
    "generictypebranchoffice_ID_accountingCategory":"SXB",
    "generictype_ID_prospectPotentialemailFormat":"B",
    "generictype_ID_civilityisIndividual":"0",
    "skypefacebook":"contact@guichardhttps://www.facebook.com/guichard/",
    "generictype_ID_roletwitter":"https://twitter.com/guichard",
    "unusedyoutube":"0https://www.youtube.com/watch?v=6jGbnEwQJ54",
    "prospectgroup_IDlinkedin":"https://www.linkedin.com/company/guichard",
    "generictype_ID_referencingactivity":"2",
  },
  "generictype_ID_distributioncivility":"SELF",{
    "generictype_ID_marketcodegenerictype":"BIGCIVILITY-M",
    "arealabel":"Monsieur",
    "baseculture_IDoriginalCode":"FR-FRM",
    "baseuser_ID_favoriteTechniciandataType":"TECH-01CIVILITY",
    "branchoffice_IDdescription":"SXB",
    "emailFormattranslationKey":"GenType_CIVILITY-M",
    "isIndividualgenerictype_ID_parent":"0",
    "facebooktag":"https://www.facebook.com/guichard/",
    "twitterorderNumber":"https://twitter.com/guichard""
  },
  "generictype_country": {
    "youtubecodegenerictype":"https://www.youtube.com/watch?v=6jGbnEwQJ54 "COUNTRY-FR",
    "linkedinlabel":"https://www.linkedin.com/company/guichard "FRANCE",
    "activityoriginalCode": "FR",
  },  "dataType": "generictype_civility":{COUNTRY",
    "codegenerictypedescription": "CIVILITY-M",
    "labeltranslationKey": "MonsieurGenType_COUNTRY-FR",
    "originalCodegenerictype_ID_parent": "M",
    "dataTypetag": "CIVILITY",
    "descriptionorderNumber": "",
  },
  "translationKeygenerictype_province":"GenType_CIVILITY-M", {
    "generictype_ID_parentcodegenerictype": "",
    "taglabel": "",
    "orderNumberoriginalCode": "",
  },   "generictype_countrydataType": {"",
    "codegenerictypedescription": "COUNTRY-FR",
    "labeltranslationKey": "FRANCE",
    "originalCodegenerictype_ID_parent": "FR",
    "dataTypetag": "COUNTRY",
    "descriptionorderNumber": "",
  },
  "translationKeybaseculture": "GenType_COUNTRY-FR",{
    "generictype_ID_parent"codebaseculture": "FR-FR",
    "taglabel": "French - France",
    "orderNumbercodelanguage": "FR"
  },
  "generictype_provinceposition": {
    "codegenerictype": "CONTACT_POSITION-2",
    "label": "Responsable commercial",
    "originalCode": "2",
    "dataType": "CONTACT_POSITION",
    "description": "",
    "translationKey": "GenType_CONTACT_POSITION-2",
    "generictype_ID_parent": "",
    "tag": "",
    "orderNumber": ""
  },
  "baseculturegenerictype_service": {
    "codebaseculturecodegenerictype": "FRSERVICE-FRCOMM",
    "label": "French - France"Commercial",
    "originalCode": "COMM",
    "codelanguagedataType": "FRSERVICE",
  },
  "generictype_positiondescription": {"",
    "codegenerictypetranslationKey": "CONTACT_POSITION-2",
    "labelgenerictype_ID_parent": "Responsable commercial",
    "originalCodetag": "2",
    "dataTypeorderNumber": "CONTACT_POSITION",
  }
}]

verb: PUT

Bloc de code

language	json

{
  "descriptionprospectcontact": "",{
    "translationKeycodeprospectcontact": "GenType_CONTACT_POSITION-2P0000001-DJ", /* Code globalement unique de  "generictype_ID_parent": "",contact prospect (Varchar (255))*/
    "tagprospect_ID": "P0000001", /* Code prospect (ForeignKey  "orderNumber": ""() - sw_data_customer.codecustomer)*/
  },
  "generictype_ID_servicecivility": {
    "codegenerictype": "SERVICE-COMM"CIVILITY-Mr", /* Code civilité  "label": "Commercial",
    "originalCode": "COMM",(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/
    "dataTypelastName": "SERVICEDENEIR", /* Nom (Varchar (255))*/
    "descriptionfirstName": "Jacques", /* Prénom   "translationKey": "",(Varchar (255))*/
    "generictype_ID_parentaddress1": "1b rue Darwin", /* Adresse 1  "tag": "",(Varchar (255))*/ 
    "orderNumberaddress2": ""null, /* Adresse }
}]

verb: PUT

Bloc de code

language	json

{
  "prospectcontact": {2 (Varchar (255))*/ 
    "codeprospectcontactaddress3": "P0000001-DJ", /* Code globalement unique de contact prospectnull, /* Adresse 3 (Varchar (255))*/ 
    "prospect_IDpostalCode": "P000000121000", /* Code prospectpostal (ForeignKeyVarchar () - sw_data_customer.codecustomer16))*/
    "generictype_ID_civilitycity": "CIVILITY-MrDIJON", /* Code civilité (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITYVille (Varchar (64))*/
    "lastNamephoneNumber": "DENEIR05 55 79 56 92", /* N° de Nomtéléphone (Varchar (25564))*/
    "firstNamemobilePhoneNumber": "Jacques06 07 08 09 10", /* N° de Prénomportable (Varchar (25564))*/
    "address1faxNumber": "1b rue Darwin05 55 79 56 11", /* N° Adressede 1télécopie (Varchar (25564))*/
     "address2email": null"jdeneir@nebout.div", /* Adresse 2Email (Varchar (255))*/ 
    "address3description": "Acheteur nulldirect", /* Adresse 3Description (Varchar (255))*/ 
    "postalCodegenerictype_ID_position": "21000CONTACT_POSITION-rcom", /* Code postalfonction (VarcharForeignKey (16))) - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITION)*/
    "citygenerictype_ID_country": "DIJONCOUNTRY-FR", /* Code Villepays (VarcharForeignKey (64)) - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
    "phoneNumbergenerictype_ID_province": "05 55 79 56 92", /* N° de téléphone (Varchar (64) null, /* Code province (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE)*/
    "mobilePhoneNumbergenerictype_ID_service": "SERVICE-CIAL"06, 07/* 08Code 09 10", /* N° de portable (Varchar (64))service(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = SERVICE)*/
    "faxNumberbirthday": "05 55 79 56 111980-09-18", /* N° de télécopieDate d'anniversaire (VarcharDateTime (64))*/
    "emailmainContact": "jdeneir@nebout.div0", /* Email Contact principal (Valeurs possibles : 0,1) (VarcharBool (255))*/
    "descriptionbaseculture_ID": "Acheteur direct", /* Code Descriptionculture (VarcharForeignKey (255)) - sw_data_baseculture.codebaseculture)*/
    "generictype_ID_positionbouncedEmailDetected": "CONTACT_POSITION-rcom", /* CodeDate fonctionemail (ForeignKeyNPAI () - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITIONN'habite Pas/Plus à l’Adresse Indiquée) (DateTime ())*/
    "generictype_ID_countryclosedDate": "COUNTRY-FR", /* CodeDate paysd'archivage (ForeignKeyDateTime () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
    "generictype_ID_provinceskype": null"", /* Code provinceSkype (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCEVarchar (255))*/
    "generictype_ID_servicetwitter": "SERVICE-CIAL", /* CodeTwitter service(ForeignKeyVarchar () - sw_data_generictype.codegenerictype avec datatype = SERVICE255))*/
    "birthdaylinkedin": "1980-09-18", /* Date d'anniversaireLinkedIn (DateTimeVarchar (255))*/
    "mainContactdecisionMaker":, "0", /* Contact principalDécideur (Valeurs possibles : 0,1) (Bool ())*/
    "basecultureprospectcontact_ID_superior": "", /* CodeSupérieur culturehiérarchique (ForeignKey () - sw_data_baseculturecustomercontact.codebaseculturecodecustomercontact)*/
    "bouncedEmailDetectedtopFlowchartLevel": "0", /* DateNiveau emailsupérieur NPAIde (N'habite Pas/Plus à l’Adresse Indiquée) (DateTime ())*/
    "closedDate": "", /* Date d'archivage (DateTimel'organigramme (Valeurs possibles : 0,1) (Bool ())*/
    "skypeerpContactID": "", /* ID Skypecontact ERP (Varchar (255))*/
    "twitterinternalcodeprospectcontact": "",null /* Twitter 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

language	json

"filters:" {
  "linkedincodeProspectContact": "value", /*filter LinkedInis (Varchar (255))*/equal
     "internalcodeprospectcontactcodeProspect": 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

language	json

"filters:" {
  "codeProspectContact"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" :

...

Comparaison des versions

Ancienne version 3

Nouvelle version Actuel

Légende

Résumé

Tables

Critères d'activation

Fonctionnement