This extension helps you to integrate NocoDB database in your app.
Events:
GotAllRows
Triggered when successfully retrieved all rows.
| Parameter | Type |
|---|---|
| values | text |
| rowIds | list |
| totalRows | number |
| response | text |
GotRowById
Triggered when successfully retrieved row by id.
| Parameter | Type |
|---|---|
| response | text |
GotColumn
Triggered when successfully retrieved column.
| Parameter | Type |
|---|---|
| values | text |
| totalRows | number |
| response | text |
GotCell
Triggered when successfully retrieved cell.
| Parameter | Type |
|---|---|
| response | text |
| value | any |
GotRowCount
Triggered when successfully retrieved rows count.
| Parameter | Type |
|---|---|
| count | number |
RowCreated
Triggered when successfully create a row.
| Parameter | Type |
|---|---|
| rowId | number |
RowUpdated
Triggered when successfully updated row.
| Parameter | Type |
|---|---|
| response | text |
RowDeleted
Triggered when successfully deleted a row.
| Parameter | Type |
|---|---|
| response | text |
OnError
Triggered on error.
| Parameter | Type |
|---|---|
| errorMessage | text |
| errorFrom | text |
Methods:
GetAllRows
Function to get all rows of the database. Keep the filterList empty if you don’t want to filter the data based on certain conditions.
| Parameter | Type |
|---|---|
| filters | list |
GetRowById
Function to get a row by id. Keep the column list empty if you don’t want row of any specific column.
| Parameter | Type |
|---|---|
| rowId | number |
| columnList | list |
GetColumn
Function to get a column using column name. Keep the filters list empty if you want to get the column without applying any filter.
| Parameter | Type |
|---|---|
| columnName | text |
| filters | list |
FilterSortBy
Function to apply SortBy filter that can sort the result based on the ascending or descending order of column names.
| Parameter | Type |
|---|---|
| columnNames | list |
Return Type: text
Ascending
Function to retrieve ascending order of a column name.
| Parameter | Type |
|---|---|
| columnName | text |
Return Type: text
Descending
Function to retrieve descending order of a column name
| Parameter | Type |
|---|---|
| columnName | text |
Return Type: text
FilterSkipRows
Function to apply SkipRows filter that can skip first n number of rows in the data.
| Parameter | Type |
|---|---|
| number | number |
Return Type: text
FilterLimitLength
Function to apply LimitLength filter that can limit the number of rows to be retrieved in the data.
| Parameter | Type |
|---|---|
| number | number |
Return Type: text
FilterWhere
Function to apply conditional filters. Don’t include space anywhere in the condition string.
| Parameter | Type |
|---|---|
| conditions | text |
Return Type: text
GetCell
Function to get a cell.
| Parameter | Type |
|---|---|
| rowId | number |
| columnName | text |
GetRowCount
Function to get row count. Keep the conditions string empty if you don’t want to retrieve count based on certain conditions. If you are adding any condition don’t include space anywhere in the string.
| Parameter | Type |
|---|---|
| conditions | text |
CreateRow
Function to create row.
| Parameter | Type |
|---|---|
| columnList | list |
| valueList | list |
UpdateRow
Function to update a row.
| Parameter | Type |
|---|---|
| rowId | number |
| columnList | list |
| valueList | list |
DeleteRow
Function to delete a row.
| Parameter | Type |
|---|---|
| rowId | number |
Properties:
Url
Host url of NocoDB server. Change it only if you are using self hosted server.
TableId
Table id of your NocoDB database.
Token
API Token of your NocoDB database.
Usage
This is how our data structure looks on NocoDB
Now we have to get an APi token from the NocoDB dashboard that we will be adding in the extension in order to integrate the database with our app.
Now we have to get the table ID
[
{
"Id": 35,
"Name": "Anshuman",
"Marks": 100,
"CreatedAt": "2024-10-05 09:29:28+00:00",
"UpdatedAt": "2024-10-06 06:29:47+00:00"
},
{
"Id": 79,
"Name": "Nobita",
"Marks": 0,
"CreatedAt": "2024-10-06 06:30:25+00:00",
"UpdatedAt": "2024-10-06 06:30:33+00:00"
}
]
[
{
"Id": 35,
"Name": "Anshuman",
"Marks": 100,
"CreatedAt": "2024-10-05 09:29:28+00:00",
"UpdatedAt": "2024-10-06 06:29:47+00:00"
},
{
"Id": 70,
"Name": "Akshat",
"Marks": 69,
"CreatedAt": "2024-10-06 04:27:42+00:00",
"UpdatedAt": "2024-10-06 06:29:53+00:00"
},
{
"Id": 72,
"Name": "Chutki",
"Marks": 50,
"CreatedAt": "2024-10-06 04:32:31+00:00",
"UpdatedAt": "2024-10-06 06:30:23+00:00"
},
{
"Id": 79,
"Name": "Nobita",
"Marks": 0,
"CreatedAt": "2024-10-06 06:30:25+00:00",
"UpdatedAt": "2024-10-06 06:30:33+00:00"
}
]
