Comparaison des versions

Légende

  • Ces lignes ont été ajoutées. Ce mot a été ajouté.
  • Ces lignes ont été supprimées. Ce mot a été supprimé.
  • La mise en forme a été modifiée.
Commentaire: Published by Scroll Versions from space VERSIONSWEAVY and version 5.4

verb: GET
resultType: simple

...

Résumé

Manipulation de l'entité CustomerContact (Contacts des clients) 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_CustomerContact est défini dans la gestion des webhooks du studio.

Fonctionnement

verb: GET
resultType: simple

Info

  "customercontact":{
    "codecustomercontact":"C0000001-DJ",
    "customer_ID":"C0000001",
    "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

Info
"customercontact":{
    "codecustomercontact":"C0000001-DJ",
    "customer_ID":"C0000001",
    "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":"",
    "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, customer, generictype_position, generictype_country, generictype_province, generictype_service et baseculture.

Info
Info
"related":[
{
  "generictype_civility":{
    "codecustomercontactcodegenerictype":"C0000001-DJCIVILITY-M",
    "label":"Monsieur",
    "originalCode":"M",
    "customer_IDdataType":"C0000001CIVILITY",
    "lastNamedescription":"DENEIR",
    "firstNametranslationKey":"JacquesGenType_CIVILITY-M",
    "generictype_ID_civilityparent":"Monsieur",
  }

verb: GET
resultType: extended

Info
"customercontact":{  "tag":"",
    "codecustomercontactorderNumber":"C0000001-DJ",
  },
  "customer_ID":"C0000001",{
    "lastNamecodecustomer":"DENEIRC0000001",
    "firstNamename":"Jacques"ENTREPRISE DIJON GUICHARD",
    "generictypebaseuser_ID_civility":"Monsieur",
    "address1":"1b33 Avenue ruedu DarwinDrapeau", 
    "address2":"",
    "address3":"",
    "postalCode":"21000",
    "city":"DIJON",
    "phoneNumber":"0503 5590 7911 5622 9233",
    "faxNumber":"0503 5590 7911 5622 1144",
    "mobilePhoneNumber":"06 07 08 09 10",
    "email":"jdeneir@nebout.div90 11 22 33",
    "gpsLongitudeemail":"contact@guichard.com",
    "gpsLatitudedeliveryDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "gpsAccuracyopeningDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
    "gpsUpdateDatesiretNumber":"",
    "gpsManualvatIntra":"",
    "descriptionapeCode":"Acheteur direct516K",
    "generictype_ID_positioncomment":"Direction",
    "birthdayblocked":"1980-09-18 00:00:000",
    "generictype_ID_countryblockedComment":"FR",
    "generictype_ID_provincemessage":"",
    "mainContactvacationStart":"0",
    "generictype_ID_servicevacationEnd":"Direction",
    "skypegpsLongitude":"5.04372",
    "baseculture_IDgpsLatitude":"47.33222",
    "bouncedEmailDetectedgpsPrecision":"8",
    "closedDategpsUpdateDate":"2020-09-03 23:02:12",
    "twittergpsManual":"",
    "linkedinaccountNumber":"C0000001"
  }

Verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables generictype_civility et customer

"related":[
{,
    "contactName":"",
    "generictypecurrency_civilityID":{"",
    "codegenerictypeauthorizedCredit":"CIVILITY-M0",
    "labelrisk":"Monsieur1",
    "originalCodelanguage":"M",
    "dataTypeunderSurveillance":"CIVILITY",
    "descriptionworkforce":"25",
    "translationKeycustomer_ID_paying":"GenType_CIVILITY-M",
    "generictypepricecategory_ID_parent":"",
    "tagdiscountRate":"0",
    "orderNumberwebsite":"https://www.guichard.com",
  },
  "customerlegalStatus":{"Société Anonyme avec Directoire",
    "codecustomergenerictype_ID_brand":"C0000001",
    "namegenerictype_ID_deliveryMode":"ENTREPRISE DIJON GUICHARD",
    "baseusergenerictype_ID_paymentMean":"",
    "address1"generictype_ID_country":"33 Avenue du DrapeauFR",
    "address2generictype_ID_province":"",
    "address3generictype_ID_customerType":"CTC",
    "postalCodegenerictype_ID_customerFamily":"21000",
    "cityconfirmationEmail":"DIJONcontact@guichard.com",
    "phoneNumberconfirmationFax":"03 90 11 22 3344",
    "faxNumber":"03 90 11 22 44generictype_ID_taxCode":"",
    "mobilePhoneNumberproductdepot_ID":""06,
 90 11 22 33 "generictype_ID_accountingCategory":"",
    "emailgenerictype_ID_customerPotential":"contact@guichard.comB",
    "deliveryDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5Bgenerictype_ID_civility":"",
    "openingDaysskype":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5Bcontact@guichard.com",
    "siretNumbergenerictype_ID_role":"",
    "vatIntraunused":"0",
    "apeCodecustomergroup_ID":"516K",
    "commentgenerictype_ID_referencing":"2",
    "blocked"generictype_ID_distribution":"0SELF",
    "blockedCommentgenerictype_ID_market":"BIG",
    "messagearea":"",
    "vacationStartbaseculture_ID":"FR-FR",
    "vacationEndbaseuser_ID_favoriteTechnician":"TECH-01",
    "gpsLongitudebranchoffice_ID":"5.04372SXB",
    "gpsLatitudeemailFormat":"47.33222",
    "gpsPrecisionisIndividual":"80",
    "gpsUpdateDatefacebook":"2020-09-03 23:02:12https://www.facebook.com/guichard/",
    "gpsManualtwitter":"https://twitter.com/guichard",
    "accountNumberyoutube":"C0000001https://www.youtube.com/watch?v=6jGbnEwQJ54",
    "linkedin"contactName:":"https://www.linkedin.com/company/guichard",
    "currency_IDactivity":"",
  }
}]

verb: PUT

Info
Info
{
  "authorizedCreditcustomercontact":"0", {
    "riskcodecustomercontact": "1C0000001-DJ", /* Code globalement unique de contact client  "language":"",(Varchar (255))*/
    "underSurveillancecustomer_ID": "C0000001", /* Code client  "workforce":"25",
    "customer_ID_paying":"",(ForeignKey () - sw_data_customer.codecustomer)*/
    "pricecategorygenerictype_ID_civility":" "CIVILITY-Mr", /* Code civilité  "discountRate":"0",
    "website":"https://www.guichard.com",(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/
    "legalStatuslastName":"Société Anonyme avec Directoire", "DENEIR", /* Nom (Varchar (255))*/
    "generictype_ID_brandfirstName": "Jacques", /* Prénom   "generictype_ID_deliveryMode":"",(Varchar (255))*/
    "generictype_ID_paymentMeanaddress1": "1b rue Darwin", /* Adresse 1  "generictype_ID_country":"FR",(Varchar (255))*/ 
    "generictype_ID_provinceaddress2":"" null, /* Adresse 2  "generictype_ID_customerType":"CTC",(Varchar (255))*/ 
    "generictype_ID_customerFamilyaddress3":"" null, /* Adresse 3  "confirmationEmail":"contact@guichard.com",(Varchar (255))*/ 
    "confirmationFaxpostalCode":"03 90 11 22 44", "21000", /* Code postal (Varchar (16))*/
    "generictype_ID_taxCodecity": "DIJON", /* Ville (Varchar (64))*/
    "productdepot_IDphoneNumber": "05 55 79 56 92", /*  de téléphone  "generictype_ID_accountingCategory":"",(Varchar (64))*/
    "generictype_ID_customerPotentialmobilePhoneNumber": "B",06 07 08 09  "generictype_ID_civility":"",
    "skype":"contact@guichard.com",10", /* N° de portable (Varchar (64))*/
    "generictype_ID_rolefaxNumber": "",05 55 79   "unused":"056 11", /*  de  "customergroup_ID":"",
    "generictype_ID_referencing":"2",télécopie (Varchar (64))*/
    "generictype_ID_distributionemail": "SELFjdeneir@nebout.div", /* Email (Varchar (255))*/
  "generictype_ID_market  "description": "BIGAcheteur direct", /* Description   "area":"",(Varchar (255))*/
    "baseculturegenerictype_ID_position": "FRCONTACT_POSITION-FRrcom", /* Code fonction (ForeignKey () - "baseusersw_ID_favoriteTechnician":"TECH-01",
    "branchoffice_ID":"SXB",data_generictype.codegenerictype avec datatype = CONTACT_POSITION)*/
    "emailFormatgenerictype_ID_country": "COUNTRY-FR", /* Code pays  "isIndividual":"0",
    "facebook":"https://www.facebook.com/guichard/",(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
    "twitter":"https://twitter.com/guichard",
    "youtube":"https://www.youtube.com/watch?v=6jGbnEwQJ54",generictype_ID_province": null, /* Code province (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE)*/
    "linkedingenerictype_ID_service":"https://www.linkedin.com/company/guichard",
    "activity":""
  }
}]

verb: PUT

{
  "customercontact": {
    "codecustomercontact": "C0000001-DJ", "SERVICE-CIAL", /* Code service(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = SERVICE)*/
    "birthday": "1980-09-18", /* Date d'anniversaire (DateTime ())*/
    "customer_IDmainContact": "C00000010", /* Contact principal  "generictype_ID_civility": "CIVILITY-Mr",(Valeurs possibles : 0,1) (Bool ())*/
    "lastNamebaseculture_ID": "DENEIR", /* Code culture (ForeignKey  "firstName": "Jacques",() - sw_data_baseculture.codebaseculture)*/
    "address1bouncedEmailDetected": "1b rue Darwin", /* Date email  "address2": null,
    "address3": null,NPAI (N'habite Pas/Plus à l’Adresse Indiquée) (DateTime ())*/
    "postalCodeclosedDate": "21000", /* Date d'archivage (DateTime ())*/
    "cityskype": "DIJON", /* Skype (Varchar (255))*/
    "phoneNumbertwitter": "05", 55/* 79Twitter 56 92",(Varchar (255))*/
    "mobilePhoneNumberlinkedin": "06", 07/* 08LinkedIn 09 10",(Varchar (255))*/
    "faxNumberinternalCodeCustomerContact": "05 55 79 56 11"null, /* CodeCustomerContact original de "email": "jdeneir@nebout.div",
    "description": "Acheteur direct",weavy s'il y a eu transcodage (Varchar (255)) */
    "generictypeinternalcustomer_ID_position": "CONTACT_POSITION-rcom"null, /* CodeCustomer original  "generictype_ID_country": "COUNTRY-FR",
    "generictype_ID_province": null,
    "generictype_ID_service": "SERVICE-ACHATS",
    "birthday": "1980-09-18",
    "mainContact": "0",
    "baseculture_ID": "",
    "bouncedEmailDetected": "",de weavy s'il y a eu transcodage (Varchar (255)) */  

    /* Optionnel : pour mettre à jour les champs dynamiques selon paramétrage */
    /* Exemple 1 : */
    "closedDatedynamicfields": 
"",    [{
"skype": "",     "twitterfieldname": "t10",
      "linkedinfieldvalue": "",Formation     "internalCodeCustomerContact": null, /* CodeCustomerContact original de weavy s'il y a eu transcodage (Varchar (255)) */
    "internalcustomer_ID": null, /* CodeCustomer original de weavy s'il y a eu transcodage (Varchar (255)) */  

    /* Optionnel : pour mettre à jour les champs dynamiques selon paramétrage */marketing 2.0"
    },
    {
      "fieldname": "t20",
      "fieldvalue": "Formation commerciale expert"    
    },
    {
      ...
    }]
    /* Exemple 2 : */
    "dynamicfields": 
    [{
      "fieldname": "t10",
      "fieldvalue": "Formation marketing 2.0"
    },
    {
 /* A partir de la version SUMMER'21, le mappage direct des champs dynamiques est possible en utilisant le nom du champ en bdd */
    "fieldnamev_t10": "t20Formation marketing 2.0",
      "fieldvaluev_t20": "Formation commerciale expert"    
    },
    {
 
    ...
    }]	
  }
}

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

Info
"filters:" {:" {
  "codeCustomerContact": "value", filter is equal
  "codeCustomer": "value", filter is equal
  "lastName": "value", filter is contains  
  "codeCustomerContactfirstName": "value", filter is equalcontains
  "codeCustomerbirthday": "value", filter is greater or equal to
  "firstNamebirthdayBetween": "valuevalue1|value2", filter is contains between value1 and value2
  "lastNamecodeCountry": "value", filter is containsequal
  "birthdayemail": "value", filter is greater or equal to  equal
  "emailDomain": "value" filter is endswith
}