"data":   
[{
    "xxxxx":
    {
        "codexxxxx": "value", // optional
        "field1": "value",
        "field2": "value",
        ....
    }
},
{
    "xxxxx":
    {
        "codexxxxx": "value", // optional
        "field1": "value",
        "field2": "value",
        ....
    }
},
{
    ....
}]

"data":
{
    "xxxxx":
    {
        "codexxxxx": "value",
        "field1": "value",
        "field2": "value",        
        ....
        "internalcodexxxxx" : "value" 
    }
}

"action":
{
    "verb": "DELETE"
    "parameters": 
    {
        "code": code of the record to delete (mandatory)
        "deleteType": 
          "logical": no real delete in db (by default - not implemented at time)
          "physical": real delete, possible if record is not referred to elsewhere
          "simulation": simulate the delete (can be used to know in advance if a record can be deleted)
    }
} 

"action":
{
    "verb": "GET"
    "parameters": 
    {
        "code": code of the record to get (mandatory)
        "resultType":
          "simple" : main info of the record (by default)
          "extended": all columns of the record 
          "extendedRelated": all columns of the record + given context (one entity per foreign key)
        "settings": 
        {
            // depends of the webhook (optional)
        }
    }
}

"action":
{
    "verb": "LIST" 
    "parameters": 
    {
        "listType": 
          "simple": main info of the record (by default), the columns are determined by each webhook
          "extended": all columns of the record 
          "extendedRelated": not used for verb="LIST"  
        "pageNumber": "xx" // used to read the page of the records list, 1 page = 10 records (optional, default pageNumber is 1)
                          You can read the list page per page until maxPageNumber (result of maxPageNumber given in the "response")   
        "settings": 
        {
            // depends of the webhook (optional)
        }
        "filters":              
        {
            // depends of the webhook (optional), each filter added will result is an AND in the query
            // For a filter operator "equal" it is possible to give more values separated by "|" (ie "email": "email1|email2|email3")
            // For a filter operator "equal" it is possible to give the value "null" who will be transformed in "IS NULL"
        }
        "logicalorderBy" : no real delete in db (by default - not implemented at time)
      "physical": real delete, possible if record is not referred to elsewhere"value" // depends of the webhook (optional), order the returned records (for example webhook event, the value can be "eventDateDesc" to order the records by event date descending)
        "simulation": simulate the delete (can be used to know in advance if a record can be deleted)topRows": "xx" // limit the returned records (optional)
    }
}

{
    "label": "Webhook xxx", //name of the called webhook
    "codeScript": "Webhookxxx", //script called by the webhook
    "resultType": "JSON",
    "result":
    {
        "simplecommon":
main  info of the record (by default), the{
columns are determined by each webhook       "extendedresultCode": all columns of the record 
      "extendedRelated": not used for verb="LIST""0", // 0 if ok otherwise specific error of the webhook
            "pageNumbererrorMessage": "xx" // usedif toresultCode read<> the0, pagetext of the error in english
 records list, 1 page = 10 records (optional},
default pageNumber is 1)     "response":
        {
            You// candepends readof the listwebhook
page per page until maxPageNumber (result of maxPageNumber given}
in the "response")  },
    "settingsstatistics": 
    {
        "durationMs": xx, // dependsduration of theexecution webhooktime
(optional)    }    "filters":consumedTimeOnDatabaseMs": xx, // DB time used
        "selectQueryCount": xx, // number of select query done
  {      "insertQueryCount": xx, // dependsnumber of insert thequery webhookdone
(optional), each filter added will result is an AND in the query
   "updateQueryCount": xx, // number of update query done
   // For a filter operator "equal" it is possible to give more values separated by "|" (ie "email": "email1|email2|email3")deleteQueryCount": xx, // number of delete query done
        "readTokenCount": xx, 
    }    "orderByexecutedFunctionCount" : "value"xx, // dependsnumber of function thecalled
webhook (optional), order the returned records (for example webhook event"translatorHitCount": xx, the// valuenumber canof be "eventDateDesc" to order the records by event date descending)translations done
        "topRowslanguageHitCount": "xx" // limit the returned records (optional) 
    }    
}

"result": 
{
    "resultresults": 
    [{
        "common": 
        {
            "resultCode": "0", // 0 if ok otherwise specific error of the webhook
            "errorMessage": "" // if resultCode <> 0, text of the error in english
        },
        "response":
        {
            // depends of the error in webhookenglish
        },
    },     "statisticsresponse": 
    {         "durationMs": xx, // duration of execution time{
              "consumedTimeOnDatabaseMsmaxElementAtOnce": xx,"10" // DBmax timeelements usedthat can be passed at once
   "selectQueryCount": xx, // number of select query done
        "insertQueryCountdata": xx, //
number of insert query done        [{
"updateQueryCount": xx, // number of update query done         "deleteQueryCountaction": xx"value", // number of delete query done inserted or updated
                "readTokenCountxxxxx_ID": xx"value", // with xxxxx = table and value is  "executedFunctionCount": xx, // number of function calledID created/updated
                "translatorHitCountcodexxxxx": xx,"value" // numberwith of translationsxxxx done= table and value is code created/updated
  "languageHitCount": xx      }   }]
 }

"response": 
{
        "data": 
            [{
       
        "action": "valuedeleted",
// inserted or updated }]
   }

"response":
{
           "xxxxx_ID"data":
"value", // with xxxxx = table and value is ID created/updated
          [{ 
        // depends of the webhook
    }],
    "codexxxxxfieldList": "value"
// with xxxx = table[{
and value is code created/updated    "entityName": "value", // name of the entity (ie intervention)
}]        "fields":
  }     }, [{
   {         "commonfieldName": "value", // name of the field (ie codeintervention, customer_ID, …)
{             "resultCodefieldType": "0value", // type of the field : varchar, text, int, double, bool,  "errorMessage": ""datetime, timestamp, foreignkey
        },
        "responsefieldLength": "value", // length of the field : informed for {varchar, text
            "maxElementAtOncefieldLabel": "10value" // max elements that can be passed at once
            "data":label of the field : depends on the value of the languageCode from the header (default : FR)
        },
    [{    {
            "actionfieldName": "value",
                "xxxxx_ID"fieldType": "value",
                "codexxxxxfieldLength": "value",
            }]"fieldLabel": "value"
        },
     },   {
  {          ...
    }]
}

"response":
{
     "fieldNamemaxPageNumber": "value",
   xx, // number of pages of records
    "fieldTypepageSize": "value"10, // number of records per page
    "fieldLengthdata":
"value",    [{ 
         "fieldLabel": "value"
 // depends of the webhook
    }],
    "fieldList": 
{    [{
    ...       }]"entityName": "value", // name of the entity  "related": // for listType = "extendedRelated"(ie intervention)
        "fields":
  [{      [{
  "entityName": "value",         "fieldsfieldName": "value", // name of the field (ie  [{
codeintervention, customer_ID, …)
         ...   "fieldType": "value", // type of the }]field : varchar, text, int, double, bool, }datetime, timestamp,  foreignkey
   {         "entityNamefieldLength": "value", // length of the field : informed  "fields":for varchar, text
            "fieldLabel":  [{
          ...
        }]"value" // label of the field : depends on the value of the languageCode from the header (default : FR)
        },
      {  {
      ...      "fieldName": "value",
 }]     }]    

"response":
{
    "fieldsdata":
 
    [{ 
        "fieldNamefieldName1":
"value", // name of the field (ie codeintervention, customer_ID, …)        [{
            "fieldTypecode": "value",
//   type of the field : varchar, text, int, double, bool, datetime, timestamp, foreignkey "label": "value"
        },
 "fieldLength": "value", // length of the field :{
informed for varchar, text         "fieldLabelcode": "value",
// label of the field : depends on the value of the languageCode from the header (default : FR)"label": "value"
        },
  },      {
{         "fieldName": "value",  ...
      "fieldType": "value", }
       "fieldLength": "value" }],
        "fieldLabel": "value"
      },fieldName2":
        [{
        ...    "code": "value",
 }],     }]