JSON Tools Import Document

JSON Tools Import Document Schema Version 1

Using Schema version 1, you can import tools.


Use SOADB
DECLARE @insertedDate Datetime = GetUTCDate()INSERT INTO erp.Erp_integration_inbound_messages
(Inserted_Date, Key_Data, Media_Type, Message, Message_Type, Process_Completion_Date, Process_Start_Date, Response_Code, Response_Message, Inserted_By)
VALUES
(@insertedDate,
'',
'application/json',
'{
"toolCode": "ScrewDriver1",
"toolDescription": "Metal screw Driver",
"toolType": {
"name": "Screw tools",
"externalToolTypeId": "SCR001",
"toolSubType": null
},
"toolStatus": "Active",
"calibrationDueDate": "2022-12-02T13:41:57Z",
"toolUsageLimit": 6,
"externalToolId": "SCR_DR123",
"toolLastCalibration": "2022-12-02T13:41:57Z",
"toolSerialNo": "1",
"toolManufacturer": null
}',
'tool',
null,
null,
null,
null,
'system')