How to Connect JSON as Data Destination
The integration will allow you to send data from different systems to the system you need, if it supports transfer via JSON. For example, you can transfer order data from CRM or Google Sheets to the system you need. This way you can automate the process of processing data, such as orders, with the help of the different services that you use as efficiently as possible.
Let's go through the entire JSON setup steps together!
Navigation:
1. What will the JSON integration do?
2. How to connect a JSON account to ApiX-Drive?
3. How to configure data transfer in JSON in the selected action ?
4. Example of data that will be sent in your JSON.
5. Auto-update and update interval.
To do this, click "Start Configuring Data Destination".
Select the system as Data Destination. In this case, JSON must be specified.
Next, you need to specify the action - Send DATA.
- Send DATA - data will be sent to the url you specified according to the specified settings.
For an example of work, we use the Click Send system.
You can do the same on any other system that supports JSON.
Now you need to configure the connection of the Data Source fields using Google Sheets as an example with the corresponding fields in Click Send.
First, you need to specify the URL for receiving data according to the documentation of the service and the action you have chosen. For example, we'll take Creating a Contact in Click Send.
Next, select the Method, Authorization specified in the documentation, and also specify the Login and Password.
In this case, we indicate the login from the Click Send account and the API key. Fill in the Header as per the documentation.
In the Key field, you must enter the name of the variable and assign the corresponding variable to the Value.
Now you can see the test data.
If you want to send test data to Click Send to check that your setup is correct, click "Send test data to JSON" and go to your Click Send to check the result.
The result of sending data is located in your Click Send account.
If you want to change the settings, click "Edit" and you will go back a step.
If you are satisfied with everything, click “Continue”.
Example of sent data log:
Now you can start choosing the update interval and enabling auto-update.
To do this, click "Enable update".
On the main screen, click on the gear icon to select the required update interval or setup scheduled launch. To start the connection by time, select scheduled start and specify the desired time for the connection update will be started, or add several options at once when you need the connection will be started.
Attention! In order for the Scheduled Run to work at the specified time, the interval between the current time and the specified time must be more than 5 minutes. For example, you select the time 12:10 and the current time is 12:08 - in this case, the automatic update of the connection will occur at 12:10 the next day. If you select the time 12:20 and the current time is 12:13 - the auto-update of the connection will work today and then every day at 12:20.
To make the current connection transmit data only after another connection, check the box "Update connection only after start other connection" and specify the connection after which the current connection will be started.
To enable auto-update, switch the slider to the position as shown in the picture.
To perform a one-time data transfer, click on the arrow icon.
This completes setup JSON as Data Destination! See how easy it is!?
Now don't worry, ApiX-Drive will do everything on its own!