Insight Catalog Report Data Parsing

Andrew Nelson October 25, 2017

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

1 answer

2 votes
Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 27, 2017

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 June 20, 2019

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 June 20, 2019

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 March 24, 2020

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

Suggest an answer

Log in or Sign up to answer