Korona.Integration is an add-on tool that can be linked to your Korona.Cloud account to help you do a variety of tasks with data from Korona. This page is still a work in progress, for any questions please email us at email@example.com
Korona.Integration allows you to set up your own data to export and re-arrange as you see fit. In the example below we demonstrate how to setup custom data to export from Korona to a CSV that is then sent out via email.
NOTE: If you are a developer and want to use some of the more intricate options not covered under Workflow please email us firstname.lastname@example.org
On the left side click on ‘Jobs’ and then ‘New’. You will have to give it a name, and select the Type ‘. Image version and Maximum Log History should not change but if you accidentally change them they should be set to V2 and 10.
On the right side under Process Control you can leave it at Manual if you want to trigger the Job or you can set a schedule via the Cron tool. Then hit ‘Save’ and the ‘Workflow’ button will appear.
Now click the purple ‘Workflow’ button. In this instance we’re going to be create a request for certain data fields to be returned from Korona as a CSV. First add the HTTP Request, the URL will be:
In this instance it’s products because we’re going to be querying products. The HTTP/Request method should autofill but it is GET if you accidentally changed it. The User and Password information is found underneath your API Key in Settings>Data Exchange>API. You will have to setup a user and pswd if you have not already done so.
The next step is to add the CSV parameters we want to return from korona.cloud. Object Selector should autofill with ‘results’. Underneath ‘Columns’ select ‘Add Column’ and then give it a name, and a Json key name. The Json key names will come from our APIv3 page.
On the APIv3 page find the call for products and the keys in the results as shown to the right.
Column name is whatever you want to call the column. Notice that to get Commodity Group name I concatenate onto commodityGroup “.name”. If I wanted number or key I would use “.number” or “.key”.
The next step would be to add ‘File’ the operation should be ‘Write’ and the File Path will be the file name. If you do not give it a name Integration will not create the file.
If you would like the CSV Emailed to a specific address, add ‘Email Client’ from the left, set a recipient’s email address, and add a subject.
If your Job is a manual launch like ours, you will need to click ‘Live Log’ at the top, and then start as shown to the left. Have a lot of fun!