csv2api

Note

csv2api is a subscription connector. Make sure that you have already got your subscription. If in doubt, contact our support support@opencelium.io.

Installation

1root@shell> mkdir /opt/services
2root@shell> cd /opt/services/
3root@shell> git clone https://github.com/opencelium/csv2api.git
4root@shell> cd csv2api/
5root@shell> gradle build
6root@shell> cd build/libs/
7root@shell> java -jar csvtoapi-0.0.1-SNAPSHOT.jar

Additional Information are available at github (https://github.com/opencelium/csv2api)

Afterwords please download the CSV2api Invoker file from the service portal (https://service.opencelium.io) an import it into you OpenCelium instance.

Serv file through HTTP

To load the csv file its has to be available through http / https.

Adhoc

This can for example be achieved with a simple HTTP Server. Copy the csv file to a folder you like on a linux server and afterwords execute

1root@shell> python3 -m http.server 8123

Afterwords you can see all files at the following address: http://[MyLinuxServer]:8123/

The URL for the Connector would be: http://[Csv2APIServer]:8080?source=http://[MyLinuxServer]:8123/my-test.csv

Permanent

1root@shell> mkdir /opt/csv2api/

Copy your csv file into this folder. Change Nginx config an add the following Code:

location /csv2api {
        autoindex on;
        alias /opt/csv2api;
}

Afterwords you can see all files at the following address: http://[MyLinuxServer]/csv2api/

The URL for the Connector would be: http://[Csv2APIServer]:8080?source=http://[MyLinuxServer]/csv2api//my-test.csv

Usage

First of all add a connector to your db.

image0

After that you can use it in a connection. Add a GetDataSources process to make a request to retrieve data from csv.

image1

Additional Service

User with subscription has an access to Service Portal. There is a tool for easy conversion a csv file into an invoker file.

image2

In general data section you need to provide a name, an authentication type and a csv file.

image3

There is also a list of already converted files as a history. You can make such manipulations there, like: download, edit or delete.

image4