We have a report in Birst that we would like to be able to obtain the data and use it in another application. This is after modelling has been applied in Birst, so we can't use the data before it comes into Birst. I am seeing several different ways that this should be possible in the documentation for Birst, but I'm not having any success in actually accomplishing the goal. Has anyone else done this?
If you go to docs.infor.com, click on Platforms and then on Birst, you get the documentation I'm referring to, which as far as I know should be the most current. Then within the documentation, if you navigate to Administrator>Space management in Admin>Notifications in Space Management>Notification and Exporting Data Limitations, or just search for export report and select the first result, you'll get a page with options for exporting bulk data from a report.
It states you can use the Export Report Data page in Admin to export the result set of a report with up to 500,000 rows as a .TXT file. - I can't find this page in Admin? It also states: Bulk Export of data. This is done by creating a report in Birst and then calling that report through a Birst Connect task that runs a command file invoking the generatebulkqueryresults command. Can be automated for scheduled runs of data statistics or similar. - I was able to figure out that you can run generatebulkqueryresults in Admin>Space Management>Command Window (not Connect), but I can't get it to actually work. It gives me errors such as "Problem was encountered loading the report file".
Unfortunately, it is not possible to simply do a notification to export this report as a CSV or Excel, because it won't load without filtering the report to a specific customer. Although the number of rows per customer is small (< 350 for the largest customer), there are a lot of customers. On this page and elsewhere I've seen a few references to APIs to accomplish this task, so if that's something someone else has done, can you share any examples?
