Baserow - Open source no-code database

💽 Baserow Extension

An Opensouce no-code airtable alternative database

Baserow is open-source database that helps you to store data like an airtable. This extension has method to get, create, update or delete data of your baserow’s database. You can upload file to the baserow server through this extension.

Blocks & Documentation :

1. SetToken

blocks (2)

This block is used to set API token & must be initialized . On baserow, Go to your dashboard, Click on your profile, then setting and API token to get the token for the particular group.

2. Set TableId

blocks (3)

This block is used to set the table id of your particular table from which you wanted to fetch/write data. This block must be initialized.

3. Set URL

blocks (7)

If you are using self-hosting of base, you should set the URL to your particular url. By default, its value is https://api.baserow.io/.

4. Get Column

blocks (4)

This method will help you to get the particular column data. Page defines page of data which should be returned and accepts int. Size defines how many rows of data should be returned per page and accepts int.
After V3.2, size actually works like maxSize of Airtable. For example, I’ve 1000 rows in my table, then if you assign page 1 and size 400 then it will fetches 400 rows and call GotColumn event on success.

5. GetListFields

component_method

This method helps you to get the information about the columns in your table. It will trigger GotListFields event.

6. Get All Rows

component_method (1)

This block will help you to get the rows of the table of particular page and particular size. Page defines page of rows which should be returned and accepts int. Size defines how many rows should be returned per page and accepts int.
After V3.2, size actually works like maxSize of Airtable. For example, I’ve 1000 rows in my table, then if you assign page 1 and size 400 then it will fetches 400 rows and call GotAllRows event on success.

7. Get Row

blocks (5)

GetRow method will help you to get the particular row of the table. Remember row id is not a index id. rowId accepts integer row id. If success, GotRow Event will be triggered.

8. Create Row

blocks (6)

This block will help you to create a new row in your table. columns and values accepts YailList. Remember columns length and values length should be same. If success, then it will trigger RowCreated Event.

9. Update Row

blocks (8)

This block will help you to update existing row with new values. columns & values both accepts YailList. If success, It will trigger RowUpdated Event.

10. DeleteRow

blocks (9)

This method will help you to delete particular row of your table. If deletion is success then it will trigger RowDeleted Event.

11. MoveRow

blocks (10)

This block will help you to move the existing row before another row. rowId and beforeId both accepts integer. beforeId helps to move the row related to the given rowId before the row related to the provided value. It will trigger RowMoved method.

12. Get Cell

blocks (11)

This method will help you to get a single cell from rowId and column name . If got cell is success then it will trigger GotCell method.

13. Got Column

blocks (12)

This event is trigger from GetColumn method. It will give two objects, values & response. values is YailList which provides data in all cell of particular column and response gives true JSON response.

14. OnFieldsListed

blocks (13)

This event is triggered from GetListFields method. It will give you ids, names, types, if table is primary and tableId of the columns of your database. Basically, it gives information of you table’s columns. The above example will give you name of columns in your database in List.

15. Got All Rows

blocks (15)

This event is triggered after GetAllRows method. It will give you values, numberOfRows and response. Values is in list of rows which again contains list of data in row. So above example will give you data in your first row. You can get number of rows in your table from numberOfRows. And response will give you true JSON response.

16. Got Row

blocks (16)

This event is triggered from GetRow method. values will give you list of datas present in the particular row and response will give you true JSON response.

17. Got Cell

blocks (17)

This event is triggered from GetCell method. value will give you the data stored in the particular cell and response will give you the true JSON response.

18. Row Created

blocks (18)

This event is triggered from CreateRow method. response will give you JSON response from baserow.

19. Row Updated

component_event (2)

This event is triggered from UpdateRow method. response will give you JSON response from baserow.

20. Row Deleted

component_event (3)

This event is triggered from DeleteRow method. response will give you JSON response from baserow.

21. Row Moved

component_event (4)

This event is triggered from RowMoved method. response will give you JSON response from baserow.


Version 3 :

22. UploadFileByUrl

component_method

This method will help you to upload file through url to baserow server. token parameter needsjwtToken which can be generated from GenerateToken block. The single token generated from this method will be valid for only 60 minutes, So you can refresh token to generate a new one from old token by RefreshToken method. You can also check validity of the token from VerifyToken method. fileUrl parameter need direct file url.

23. GenerateToken

component_method (1)

This method will help you to generate new jwtToken. It needs username & password of your baserow account as parameters. So, I’ll not suggest you to use this method in public app instead you can make an admin app and send jwtToken to your public app. This block will trigger TokenGenerated event.

24. RefreshToken

component_method (2)

This method will help you to refresh a new jwtToken from your old valid jwtToken. It will trigger TokenGenerated event.

25. VerifyToken

component_method (3)

This method will help you to check token’s validity whether it is still valid to use or you have to generate new token. It will trigger TokenVerified event.

26. TokenGenerated

component_event

This event is triggered from GenerateToken & RefreshToken method. It provides you new jwtToken which you can use to upload file as well as response is true Json response.

27. TokenVerified

component_event (1)

This event is raised from VerifyToken method. This can be used to check if the jwtToken is valid or not. isVerified will give you boolean wether jwtToken is still valid or not.

28. FileUploadedByUrl

component_event (2)

This event is raised from UploadFileByUrl method. It will give you size, url, mimeType, isImage, name, originalName of the file you have uploaded as well as give you true jsonResponse.


Downloads :

The first version of this extension was launched in MIT Community.

See All Releases From Here

Download Latest Version :
com.oseamiya.baserow

This extension is open-source here :

Donate :

34 Likes

Congratulations for the extension :star:

2 Likes

This post was flagged by the community and is temporarily hidden.

3 Likes

Wow… Very good and valuable extension for those who feel hard to link baserow to their app.

Keep going @oseamiya

3 Likes

And it’s open source, well done!

2 Likes

Epic extension, Salute to you :smiling_face_with_three_hearts:
:upside_down_face:

1 Like

awesome extension @oseamiya :heart_eyes: :clap:

2 Likes

Excellent piece of work :+1: :sweat_smile:

2 Likes

@vknow360 , @Raja_HarshVardhanSolanki @Still-learning @UnknownBeast @Victor_Ken @Yashsehgal022 @FlailingOctopus

Thankyou for your comments ! :heart:

6 Likes

Awesome Extension @oseamiya :clap: :+1:

2 Likes

Help ,Where will I get the Tableid?
5649854

2 Likes


See in the URL, 26599 is the table id for this table…

You can either set in properties :
image

or by using this block

Also Thankyou @Anu for your comment. :heart:

3 Likes

You can find all your table ids of a group in token panel. Where you generates your tokens.

8 Likes


I get this error

1 Like

Got it and fixed here :-
com.oseamiya.baserow.aix (109.0 KB)
Thankyou for reporting issue @Jishnu_Vardhan_Reddy

See fixed issues here (Commits) :

3 Likes

Amazing works!!!

2 Likes

Is it better than airtable? By the way, nice extension.

2 Likes

Really awesome. I was about to create an open source version but I am glad you did it first. Superb.

2 Likes

Wow :golfing_woman: Great extension.

2 Likes

Maybe… You can compare their services .

2 Likes