I need to export our asset data in Insight nightly through an automated scheduled process. The output should be similar to the .csv file that is generated via the manual Export process from an Insight object type.
The only method I have found so far (via documentation…providing I am viewing the correct version) is to use this insight api endpoint (POST /object/navlist/iql )
from which the JSON output is extremely complex and will require quite a bit of transformation.
Is there a better api endpoint or tool that will allow us to get a copy of our insight data nightly in a friendlier JSON format (without someone pressing an Export button)?
Thank you!