I have a need to generated a document from the Data Lake on a daily schedule. While this is similar to the question Venky did, "How to run a Compass API as a Job", I'm required to make this work completely in ION. *I have written a C# program to export a Data Lake query to a file, but the customer doesn't want anything not in the Infor Cloud.
My question is this, I've setup ION Desk so I can schedule a Data Lake query and write the results to a file using ION Desk. However, the solution took a little bit of duct tape and bailing wire to get working.
Question 1: Does Infor has plans to release an official method of doing something like this? A way to schedule an extract to run in ION?
Question 2: The V2 Compass APIs are marked Beta. Since V1 doesn't support JSON, but V2 does, I had to start the query with a V2 call to get JSON output. I use the V1 APIs for everything else. The V2 work, but they are definitely throw odd errors at times, but a retry seems to resolve it. Any timeline on those becoming Gold?
For the curious, the current way I'm testing this process is as follows:
This was a bear to figure out, and I hope it helps folks get started in the right direction. I still think an external program is best for extracting data, but sometimes we're required to do it all in cloud.
Did you get any result?
I'm sorry, I didn't see your question when it was posted, the one below just popped it up in my feed.
I had to modify the swagger document to get it to work with ION. Here is the Swagger document I used to make the connection. Try the V2 and the V1 interfaces. Replace the value YOURENVIRONMENT in the XML for your system.