Insight Catalog Report Data Parsing

[Andrew Nelson]

Is there a plugin or API to sort exported data from a catalog report in JSON, HTML or XML format? I want to be able to create a report that displays data in a customized manner, without having to rely on the IQL and attribute filter.

Thanks

[Alexander Sundström]

Hi Andrew,

You could use the open API to get this as JSON:

Method: GET

URL http://yourinstance/rest/insight/1.0/catalog/objecttype/src?levels=1&typeIds=10834,9268&iql=Name%20is%20not%20empty

Levels sets the depth

typeIds, the object types to use, separated with ,

iql, the iql to use to filter
Best Regards
Alexander

[Roshan Fernando]

Hi Andrew,

This is exactly what I was after. Can you please put something tother for me to build the JSON.

My Schema is "TR" and I have a ObjectType called "Machines". 

I want to get a report on above object with attribute "Company Name" as the filter.

Can you please generate a URL for me. Thanks.

[Roshan Fernando]

Hi Andrew,

I was able to figure out how to pull the data. But can you please explain how can I put the authentication into the link. My link is as follows with authentication at the moement.

http://yourinstance/rest/insight/1.0/catalog/objecttype/src?levels=1&typeIds=1720,9268&iql=%22Machine%20Name%22%20=%20MAR_TFLS_15H208

Many Thanks

[Roshan Fernando]

Hi @Alexander Sundström ,

After the Insight 8.4 update, the catalog report open API function has stopped working. Is there a new way of accessing this data through Open API?

Thanks

Roshan