Dynamically Construct A List Array String of Report Columns To Be Used For Progress DataDirect Autonomous REST Driver

We are currently trying to use the Progress DataDirect Autonomous REST driver to connect to some our custom UKG APIs. During our initial observation on how the driver works, we’ve noticed that even if we create a Cognos report against the APIs with just ONE field, it still returns the data for all of the API fields and via local processing, it then renders the report for the one field in the report. We are hoping to somehow send a parameter to the API with a string value that is a construct array of fields used in the report. 

For example, if I create a report with the following 3 fields: 

1) Employee Name 
2) Employee Number 
3) Location

We then are able to create a calculation in the report that will be sent as a parameter value with following sample string (based on the report’s metadata): 

“EmployeeName,EmployeeNumber,Location”

The idea is that the API is able to then receive the above string as a parameter as list of all the fields that were used in the report. The API will have the appropriate logic to consume that list to bring back the data for ONLY the 3 fields selected in the report. This approach will help resolve the existing performance issue that may result from bringing back all the API data as it exists today. 

The above enhancement request involves grabbing report specs related data and then making it part of the actual query. 

NOTE: Another workaround enhancement is to have the Progress DataDirect Autonomous REST driver updated to specifically know what report columns are actually used in the report and thus only return the data for those columns.