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.

...

Bloc de code
languagejson
  "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
languagejson
  "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
languagejson
"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
languagejson
{
  "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",
/*  de portable (Varchar (64))*/ "description": "",
    "faxNumbertranslationKey": "05 55 79 56 11GenType_CONTACT_POSITION-2",
/*  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
languagejson
{
  "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
languagejson
"filters:" {
  "codeCustomerContact "v_t20": "Formation commerciale expert",
    ...	
  }
}

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

Bloc de code
languagejson
"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" :

...