Primavera (MOSC)

MOSC Banner

Query not retrieving data as expected from PDS

edited Aug 6, 2024 1:49PM in Primavera (MOSC) 4 commentsAnswered

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                                           }                                           ]                              }               }            ]}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center