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.
All Blocks
Documentation
This event raises when a column got. Values is a list of data and response is a JSON body that is return by baserow.
This event raises rows are got. Response content will be a JSON body that is returned by server and total rows will be number.
This event raises when a particular row got. Values is a list of cells that is return by server.
This event raises when name of all columns are got. Names is a list of all columns name that you table contains.
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.
This event raises when a row or cell is updated. Response will be a JSON body returned by the server.
This event raises when any error occurs.
This event raises when a row is deleted. If the row is deleted then response variable will return
Row Deleted
.
This event raises when a row is moved to a particular index. Response will be a JSON body returned by the server.
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.
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.
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.
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.
This block helps you to delete a particular row from your table. RowDeleted
event
will be triggered if row deleting success.
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.
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.
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.
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.
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.
Two properties for defining the techique while fetching rows with technique.
This block is for setting or getting the Table name.
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
Make sure to enter the token and table id before you use any block.
Creating row with Hindi language
You can also use other languages for string data.
Creating row with Turkish language
Creating row with Vietnamese language
Getting the Data
Searching the Data
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.