Query not retrieving data as expected from PDS
Hi,
I have written a query to connect to PDS via Post-man that should retrieve Resource ID's for a particular project, But it's response is
{
"data": {
"PROJECT": [ {
"RSRC_ID": null } ],
"pagination": [ { "nextTableName": "-1", "nextKey": "0" } ], "safetyDate": [ { "queryName": "Test", "sinceDate": "2024-08-05 10:01:27 +00:00" } ] }}
Query:
{
"name": "Test",
"pageSize": "1000",
"tables": [
{
"tableName": "PROJECT",
"columns": [ "RSRC_ID" ],
"condition": {
"operator": "AND",
"conditions": [
{"columnName": "PROJ_SHORT_NAME",
"operator": "EQUALS",
"value1": "003920MESFEB } ] } } ]}