Baserow Database

This extension allows you to use Baserow database that is a far better alternative of Airtable in your apps. This extension is based on Baserow's rest APIs.

Released on : 02 Aug 2021

Last Updated on : 23 Aug 2021

Latest Version : 1.4.0

All Blocks
image image image image
Documentation
component_event (4)

This event raises when a column got. Values is a list of data and response is a JSON body that is return by baserow.

component_event (5)

This event raises rows are got. Response content will be a JSON body that is returned by server and total rows will be number.

component_event (6)

This event raises when a particular row got. Values is a list of cells that is return by server.

component_event (7)

This event raises when name of all columns are got. Names is a list of all columns name that you table contains.

component_event (8)

This event raises when you use Create Row block and row is created in your table. Response will be a JSON body returned by the server.

component_event (9)

This event raises when a row or cell is updated. Response will be a JSON body returned by the server.

component_event (10)

This event raises when any error occurs.

component_event (11)

This event raises when a row is deleted. If the row is deleted then response variable will return Row Deleted.

component_event (12)

This event raises when a row is moved to a particular index. Response will be a JSON body returned by the server.

component_method (2)

This block helps you to create a row in table. Columns names and values must be list. If you entered any value wrong in column name then baserow will store null value to that row. If the row is created then Row Created event will be triggered.

component_method (3)

This block helps you to get the column with column name and a limit that you want to recieve. Note:- Baserow has a limit of 200 maximum records so if you tried to get more than 200 then Error Occurred event will be triggered.

component_method (4)

This block helps you to get all the columns names that your table contains. GotColumnsNames event will be trieggered with a list of all cloumns names.

component_method (5)

This block helps you to fetch a particular row in your table. Got Row event will be triggered with a list of all values ot that row.

component_method (6)

This block helps you to delete a particular row from your table. RowDeleted event will be triggered if row deleting success.

component_method (7)

This block helps you to fetch such rows that contains given text. for ex, I have three rows in my table

Firstname Lastname Age
Jill Smith 50
Eve Jackson 94
John Doe 80

And I used this block and searched Jill then the first row will be fetched and GotAllRows event will be triggered and if you searched j then all the rows will be fecthed as all row contains J letter in their cells. It is a type of filter that Baserow offers.

component_method (8)

This block helps you to fetch all the rows of table with a limit size. GotAllRow event will be triggered with a JSON response body and a integer that contains total number of the rows present in your table.

component_method (9)

This block helps you to move a particular row to a particular index. for ex I have three rows with id 1,2,3

ID Firstname Lastname Age
1 Jill Smith 50
2 Eve Jackson 94
3 John Doe 80

If I want to move the last row to the top of the table then I wills imply pass the id of the last row to row Id parameter and first row's id to before Id parameter then the updated result will be like below.

ID Firstname Lastname Age
3 John Doe 80
1 Jill Smith 50
2 Eve Jackson 94

RowMoved event will be triggered with a JSON response body. I hope you got this.

component_method (10)

This block fetches the all row in ascending or descending order of a particular column. column Name parameter accept the column name that you want to filter. And technique parameter accept string in which order you want to filter the row, There are two properties avaliable for technique.

for exampe,

ID Firstname Lastname Age
1 Jill Smith 50
2 Eve Jackson 94
3 John Doe 80

If you want to fetch the rows in ascending order of age simply pass the Ascending property to technique parameter and Age to column Name parameter. And the data will be fetched in acsending order of Age column like this.

ID Firstname Lastname Age
1 Jill Smith 50
3 John Doe 80
2 Eve Jackson 94

GotAllRows event will be triggered with a JSON response body and total number of the rows of table. I hope you got this.

component_method (11)

This block helps you to set or update the cell of a particular row of given id, column Name and the cell value. Row Updated event will be triggered when it will updated.

image

Two properties for defining the techique while fetching rows with technique.

image

This block is for setting or getting the Table name.

image

This block is for setting and getting the token. It is main thing for authenticating with your database. You need to generate it within your account.

How to Use

Creating a Row

blocks - 2021-08-03T122656.274

Make sure to enter the token and table id before you use any block.

Creating row with Hindi language

blocks - 2021-08-03T123039.887

You can also use other languages for string data.

Creating row with Turkish language

blocks-1

Creating row with Vietnamese language

blocks

Getting the Data

blocks - 2021-08-03T123341.504

Searching the Data

blocks - 2021-08-03T123613.248


Note :- Row Id != Row Number. Mean row id is given by baserow database when you create the rows. And it is the unique identity of a row. For ex, first row of your table's Id will be 1 if you delete it then the next newly created row's Id will be 2 not 1. So make sure to use correct I'd while updating and fetching the data. You can extract the row id of the newly created row from the JSON response received from Row Created event

Downloads

You can download this extension from AI2 Store.