Export data from DataRefiner to Onesait Platform

Introduction

The DataRefiner module can be accessed with the ADMINISTRATOR and ANALYTICS roles, from the Control Panel menu option

Open

After this, you access the project that you intend to export to the Platform.

Open

Click on “Onesait Platform”, then on the option “EXPORT TO ONESAITPLATFORM” and a dialog window appears

Export screen

Description of the different components that make it up

The prefix is prepended to the entire result of running the template on the data

The suffix goes to the end of all the result of executing the template on the data

Here is the row separator

Here the template is implemented, which is used for each of the rows, it allows generating a result in this case a JSON object for each row that is how it is sent to the platform.

With this button we return the template to its initial state

In this area we see the reduced result of applying all prefix separator suffix and template to the data

Form to export the data to the platform

Use Proxy, Proxy and ProxyPort: They will be filled in if you have to use a proxy.

Token: corresponds to the user's oauth2 token can be retrieved as follows,

Press the icon with the three dots in the header of the control panel menu and the APIS option

Click on Bearer ... and it will be copied to the clipboard, just having to paste it into the token field of the form

New Ontology: From this form you can mark this check in which case both Ontology Name and Ontology Description must be filled in and when exporting the data a new ontology will be created with the loaded data.

Ontology Name: it is mandatory to indicate the name of the ontology where the data will be loaded.

Export button: Clicking on it begins the process of exporting the information to the platform.

Export to JSON File button: This button exports the information to a file with the JSON format, it is not necessary to fill in the form to be able to execute it.

Alert messages: This text box will appear under the title of the dialog window in case to indicate to the user alerts, errors or if the data has been successfully exported.