Baserow

GetAllRows

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. Size should always be less than or equal to 200 else it will trigger OnError event. If successful then it will trigger GotAllRows event method.

GetRow

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.

CreateRow

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.

UpdateRow

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

MoveRow

  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.  

DeleteRow

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

GenerateToken

  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.  

RefreshToken

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

VerifyToken

  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.  

UploadFileByUrl

  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.  

TableId

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.

Url

  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/.  

Token

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.

OnFieldsListed

  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.  

OnError

This event is triggered while error.

GotCell

  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.  

GotColumn

  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.  

GotAllRows

  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.  

GotRow

  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.  

RowCreated

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

RowUpdated

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

RowMoved

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

RowDeleted

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

TokenGenerated

  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.  

TokenVerified

  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.  

FileUploadedByUrl

  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.  

Why I didn’t removed page parameter in this version ?

Now, If I can fetch any max amount of rows then what is the need of page parameter in GetColumn method and GetAllRows method ?

Yeah, If you are not experimenting with databases & you are a Airtable user and you are migrating to Baserow then you can simply set page parameter to 1 and use size as maxSize like Airtable.

But page can be very important in some scenarios & can be used to experiment . For example, If have 1000 rows but I only need to fetch value from 200 to 400 then I can assign page as 2 and size as 200.