{"id":202,"date":"2024-10-06T10:06:49","date_gmt":"2024-10-06T10:06:49","guid":{"rendered":"https:\/\/akshatdeveloper.in\/extensions\/?p=202"},"modified":"2024-10-06T10:06:50","modified_gmt":"2024-10-06T10:06:50","slug":"nocodb","status":"publish","type":"post","link":"https:\/\/akshatdeveloper.in\/extensions\/free\/nocodb\/","title":{"rendered":"NocoDb"},"content":{"rendered":"\n

NocoDB<\/a>\u00a0provides an intuitive spreadsheet interface for creating online databases like Airtable and Baserow, either from scratch or by connecting to any Postgres\/MySQL.<\/p>\n\n\n\n

GetAllRows<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
filters<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
GetRowById<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to get a row by id. Keep the column list empty if you don’t want row of any specific column.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
rowId<\/td>number<\/td><\/tr>
columnList<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
GetColumn<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to get a column using column name. Keep the filters list empty if you want to get the column without applying any filter.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
columnName<\/td>text<\/td><\/tr>
filters<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
FilterSortBy<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to apply SortBy filter that can sort the result based on the ascending or descending order of column names.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
columnNames<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
Ascending<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to retrieve ascending order of a column name.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
columnName<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
Descending<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to retrieve descending order of a column name<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
columnName<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
FilterSkipRows<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to apply SkipRows filter that can skip first n number of rows in the data.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
number<\/td>number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
FilterLimitLength<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to apply LimitLength filter that can limit the number of rows to be retrieved in the data.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
number<\/td>number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
FilterWhere<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to apply conditional filters. Don’t include space anywhere in the condition string.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
conditions<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Return Type: text<\/p>\n\n\n\n

\n\n\n\n
GetCell<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to get a cell.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
rowId<\/td>number<\/td><\/tr>
columnName<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
GetRowCount<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
conditions<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
CreateRow<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to create row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
columnList<\/td>list<\/td><\/tr>
valueList<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
UpdateRow<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to update a row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
rowId<\/td>number<\/td><\/tr>
columnList<\/td>list<\/td><\/tr>
valueList<\/td>list<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
DeleteRow<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Function to delete a row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
rowId<\/td>number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

Events:<\/h4>\n\n\n\n

GotAllRows<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully retrieved all rows.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
values<\/td>text<\/td><\/tr>
rowIds<\/td>list<\/td><\/tr>
totalRows<\/td>number<\/td><\/tr>
response<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
GotRowById<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully retrieved row by id.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
response<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
GotColumn<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully retrieved column.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
values<\/td>text<\/td><\/tr>
totalRows<\/td>number<\/td><\/tr>
response<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
GotCell<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully retrieved cell.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
response<\/td>text<\/td><\/tr>
value<\/td>any<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
GotRowCount<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully retrieved rows count.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
count<\/td>number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
RowCreated<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully create a row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
rowId<\/td>number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
RowUpdated<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully updated row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
response<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
RowDeleted<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered when successfully deleted a row.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
response<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
OnError<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Triggered on error.<\/p>\n\n\n\n

Parameter<\/th>Type<\/th><\/tr><\/thead>
errorMessage<\/td>text<\/td><\/tr>
errorFrom<\/td>text<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

Properties:<\/h4>\n\n\n\n

Url<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Host url of NocoDB server. Change it only if you are using self hosted server.<\/p>\n\n\n\n

\n\n\n\n
TableId<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Table id of your NocoDB database.<\/p>\n\n\n\n

\n\n\n\n
Token<\/h5>\n\n\n\n

\"image\"<\/p>\n\n\n\n

API Token of your NocoDB database.<\/p>\n\n\n\n

Conditional Operators<\/strong><\/h4>\n\n\n\n

Do not include any space while using this inside the string.<\/p>\n\n\n\n

It can be used in these two blocks:<\/p>\n\n\n\n

\"image\"\u00a0\"image\"<\/p>\n\n\n\n

\n\n\n\n
Operation<\/th>Meaning<\/th>Example<\/th><\/tr><\/thead>
eq<\/td>equal<\/td>(colName,eq,colValue)<\/td><\/tr>
neq<\/td>not equal<\/td>(colName,neq,colValue)<\/td><\/tr>
not<\/td>not equal (alias of neq)<\/td>(colName,not,colValue)<\/td><\/tr>
gt<\/td>greater than<\/td>(colName,gt,colValue)<\/td><\/tr>
ge<\/td>greater or equal<\/td>(colName,ge,colValue)<\/td><\/tr>
lt<\/td>less than<\/td>(colName,lt,colValue)<\/td><\/tr>
le<\/td>less or equal<\/td>(colName,le,colValue)<\/td><\/tr>
is<\/td>is<\/td>(colName,is,true\/false\/null)<\/td><\/tr>
isnot<\/td>is not<\/td>(colName,isnot,true\/false\/null)<\/td><\/tr>
in<\/td>in<\/td>(colName,in,val1,val2,val3,val4)<\/td><\/tr>
btw<\/td>between<\/td>(colName,btw,val1,val2)<\/td><\/tr>
nbtw<\/td>not between<\/td>(colName,nbtw,val1,val2)<\/td><\/tr>
like<\/td>like<\/td>(colName,like,%name)<\/td><\/tr>
isWithin<\/td>is Within (Available in Date<\/code> and DateTime<\/code> only)<\/td>(colName,isWithin,sub_op)<\/td><\/tr>
allof<\/td>includes all of<\/td>(colName,allof,val1,val2,…)<\/td><\/tr>
anyof<\/td>includes any of<\/td>(colName,anyof,val1,val2,…)<\/td><\/tr>
nallof<\/td>does not include all of (includes none or some, but not all of)<\/td>(colName,nallof,val1,val2,…)<\/td><\/tr>
nanyof<\/td>does not include any of (includes none of)<\/td>(colName,nanyof,val1,val2,…)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Comparison Sub-Operators<\/h4>\n\n\n\n

The following sub-operators are available in Date<\/code> and DateTime<\/code> columns.<\/p>\n\n\n\n

Operation<\/th>Meaning<\/th>Example<\/th><\/tr><\/thead>
today<\/td>today<\/td>(colName,eq,today)<\/td><\/tr>
tomorrow<\/td>tomorrow<\/td>(colName,eq,tomorrow)<\/td><\/tr>
yesterday<\/td>yesterday<\/td>(colName,eq,yesterday)<\/td><\/tr>
oneWeekAgo<\/td>one week ago<\/td>(colName,eq,oneWeekAgo)<\/td><\/tr>
oneWeekFromNow<\/td>one week from now<\/td>(colName,eq,oneWeekFromNow)<\/td><\/tr>
oneMonthAgo<\/td>one month ago<\/td>(colName,eq,oneMonthAgo)<\/td><\/tr>
oneMonthFromNow<\/td>one month from now<\/td>(colName,eq,oneMonthFromNow)<\/td><\/tr>
daysAgo<\/td>number of days ago<\/td>(colName,eq,daysAgo,10)<\/td><\/tr>
daysFromNow<\/td>number of days from now<\/td>(colName,eq,daysFromNow,10)<\/td><\/tr>
exactDate<\/td>exact date<\/td>(colName,eq,exactDate,2022-02-02)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

For isWithin<\/code> in Date<\/code> and DateTime<\/code> columns, the different set of sub-operators are used.<\/p>\n\n\n\n

Operation<\/th>Meaning<\/th>Example<\/th><\/tr><\/thead>
pastWeek<\/td>the past week<\/td>(colName,isWithin,pastWeek)<\/td><\/tr>
pastMonth<\/td>the past month<\/td>(colName,isWithin,pastMonth)<\/td><\/tr>
pastYear<\/td>the past year<\/td>(colName,isWithin,pastYear)<\/td><\/tr>
nextWeek<\/td>the next week<\/td>(colName,isWithin,nextWeek)<\/td><\/tr>
nextMonth<\/td>the next month<\/td>(colName,isWithin,nextMonth)<\/td><\/tr>
nextYear<\/td>the next year<\/td>(colName,isWithin,nextYear)<\/td><\/tr>
nextNumberOfDays<\/td>the next number of days<\/td>(colName,isWithin,nextNumberOfDays,10)<\/td><\/tr>
pastNumberOfDays<\/td>the past number of days<\/td>(colName,isWithin,pastNumberOfDays,10)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Logical Operators<\/h4>\n\n\n\n

It can be used if more than one condition is to be used.<\/p>\n\n\n\n

Operation<\/th>Example<\/th><\/tr><\/thead>
~or<\/td>(checkNumber,eq,JM555205)~or((amount, gt, 200)~and(amount, lt, 2000))<\/td><\/tr>
~and<\/td>(checkNumber,eq,JM555205)~and((amount, gt, 200)~and(amount, lt, 2000))<\/td><\/tr>
~not<\/td>~not(checkNumber,eq,JM555205)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

Extension Setup<\/strong><\/h4>\n\n\n\n

Our data structure is like this:
\"image\"
<\/p>\n\n\n\n

How to get API Token?<\/a><\/p>\n\n\n\n

Getting Table ID \":point_down:\"<\/p>\n\n\n\n

\"image\"<\/p>\n\n\n\n

FAQs<\/strong><\/h4>\n\n\n\n

Q. How to use conditional filters?<\/p>\n\n\n\n

\"image\"<\/p>\n\n\n\n

Output:<\/p>\n\n\n\n

[\n  {\n    \"Id\": 35,\n    \"Name\": \"Anshuman\",\n    \"Marks\": 100,\n    \"CreatedAt\": \"2024-10-05 09:29:28+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:29:47+00:00\"\n  },\n  {\n    \"Id\": 79,\n    \"Name\": \"Nobita\",\n    \"Marks\": 0,\n    \"CreatedAt\": \"2024-10-06 06:30:25+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:30:33+00:00\"\n  }\n]\n<\/code><\/pre>\n\n\n\n
Q. How to use sort filters?<\/p>\n\n\n\n
\"image\"<\/p>\n\n\n\n
Output:<\/p>\n\n\n\n
[\n  {\n    \"Id\": 35,\n    \"Name\": \"Anshuman\",\n    \"Marks\": 100,\n    \"CreatedAt\": \"2024-10-05 09:29:28+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:29:47+00:00\"\n  },\n  {\n    \"Id\": 70,\n    \"Name\": \"Akshat\",\n    \"Marks\": 69,\n    \"CreatedAt\": \"2024-10-06 04:27:42+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:29:53+00:00\"\n  },\n  {\n    \"Id\": 72,\n    \"Name\": \"Chutki\",\n    \"Marks\": 50,\n    \"CreatedAt\": \"2024-10-06 04:32:31+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:30:23+00:00\"\n  },\n  {\n    \"Id\": 79,\n    \"Name\": \"Nobita\",\n    \"Marks\": 0,\n    \"CreatedAt\": \"2024-10-06 06:30:25+00:00\",\n    \"UpdatedAt\": \"2024-10-06 06:30:33+00:00\"\n  }\n]<\/code><\/pre>\n\n\n\n
\n
Download<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
This extension helps you to add NocoDB database into your app.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[6],"tags":[5,4,2,15],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-free","tag-akshat-developer-extensions","tag-extension","tag-free","tag-kodular"],"_links":{"self":[{"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/posts\/202"}],"collection":[{"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/comments?post=202"}],"version-history":[{"count":4,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/posts\/202\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/akshatdeveloper.in\/extensions\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}