How to Connect Short.io as Data Search

Integration with Short.io is implemented as a separate Search block, which can be placed between the Data Source and Data Destination. This will allow you to compress the resulting URL from the Data Source and use it in further work. Also, you will be able to compress URLs based on data from other systems and automate the process of interacting with data in conjunction with the services you use.

The function allows you to shorten links via Short.io for further work with them and update data.

Navigation:

Connecting Short.io as a Data Search:

1. What data can you get from Short.io?
2. How to connect your Short.io account to ApiX-Drive?
3. How to set up data search in Short.io in the selected action?
4. An example of data that will be transferred from Short.io.

Setting up row updates in Google Sheets:
1. What will the Google Sheets integration do?
2. How to connect your Google Sheets account to ApiX-Drive?
3. How can I set up the selected action to transfer data to Google Sheets?
4. Example of data that will be sent to your Google Sheets.
5. Auto-update and update interval.

When you have created the "Data Source" block, add a new block such as "Data Search". To do this, click on the “+” under the Data Source block and select “ Data SEARCH” from the list.

As the system in which the search will be performed, select "Short.io".

Next, select an action, for example “Compress URL”.

- Compress URL - your Short.io account will compress the link based on data from the Data Source.
- Create Bitlink - a Bitlink will be created in your Short.io account based on data from the Data Source.

The next step is to select a Short.io account.

If there are no accounts connected to the ApiX-Drive system, click “Connect account”.

In the window that opens, you must fill in the "API Key" field.

In your Short.io account, go to the "Integrations & API" section and click the "Create API key" button.

Click "Create".

Note! You need to create a regular key, not a public one.

Скопируйте созданный ключ API и вставьте его в соответствующее поле в системе ApiX-Drive.

When the connected account appears in the "active accounts" list, select it.

Attention! If your account is on the "inactive accounts" list, check your access to this login!

Now specify the Domain and the variable in which the shortening link will be passed. Also, you can fill in the remaining fields with other data.

Note! In the "Full URL" field, you must specify a link with "https://".

Now you see test data from one of the links. You can pass this data to your reception table.

If the test data does not appear automatically, click “Search in Short.io.”

If you are not satisfied with something, click “Edit”, go back a step and change the search field settings.

This completes the Data Search setup!

Now we can start setting up Google Sheets as a Data Destination system.

To do this, click "Data DESTINATION".  

Setup Data Destination system: Google Sheets

Select the system as Data Destination. In this case, you must specify Google Sheets.

Next, you need to specify the action "Update ROW".

The next step is to select a Google Sheets account into which the shortened links will be transferred. If this is the same account, then we select it.

If you need to connect another login to the system, click “Connect account” and repeat the same steps described when connecting Google Sheets as a Data Source.

Now you need to select the File (Table) and Sheet in which the row with the shortened link will be updated.

In the "Search Column" field, you need to select the column in which the data will be searched. That is, where to look for data in the table.

Next, in the “Search” field, you need to select a variable from the drop-down list or enter the data manually, by what value the system will search for data, to update the row you need. In our case, we select column “E”, which contains information about the link. The system will update the data in the required row only if the link in it matches.

Also, you need to specify the Search Type, in case several lines with the same links are found:

"First found row" - searching and updating data will occur in the first found row that satisfies the search conditions.
"Last found row" - searching and updating data will occur in the last found row that satisfies the search conditions.
"All found rows" - search and update of data will be performed on all found rows that satisfy the search conditions.  

Also specify the option how to Overwrite data:

- Overwrite old data - new data will be written over the old ones.
- Append to old data - new data from the Data Source will be appended to the old data.

Now you need to assign a shortened link variable to the empty column, which we take from the Data Search block. In the future, the data in this column will be updated.

After setting, click “Continue”.

Thus, the Data Search block takes the field in which you have a link in the Data Source, shortens it in the Short.io system and transfers the compressed link to the Data Destination field, for example, in column “F”.

This completes the Data Destination system setup!

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 set up scheduled launch. To start the connection by time, select scheduled start and specify the desired time for the connection update to be triggered, or add several options at once when you need the connection to be triggered.

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 force the connection, click on the arrow icon.  

This completes the shorten of links via Short.io in the Data Search block! It's quite simple!

Now you don’t have to worry, ApiX-Drive will do everything on its own!