...
sw_data_equipmentaddress : Table des adresses des équipements
sw_data_modulecoldequipmentcharacteristic : Module Froid - Table des caractéristiques froid des équipements
Critères d'activation
WHK_Equipment est défini dans la gestion des webhooks du studio.
...
Bloc de code | ||
---|---|---|
| ||
"equipment":{
"codeequipment": "BAL01-201910",
"description": "Ballon 300 litres",
"equipmenttype_ID": "BALL",
"serialNumber": "BAL-169-2",
"equipment_ID_parent": "",
"location": "Cave",
"gpsLongitude": "",
"gpsLatitude": "",
"gpsAccuracy": "",
"gpsUpdateDate_fixed": "",
"gpsManual": "",
"baseuser_ID_favoriteTechnician": "",
"installationDate": "2020-08-04 00:00:00",
"equipmentstatus_ID": "BEING_CREATED",
"customerReference": "",
"brand": "",
"maker": "",
"inServiceDate": "",
"terminationDate": "",
"replacementDate": "",
"product_ID": "",
"quantityRepresented": "1",
"orderheader_ID": "",
"externalID": "DTR 1 C1",
"equipmentkind_ID": "DEFAULT",
"useModuleCold": "0"
} |
verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables equipmenttype, equipmentkind, equipment_parent, baseuser_favoriteTechnician, equipmentstatus et product
...
Bloc de code | ||
---|---|---|
| ||
"equipment": { ... }, "contracts": [ { "codecontract": "2950000000014", "label": "Contrat maintenance", "contractNumber": "CONTRACT_000057", "startDate": "2020-07-13 00:00:00", "endDate": "" }, { ... }], "warranties": [ { "codeequipmentwarranty": "5550000000022", "equipmentwarrantytype_ID": "Garantie classique", "startDate": "2020-05-18 16:20:05", "endDate": "2021-05-18 16:20:05", "partIncluded": "0", "workIncluded": "0", "travelIncluded": "0" }, { ... }], "modulecoldequipmentcharacteristic": [ { "codemodulecoldequipmentcharacteristic": "6510000000002BAL01-201910", "modulecoldfluidnature_ID": "Nature-Fluide 01", "coolingCapacity": "2", "hasAutoLeakDetector": "0" } ] |
...
Bloc de code | ||
---|---|---|
| ||
{ "equipment": { "codeequipment": "BAL01-201910", /* Code globalement unique de l'équipement (Varchar (255))*/ "equipmentkind_ID": "DEFAULT", /* Code du genre d'équipement (ForeignKey () - sw_data_equipmentkind.codeequipmentkind)*/ "equipmenttype_ID": "BALL", /* Code du type d'équipement (ForeignKey () - sw_data_equipmenttype.codeequipmenttype)*/ "description": "Ballon 300 litres", /* Description de l'équipement (Text (65535))*/ "serialNumber": "BAL-169-2", /* N° de série (Varchar (64))*/ "equipment_ID_Parentparent": null, /* Code de l'équipement parent (nécessite que le parent a été créée avant celui-ci) (ForeignKey () - sw_data_equipment.codeequipment)*/ "location": "Cave", /* Localisation sur le site (Varchar (255))*/ "equipmentstatus_ID": "BEING_CREATED", /* Statut de l'équipement (ForeignKey () - sw_data_equipmentstatus.codeequipmentstatus)*/ "customerReference": null, /* Référence chez le client (Varchar (64))*/ "brand": "", /* Marque (Varchar (255))*/ "maker": "", /* Constructeur (Varchar (255))*/ "installationDate": "2020-08-04", /* Date d'installation (DateTime ())*/ "inServiceDate": null, /* Date de mise en service (DateTime ())*/ "terminationDate": null, /* Date de fin d'existence (DateTime ())*/ "replacementDate": null, /* Date de remplacement (DateTime ())*/ "product_ID": null, /* Code article (ForeignKey () - sw_data_product.codeproduct)*/ "quantityRepresented": "1", /* Quantité représentée (Int ())*/ "externalID": "DTR 1 C12", /* Origine externe (Varchar (64))*/ "internalcodeequipmentuseModuleCold": null"0", /* codeequipmentUtilise originalle demodule weavyfroid pour transcodage (Valeurs possibles : 0,1) (Bool ())*/ "internalcodeequipment": null, /* codeequipment original de weavy pour transcodage (Varchar (255))*/ /* Optionnel : pour mettre à jour les champs dynamiques selon paramétrage */ /* Exemple 1 : */ "dynamicfields": [{ "fieldname": "MATPRIX", "fieldvalue": "45.12" }, { "fieldname": "MATCODE", "fieldvalue": "Nickel" }, { ... }] /* 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_MATPRIX": "45.12", "v_MATCODE": "Nickel", ... }, "equipmentaddress": { "codeequipmentaddress": "BAL01-201910-SITE", /* Code globalement unique de l'adresse de l'équipement (Varchar (255))*/ "equipment_ID": "BAL01-201910", /* Code de l'équipement. Reprendre le code équipement du bloc json "equipment" (ForeignKey () - sw_data_equipment.codeequipment)*/ "customeraddress_ID" : "C0000001-BDX", /* Code adresse client (ForeignKey () - sw_data_customeraddress.codecustomeraddress)*/ "startDate": "2019-10-26", /* Date de début (DateTime ())*/ "endDate": null, /* Date de fin (DateTime ())*/ "internalcodeequipmentaddress": null /* codeequipmentaddress original de weavy pour transcodage (Varchar (255))*/ }, "modulecoldequipmentcharacteristic": [ { /* Une seule caratéristique froid pour un équipement */ "modulecoldequipmentcharacteristic": [ { "codemodulecoldequipmentcharacteristic" : "stringBAL01-201910", //Unique code* Code globalement unique de la caractéristique froid de l'équipement (Varchar (255))*/ "modulecoldfluidnature_ID": "stringNATURE01", //* Code nature de fluide (ForeignKey () - sw_data_modulecoldfluidnature.codemodulecoldfluidnature)*/ "coolingCapacity": "number2", //(Int* Capacité de refroidissement (Double ())*/ "hasAutoLeakDetector": "0" /* A "hasAutoLeakDetector": "boolean" //un détecteur de fuite automatique (Valeurs possibles : 0,1) (Bool ())*/ } ] } |
verb: LIST
resultType: simple, extended reprendre les définitions du GET
Bloc de code | ||
---|---|---|
| ||
"filters:" { "codeEquipment": "value", filter is equal "description": "value", filter is contains "serialNumber": "value", filter is equal "equipmentType": "value", filter is equal "equipmentKind": "value", filter is equal "codeCustomerAddress": "value", filter is equal "codeEquipmentStatus": "value", filter is equal "equipmentNotClosed": "value", filter is codeEquipmentStatus <> 'DELETED' and (terminationDate is null OR terminationDate >= value) "useModuleCold": "value", filter is equal (if value = "1" return only equipments that use cold characteristics) }, "orderBy": "value" |
Valeurs possibles pour le tri "orderBy" :
...