lib_BaseRow

This is the Baserow connector for Convertigo. Use this connector to exchange data with Baserow databases.

Symbols

This library uses the following symbols

Symbol	Usage
lib_baserow.server	the host name of the baserow server
lib_baserow.port	the port baserow server, set to 443 for https, to 80 for http
lib_baserow.https	set to true for https, to false otherwise
lib_baserow.password.secret	The baserow admin password
lib_baserow.adminuser	The baserow admin user email.

For more technical informations : documentation

• Installation
• Sequences
  • _disabled_formssource_GetSelectDataOld
  • _disabled_formssource_GetTableDataOld
  • AdminLogin
  • AdminUserCreate
  • AdminUserDelete
  • AssetFileUpload
  • ClearTableIdCache
  • DatabaseTokenCreate
  • DatabaseTokenDelete
  • DatabaseTokenList
  • FieldsList
  • FieldsListApiKey
  • forms_AddRow
  • forms_AddRowFromData
  • forms_DeleteRow
  • formscommon_ApplicationsList
  • formscommon_CheckConfig
  • formscommon_FieldsList
  • formssource_GetFieldValues
  • formssource_GetSelectData
  • formssource_GetTableData
  • FSExecuteView
  • FSPullAndPushTable
  • GroupsList
  • TableBulkExportToCSV
  • TableBulkExportWaitFInished
  • TableBulkImportFromCSV
  • TableBulkUpdateFromCSV
  • TableCreateColumn
  • TableCreateRow
  • TableCreateRowApiKey
  • TableCreateRows
  • TableCreateRowsApiKey
  • TableCreateView
  • TableCreateViewFilter
  • TableDeleteAllRows
  • TableDeleteRow
  • TableDeleteView
  • TableGetData
  • TableGetDataApiKey
  • TableGetRowByIdApiKey
  • TableGetViews
  • TableReadRow
  • TableUpdateRow
  • TableUpdateRowApiKey
  • TokenGetOrRefresh

Installation

1. In your Convertigo Studio use File->Import->Convertigo->Convertigo Project and hit the Next button

2. In the dialog Project remote URL field, paste the text below:

   Usage	Click the copy button
   To contribute	[email protected]:convertigo/c8oprj-lib-baserow.git:branch=master
   To simply use	[email protected]:convertigo/c8oprj-lib-baserow/archive/master.zip

3. Click the Finish button. This will automatically import the lib_BaseRow project

Sequences

_disabled_formssource_GetSelectDataOld

Get data from a Baserow table. You will be able to choose the Baserow columns for the names to be displayed in the select dropdown list and the column for the values of each name.

variables

name	comment
forms_config	Choose a table in Baserow
forms_filter	Filters
forms_Filter	Define a filter to apply to Baserow table
model	If true, just return one line of data so that No Code studio can compte the table model

_disabled_formssource_GetTableDataOld

Get data from a Baserow table for a data grid. Each column of the Baserow table will be displayed as the same column in the data grid

variables

name	comment
forms_config	Choose a table in Baserow
forms_tableFilter	Define a filter to apply to Baserow table
model	If true, just return one line of data so that No Code studio can compte the table model

AdminLogin

Establishes a session with Baserow. Must be called before any other API

variables

name	comment
email	The Base row admin email
password	The baserow admin password

AdminUserCreate

Create a user

variables

name	comment
email
name
password

AdminUserDelete

Delete a User

variables

name	comment
user_id	The id of the user to delete

AssetFileUpload

Uploads a file asset, the returned link can be used to be set as a value of a 'file' Type cell

variables

name	comment
apikey	The API Key
file	A File variable holding the path to the file to be uploaded

ClearTableIdCache

DatabaseTokenCreate

Create a Token to acess databases within a group. This token will hold permissions to specific databases in the group

variables

name	comment
group_id	The ID of the group holding the databases to get a token to (Unique)
name	Token Name

DatabaseTokenDelete

Delete a previously created Token by providing its id

variables

name	comment
token_id	Deletes the token related to the provided value.

DatabaseTokenList

Create a Token to acess databases within a group. This token will hold permissions to specific databases in the group

FieldsList

Lists all the fields in a baserow table

variables

name	comment
table_id	Returns only the fields of the table related to the provided value.

FieldsListApiKey

Lists all the fields in a baserow table

variables

name	comment
apikey
table_id	Returns only the fields of the table related to the provided value.

forms_AddRow

Add or update a row in a table. If a column in the table has the same name as the technical ID of a form field, the data will be inserted into that column. If the 'Columns creation' option is enabled, a column will be created when the technical ID of a form field does not match any column in the form. Form fields can be of any type, but typically, selection lists are mapped to linked columns.

variables

name	comment
doc
forms_config	Choose a table in the no-code database
forms_createColumn	Create a column if a field identifier does not match any column in the table
forms_id	The Identifier of the row to update. If not set, the action will add a row. If set, all row's columns identified by the 'technicalID' will be updated
originalDoc

forms_AddRowFromData

Add or update a row in a table. Add columns to fill by pressing the + button, and entering a column name and a value for the column. This operation can be repeated as many times as necessary. If 'Create Columns' option is enabled, a column will be created when the provided column name does not match any column in the table

variables

name	comment
doc
forms_config	Choose a table in the no-code database
forms_createColumn	Create a column if a field identifier does not match any column in the table
forms_freeVars	Enter a column name and a value to associate with it
forms_id	The Identifier of the row to update. If not set, the action will add a row. If set, all row's columns identified by the 'technicalID' will be updated
originalDoc

forms_DeleteRow

Deletes a data row from a table

variables

name	comment
doc
forms_config	Choose a table in the no-code database
forms_id	The Identifier of the row to delete
originalDoc

formscommon_ApplicationsList

Lists all applications (databases) in baserow

formscommon_CheckConfig

variables

name	comment
forms_config	Fills the select component from data with a given configuration. The first column will be the displayed item in the select, the second column will be the value of this item

formscommon_FieldsList

variables

name	comment
forms_config	Choose a table in Baserow

formssource_GetFieldValues

Retrieve all possible values from a dropdown list.

variables

name	comment
forms_config	Choose a table
forms_filter	Filters

formssource_GetSelectData

Get data from the no-code database table. You will be able to choose the columns for the names to be displayed in the select dropdown list and the column for the values of each name.

variables

name	comment
forms_config	Choose a table
forms_filter	Filters
forms_Filter	Define a filter to apply to a table
forms_tableSort	Define a sort order to apply to a table
model	If true, just return one line of data so that No Code studio can compte the table model

formssource_GetTableData

Get data from the no-code database table for a data grid. Each column of the table will be displayed as the same column in the data grid

variables

name	comment
forms_config	Choose a table
forms_tableFilter	Define a filter to apply to a table
forms_tableSort	Define a sort order to apply to a table
model	If true, just return one line of data so that No Code studio can compte the table model

FSExecuteView

Execute a FullSync View

variables

name	comment
_use_ddoc
_use_descending
_use_endkey
_use_group
_use_group_level
_use_key
_use_limit
_use_reduce
_use_startkey
_use_view

FSPullAndPushTable

Push a BaserowTable to FullSync for offline access

variables

name	comment
chunkSize
table_id	The table id to create and start an export job for

GroupsList

Lists all Groups for the current user

TableBulkExportToCSV

Exports a Table to CSV.. Export status must me monitored with the TableBulkExportWaitFinished sequence

variables

name	comment
table_id	The table id to create and start an export job for

TableBulkExportWaitFInished

Wait for an export job to be finished. Will return the URL to the exported data

variables

name	comment
job_id	The job id to lookup information about.

TableBulkImportFromCSV

Uploads a CSV to a table. Each CSV column will be mapped to the existing table Column. If there is more columns in the CSV than in the table additional columns will not be mapped.

variables

name	comment
chunkSize	The Number of lines imported for each loop
files	List of CSV files to be imported in the table . Can be only one
fileSeparator	The column seperatorr ( , or ; )
firstLineColumn	Set to true if the first CSV lines represents columns names
quoteChar	The character to be used to identify strings ion the CSV file (Usually " but can be ')
table_id	The table ID (Can also be a generic 'Workspace~>Base~>Table' definition)

TableBulkUpdateFromCSV

Updates or inserts data in a Table from a CSV file. Given a list of column names, the sequence will update all lines from the CSV where the column names will be considered as unique ids. If CSV file contains lines not matching the columns names, they will be added to the table.

variables

name	comment
chunkSize	The Number of lines imported for each loop
files	List of CSV files to be imported in the table . Can be only one
fileSeparator	The column seperatorr ( , or ; )
firstLineColumn	Set to true if the first CSV lines represents columns names
quoteChar	The character to be used to identify strings ion the CSV file (Usually " but can be ')
table_id	The table ID (Can also be a generic 'Workspace~>Base~>Table' definition)
uniqueFields	List of fields name representing an unique line in the CSV identifying the line to be updated in the table. (Can be only one field)

TableCreateColumn

Creates a row in a table

variables

name	comment
data	A JSON object with each field name and value
table_id	Insert row in this table_id

TableCreateRow

Creates a row in a table

variables

name	comment
before	If provided then the newly created row will be positioned before the row with the provided id.
data	A JSON object with each field name and value
table_id	Insert row in this table_id

TableCreateRowApiKey

Creates a row in a table using an apikey instead of credentials

variables

name	comment
apikey
before	If provided then the newly created row will be positioned before the row with the provided id.
data	A JSON object with each field name and value
table_id	Insert row in this table_id

TableCreateRows

Creates a row in a table

variables

name	comment
data	A JSON object with each field name and value
table_id	Insert row in this table_id

TableCreateRowsApiKey

Creates a row in a table

variables

name	comment
apikey
data	A JSON object with each field name and value, such as: {"items" : [{"field1":"value1", "field2": "value2"}, {"field1":"value1B", "field2": "value2B"}]}
table_id	Insert row in this table_id
user_field_names	A flag query parameter which if provided this endpoint will expect and return the user specified field names instead of internal Baserow field names (field_123 etc).

TableCreateView

Creates a new view for the table related

variables

name	comment
apikey
data
table_id	Insert row in this table_id

TableCreateViewFilter

Updates the existing filter if the authorized user has access to the related database's group.

variables

name	comment
apikey
data
table_id	Returns only the fields of the table related to the provided value.
view_id	Creates a filter for the view related to the provided value.

TableDeleteAllRows

Deletes all rows from a table

variables

name	comment
chunkSize	The Number of lines deleted for each loop
table_id	The table ID (Can also be a generic 'Workspace~>Base~>Table' definition)

TableDeleteRow

deletes a row from a from a given table

variables

name	comment
row_id	Deletes the row related to the value.
table_id	Returns the rows of the table related to the provided value.

TableDeleteView

Deletes the existing view if the authorized user has access to the related database's group. Note that all the related settings of the view are going to be deleted also. The data stays intact after deleting the view because this is related to the table and not the view.

variables

name	comment
apikey
view_id	Deletes the view related to the provided value.

TableGetData

Gets data from a given table

variables

name	comment
describeStructure
exclude	All the fields are included in the response by default. You can select a subset of fields by providing the exclude query parameter. If you for example provide the following GET parameter `exclude=field_1,field_2` then the fields with id `1` and id `2` are going to be excluded from the selection and response. If the `user_field_names` parameter is provided then instead exclude should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `exclude=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `exclude=My Field,Field with \"`.
filterExpression	A JSON Structure representing the filters in the form : { "mode": "AND", // Can be AND or OR "filters": [ { "field": "Name", // The name of the column to filter on "op": "contains", // the operation, can be any of the operations described below "value": "Little" // The value of the filter operation }, { "field": "Description", "op": "contains", "value": "1954" } ] } operations Filter Example value Full example equal string field is 'string' not_equal string field is not 'string' date_equal 2020-01-01 field is date '2020-01-01' date_not_equal 2020-01-01 field is not date '2020-01-01' date_equals_today field is today date_before_today field is before today date_after_today field is after today date_equals_days_ago Europe/Paris?1 field is days ago 'Europe/Paris?1' date_equals_months_ago Europe/Paris?1 field is months ago 'Europe/Paris?1' date_equals_years_ago Europe/Paris?1 field is years ago 'Europe/Paris?1' date_equals_week field in this week date_equals_month field in this month date_equals_year field in this year date_equals_day_of_month 1 field day of month is '1' date_before 2020-01-01 field is before date '2020-01-01' date_after 2020-01-01 field is after date '2020-01-01' contains string field contains 'string' filename_contains string field filename contains 'string' has_file_type image / document field has file type 'image / document' contains_not string field contains not 'string' length_is_lower_than 5 field length is lower than '5' higher_than 100 field higher than '100' lower_than 100 field lower than '100' single_select_equal 1 field is '1' single_select_not_equal 1 field is not '1' boolean true field is 'true' link_row_has 1 field has '1' link_row_has_not 1 field has not '1' link_row_contains string field contains 'string' link_row_not_contains string field contains not 'string' multiple_select_has 1 field has '1' multiple_select_has_not 1 field has not '1' empty field is empty not_empty field is not empty
include_fields	All the fields are included in the response by default. You can select a subset of fields by providing the include query parameter. If you for example provide the following GET parameter `include=field_1,field_2` then only the fields withid `1` and id `2` are going to be selected and included in the response. If the `user_field_names` parameter is provided then instead include should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `include=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `include=My Field,Field with \"`.
order_by	Optionally the rows can be ordered by provided field ids separated by comma. By default a field is ordered in ascending (A-Z) order, but by prepending the field with a '-' it can be ordered descending (Z-A). If the `user_field_names` parameter is provided then instead order_by should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `order_by=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `order_by=My Field,Field with \"`.
page	Defines which page of rows should be returned.
search	If provided only rows with data that matches the search query are going to be returned.
size	Defines how many rows should be returned per page.
table_id	Returns the rows of the table related to the provided value.
view_id	Includes all the filters and sorts of the provided view.

TableGetDataApiKey

Gets data from a given table

variables

name	comment
apikey
exclude	All the fields are included in the response by default. You can select a subset of fields by providing the exclude query parameter. If you for example provide the following GET parameter `exclude=field_1,field_2` then the fields with id `1` and id `2` are going to be excluded from the selection and response. If the `user_field_names` parameter is provided then instead exclude should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `exclude=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `exclude=My Field,Field with \"`.
filterExpression	A JSON Structure representing the filters in the form : { "mode": "AND", // Can be AND or OR "filters": [ { "field": "Name", // The name of the column to filter on "op": "contains", // the operation, can be any of the operations described below "value": "Little" // The value of the filter operation }, { "field": "Description", "op": "contains", "value": "1954" } ] } operations Filter Example value Full example equal string field is 'string' not_equal string field is not 'string' date_equal 2020-01-01 field is date '2020-01-01' date_not_equal 2020-01-01 field is not date '2020-01-01' date_equals_today field is today date_before_today field is before today date_after_today field is after today date_equals_days_ago Europe/Paris?1 field is days ago 'Europe/Paris?1' date_equals_months_ago Europe/Paris?1 field is months ago 'Europe/Paris?1' date_equals_years_ago Europe/Paris?1 field is years ago 'Europe/Paris?1' date_equals_week field in this week date_equals_month field in this month date_equals_year field in this year date_equals_day_of_month 1 field day of month is '1' date_before 2020-01-01 field is before date '2020-01-01' date_after 2020-01-01 field is after date '2020-01-01' contains string field contains 'string' filename_contains string field filename contains 'string' has_file_type image / document field has file type 'image / document' contains_not string field contains not 'string' length_is_lower_than 5 field length is lower than '5' higher_than 100 field higher than '100' lower_than 100 field lower than '100' single_select_equal 1 field is '1' single_select_not_equal 1 field is not '1' boolean true field is 'true' link_row_has 1 field has '1' link_row_has_not 1 field has not '1' link_row_contains string field contains 'string' link_row_not_contains string field contains not 'string' multiple_select_has 1 field has '1' multiple_select_has_not 1 field has not '1' empty field is empty not_empty field is not empty
include_fields	All the fields are included in the response by default. You can select a subset of fields by providing the include query parameter. If you for example provide the following GET parameter `include=field_1,field_2` then only the fields withid `1` and id `2` are going to be selected and included in the response. If the `user_field_names` parameter is provided then instead include should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `include=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `include=My Field,Field with \"`.
order_by	Optionally the rows can be ordered by provided field ids separated by comma. By default a field is ordered in ascending (A-Z) order, but by prepending the field with a '-' it can be ordered descending (Z-A). If the `user_field_names` parameter is provided then instead order_by should be a comma separated list of the actual field names. For field names with commas you should surround the name with quotes like so: `order_by=My Field,"Field With , "`. A backslash can be used to escape field names which contain double quotes like so: `order_by=My Field,Field with \"`.
page	Defines which page of rows should be returned.
search	If provided only rows with data that matches the search query are going to be returned.
size	Defines how many rows should be returned per page.
table_id	Returns the rows of the table related to the provided value.
view_id	Includes all the filters and sorts of the provided view.

TableGetRowByIdApiKey

Gets data from a given table

variables

name	comment
apikey
row_id	Returns the row related the provided value.
table_id	Returns the rows of the table related to the provided value.

TableGetViews

List all views for the table related

variables

name	comment
apikey
include	A comma separated list of extra attributes to include on each view in the response. The supported attributes are filters, sortings and decorations. For example include=filters,sortings will add the attributes filters and sortings to every returned view, containing a list of the views filters and sortings respectively.
limit	The maximum amount of views that must be returned. This endpoint doesn't support pagination, but if you for example just need to fetch the first view, you can do that by setting a limit. There isn't a limit by default.
table_id	Returns only views of the table related to the provided value.
type	Optionally filter on the view type. If provided, only views of that type will be returned.

TableReadRow

Reads a row from a from a given table

variables

name	comment
row_id	Deletes the row related to the value.
table_id	Returns the rows of the table related to the provided value.

TableUpdateRow

Updates a row in a table

variables

name	comment
data
row_id	Insert row in this table_id
table_id	Insert row in this table_id

TableUpdateRowApiKey

Updates a row in a table ising apikey instead of credentials

variables

name	comment
apikey
data
row_id	Insert row in this table_id
table_id	Insert row in this table_id

TokenGetOrRefresh

Gets a token or refresh it if the token is expired the Token will be placed in the current user session

variables

name	comment
email	The Base row admin email
password	The baserow admin password