WebhookDefinitionOverload_xxx

// WebhookDefinitionOverload_xxx
// @Description             =>  Overload webhook definition

languageCode     = VARGET_SHELL( "languageCode", "WebhookDefinition" )

specificOverload = TRANSLATE( "
  {
    'extendedFieldsListToExclude': '',
    'simpleFieldsList': '',
    'relatedTablesCount': '',
    'relatedTables': [],
    'authorizedTables': [],
    'cascadeDeleteTables': [],
    'fieldsList': {
    
    },
    strictFilters: [
      
    ],
    'strictOrderBy': [
      
    ],
    'outOfMainTableFields': [
      
    ]
  }
" )
RETURN( "<varscript>specificOverload</varscript>" )

'extendedFieldsListToExclude': 'field1,field2,field3,...'

'extendedFieldsListToExclude': 'serialnumber,location'

'simpleFieldsList': 'field1,field2,field3,...'

'simpleFieldsList': 'codecustomer,name,city,final_pricecategory_ID_tarCod'

'relatedTablesCount': xx,
'relatedTables': ['fieldFK1', 'fieldFK2', '...']

'relatedTablesCount': 4,
'relatedTables': ['generictype_ID_customerFamily', 'baseuser_ID', 'generictype_ID_country', 'final_pricecategory_ID_tarCod']

'relatedTablesCount': 2,
'relatedTables': ['generictype_ID_customerFamily', 'final_pricecategory_ID_tarCod']

'authorizedTables': [{'tableName':'mainTableName'}, {'tableName':'additionalTableName1'}, {'tableName':'additionalTableName2'}, {'tableName':'....'}]

'authorizedTables': [{'tableName':'intervention'}, {'tableName':'interventionequipment'}, {'tableName':'interventionpart'}, {'tableName':'interventionoperationrange'}]

'cascadeDeleteTables': [{'tableName':'tableName1'}, {'tableName':'tableName2'}, {'tableName':'...'}]

'cascadeDeleteTables': [{'tableName':'interventionequipment'}, {'tableName':'interventionpart'}, {'tableName':'interventionoperationrange'}],

'fieldsList': {
      'field1': {
          'type': '…',
          'length': '…',
          'label': '…',
          'targetTableName': '…',
          'targetFieldName': '…',
          'fieldNameToShow': '…',
          'alias': '…',
          'mandatory': 0 or 1,
          'cannotBeNull': 0 or 1,
          'canGet': 0 or 1,
          'canInsert': 0 or 1,
          'canUpdate': 0 or 1,
          'deprecated': 0 or 1,
          'foreignParent': '…'		
      },
      'field2': {
          'type': '…',
          'length': '…',
          'label': '…',
          'targetTableName': '…',
      	  'targetFieldName': '…',
	  	  'fieldNameToShow': '…',
	      'alias': '…',
          'mandatory': 0 or 1,
          'cannotBeNull': 0 or 1,
          'canGet': 0 or 1,
          'canInsert': 0 or 1,
          'canUpdate': 0 or 1,
          'deprecated': 0 or 1,
	      'foreignParent': '…'
      },
      'field3': {
          'type': '…',
          'length': '…',
          'label': '…',
          'targetTableName': '…',
      	  'targetFieldName': '…',
	      'fieldNameToShow': '…',
	      'alias': '…',
          'mandatory': 0 or 1,
          'cannotBeNull': 0 or 1,
          'canGet': 0 or 1,
          'canInsert': 0 or 1,
          'canUpdate': 0 or 1,
          'deprecated': 0 or 1,
	      'foreignParent': '…'
      }
      … 
},
'outOfMainTableFields': [
{
    'fieldName': '…',
    'tableName': '…'
}
],

"response":
  {
    "data":
      [{ depends of the webhook}],

    "fieldList": 
    [{
      "entityName": "value", // name of the table (ie intervention)
      "fields":
      [{
        "fieldName": "value", // name of the field (ie codeintervention, customer_ID, …)
        "fieldType": "value", // type of the field : varchar, text, int, double, bool, datetime, timestamp, foreignkey
        "fieldLength": "value", // length of the field : informed for varchar, text
        "fieldLabel": "value" // label of the field : depends on the value of the languageCode from the header (default : FR)
      },
      {
        "fieldName": "value",
        "fieldType": "value",
        "fieldLength": "value",
        "fieldLabel": "value"
      },
      {
        ...
      }],
      "related":
      [{
        "entityName": "value",
        "fields":
        [{
          ...
        }]
      },
      {
        "entityName": "value",
        "fields":
        [{
          ...
        }]
      },
      {
        ...  
      }]
    }]

'fieldsList': {
    'final_pricecategory_ID_tarCod': {
        'mandatory': 1,
        'cannotBeNull': 1
    }
}

"result": {
  "common" : {
    "resultCode": "1",
    "errorMessage": "Data Error: final_pricecategory_ID_tarCod is required" 
  }
}

"result": {
  "common" : {
    "resultCode": "1",
    "errorMessage": "Data Error: Value of final_pricecategory_ID_tarCod cannot be null" 
  }
}

'fieldsList': {
    'serialnumber': {
        'canGet': 0
    },
    'location': {
        'canGet': 0
    }
}

'fieldsList': {
    'CodeCustomer': {
        'fieldNameToShow': 'Code du client' 
    },
    'name': {
        'fieldNameToShow': 'Nom du client' 
     },	
    'baseuser_ID': {
        'fieldNameToShow': 'Utilisateur lié au client' 
    }
}

"customer": {
  "codecustomer" : "C0000001",
  "name": "ENTREPRISE DIJON GUICHARD" 
  "baseuser_ID" : "DUPREZ - Secteur Ouest GRO",

"customer": {
  "Code du client" : "C0000001",
  "Nom du client": "ENTREPRISE DIJON GUICHARD" 
  "Utilisateur lié au client" : "DUPREZ - Secteur Ouest GRO",

'fieldsList': {
    'baseuser_ID': {
        'targetFieldName': 'codebaseuser'
    }
}

'fieldsList': {
    'baseuser_ID': {
        'targetFieldName': 'initials'
    }
}

"baseuser_ID" : "DUPREZ - Secteur Ouest GRO",

"baseuser_ID" : "GRO-OUEST",

"baseuser_ID" : "DEMO",

'fieldsList': {
    'final_pricecategory_ID_tarCod': {
        'targetTableName': 'sw_data_pricecategory',
        'targetFieldName': 'CodePricecategory'
    }
}

'fieldsList': {
    'final_pricecategory_ID_tarCod': {
        'targetTableName': 'sw_data_pricecategory',
        'targetFieldName': 'label'
    }
}

"final_pricecategory_ID_tarCod" : "TC",

"final_pricecategory_ID_tarCod" : "Prix public TTC",

'fieldsList': {
    'final_t035_ID': {
        'targetFieldName': 'final_lib'
    }
}

'extendedFieldsListToExclude': "divinf_t035_ID"

"final_t035_ID" : "RG",

"final_t035_ID" : "Remise grossiste générale",

'fieldsList': {
    'customer_ID': {
        'foreignParent': 'customeraddress_ID',
        'targetFieldName': 'codecustomer'
    },
},
'outOfMainTableFields': [
{
    'fieldName': 'customer_ID',
    'tableName': 'sw_data_customeraddress'
}
]

"customer_ID" : "C0000001",

'fieldsList': {
    'customer_ID': {
        'foreignParent': 'customergroup_ID',
        'targetFieldName': 'siretNumber',
	'fieldNameToShow' : 'N° siret client principal'
    },
},
'outOfMainTableFields': [
{
    'fieldName': 'customer_ID',
    'tableName': 'sw_data_customergroup'
}
]

"N° Siret du client principal" : "1234567899988",

'fieldsList': {
    'name': {
        'type': 'Char',
        'length': '111',
        'label': 'Le nom de mon client'
    }

"fields": [
  {
    "fieldName" : "name",
    "fieldType": "varchar" 
    "fieldLength" : "255",
    "fieldLabel" : "Nom",
  }
]

"fields": [
  {
    "fieldName" : "name",
    "fieldType": "char" 
    "fieldLength" : "111",
    "fieldLabel" : "Le nom de mon client",
  }
]

'fieldsList': {
      'name': {
        'label': '<lng>sw_data_customer_contactName|<varscript>languageCode</varscript></lng>'
      }

"fields": [
  {
    "fieldName" : "name",
    "fieldType": "varchar" 
    "fieldLength" : "255",
    "fieldLabel" : "Nom du contact",
  }
]

'fieldsList': {
      'name': {
        'label': '<lng>sw_data_customer_contactName|DE</lng>'
      }

"fields": [
  {
    "fieldName" : "name",
    "fieldType": "varchar" 
    "fieldLength" : "255",
    "fieldLabel" : "Kontaktname",
  }
]

'fieldsList': {
      'generictype_ID_country': {
        'type': 'foreignkey-varchar',
        'length': '255'
      }

"fields": [
  {
    "fieldName" : "generictype_ID_country",
    "fieldType": "foreignkey" 
    "fieldLength" : "",
    "fieldLabel" : "Pays",
  }
]

"fields": [
  {
    "fieldName" : "generictype_ID_country",
    "fieldType": "foreignkey-varchar" 
    "fieldLength" : "255",
    "fieldLabel" : "Pays",
  }
]

'fieldsList': {
    'name': {
        'alias': 'Nom_du_client'
    },
    'postalCode': {
        'alias': 'Code_Postal'
    },
    'city': {
        'alias': 'Ville'
    },
    'phoneNumber': {
        'alias': 'Num_Telephone'
    }
}

"action": 
[
  "verb": "PUT"
},
"data":
{
  "customer" :
  {
    "name" : "ENTREPRISE DIJON GUICHARD",
    "postalCode": "21000" 
    "city" : "DIJON",
    ...

"action": 
[
  "verb": "PUT"
},
"data":
{
  "customer" :
  {
    "Nom_du_client" : "ENTREPRISE DIJON GUICHARD",
    "Code_Postal": "21000" 
    "city" : "DIJON",
    ...

'fieldsList': {
    'final_pricecategory_ID_tarCodInternal': {
        'canInsert': 0,
        'canUpdate': 0
    }
}

'fieldsList': {
    'final_test_ID': {
        'deprecated': 1
    }
}

'fieldsList': {
    'final_pricecategory_ID_tarCodInternal': {
        'canGetDefinitionList': 1,
    }
}

"final_pricecategory_ID_tarCodeInternal": [
  {
    "code": "99",
    "label": "Prix particulier"
  },
  {
    "code": "GR",
    "label": "Grossiste"
  },

'fieldsList': {
    'final_pricecategory_ID_tarCodInternal': {
        'canGetDefinitionList': 1,
        'definitionExtraFields': [
        {
          'fieldName': 'tarifPart',
          'fieldNameToShow': 'tarif particulier' 
        }
        ]
    }
}

"final_pricecategory_ID_tarCodeInternal": [
  {
    "code": "99",
    "label": "Prix particulier",
    "tarif particulier": "1"
  },
  {
    "code": "GR",
    "label": "Grossiste",
    "tarif particulier": "0"
  },

'fieldsList': {
    'final_pricecategory_ID_tarCodInternal': {
        'canGetDefinitionList': 1,
        'definitionExtraFields': [
        {
          'fieldName': 'tarifPart',
          'fieldNameToShow': 'tarif particulier' 
        },
        {
          'fieldName': 'generictype_ID_tarifType',
          'targetFieldName': 'originalCode' 
        }
        ]
    }
}

"final_pricecategory_ID_tarCodeInternal": [
  {
    "code": "99",
    "label": "Prix particulier",
    "tarif particulier": "1",
    "generictype_ID_tarifType": "PART"
  },
  {
    "code": "GR",
    "label": "Grossiste",
    "tarif particulier": "0",
    "generictype_ID_tarifType": "STD"
  },

'fieldsList': {
    'final_pricecategory_ID_tarCodInternal': {
        'canGetDefinitionList': 1,
        'definitionFilter': 'tarifPart = 0'
    }
}

'strictFilters': [
{
    'fieldName': '…',
    'operator': '…',
    'targetField': '…',
    'query': '…'    	
},
{
    'fieldName': '…',
    'operator': '…'
    'targetField': '…',
    'query': '…'
},
{
    ...
}
]

'strictFilters': [
{
    'fieldName': 'phoneNumber',
    'operator': 'Equal'
}
]

"filters": 
{
  "phoneNumber": "02 31 14 50 00"
}

'strictFilters': [
{
    'fieldName': 'vacationEnd',
    'operator' : Equal
},
{
    'fieldName': 'vacationEndBetween',
    'operator' : 'Between',
    'targetField': 'vacationEnd'
} 
]

"filters": 
{
  "vacationEnd": "2020-08-30"
}

"filters": 
{
  "vacationEndBetween": "2020-08-01|2020-08-30"
}

strictFilters: [
{
    'fieldName': 'final_pricecategory_ID_tarCod',
    'operator': 'In',
    'targetField': 'customer_ID',
    'query': '( SELECT customer_ID 
              FROM sw_data_customer AS c 
              INNER JOIN sw_data_pricecategory AS pc 
              ON pc.pricecategory_ID = c.final_pricecategory_ID_tarCod 
              WHERE pc.codepricecategory = %valueToBeReplaced% )'
}
]

"filters": 
{
  "final_pricecategory_ID_tarCod": "TC"
}

strictFilters: [
{
    'fieldName': 'final_t035_ID',
    'operator': 'In',
    'targetField': 'customer_ID',
    'query': '( SELECT customer_ID 
              FROM sw_data_customer AS c 
              INNER JOIN sw_data_final_t035 AS t035 
              ON t035.final_t035_ID = c.final_t035_ID 
              WHERE t035.codefinal_t035 = %valueToBeReplaced% )'
}
]

"filters": 
{
  "final_t035_ID": "RG"
}

strictFilters: [
{
    'fieldName': 'v_A101',
    'operator': 'GreaterOrEqual'
}
]

"filters": 
{
  "v_A101": "1000"
}

'strictFilters': [
{
    'fieldName': 'locationCodeCustomerAddressAndDate',
    'operator': 'In',
    'targetField': 'equipment_ID',
    'query': '( SELECT e.equipment_ID 
              FROM sw_data_equipment AS e 
              INNER JOIN sw_data_equipmentaddress AS ea ON ea.equipment_ID = e.equipment_ID 
              INNER JOIN sw_data_customeraddress AS ca ON ca.customeraddress_ID=ea.customeraddress_ID 
              WHERE ca.codecustomeraddress = %valueToBeReplaced1% 
              AND (ea.startDate IS NULL OR ea.startDate <= %valueToBeReplaced2%) 
              AND (ea.endDate IS NULL OR ea.endDate >= %valueToBeReplaced2%) )'
}
]

"filters": 
{
  "locationCodeCustomerAddressAndDate": "1347&2024-05-04 07:06:36"
}

'strictOrderBy': [
{
    'name': '...',
    'fields': [
    {
        'table': '...'
        'field': '...',
        'order': '...'
    },
    {
        'table': '...'
        'field': '...',
        'order': '...'
    },
    {
        ...
    }]
},
{
    'name': '...',
    'fields': [
    {
        'table': '...'
        'field': '...',
        'order': '...'
    },
    {
        ...
    }]        
}]

'strictOrderBy': [
{
    'name': 'postalCodeAscCityAsc',
    'fields': [
    {
        'field': 'postalCode',
        'order': 'asc'
    },
    {
        'field': 'city',
        'order': 'asc'
    }]
}]

"orderBy": "postalCodeAscCityAsc"

'strictOrderBy': [
{
    'name': 'vacationEndDescNameASc',
    'fields': [
    {
        'field': 'vacationEnd',
        'order': 'desc'
    },
    {
        'field': 'name',
        'order': 'asc'
    }]
}]

"orderBy": "vacationEndDescNameASc"

'strictOrderBy': [
{
    'name': 'CapitalDesc',
    'fields': [
    {
        'field': 'v_A101',
        'order': 'desc'
    }]
}]

"orderBy": "CapitalDesc"

 'strictOrderBy': [
{
    'name': 'codePriceCategoryAscNameAsc',
    'fields': [
    {
        'table': 'pricecategory',
        'field': 'codepricecategory',
        'order': 'asc'
    },
    {
        'field': 'name',
        'order': 'asc'
    }]
}

"orderBy": "codePriceCategoryAscNameAsc"

 'strictOrderBy': [
{
    'name': 'codeCountryAscNameAsc',
    'fields': [
    {
        'table': 'generictype_country',
        'field': 'originalCode',
        'order': 'asc'
    },
    {
        'field': 'name',
        'order': 'asc'
    }]
}

"orderBy": "codeCountryAscNameAsc"

// WebhookRulesOverload_xxxx
// @description     => Overload rules with yours. Return a response and a errorMessage if needed.
//
// @code            => Row code. Not exploited at the moment.
// @verb            => Method used. Can be PUT | GET | LIST | DELETE
// @dataInput       => Depending of the method. Contains json for the PUT method. Only PUT contain data.
// @ruleFields      => Empty Object
//                     Can be filled like this : DOCUMENT_ADD_PROPERTY_TO_OBJECT( ruleFields, "nameOfDataInput", yourNewValue )
//
// @returns         => Response JSON document with two properties :
//                     response [ required ] => 1 if all rules are valid or 0 IF at least one rule is not valid
//                     errorMessage [ optional ] => if response equal to 0, THEN we display your errorMessage

code       = TRANSLATE( "<varscript>arg1</varscript>" )
verb       = TRANSLATE( "<varscript>arg2</varscript>" )
dataInput  = TRANSLATE( "<varscript>arg3</varscript>" )
ruleFields = TRANSLATE( "<varscript>arg4</varscript>" )

jsonResponse = DOCUMENT_CREATE_DOCUMENT()

// To complete
…

response = DOCUMENT_SERIALIZE( jsonResponse, "json" )
RETURN( response )

DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "response", "1" )

response = DOCUMENT_SERIALIZE( response, "json" )
RETURN( response )

DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "response", "0" )
DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "errorMessage", "Specific rule error: …" )
      
response = DOCUMENT_SERIALIZE( jsonResponse, "json" )
RETURN( response )

IF( EQUALS( method, "PUT" ) )THEN
  jsonCustomer = JSON_GET_FROM_PATH( dataInput, "customer" )
  
  IF ( JSON_EXISTS_FROM_PATH( jsonCustomer, "generictype_ID_customerType" ) ) THEN
    generictype_ID_customerType =  JSON_GET_FROM_PATH( jsonCustomer, "generictype_ID_customerType" )
    
    IF( EQUALS( generictype_ID_customerType , "CUSTOMER_TYPE-CTP" ) == 0 )THEN
      DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "response", "0" )
      DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "errorMessage", "Specific rule error: Le type doit être prospect (Valeur envoyée : <varscript>generictype_ID_customerType</varscript>)" )
      
      response = DOCUMENT_SERIALIZE( jsonResponse, "json" )
      RETURN( response )
    ENDIF
  ENDIF
   
ENDIF

"result": {
  "common": {
    "resultCode": "1",
    "errorMessage": "Specific rule error: Le type doit être prospect (Valeur envoyée : CUSTOMER_TYPE-CTC)"
  },

"data": {
  "customer": {
    "codecustomer": "C0000001",
    "name": "ENTREPRISE DIJON GUICHARD",
    
    "dynamicfields":
    [{
      "fieldname":"CLI40",
      "fieldvalue": "8"
    },
    {
      "fieldname":"CLI50",
      "fieldvalue": "6"
    }]	
  }
}
IF( EQUALS( method, "PUT" ) )THEN
  jsonCustomer = JSON_GET_FROM_PATH( dataInput, "customer" )
  
  IF ( JSON_EXISTS_FROM_PATH( jsonCustomer, "dynamicfields" ) ) THEN
    jsonDynamicFields = JSON_GET_FROM_PATH( jsonCustomer, "dynamicfields" )
    
    VARSET_SHELL( "errorMessage", "", "FINAL_RulesDynamicFields" )
    EXECUTE_SCRIPT_FOREACH_ROW( "FINAL_WebhookRulesDynamicFields_customer", "json", jsonDynamicFields )
    
    errorMessage = VARGET_SHELL( "errorMessage", "FINAL_RulesDynamicFields" )
    IF (LEN( "<varscript>errorMessage</varscript>" ) > 0) THEN
        error = 1
        DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "response", "0" )
        DOCUMENT_ADD_PROPERTY_TO_OBJECT( jsonResponse, "errorMessage", "Specific rule error: <varscript>errorMessage</varscript>" )
    ENDIF
  
    VARDELGROUP_SHELL( "FINAL_RulesDynamicFields" )

    IF EQUALS( "<varscript>error</varscript>", "1" ) THEN
      response = DOCUMENT_SERIALIZE( jsonResponse, "json" )
      RETURN( response )
    ENDIF
  ENDIF
ENDIF

IF EQUALS( "<varscript>fieldName</varscript>", "CLI50" )THEN
  IF( EQUALS( "<sql>SELECT '<varscript>fieldValue</varscript>' < 8 </sql>", "1" ) ) THEN
    VARSET_SHELL( "errorMessage", "La note administrative du client est inférieure à 8 (champ : <varscript>fieldName</varscript>, valeur envoyée : <varscript>fieldValue</varscript>)", "FINAL_RulesDynamicFields" )    
  ENDIF
  RETURN("breakforeach")
ENDIF

"result": {
  "common": {
    "resultCode": "1",
    "errorMessage": "Specific rule error: La note administrative du cl, valeur envoyée 6)""
  },

IF( EQUALS( method, "PUT" ) )THEN
  jsonCustomer = JSON_GET_FROM_PATH( dataInput, "customer" )
  VARINITIALIZE_SCRIPT_BYJSON( jsonCustomer )
  
  msg = ""
  IF( LEN( "<varscript>apeCode</varscript>" ) == 0 )THEN
    msg = CONCAT( msg, "*** Code APE" )
  ENDIF
  IF( LEN( "<varscript>phoneNumber</varscript>" ) == 0 )THEN
    msg = CONCAT( msg, "*** Téléphone" )
  ENDIF
  IF( LEN( "<varscript>generictype_ID_country</varscript>" ) == 0 )THEN
    msg = CONCAT( msg, "*** Pays" )
  ENDIF

  IF( LEN( "<varscript>msg</varscript>" ) > 0 )THEN
    msg = CONCAT ( "Informations nécessaires à renseigner dès que possible : ", msg ) 
  ENDIF

  DOCUMENT_ADD_PROPERTY_TO_OBJECT( ruleFields, "comment", msg)
END IF

contractID = CALL_SCRIPT( "FINAL_GetContract4Customer", "<varscript>customer_ID</varscript>" ) // script for example who return a contract id
contractCode = CALL_SCRIPT( "Func_GetCodeFromID", "sw_data_contract", "<varscript>contractID</varscript>" )

DOCUMENT_ADD_PROPERTY_TO_OBJECT( ruleFields, "final_contract_ID_default", "<varscript>contractCode</varscript>" )

// WebhookOverload_Before
// @Description             => A script to use before webhook execution
//
// @tableName               => Name on wich table webhook will proceed
// @code                    => Row code. Can be empty depending of the method. It is empty for LIST || PUT.
//                             GET: contains code link to the row to be returned
//                             DELETE: contains code link to the row to be deleted
// @method                  => Method used. Can be GET || LIST || PUT || DELETE
// @headerInput             => Header input
// @dataInput               => Data input. Can be empty depending of the method. It is empty for GET || LIST || DELETE.
//                             PUT: contains data to be inserted
// @resultCode              => If webhook execution will fail, resultCode is equal to 0. Otherwise, 1.
// @errorMessage            => Error message associated to the code
// @verifiedData            => An object that contains all data. IF others arguments are not enough
// @entity                  => To be used to differenciate between webhooks using the same table
//
// @Returns                 => Void
 
tableName     = TRANSLATE( "<varscript>arg1</varscript>" )
code          = TRANSLATE( "<varscript>arg2</varscript>" )
method        = TRANSLATE( "<varscript>arg3</varscript>" )
headerInput   = TRANSLATE( "<varscript>arg4</varscript>" )
dataInput     = TRANSLATE( "<varscript>arg5</varscript>" )
resultCode    = TRANSLATE( "<varscript>arg6</varscript>" )
errorMessage  = TRANSLATE( "<varscript>arg7</varscript>" )
verifiedData  = TRANSLATE( "<varscript>arg8</varscript>" )
entity        = TRANSLATE( "<varscript>arg9</varscript>" )

// For specific case, markForExport property can be changed here.
// To do it, a variable is available
// VARSET_SHELL( "markForExport", "Can be 0, 1, 2", "WebhookHeader" )

// IF resultCode = 0, THEN all data are empty, except errorMessage.
IF( EQUALS( resultCode, "1" ) )THEN
  
ENDIF

dataInput = REPLACE("<varscript>dataInput</varscript>",";",",")

msg = "message="
msg = CONCAT( msg, "tableName = <varscript>tableName</varscript>-" )
msg = CONCAT( msg, "code = <varscript>code</varscript>-" )
msg = CONCAT( msg, "method = <varscript>method</varscript>-" )
msg = CONCAT( msg, "headerinput = <varscript>headerinput</varscript>-" )
msg = CONCAT( msg, "datainput = <varscript>datainput</varscript>-" )
msg = CONCAT( msg, "resultcode = <varscript>resultcode</varscript>-" )
msg = CONCAT( msg, "errormessage = <varscript>errormessage</varscript>" )
msg = CONCAT( msg, "entity= <varscript>entity</varscript>" )

VARADD_DB( "sw_data_final_log", msg )

// WebhookOverload_After
// @Description             => A script to use after webhook execution
//
// @tableName               => Name on wich table webhook proceeded
// @code                    => Row code. Can be empty depending of the method. It is empty for LIST || PUT.
//                             GET: contains code link to the returned row
//                             DELETE: contains code link to the deleted row
// @method                  => Method used. Can be GET || LIST || PUT || DELETE
// @dataInput               => Data input. Can be empty depending of the method. It is empty for GET || LIST || DELETE.
//                             PUT: contains data inserted
// @dataOuput               => Data ouput. Can be empty depending of the method. It is empty for PUT || DELETE.
//                             GET || LIST: contains data returned
// @resultCode              => IF webhook execution failed, resultCode is equal to 1. Otherwise, 0.
// @errorMessage            => Error message associated to the code
// @action                  => insert / update / select / delete. Useful to differantiate insert and update
// @verifiedData            => An object that contains all data. If others arguments are not enough
// @entity                  => To be used to differenciate between webhooks using the same table
//
// @Returns                 => Void

tableName     = TRANSLATE( "<varscript>arg1</varscript>" )
code          = TRANSLATE( "<varscript>arg2</varscript>" )
method        = TRANSLATE( "<varscript>arg3</varscript>" )
dataInput     = TRANSLATE( "<varscript>arg4</varscript>" )
dataOutput    = TRANSLATE( "<varscript>arg5</varscript>" )
resultCode    = TRANSLATE( "<varscript>arg6</varscript>" )
errorMessage  = TRANSLATE( "<varscript>arg7</varscript>" )
action        = TRANSLATE( "<varscript>arg8</varscript>" )
verifiedData  = TRANSLATE( "<varscript>arg9</varscript>" )
entity        = TRANSLATE( "<varscript>arg10</varscript>" )

dataInput = REPLACE("<varscript>dataInput</varscript>",";",",")
dataOutput = REPLACE("<varscript>dataOutput</varscript>",";",",")

msg = "message="
msg = CONCAT( msg, "tableName = <varscript>tableName</varscript>-" )
msg = CONCAT( msg, "code = <varscript>code</varscript>-" )
msg = CONCAT( msg, "method = <varscript>method</varscript>-" )
msg = CONCAT( msg, "datainput = <varscript>datainput</varscript>-" )
msg = CONCAT( msg, "dataoutput = <varscript>dataoutput</varscript>-" )
msg = CONCAT( msg, "resultcode = <varscript>resultcode</varscript>-" )
msg = CONCAT( msg, "errormessage = <varscript>errormessage</varscript>" )
msg = CONCAT( msg, "action= <varscript>action</varscript>" )
msg = CONCAT( msg, "entity= <varscript>entity</varscript>" )

VARADD_DB( "sw_data_final_log", msg )