...
| Bloc de code | ||
|---|---|---|
| ||
"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
| Bloc de code | ||
|---|---|---|
| ||
"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":"",
"decisionMaker":"",
"customercontact_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 customer, generictype_civility, customer, generictype_position, generictype_country, generictype_ID_province, generictype_service et baseculture
| Bloc de code | ||
|---|---|---|
| ||
"related":[
{
"generictype_civilitycustomer":{
"codegenerictypecodecustomer":"CIVILITY-MC0000001",
"labelname":"MonsieurENTREPRISE DIJON GUICHARD",
"originalCodebaseuser_ID":"M",
"dataTypeaddress1":"CIVILITY33 Avenue du Drapeau",
"descriptionaddress2":"",
"translationKeyaddress3":"GenType_CIVILITY-M",
"generictype_ID_parentpostalCode":"21000",
"tagcity":"DIJON",
"orderNumberphoneNumber":""03 90 11 },22 "customer":{33",
"codecustomerfaxNumber":"C000000103 90 11 22 44",
"namemobilePhoneNumber":"ENTREPRISE DIJON GUICHARD06 90 11 22 33",
"baseuser_IDemail":"contact@guichard.com",
"address1deliveryDays":"33 Avenue du Drapeau1A;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 "blocked":"0",
"faxNumberblockedComment":"03 90 11 22 44",
"mobilePhoneNumbermessage":"06 90 11 22 33",
"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;5B5.04372",
"siretNumbergpsLatitude":"47.33222",
"vatIntragpsPrecision":"8",
"apeCodegpsUpdateDate":"516K"2020-09-03 23:02:12",
"commentgpsManual":"",
"blockedaccountNumber":"0C0000001",
"blockedCommentcontactName":"",
"messagecurrency_ID":"",
"vacationStartauthorizedCredit":"0",
"vacationEndrisk":"1",
"gpsLongitudelanguage":"5.04372",
"gpsLatitudeunderSurveillance":"47.33222",
"gpsPrecisionworkforce":"825",
"gpsUpdateDatecustomer_ID_paying":"2020-09-03 23:02:12",
"gpsManualpricecategory_ID":"",
"accountNumberdiscountRate":"C00000010",
"contactNamewebsite":"https://www.guichard.com",
"currency_IDlegalStatus":"Société Anonyme avec Directoire",
"authorizedCreditgenerictype_ID_brand":"0",
"riskgenerictype_ID_deliveryMode":"1",
"languagegenerictype_ID_paymentMean":"",
"underSurveillancegenerictype_ID_country":"FR",
"workforcegenerictype_ID_province":"25",
"customergenerictype_ID_payingcustomerType":"CTC",
"pricecategorygenerictype_ID_customerFamily":"",
"discountRateconfirmationEmail":"0",
"website":"<https://www.guichardcontact@guichard.com",>
"legalStatusconfirmationFax":"Société03 90 Anonyme11 avec22 Directoire44",
"generictype_ID_brandtaxCode":"",
"generictypeproductdepot_ID_deliveryMode":"",
"generictype_ID_paymentMeanaccountingCategory":"",
"generictype_ID_countrycustomerPotential":"FRB",
"generictype_ID_provincecivility":"",
"generictype_ID_customerTypeskype":"CTCcontact@guichard.com",
"generictype_ID_customerFamilyrole":"",
"confirmationEmailunused":"contact@guichard.com0",
"confirmationFaxcustomergroup_ID":"03 90 11 22 44",
"generictype_ID_taxCodereferencing":"2",
"productdepotgenerictype_ID_distribution":"SELF",
"generictype_ID_accountingCategorymarket":"BIG",
"generictype_ID_customerPotentialarea":"B",
"generictypebaseculture_ID_civility":"FR-FR",
"skypebaseuser_ID_favoriteTechnician":"contact@guichard.comTECH-01",
"generictypebranchoffice_ID_role":"SXB",
"unusedemailFormat":"0",
"isIndividual"customergroup_ID":"0",
"generictype_ID_referencingfacebook":"2https://www.facebook.com/guichard/",
"generictype_ID_distributiontwitter":"SELFhttps://twitter.com/guichard",>
"generictype_ID_marketyoutube":"BIGhttps://www.youtube.com/watch?v=6jGbnEwQJ54",
"arealinkedin":"https://www.linkedin.com/company/guichard",
"baseculture_IDactivity":"FR-FR","
},
"generictype_civility":{
"baseuser_ID_favoriteTechniciancodegenerictype":"TECHCIVILITY-01M",
"branchoffice_IDlabel":"SXBMonsieur",
"emailFormatoriginalCode":"M",
"isIndividualdataType":"0CIVILITY",
"facebookdescription":"<https://www.facebook.com/guichard/",>"",
"translationKey":"GenType_CIVILITY-M",
"generictype_ID_parent":"",
"tag":"",
"orderNumber":""
},
"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"
},
"generictype_position": {
"codegenerictype": "CONTACT_POSITION-2",
"label": "Responsable commercial",
"originalCode": "2",
"dataType": "CONTACT_POSITION",
"description": "",
"translationKey": "GenType_CONTACT_POSITION-2",
"generictype_ID_parent": "",
"tag": "",
"orderNumber": ""
},
"generictype_service": {
"codegenerictype": "SERVICE-COMM",
"label": "Commercial",
"originalCode": "COMM",
"dataType": "SERVICE",
"description": "",
"twittertranslationKey":"<https://twitter.com/guichard "",>
"youtubegenerictype_ID_parent":"<https://www.youtube.com/watch?v=6jGbnEwQJ54 "",>
"linkedintag":"<https://www.linkedin.com/company/guichard "",>
"activityorderNumber": ""
}
}] |
verb: PUT
| Bloc de code | ||
|---|---|---|
| ||
{
"customercontact": {
"codecustomercontact": "C0000001-DJ", /* Code globalement unique de contact client (Varchar (255))*/
"customer_ID": "C0000001", /* Code client (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", /* AdresseVille 3 (Varchar (25564))*/
"postalCodephoneNumber": "2100005 55 79 56 92", /* N° Codede postaltéléphone (Varchar (1664))*/
"citymobilePhoneNumber": "DIJON06 07 08 09 10", /* N° de Villeportable (Varchar (64))*/
"phoneNumberfaxNumber": "05 55 79 56 9211", /* N° de téléphonetélécopie (Varchar (64))*/
"mobilePhoneNumberemail": "06 07 08 09 10jdeneir@nebout.div", /* N°Email de portable (Varchar (64255))*/
"faxNumberdescription": "05 55 79 56 11Acheteur direct", /* N° de télécopieDescription (Varchar (64255))*/
"emailgenerictype_ID_position": "jdeneir@nebout.divCONTACT_POSITION-rcom", /* Email (Varchar (255)* Code fonction (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITION)*/
"descriptiongenerictype_ID_country": "Acheteur directCOUNTRY-FR", /* Code Descriptionpays (VarcharForeignKey (255)) - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
"generictype_ID_positionprovince": "CONTACT_POSITION-rcom"null, /* Code fonctionprovince (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITIONPROVINCE)*/
"generictype_ID_countryservice": "COUNTRYSERVICE-FRCIAL", /* Code pays service(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRYSERVICE)*/
"generictype_ID_provincebirthday": null"1980-09-18", /* CodeDate provinced'anniversaire (ForeignKeyDateTime () - sw_data_generictype.codegenerictype avec datatype = PROVINCE)*/
"mainContact": "0", /* Contact principal (Valeurs possibles : 0,1) (Bool ())*/
"generictypebaseculture_ID_service": "SERVICE-CIAL", /* Code culture service(ForeignKey () - sw_data_generictype.codegenerictype avec datatype = SERVICEbaseculture.codebaseculture)*/
"birthdaybouncedEmailDetected": "1980-09-18", /* Date d'anniversaire email NPAI (N'habite Pas/Plus à l’Adresse Indiquée) (DateTime ())*/
"mainContactclosedDate": "0", /* ContactDate principald'archivage (Valeurs possibles : 0,1) (Bool DateTime ())*/
"baseculture_IDskype": "", /* Code cultureSkype (ForeignKeyVarchar () - sw_data_baseculture.codebaseculture255))*/
"bouncedEmailDetectedtwitter": "", /* Date email NPAI (N'habite Pas/Plus à l’Adresse Indiquée)* Twitter (DateTimeVarchar (255))*/
"closedDatelinkedin": "", /* Date d'archivageLinkedIn (DateTimeVarchar (255))*/
"skypedecisionMaker":, "0", /* Skype Décideur (Valeurs possibles : 0,1) (VarcharBool (255))*/
"twittercustomercontact_ID_superior": "", /* Supérieur Twitterhiérarchique (VarcharForeignKey (255))) - sw_data_customercontact.codecustomercontact)*/
"linkedintopFlowchartLevel": "0", /* LinkedInNiveau supérieur de l'organigramme (Valeurs possibles : 0,1) (VarcharBool (255))*/
"internalCodeCustomerContacterpContactID": null"", /* CodeCustomerContactID original de weavy s'il y a eu transcodagecontact ERP (Varchar (255)) */
"internalcustomer_IDinternalcodecustomercontact": null, /* CodeCustomerCodeCustomerContact original de weavy s'il y a eu transcodage (Varchar (255)) */
/* Optionnel : pour mettre à jour les champs dynamiques selon paramétrage */
/* Exemple 1 : */
"dynamicfields":
[{
"fieldname": "t10",
"fieldvalue": "Formation marketing 2.0"
},
{
"fieldname": "t20",
"fieldvalue": "Formation commerciale expert"
},
{
...
}]
/* Exemple 2 : */
/* A partir de la version SUMMER'21, le mappage direct des champs dynamiques est possible en utilisant le nom du champ en bdd */
"v_t10": "Formation marketing 2.0",
"v_t20": "Formation commerciale expert",
...
}
} |
verb: LIST
resultType: simple, extended , extendedRelated reprendre les définitions du GET
| Bloc de code | ||
|---|---|---|
| ||
"filters:" {
"codeCustomerContact": "value", filter is equal
"codeCustomer": "value", filter is equal
"lastName": "value", filter is contains
"firstName": "value", filter is contains
"birthday": "value", filter is greater or or equal to
"birthdayBetween": "value1|value2", filter is between value1 and value2
"codeCountry": "value", filter is equal
"email": "value", filter is 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" |
Valeur Valeurs possibles pour le tri "orderBy" :
...