verb: GET
resultType: simple
"deal":{
"codedeal":"PJ000011",
"customer_ID":"C0000001",
"label":"Vitrine de magasin",
"generictype_ID_dealType":"DEAL_DEALTYPE-PRJ",
"dealNumber":"PJ000011"
}
verb: GET
resultType: extended
"deal":{
"codedeal":"PJ000011",
"customer_ID":"C0000001",
"label":"Vitrine de magasin",
"generictype_ID_dealType":"DEAL_DEALTYPE-PRJ",
"dealNumber":"PJ000011",
"description":"",
"creationDate":"2020-09-18 00:00:00",
"closingDate":"",
"amount":"300",
"probability":"55",
"generictype_ID_lossReason":"",
"customer_ID_introducer":"",
"baseuser_ID":"",
"amount2":"",
"generictype_ID_status":"DEAL_STATUS-PRJ-1",
"lossReasonComment":"",
"realClosingDate":"",
"dealstep_ID_current":"",
"deal_ID_origin":"",
"isProject":"1",
"manualProbability":"0",
"marketinglead_ID_origin":"",
"customercontact_ID":"C0000001-DJ"
}
Verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables generictype_deal_type, customer et customercontact
"related":[
{
"generictype_dealType":{
"codegenerictype":"DEAL_DEALTYPE-PRJ",
"label":"Project type 1",
"originalCode":"PRJ",
"dataType":"DEAL_DEALTYPE",
"description":"",
"translationKey":"",
"generictype_ID_parent":"Project",
"tag":"",
"orderNumber":""
},
"customer":{
"codecustomer":"C0000001",
"name":"ENTREPRISE DIJON GUICHARD",
"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",
"openingDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
"siretNumber":"",
"vatIntra":"",
"apeCode":"516K",
"comment":"",
"blocked":"0",
"blockedComment":"",
"message":"",
"vacationStart":"",
"vacationEnd":"",
"gpsLongitude":"5.04372",
"gpsLatitude":"47.33222",
"gpsPrecision":"8",
"gpsUpdateDate":"2020-09-03 23:02:12",
"gpsManual":"",
"accountNumber":"C0000001",
"contactName":"",
"currency_ID":"",
"authorizedCredit":"0",
"risk":"1",
"language":"",
"underSurveillance":"",
"workforce":"25",
"customer_ID_paying":"",
"pricecategory_ID":"",
"discountRate":"0",
"website":"https://www.guichard.com",
"legalStatus":"Société Anonyme avec Directoire",
"generictype_ID_brand":"",
"generictype_ID_deliveryMode":"",
"generictype_ID_paymentMean":"",
"generictype_ID_country":"",
"generictype_ID_province":"",
"generictype_ID_customerType":"CTC",
"generictype_ID_customerFamily":"",
"confirmationEmail":"contact@guichard.com",
"confirmationFax":"03 90 11 22 44",
"generictype_ID_taxCode":"",
"productdepot_ID":"",
"generictype_ID_accountingCategory":"",
"generictype_ID_customerPotential":"B",
"generictype_ID_civility":"",
"skype":"contact@guichard.com",
"generictype_ID_role":"",
"unused":"0",
"customergroup_ID":"",
"generictype_ID_referencing":"2",
"generictype_ID_distribution":"SELF",
"generictype_ID_market":"BIG",
"area":"",
"baseculture_ID":"FR-FR",
"baseuser_ID_favoriteTechnician":"TECH-01",
"branchoffice_ID":"SXB",
"emailFormat":"",
"isIndividual":"0",
"facebook":"https://www.facebook.com/guichard/",
"twitter":"https://twitter.com/guichard",
"youtube":"https://www.youtube.com/watch?v=6jGbnEwQJ54",
"linkedin":"https://www.linkedin.com/company/guichard",
"activity":""
},
"customercontact":{
"codecustomercontact":"C0000001-DJ",
"customer_ID":"C0000001",
"lastName":"DENEIR",
"firstName":"Jacques",
"generictype_ID_civility":"Monsieur",
"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",
"gpsLongitude":"5.0384",
"gpsLatitude":"47.33073",
"gpsAccuracy":"6",
"gpsUpdateDate":"2020-09-16 23:02:26",
"gpsManual":"",
"description":"Acheteur direct",
"generictype_ID_position":"Direction",
"birthday":"1980-09-18 00:00:00",
"generictype_ID_country":"FR",
"generictype_ID_province":"",
"mainContact":"0",
"generictype_ID_service":"Direction",
"skype":"",
"baseculture_ID":"",
"bouncedEmailDetected":"",
"closedDate":"",
"twitter":"",
"linkedin":""
}
}]
verb: PUT
{
"deal": {
"codedeal": "PJ000011",
"customer_ID": "C0000001",
"label": "Vitrine de magasin",
"generictype_ID_dealType": "DEAL_DEALTYPE-PRJ",
"dealNumber": "PJ000011",
"description": "",
"creationDate" : "2020-09-18",
"closingDate": "",
"coefficient": "",
"amount": "300",
"probability": "55",
"generictype_ID_lossReason": "",
"customer_ID_introducer": "",
"baseuser_ID": "",
"amount2": "",
"generictype_ID_status": "DEAL_STATUS-PRJ-1",
"lossReasonComment": "",
"realClosingDate": "",
"dealstep_ID_current": "",
"deal_ID_origin": "",
"isProject": "1",
"manualProbability": "0",
"marketinglead_ID_origin": "",
"customercontact_ID": "C0000001-DJ",
"internalCodeDeal": null, /* CodeDeal 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 */
/* Exemple : */
"dynamicfields":
[{
"fieldname": "prj10",
"fieldvalue": "100000"
},
{
"fieldname": "prj30",
"fieldvalue": "Jean-René Abraham"
},
{
...
}]
},
"dealelement": [
{
"codedealelement": "PJ000011-0-1",
"deal_ID": "PJ000011",
"label" : "Elément 1",
"DataOrder": "10",
"originalCode": "1",
"dealelementstructure_ID": "",
"dealelement_ID_parent": ""
},
{
"codedealelement": "PJ000011-0-1.1",
"deal_ID": "PJ000011",
"label" : "Elément 1.1",
"DataOrder": "11",
"originalCode": "1.1",
"dealelementstructure_ID": "",
"dealelement_ID_parent": "PJ000011-0-1"
},
{
"codedealelement": "PJ000011-0-2",
"deal_ID": "PJ000011",
"label" : "Elément 2",
"DataOrder": "20",
"originalCode": "2",
"dealelementstructure_ID": "",
"dealelement_ID_parent": ""
}]
}
verb: LIST
resultType: simple, extended, extendedRelated reprendre les définitions du GET
"filters:" {
"codeDeal": "value", filter is equal
"label": "value", filter is contains
"codeCustomer": "value", filter is equal
"dealType": "value" filter is equal
}