Hi all,
I’m trying to GET the content of a Quick Report using the REST APIs. I can see the endpoints in API Explorer; but when I make the request in Postman, although the status code is 200, the payload is an empty array (see image).
I’ve tried this with a couple of different endpoints:
- https://.../projection/v1/QuickReports.svc/QuickReport_36969()
- https://.../projection/v1/QuickReport36969.svc/VirtualOrderSqlReports
Both give the same result. I’ve also tried with a couple of other Quick Reports - it’s not just that one.
The endpoints are showing as ‘Active’ in API Explorer (and presumably I’d get an error if they weren’t anyway). Is there something else I need to do to ‘activate’ the APIs? The Quick Reports themselves are generated from an SQL statement, if that makes a difference (and to confirm - if I view the report directly, there is plenty of data to see!).