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.
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.
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.
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.
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.
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.
Click on the Deploy button to deploy the flow.
Click on the Test Run button to test the flow.
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.
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.
Click on the Deploy button to deploy the flow.
Click on the Test Run button to test the flow.
Once the flow runs successfully, click on the “i” button to view the output values.
You have successfully configured the flow.
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.
Click on the Deploy button to deploy the flow.
Click on the Test Run button to test the flow.
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.