Embedded Files
Interface
Interface
It allows you:
to insert new work order documents details in one json file
to view , update and delete work order documents details in one json file
This document is used for:
usage (out) of raw material for production
Prerequisites:
In order to use this API Method for PUT there must be accomplished the following requirements in SocrateCloud:
to have an Organization active
to have an Role active
Columns that can be used as filters:
DocumentNo
WorkOrderSo_ID
Line
WorkOrderSoLine_ID
Product
Product_ID
Actions can be done:
list
create
update
delete
Work Order Details
List details:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/line/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}&DocumentNo={document_no}
Method: GET
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Line
WorkOrderSoLine_ID
Product
Product_ID
Return: JSON object with next format:
{
"data": [
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 06:59:22+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 07:00:12+0000",
"UpdatedBy": "Ionut",
"Line": 10,
"Product_ID": 1000160,
"Product": "MFG-PS000-23Q2M2VEM",
"ProductName": "PS000 - marfa-fifo-gestiune",
"Locator_ID": 1000006,
"Locator": "A00-0",
"Warehouse": "Depozit A-00",
"Warehouse_ID": 1000006,
"Description": null,
"Consumed": false,
"BOMUse": true,
"Active": true,
"Deviation": 3,
"UOM_ID": 100,
"UOM": "Each",
"QtyDisposed": 100,
"QtyReserved": 0,
"QtyIssuedProcessed": 0,
"QtyIssued": null,
"WeightReserved": 0,
"WeightDisposed": 100,
"WeightIssued": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Campaign_ID": null,
"CampaignValue": null,
"Campaign": null,
"Asset_ID": null,
"AssetValue": null,
"Asset": null,
"User1_ID": 0,
"User1": null,
"User2_ID": 0,
"User2": null,
"Employee_ID": null,
"Employee": null,
"WorkOrderSoLine_ID": 1004719,
"WorkOrderSo_ID": 1004753
}
],
"totalRows": 1
}
Create detail:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/line/create/{version}?accessToken={access_token}&DocumentNo={document_no}
Method: POST
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Return: line no for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-06 07:24:19+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-06 07:24:19+0000",
"UpdatedBy": "Ionut",
"Line": 10,
"Product_ID": 1009534,
"Product": "MFG-A028",
"ProductName": "A028 - marfa-fifo-gestiune",
"Locator_ID": 1000006,
"Locator": "A00-0",
"Warehouse": "Depozit A-00",
"Warehouse_ID": 1000006,
"Description": "test123",
"Consumed": false,
"BOMUse": true,
"Active": true,
"Deviation": 0,
"UOM_ID": 100,
"UOM": "Each",
"QtyDisposed": 320,
"QtyReserved": 0,
"QtyIssuedProcessed": 0,
"QtyIssued": null,
"WeightReserved": 0,
"WeightDisposed": 8.8,
"WeightIssued": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Campaign_ID": null,
"CampaignValue": null,
"Campaign": null,
"Asset_ID": null,
"AssetValue": null,
"Asset": null,
"User1_ID": null,
"User1": null,
"User2_ID": null,
"User2": null,
"Employee_ID": null,
"Employee": null,
"WorkOrderSoLine_ID": 1004732,
"WorkOrderSo_ID": 1004754
}
Update detail:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/line/update/{version}?accessToken={access_token}&DocumentNo={document_no}&Line={line_no}
Method: POST
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Line
WorkOrderSoLine_ID
Return: line no for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-06 07:24:19+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-06 07:24:19+0000",
"UpdatedBy": "Ionut",
"Line": 10,
"Product_ID": 1009534,
"Product": "MFG-A028",
"ProductName": "A028 - marfa-fifo-gestiune",
"Locator_ID": 1000006,
"Locator": "A00-0",
"Warehouse": "Depozit A-00",
"Warehouse_ID": 1000006,
"Description": "test123",
"Consumed": false,
"BOMUse": true,
"Active": true,
"Deviation": 0,
"UOM_ID": 100,
"UOM": "Each",
"QtyDisposed": 320,
"QtyReserved": 0,
"QtyIssuedProcessed": 0,
"QtyIssued": null,
"WeightReserved": 0,
"WeightDisposed": 8.8,
"WeightIssued": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Campaign_ID": null,
"CampaignValue": null,
"Campaign": null,
"Asset_ID": null,
"AssetValue": null,
"Asset": null,
"User1_ID": null,
"User1": null,
"User2_ID": null,
"User2": null,
"Employee_ID": null,
"Employee": null,
"WorkOrderSoLine_ID": 1004732,
"WorkOrderSo_ID": 1004754
}
Delete detail:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/line/delete/{version}?accessToken={access_token}&DocumentNo={document_no}&Line={line_no}
Method: POST
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Line
WorkOrderSoLine_ID
Return: 'Deleted' for success or error message (start with "ERROR: ")
Page updated
Report abuse