1305 - Create external table from CVS

Step 1: Obtain a security token

Open [Postman] (https://www.postman.com) and create a new request. 

Set the request type to POST (in the drop-down menu to the left of the URL). 

1. Enter URL: https://prod2022.plugnotes.com/Apis/External/GetToken.php
2. In the header section, add a key: X-API-KEY
3. For the value, enter the unique key given by Plugnotes  

Press “Send” to obtain: 
 - token
 - uh 

Result From Step 1: 

Once the request has been sent, you should see this just below the parameters you filled in: 

Step 2: Using the API

Using the security token, create a new POST request. 

1. Set the URL to: https://prod2022.plugnotes.com/Apis/External/1305_create_external_table_from_csv.php
2. In the header section, add a key: X-AUTH-TOKEN
3. For the value, it's a token from the previous request in “Result from Step 1”.

1. You then need to go to the Body section and select “form-data”.

2. Once you have done that, you need to fill in the “uh”, “tableName”, and “type_action” and select your file for “csvFile”:

 “uh”: From the previous request.

“tableName”: The name of the table in which you want your data to be processed. (As to be the same as in your Plugnote web service in Plugkey)

“type_action”: “1” to replace the existing data and “2” to add after it.

(1 Drop the entire table and then make a table of your CSV file, choose carefully)

“csvFile”: Select your csv file from your local machine.

Result From Step 2

After filling everything you can send the request and it should look like this:

Result:

• If successful, you'll receive confirmation;
• In the event of a problem, an error message will be provided. 

Note: Be sure to complete each step before proceeding to the next. In the event of a problem, consult the error message for assistance.