Table of Contents |
---|
...
Connectors can be created by using the CSV and Json JSON files in order to access the data of these files.
In the following, we will give an example to create a connector from the CSV file “Suppliers” which contains supplier information such as name, IDcode, and industry.
...
Creating a new connector
From CSV File
In order to create a connector, please open the page Connector under the Design. Connector The connector will be available to use in the Smartform form after necessary configuration.
...
You can test the connector by clicking the “Execute connector” button.
...
...
...
From JSON File
You can easily upload a JSON file after filling the name of the connector and choosing the JSON file type:
...
Using the connector in the
...
form
Custom connectors can be used in the smartformform. In our example, we have created a connector for supplier information. In order to show the supplier list in the “Select” element of the smartformform, “Connections” section should be opened on the left-hand side. The label and the value will be selected from the headers of the CSV file, which contain different information of suppliers.
...
Info |
---|
Column names of the Supplier document that we use in this example as follows: |
...
Parameter | Description | Example |
---|---|---|
Connection 1 | Custom connectors can be reached via this drop-down list. |
Supplier | |
JSON Path: label | This area determines the parameter which should be shown in the |
form drop-down list. |
| |||
JSON Path: value | This area determines the parameter which will be stored in the database. |
|
|
|
Info |
---|
Syntax for JSON path starts with a |
...
means all rows should be included. The last part after |