15.05.2024
296

How to Connect JSON as Data Destination

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".

How to Connect JSON as Data Destination | Setup Data Destination system

Select the system as Data Destination. In this case, JSON must be specified.

How to Connect JSON as Data Destination | System selection

Next, you need to specify the action - Send DATA.

How to Connect JSON as Data Destination | Action selection

- 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.

How to Connect JSON as Data Destination | Account connection

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.

How to Connect JSON as Data Destination | Editing settings
How to Connect JSON as Data Destination | Editing settings

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.

How to Connect JSON as Data Destination | Editing settings
How to Connect JSON as Data Destination | Editing settings
How to Connect JSON as Data Destination | Editing settings

In the Key field, you must enter the name of the variable and assign the corresponding variable to the Value.

How to Connect JSON as Data Destination | Editing settings
How to Connect JSON as Data Destination | Editing settings

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”.

How to Connect JSON as Data Destination | Test data

Example of sent data log:

How to Connect JSON as Data Destination | Data log

Now you can start choosing the update interval and enabling auto-update.

To do this, click "Enable update".

How to Connect JSON as Data Destination | Enable auto-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.

How to Connect JSON as Data Destination | Update interval

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.

How to Connect JSON as Data Destination | Update priority

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.

How to Connect JSON as Data Destination | Enable auto-update

This completes setup JSON as Data Destination! See how easy it is!?

Now don't worry, ApiX-Drive will do everything on its own!