...
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", "twittergenerictype_ID_parent":"<https://twitter.com/guichard",> "youtubetag":"<https://www.youtube.com/watch?v=6jGbnEwQJ54",> "linkedinorderNumber":"<https://www.linkedin.com/company/guichard",> "" }, "activitygenerictype_country":"" { } }] |
verb: PUT
Bloc de code | ||
---|---|---|
| ||
{ "customercontactcodegenerictype": {"COUNTRY-FR", "codecustomercontactlabel": "C0000001-DJFRANCE", /* Code globalement unique de contact client (Varchar (255))*/"originalCode": "FR", "dataType": "COUNTRY", "customer_IDdescription": "C0000001", /* Code client (ForeignKey () - sw_data_customer.codecustomer)*/ "translationKey": "GenType_COUNTRY-FR", "generictype_ID_civilityparent": "CIVILITY-Mr", /* Code civilité (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/ "lastName "tag": "", "orderNumber": "DENEIR" }, /* Nom (Varchar (255))*/ "generictype_province": { "firstNamecodegenerictype": "Jacques", /* Prénom (Varchar (255))*/ "label": "", "address1originalCode": ""1b rue Darwin, "dataType": "", /* Adresse 1 (Varchar (255))*/ "description": "", "address2translationKey": null"", /* Adresse 2 (Varchar (255))*/ "generictype_ID_parent": "", "address3tag": null, /* Adresse 3 (Varchar (255))*/ "", "orderNumber": "" }, "baseculture": { "postalCodecodebaseculture": "21000FR-FR", /* Code postal (Varchar (16))*/ "label": "French - France", "citycodelanguage": "DIJONFR" }, /* Ville (Varchar (64))*/ "generictype_position": { "phoneNumbercodegenerictype": "05 55 79 56 92", /* N° de téléphone (Varchar (64))*/"CONTACT_POSITION-2", "label": "Responsable commercial", "originalCode": "2", "mobilePhoneNumberdataType": "06 07 08 09 10CONTACT_POSITION", /* N° de portable (Varchar (64))*/ "description": "", "faxNumbertranslationKey": "05 55 79 56 11GenType_CONTACT_POSITION-2", /* N° de télécopie (Varchar (64))*/ "generictype_ID_parent": "", "emailtag": "jdeneir@nebout.div", /* Email (Varchar (255))*/ "descriptionorderNumber": "Acheteur direct", /* Description (Varchar (255))*/ }, "generictype_service": { "generictype_ID_positioncodegenerictype": "CONTACT_POSITIONSERVICE-rcomCOMM", /* Code fonction (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CONTACT_POSITION)*/ "label": "Commercial", "originalCode": "COMM", "generictype_ID_countrydataType": "COUNTRY-FRSERVICE", /* Code pays (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/ "description": "", "translationKey": "", "generictype_ID_provinceparent": null, /* Code province (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE"", "tag": "", "orderNumber": "" } }] |
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", /* 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 ())*/ "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": "", /* DateTwitter email NPAI (N'habite Pas/Plus à l’Adresse Indiquée) (DateTime ((Varchar (255))*/ "closedDatelinkedin": "", /* DateLinkedIn d'archivage (DateTimeVarchar (255))*/ "skypedecisionMaker":, "0", /* Skype Décideur (Valeurs possibles : 0,1) (VarcharBool (255))*/ "twittercustomercontact_ID_superior": "", /* TwitterSupérieur hiérarchique (VarcharForeignKey (255)) - sw_data_customercontact.codecustomercontact)*/ "linkedintopFlowchartLevel": "0", /* LinkedIn (Varchar (255 Niveau supérieur de l'organigramme (Valeurs possibles : 0,1) (Bool ())*/ "internalCodeCustomerContacterpContactID": null"", /* CodeCustomerContact original de weavy s'il y a eu transcodage* ID contact 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" }, { ... }] "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 */* Exemple 2 "v_t10": */"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 */ "v_t10": "Formation marketing 2.0", "v_t20": "Formation commerciale expert", ... } } |
verb: LIST
resultType: simple, extended reprendre les définitions du GET
Bloc de code | ||
---|---|---|
| ||
"filters:" { "codeCustomerContact "v_t20": "Formation commerciale expert", ... } } |
verb: LIST
resultType: simple, extended 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 equalcontains "codeCustomerbirthday": "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" :
...