Examples of data to upload to Data API
- Last UpdatedJun 24, 2025
- 1 minute read
- Engineering
- Integration Service 4.0
- Integrators
"path":"/tables"
{
"metadata": "List Of Tables",
"path": "/tables",
"data":"[{\"Name\":\"EQUIPMENT\",\"Type\":\"PROCEDURE\"},
{\"Name\":\"PIPE\",\"Type\":\"PROCEDURE\"}]"
}
"path":"/tables('EQUIPMENT')"
{
"metadata": "Table data",
"Path": "/tables('EQUIPMENT')",
"data": "[{\"DBREF\":\"=2013286708/3605\",\"TYPE\":
\"EQUIPMENT\",\"ACTTYPE\":\"EQUIPMENT\",\"NAME\":
\"D1201\",\"DESC\":\"RefluxDrummer\",\"FUNC\":\"\",
\"PURP\":\"\",\"NUMB\":\"0\"},{\"DBREF\":\"=2013286708/3745\",\"TYPE\":
\"EQUIPMENT\",\"ACTTYPE\":\"EQUIPMENT\",\"NAME\":\"C1101\",\"DESC\":
\"COLUMN\",\"FUNC\":\"\",\"PURP\":\"\",\"NUMB\":\"0\"}]"
}
"Path": "/Tables('AIRCOOLEDHEATEXCHANGER')/Schema"
{
"metadata": "Schema of table AIRCOOLEDHEATEXCHANGER",
"Path": "/Tables('AIRCOOLEDHEATEXCHANGER')/Schema",
"data": "[{\"REF\":\"\",\"NAME\":\"\",\"TYPE\":\"\",
\"ACTTYPE\":\"\",\"LOCK\":\"\",\"OWNER\":\"\",\"DESC\":\"\",
\"SCSYSF\":\"\",\"EXCLEL\":\"\",\"GOVCOM\":\"\",
\"CALCSURFAREA%5C%3AHEDEFATTDATA%5B1%5D\":\"\",
\"SURFAREAEXCH%5C%3AHEDEFATTDATA%5B1%5D\":\"\"}]"
}
"path": "/PublishedTags('=16385%252F41922,=163974%252F755')"
{
"metadata": "List of published Tags",
"path": "/PublishedTags('=16385%252F41922,=163974%252F755')",
"data": "[{\"UOPName\":{\"TagName\":\"Pump\"},\"Attributes\":
[{\"UnitOperation\":\"P803\",\"Description\":\"unset\",\"DP\":
\"100.0000000000\",\"Head\":\"61.7330000000\",\"DH\":\"66.7220000000\",\"eta\":
\"0.7000000000\",\"T\":\"\",\"Q\":\"0.0040000000\",\"Power\":\"2.8416000000\",
\"LF\":\"\",\"VF\":\"0.0000000000\",\"Qref\":\"0.0040000000\",\"Headref\":
\"61.7330000000\",\"Speedref\":\"3600.0000000000\",\"Speed\":\"3600.0000000000\",
\"Pv\":\"\",\"NPSHa\":\"\",\"NPSHr\":\"\",\"NPSHm\":\"\",\"W\":\"3.2845000000\",
\"P1\":\"176.4700000000\",\"P2\":\"676.4700000000\",\"Feeds\":\"Nulref\",
\"Products\":\"\"}]},{\"UOPName\":{\"TagName\":\"Valve\"},\"Attributes\":
[{\"UnitOperation\":\"P803\",\"DP\":\"-825.0000000000\",\"Cv\":\"7.8490000000\",
\"Wmax\":\"0.0000000000\",\"Wmin\":\"0.0000000000\",\"LineSize\":\"1in\",\"Tc\":
\"5.0000000000\",\"xT\":\"0.7\",\"W\":\"2.2783000000\",\"Q\":\"0.0026000000\",
\"F\":\"29.1670000000\",\"P1\":\"3500.0000000000\",\"P2\":\"3100.0000000000\",
\"FlowType\":\"unset\",\"Pos\":\"0.5000000000\",\"ManPos\":\"\",\"Feeds\":\"Nulref\",
\"Products\":\"\"}]}]"
}
"Path": "/Elements('E1303A,E1302A,Anything')"
{
"metadata": "Object info",
"Path": "/Elements('E1303A,E1302A,Anything')",
"data": "[{\"ElementName\":\"E1303A\",\"Valid\":\"True\"},
{\"ElementName\":\"E1302A\",\"Valid\":\"True\"},
{\"ElementName\":\"Anything\",\"Valid\":\"False\"}]"
}
"Path": "/Elements('E1303A,E1302A,Anything')/Attributes('OWNER,DESC,SCSYSF,EXCLEL')"
{
"acknowledgementId": "",
"metadata": "Object info",
"Path": "/Elements('E1303A,E1302A,Anything')/Attributes('OWNER,DESC,SCSYSF,EXCLEL')",
"data": "[{'ElementName':'E1303A','Valid':'True','OWNER':'/MechanicalTags',
'DESC':'unset','SCSYSF':'/B-sysgrp','EXCLEL':'false'},
{'ElementName':'E1302A','Valid':'True','OWNER':'/MechanicalTags',
'DESC':'unset','SCSYSF':'/A','EXCLEL':'false'},{'ElementName':'Anything',
'Valid':'False','OWNER':'','DESC':'','SCSYSF':'','EXCLEL':''}]"
}
"path": "/Excel('MyExcel1.xlsx')",
{
"acknowledgementId": "",
"metadata": "Excel Name data",
"path": "/Excel('MyExcel1.xlsx')",
"data":"[{\"SheetName\":\"INST$\",\"Attributes\":[{\"Name\":\"IN001\",
\"Description\":\"Instrumnet\",\"Detail%20description\":\"Instrumnet\"},
{\"Name\":\"IN002\",\"Description\":\"Instrumnet\",
\"Detail%20description\":\"Instrumnet\"}]},
{\"SheetName\":\"Pump$\",
\"Attributes\":[{\"Name\":\"P001\",\"Description\":\"Pump\",
\"Detail%20description\":\"CentifgalPump\"},{\"Name\":\"P002\",
\"Description\":\"Pump\",\"Detail%20description\":\"CentifgalPump\"}]}]"
}
"path": "/Excel('MyExcel1.xlsx')/Sheets"
{
"acknowledgementId": "",
"metadata": "List for List of Sheets",
"path": "/Excel('TimeAllocation - Copy.xlsx')/Sheets",
"data": "[\"INST$\",\"Pump$\"]"
}
"path": "/Excel('MyExcel1.xlsx')/Sheets('INST