I don't have permission to make a database call directly to database of an application. I am using Progress Autonomous Rest connector to get data from a Rest API. The problem I am facing is that Progress only sends report filters in the Rest API body.
Is there a way that the sql can be sent as a filter in the Rest API call Progress ARC does.
Or Is there a way I can make use of Cognos Rest APIs to get SQLs generated for a report on report execution, flow can be as below
Report -> SQL -> Progress ARC -> My Rest API -> Cognos Rest API to get the SQL -> My Rest API logic to get data for the SQL -> return data to Progress ARC