Hi All,
Is anyone else experiencing that through the Filter query parameter in the REST API the ObjectID isn't returned? I've got it in the query and it shows up in the GET response from the filter itself (/apiserver/onbase/workview/filters/xxxx). It shows there as:
{
"heading": "Object ID",
"dataType": "LargeInt",
"width": "50",
"dataAddress": "1"
}
However when I query it in the body of the post (/apiserver/onbase/workview/v2/object-queries/) like this:
{
"classId": "1010",
"columns": [
{
"dataAddress": "1123"
},
{
"dataAddress": "1096"
},
{
"dataAddress": "1430"
},
{
"dataAddress": "1279.1157"
},
{
"dataAddress": "1133.1157"
},
{
"dataAddress": "1428.1401"
},
{
"dataAddress": "1268.1187"
},
{
"dataAddress": "1092"
},
{
"dataAddress": "1304"
},
{
"dataAddress": "1264"
},
{
"dataAddress": "1198"
},
{
"dataAddress": "6"
},
{
"dataAddress": "53"
},
{
"dataAddress": "1"
}
],
"constraints": [
{
"dataAddress": "1123",
"value": "1000",
"operator": "GreaterThanEqual",
"connector": "And"
}
],
"sorts": [],
"maxResults": 4000,
"returnDistinctResults": "true"
}
It isn't returned in the response while all other fields are there (anonimised for here):
{
"results": [
{
"key": "MTEsNCwxMDEwMywqMCw=",
"attributeValues": {
"1123": "1001",
"1096": "xx",
"1430": "xx",
"1092": "xx",
"1304": "",
"1264": "",
"1198": "xx",
"6": "2020-09-08T17:05:22",
"53": "2020-09-08T17:05:23",
"1279.1157": "xx",
"1133.1157": "xx",
"1428.1401": "xx",
"1268.1187": "xx",
"1279": "MTQsNCwxMDE3NiwxOTg0ODk=",
"1133": "MTQsNCwxMDE3NiwxOTg0ODk=",
"1428": "MTQsNCwxMDM2NiwyMDE4MTA=",
"1268": "MTMsNCwxMDAzNSwyNDA0Mg=="
}
Was curious if I'm the only one encountering this issue here (OnBase EP5 21.1.18.1000)? I need the objectID to integrate the objectpop in the receiving application (datawarehouse/BI).