Retrieve a report using API

Question

Is there any way to retrieve a specific report using the API ?

Is there a way to download the report using the API in XLSX or CSV format?

Appreciate if you can share the snippet of the sample code that downloads the report using the API.

Thank you

Jay

jerflo · Answer

Hi Jay,

You can retrieve the report definition, but not the contents of the report. It would look something like this:

Step 1: Get the report definition

/attask/api/v11.0/ptlsec/{GUID}?fields=objObjCode,filter:*,groupBy:*,view:*

...this should give you a list of filter criteria, how it is grouped, and the columns in the view.

Step 2: Pull the same info (assuming no grouping)

/attask/api/v11.0/{1.objObjCode}/search?{mapped string from 1.filter response}&fields={mapped string from 1.view response}

Hope this is helpful.

CC. @Darin Patterson - inactive‚ ‚

Sign up