Embedded Files
Interface
Interface
It allows you:
to insert new documents (master&details in one json file)
to view , update and delete work order documents (master&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:
Organization
Organization_ID
DocumentNo
WorkOrderSo_ID
DateOrdered
Product
Product_ID
Actions can be done:
list
create
update
delete
Work Order Master
API Method
API Method
List headers and details:
List headers and details:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/full/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Available filter parameters:
Organization
Organization_ID
DocumentNo
WorkOrderSo_ID
DateOrdered
Product
Product_ID
Return: JSON object with next format:
{
"data": [
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 06:58:26+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 07:00:36+0000",
"UpdatedBy": "Ionut",
"DocumentNo": "1000033",
"DocType": "Work Order SocrateOpen",
"DocType_ID": 2140900014,
"POReference": null,
"DateOrdered": "2025-08-05 00:00:00+0000",
"DateAcct": "2014-05-20 00:00:00+0000",
"DateStart": null,
"DateStop": null,
"Description": null,
"Product_ID": 1000968,
"Product": "P100",
"ProductName": "P100 - Produs finit 100",
"AttributeSetInstance_ID": null,
"BOM_ID": 1000065,
"BOM": "Reteta P100",
"UOM_ID": 100,
"UOM": "Each",
"UOMTo": "Each",
"Currency": "RON",
"Active": true,
"BPartner_ID": null,
"BPartnerValue": null,
"BPartner": null,
"Warehouse_ID": 1000006,
"Warehouse": "Depozit A-00",
"Locator_ID": 1000006,
"Locator": "A00-0",
"IsSelected": false,
"IsCreditApproved": false,
"IsApproved": false,
"IsExecuted": false,
"QtyReserved": 0,
"QtyEntered": 7,
"priceEntered": null,
"PriceList": "RON CMP (4z)",
"PriceList_ID": 1000104,
"UnitaryCost": null,
"UnitCostOfProduction": 234,
"ValueProducedAtUnitCost": null,
"ValueProduced": 8,
"Weight": 7,
"CostAmt": 10,
"QtyProduced": 2,
"QtyConverted": 0,
"User_ID": null,
"UserValue": null,
"User": null,
"Order_ID": null,
"OrderLine_ID": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": 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,
"DocumentStatus": "Drafted",
"DocumentAction": "Complete",
"lines": [
{
"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 header and details:
Create header and details:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/full/create/{version}?accessToken={access_token}
Method: POST
Available filter parameters:
generateDisposedComponents (True/False)
Return: document no for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 06:58:26+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 07:00:36+0000",
"UpdatedBy": "Ionut",
"DocumentNo": "1000033456",
"DocType": "Work Order SocrateOpen",
"DocType_ID": 2140900014,
"POReference": null,
"DateOrdered": "2025-08-05 00:00:00+0000",
"DateAcct": "2014-05-20 00:00:00+0000",
"DateStart": "2025-08-05",
"DateStop": "2025-08-25",
"Description": "test Bianca",
"Product_ID": 1000968,
"Product": "P100",
"ProductName": "P100 - Produs finit 100",
"AttributeSetInstance_ID": null,
"BOM_ID": 1000065,
"BOM": "Reteta P100",
"UOM_ID": 100,
"UOM": "Each",
"UOMTo": "Cutie",
"Currency": "RON",
"Active": true,
"BPartner_ID": null,
"BPartnerValue": null,
"BPartner": null,
"Warehouse_ID": 1000006,
"Warehouse": "Depozit A-00",
"Locator_ID": 1000006,
"Locator": "A00-0",
"IsSelected": false,
"IsCreditApproved": false,
"IsApproved": false,
"IsExecuted": false,
"QtyReserved": 0,
"QtyEntered": 8,
"priceEntered": null,
"PriceList": "RON CMP (4z)",
"PriceList_ID": 1000104,
"User_ID": null,
"UserValue": null,
"User": null,
"Order_ID": null,
"OrderLine_ID": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Activity_ID": 1000061,
"ActivityValue": null,
"Activity": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": 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,
"lines": [
{
"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,
"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": 1000061,
"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
}
]
}
List header only:
List header only:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Available filter parameters:
Organization
Organization_ID
DocumentNo
WorkOrderSo_ID
DateOrdered
Product
Product_ID
Return: JSON object with next format:
{
"data": [
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 06:58:26+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 07:00:36+0000",
"UpdatedBy": "Ionut",
"DocumentNo": "1000033",
"DocType": "Work Order SocrateOpen",
"DocType_ID": 2140900014,
"POReference": null,
"DateOrdered": "2025-08-05 00:00:00+0000",
"DateAcct": "2014-05-20 00:00:00+0000",
"DateStart": null,
"DateStop": null,
"Description": null,
"Product_ID": 1000968,
"Product": "P100",
"ProductName": "P100 - Produs finit 100",
"AttributeSetInstance_ID": null,
"BOM_ID": 1000065,
"BOM": "Reteta P100",
"UOM_ID": 100,
"UOM": "Each",
"UOMTo": "Each",
"Currency": "RON",
"Active": true,
"BPartner_ID": null,
"BPartnerValue": null,
"BPartner": null,
"Warehouse_ID": 1000006,
"Warehouse": "Depozit A-00",
"Locator_ID": 1000006,
"Locator": "A00-0",
"IsSelected": false,
"IsCreditApproved": false,
"IsApproved": false,
"IsExecuted": false,
"QtyReserved": 0,
"QtyEntered": 7,
"priceEntered": null,
"PriceList": "RON CMP (4z)",
"PriceList_ID": 1000104,
"UnitaryCost": null,
"UnitCostOfProduction": 234,
"ValueProducedAtUnitCost": null,
"ValueProduced": 8,
"Weight": 7,
"CostAmt": 10,
"QtyProduced": 2,
"QtyConverted": 0,
"User_ID": null,
"UserValue": null,
"User": null,
"Order_ID": null,
"OrderLine_ID": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": 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,
"DocumentStatus": "Drafted",
"DocumentAction": "Complete"
}
],
"totalRows": 1
}
Create header only:
Create header only:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/create/{version}?accessToken={access_token}
Method: POST
Return: document no for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 06:58:26+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 07:00:36+0000",
"UpdatedBy": "Ionut",
"DocumentNo": "10000339999",
"DocType": "Work Order SocrateOpen",
"DocType_ID": 2140900014,
"POReference": null,
"DateOrdered": "2025-08-05 00:00:00+0000",
"DateAcct": "2014-05-20 00:00:00+0000",
"DateStart": "2025-08-05",
"DateStop": "2025-08-25",
"Description": "test Master",
"Product_ID": 1000968,
"Product": "P100",
"ProductName": "P100 - Produs finit 100",
"AttributeSetInstance_ID": null,
"BOM_ID": 1000065,
"BOM": "Reteta P100",
"UOM_ID": 100,
"UOM": "Each",
"UOMTo": "Kilogram",
"Currency": "RON",
"Active": true,
"BPartner_ID": null,
"BPartnerValue": null,
"BPartner": null,
"Warehouse_ID": 1000006,
"Warehouse": "Depozit A-00",
"Locator_ID": 1000006,
"Locator": "A00-0",
"IsSelected": false,
"IsCreditApproved": false,
"IsApproved": false,
"IsExecuted": false,
"QtyReserved": 0,
"QtyEntered": 8,
"priceEntered": null,
"PriceList": "RON CMP (4z)",
"PriceList_ID": 1000104,
"User_ID": null,
"UserValue": null,
"User": null,
"Order_ID": null,
"OrderLine_ID": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Activity_ID": 1000061,
"ActivityValue": null,
"Activity": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": 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
}
Update header only:
Update header only:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/update/{version}?accessToken={access_token}&WorkOrderSo_ID={WorkOrderSo_ID}
Method: POST
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Return: document no for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"OrganizationValue": "TestA",
"Organization": "Test A SRL",
"Created": "2025-08-05 13:00:44+0000",
"CreatedBy": "Ionut",
"Updated": "2025-08-05 13:09:34+0000",
"UpdatedBy": "Ionut",
"DocumentNo": "1000034",
"DocType": "Work Order SocrateOpen",
"DocType_ID": 2140900014,
"POReference": null,
"DateOrdered": "2025-08-05 00:00:00+0000",
"DateAcct": "2025-08-05 00:00:00+0000",
"DateStart": null,
"DateStop": null,
"Description": null,
"Product_ID": 1000904,
"Product": "COS-C000",
"ProductName": "C000 - cos nestocabil - marfa-fifo-gestiune.",
"AttributeSetInstance_ID": null,
"BOM_ID": 1000013,
"BOM": "BOM01-COS-C000",
"UOM_ID": 100,
"UOM": "Each",
"UOMTo": null,
"Currency": "RON",
"Active": true,
"BPartner_ID": null,
"BPartnerValue": null,
"BPartner": null,
"Warehouse_ID": 1000006,
"Warehouse": "Depozit A-00",
"Locator_ID": 1000006,
"Locator": "A00-0",
"IsSelected": false,
"IsCreditApproved": false,
"IsApproved": false,
"IsExecuted": false,
"QtyReserved": 0,
"QtyEntered": 0,
"priceEntered": null,
"PriceList": "RON CMP cu TVA (2z)",
"PriceList_ID": 1000660,
"UnitaryCost": null,
"UnitCostOfProduction": 234,
"ValueProducedAtUnitCost": null,
"ValueProduced": 8,
"Weight": 0,
"CostAmt": 10,
"QtyProduced": 2,
"QtyConverted": 0,
"User_ID": null,
"UserValue": null,
"User": null,
"Order_ID": null,
"OrderLine_ID": null,
"TrxOrganization_ID": null,
"TrxOrganizationValue": null,
"TrxOrganization": null,
"Activity_ID": null,
"ActivityValue": null,
"Activity": null,
"Project_ID": null,
"ProjectValue": null,
"Project": null,
"ProjectPhase_ID": null,
"ProjectPhase": null,
"ProjectTask_ID": null,
"ProjectTask": 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
}
Delete header:
Delete header:
URL: https://api.socratecloud.com/webapi/rest/workOrderSo/delete/{version}?accessToken={access_token}&DocumentNo={document_no}
Method: POST
Available filter parameters:
DocumentNo
WorkOrderSo_ID
Return: 'Deleted' for success or error message (start with "ERROR: ")
Page updated
Report abuse