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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.