Use Case

How to Update Adalo Records

CHECK OUT THE BYTELINE FLOW

Here is the Byteline flow used for this use case. You can clone it by following the link
How to Update Adalo Records
1
Byteline flow runs on a scheduler
Byteline flow runs in the cloud at the scheduled time. You can configure the scheduled time based on your requirements.
2
Scrape job board using Byteline Web Scraper
Jobs are scraped from ZipRecruiter using Byteline's Web scraper and Chrome extension.
Jobs to Adalo
The scraped data is then exported to a Adalo database using Byteline's integration, which automatically handles inserts, updates, and deletes just by configuring a single Knack Update task.

Step by Step Instructions

Byteline step by step blog

Byteline allows you to create, update and delete Adalo Records details using Adalo - Update Records node. In this documentation, we have explained the steps to create, update and delete Adalo records by using scheduler as a trigger, scraping crypto coins from Coinbase.com, and then exporting the data to Adalo.

We will be configuring the following nodes to update Adalo records.

Scheduler Trigger Node - First of all, we’ll have to configure the scheduler node to run the flow at a regular interval of time.

Web Scraper Node - After that, we’ll need to configure the Web Scraper node to extract data from a webpage. Here, we will scrape data from the Coinbase.com site

Adalo - Update Records node - After that, we’ll need to configure the Adalo - Update Records node to update data through a single Byteline task.


Let’s get started.

1. Configure Airtable Trigger Node
Base ID
1. Heading Category
Sub-Heading
Sub-Heading
Sub-Heading
2. Heading Category
Sub-Heading
Sub-Heading
Sub-Heading
3. Heading Category
Sub-Heading
Sub-Heading
Sub-Heading
3. Heading Category
Sub-Heading
Sub-Heading
Sub-Heading
3. Heading Category
Sub-Heading
Sub-Heading
Sub-Heading

Create Flow

In this section, you’ll learn to create the flow. For more details, you can check How to Create your First Flow Design.

Step 1: Enter the flow name to create your new flow.

Step 2: Select the Scheduler trigger node to initiate your flow. 

Now, you need to configure the Scheduler Node to run the flow at a regular interval of time.

So, let’s get started with the Scheduler node configuration.

Configuring Scheduler

For title


Step 1:
Click on the edit button to configure the scheduler node. 

Note: Scheduler gets configured by default or else, users can also change the configuration according to their requirement and then click on the Save button to save the configuration.

To learn how to configure Scheduler, you can check out the dedicated documentation on Scheduler configuration. 

Once you configure the Scheduler node to run the flow at a particular interval of time, then you’ll have to configure Web Scraper Node.

Configuring Web Scraper 

For company name

Step 1: Hover the cursor over Scheduler to display the options. Once displayed, click on the add button to view the nodes in the select node window. 

Step 2: Select the Web Scraper node to add it to your flow.

Note: Users can also use Simple HTTP, API Call, RSS feed, or any of the data sources. Byteline supports all these.

Step 3: Hover the cursor over Web Scraper to display the options. Once displayed, click on the Edit button to configure the Web Scraper node. 

Note: Now you will have to scrape the data from a certain site. Here we have scraped from the Coinbase.com site.

For details on the same, check dedicated documentation on how to configure Web Scraper.

Here are the output values of the flow we have configured.

Once you are done with the configuration, the dot will become green.

Configuring Adalo - Update Records Node

For link

Step 1:  Hover the cursor over Web Scraper to display the options. Once displayed, click on the Add button to add the Adalo - Update Records node.

Step 2: Select the Adalo - Update Records node to add it to your flow.

Step 3: Hover the cursor over Adalo - Update Records to display the options. Once displayed, click on the Edit button to configure the Adalo - Update Records node.

Step 4: Click on the Configure it now to configure your API key.

Step 5: Select the API Key and click on the Save button.

Step 6: Once connected successfully, go to your Adalo account, and on the table click on the ellipsis followed by API documentation from the drop-down menu.

Note: Users are required to keep at least one record in the table so that it can autocomplete and show columns. Adalo doesn’t have any meta API so there is no way to get column data unless you have at least one row in the table.

Step 7: Fill in the App id by copy-pasting from the Endpoint.

Step 8:  Fill in the Collection id by copy-pasting from the Endpoint.

 

Step 9: Check the box in front of the loop over and select web scraper from the drop-down menu to loop over all the data from the web scraper node.

Configuring Mapping to Adalo

For location

Step 1: Click on the selector appearing next to the Price to map it to the byteline data.

Step 2: Click on the variable to pick its path. 

After choosing the variable, the below-mentioned field will be automatically fetched.

Step 3: Click on the selector appearing next to the Symbol to map it to the byteline data.

Step 4: Click on the variable to pick its path. 

After choosing the variable, the below-mentioned field will be automatically fetched.

Step 5: Click on the selector appearing next to the Change to map it to the byteline data.

Step 6: Click on the variable to pick its path. 

After choosing the variable, the below-mentioned field will be automatically fetched.

Step 7: Click on the selector appearing next to the Name to map it to the byteline data.

Step 8: Click on the variable to pick its path.

After choosing the variable, the below-mentioned field will be automatically fetched.

Step 9: Click on the Save button to save the flow.

You have successfully created the flow to update Adalo Records.

Deploy the Flow

For run

Click on the Deploy button to deploy the flow.

Test Run the Flow

For run

Click on the Test Run button to test the flow.

View Output Values

For run


Once the flow runs successfully, click on the “i” button to view the output values.

You have successfully configured the flow to update Adalo Records.

Configuring Updates

For run

Step 1: Click on Advanced to open the drop-down menu and select Overwrite from the given options to overwrite the existing data.

Step 2: Hover the cursor over Symbol to select it as the primary field to match data.

Note: Users can also select any other field or multiple fields at a time.

Step 3: Click on the Save button to save the settings.

Deploy the Flow

For run

Click on the Deploy button to deploy the flow.

Test Run the Flow

For run

Click on the Test Run button to test the flow.

View Output Values

For run


Once the flow runs successfully, click on the “i” button to view the output values.

You have successfully configured the flow.

Configuring Delete

For run

Step 1: Click on Advanced to open the drop-down menu and select Delete from the given options to delete any data from the Adalo database that is not in the source data.

Step 2: Click on the Save button to save the settings.

Deploy the Flow

For run

Click on the Deploy button to deploy the flow.

Test Run the Flow

For run

Click on the Test Run button to test the flow.

View Output Values


For run


Once the flow runs successfully, click on the “i” button to view the output values.

You have successfully configured the flow.

Feel free to connect us for any doubts.