# APIs **URL:** https://community.nocodb.com/c/apis/6.md [Latest](https://community.nocodb.com/latest.md) · [Categories](https://community.nocodb.com/categories.md) · [Tags](https://community.nocodb.com/tags.md) --- ## [About the APIs category](https://community.nocodb.com/t/about-the-apis-category/15)
**Author:** [@Navi](https://community.nocodb.com/u/Navi)\ **Replies:** 0
--- ## [How does nc\_order work?](https://community.nocodb.com/t/how-does-nc-order-work/2194)
**Author:** [@BizDev](https://community.nocodb.com/u/BizDev)\ **Replies:** 2\ **Last updated:** [April 15, 2026, 2:39pm UTC](https://community.nocodb.com/t/how-does-nc-order-work/2194 "2026-04-15T14:39:17Z")
How does the field nc\_order work? Specifically for sorting, is there a way I explicitly use this field? I only see this field in the Relations view of the Details tab in our self-hosted NocoDB dashboard, but nowhere els… --- ## [Read data in postman](https://community.nocodb.com/t/read-data-in-postman/2176)
**Author:** [@hrithik](https://community.nocodb.com/u/hrithik)\ **Replies:** 3\ **Last updated:** [February 16, 2026, 4:13pm UTC](https://community.nocodb.com/t/read-data-in-postman/2176 "2026-02-16T16:13:01Z")
I’m trying to fetch particular record from a test table, but its giving me this error. Haven’t define any params or authorization only headers. Can someone help if i’m missing something here --- ## [NOCODB container crashes when inserting a record](https://community.nocodb.com/t/nocodb-container-crashes-when-inserting-a-record/2145)
**Author:** [@OVERS1ZZEEEE](https://community.nocodb.com/u/OVERS1ZZEEEE)\ **Replies:** 6\ **Last updated:** [December 15, 2025, 1:03pm UTC](https://community.nocodb.com/t/nocodb-container-crashes-when-inserting-a-record/2145 "2025-12-15T13:03:04Z")
Hi everyone. I’m having this issue: when writing a record to a MySQL table via the NOCODB v3 API, the container crashes. The Docker logs show nothing except LOG \[RoutesResolver\]. Here’s my Golang code that inserts the re… --- ## [API v3 fails to insert multiple records](https://community.nocodb.com/t/api-v3-fails-to-insert-multiple-records/2112)
**Author:** [@OVERS1ZZEEEE](https://community.nocodb.com/u/OVERS1ZZEEEE)\ **Replies:** 2\ **Last updated:** [October 17, 2025, 12:19pm UTC](https://community.nocodb.com/t/api-v3-fails-to-insert-multiple-records/2112 "2025-10-17T12:19:44Z")
Good afternoon, everyone!I can’t use API v3 to insert multiple records in one post request. If you insert only one record, then everything goes well.I ask for your help. p.s I work with a mysql database --- ## [Airtable base import: certificate error](https://community.nocodb.com/t/airtable-base-import-certificate-error/2092)
**Author:** [@fietske](https://community.nocodb.com/u/fietske)\ **Replies:** 8\ **Last updated:** [September 26, 2025, 4:35pm UTC](https://community.nocodb.com/t/airtable-base-import-certificate-error/2092 "2025-09-26T16:35:11Z")
Hi guys - new here. When trying to import an existing Airtable base I get: ”Error: unable to get local issuer certificate” not sure where to look to fix this. any help is appreciated --- ## [Display NocoDB Table in WordPress](https://community.nocodb.com/t/display-nocodb-table-in-wordpress/1095)
**Author:** [@Klappspatack](https://community.nocodb.com/u/Klappspatack)\ **Replies:** 2\ **Last updated:** [September 18, 2025, 3:52pm UTC](https://community.nocodb.com/t/display-nocodb-table-in-wordpress/1095 "2025-09-18T15:52:33Z")
Hey, thanks for that simple but powerful software. Our dispatcher is using it on our office computer. Only it doesn’t work very well on smartphones (yet). Therefore I’d like to display our NocoDB dispatch-table on a Wor… --- ## [Error 429 "too many requests"](https://community.nocodb.com/t/error-429-too-many-requests/2066)
**Author:** [@Michael1](https://community.nocodb.com/u/Michael1)\ **Replies:** 1\ **Last updated:** [September 9, 2025, 1:43pm UTC](https://community.nocodb.com/t/error-429-too-many-requests/2066 "2025-09-09T13:43:24Z")
I’m using a cloud version of NocoDB. I’m connecting it to Replit AI. After inserting a lot of data, a request error occurs. Is this limitation only in the free cloud version? Does this limitation also apply to the self-h… --- ## [Setting Table and Field level permissions through API](https://community.nocodb.com/t/setting-table-and-field-level-permissions-through-api/2055)
**Author:** [@Bucky](https://community.nocodb.com/u/Bucky)\ **Replies:** 3\ **Last updated:** [August 13, 2025, 12:33pm UTC](https://community.nocodb.com/t/setting-table-and-field-level-permissions-through-api/2055 "2025-08-13T12:33:04Z")
Hi, I want to use the table and field permissions, but need to apply it to quite a few tables. specific we want to make them read-only. ie no create or delete rights to anyone and no edit rights for any field. But as … --- ## [NocoDB API Response Type Mismatch for OpenAPI](https://community.nocodb.com/t/nocodb-api-response-type-mismatch-for-openapi/2017)
**Author:** [@Hitu-C](https://community.nocodb.com/u/Hitu-C)\ **Replies:** 2\ **Last updated:** [July 23, 2025, 5:47pm UTC](https://community.nocodb.com/t/nocodb-api-response-type-mismatch-for-openapi/2017 "2025-07-23T17:47:51Z")
There is an inconsistency between the OpenAPI specification and the actual API response Content-Type for the link records endpoint: https://app.nocodb.com/api/v2/tables/{tableId}/links/{linkFieldId}/records/{recordId}. T… --- ## [Error when trying to update via API](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975)
**Author:** [@dougmt](https://community.nocodb.com/u/dougmt)\ **Replies:** 3\ **Last updated:** [July 21, 2025, 4:55am UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975 "2025-07-21T04:55:19Z")
After updating my self-hosted NocoDB instance to version 0.263.8, I’m getting the following error when trying to perform a batch update via the API: “error”: “DATABASE\_ERROR”, “message”: “Invalid data type or value for… --- ## [Getting "Forbidden - Not available" when using signin API endpoint](https://community.nocodb.com/t/getting-forbidden-not-available-when-using-signin-api-endpoint/1977)
**Author:** [@gpropf](https://community.nocodb.com/u/gpropf)\ **Replies:** 5\ **Last updated:** [July 3, 2025, 11:57pm UTC](https://community.nocodb.com/t/getting-forbidden-not-available-when-using-signin-api-endpoint/1977 "2025-07-03T23:57:23Z")
Hello all! I’ve created a user account and am trying to use the API to get a token to use for further API calls. I’m testing this process using curl with this command curl --url ‘https://app.nocodb.com/api/v1/auth/user/… --- ## [Import from Airtable contains no rows](https://community.nocodb.com/t/import-from-airtable-contains-no-rows/1958)
**Author:** [@Dood](https://community.nocodb.com/u/Dood)\ **Replies:** 6\ **Last updated:** [June 30, 2025, 7:57am UTC](https://community.nocodb.com/t/import-from-airtable-contains-no-rows/1958 "2025-06-30T07:57:29Z")
Trying to import from Airtable but after the import I see all the tables & columns but they all contain no rows. Verified the share URL works & tried recreating the token making sure it has data.records:read and schema.… --- ## [Struggling with datetime filtering in API](https://community.nocodb.com/t/struggling-with-datetime-filtering-in-api/1964)
**Author:** [@Pierric](https://community.nocodb.com/u/Pierric)\ **Replies:** 4\ **Last updated:** [June 28, 2025, 4:50pm UTC](https://community.nocodb.com/t/struggling-with-datetime-filtering-in-api/1964 "2025-06-28T16:50:38Z")
Hi, I’m struggling with filtering dates via the API. What I’m trying to achieve I have a Words table which has a due field, which is a DateTime. There’s also a “has many” relationship between the Users table and this t… --- ## [How can I download table as CSV via API?](https://community.nocodb.com/t/how-can-i-download-table-as-csv-via-api/1947)
**Author:** [@dan\_named](https://community.nocodb.com/u/dan_named)\ **Replies:** 3\ **Last updated:** [June 20, 2025, 3:18am UTC](https://community.nocodb.com/t/how-can-i-download-table-as-csv-via-api/1947 "2025-06-20T03:18:13Z")
Hey there! I’m curious — is it possible to download a table or table view via any of the API endpoints in the self-hosted version of NocoDB? I’ve been browsing the web, but many discussions refer to endpoints I haven’t… --- ## [Date Time Where Conditions For API's](https://community.nocodb.com/t/date-time-where-conditions-for-apis/1870)
**Author:** [@eyyupsert](https://community.nocodb.com/u/eyyupsert)\ **Replies:** 2\ **Last updated:** [May 13, 2025, 12:09pm UTC](https://community.nocodb.com/t/date-time-where-conditions-for-apis/1870 "2025-05-13T12:09:48Z")
The current date is 13.05-2025 14:13.00. I want to filter by a column that is between two date times and I am using activepieces. How can I find that a column with the CreatedAtCustom field name of 12.05-2025 14:13.00 an… --- ## [Querying multi-tag fields with spaces in NocoDB: anyof filter not matching tags containing spaces](https://community.nocodb.com/t/querying-multi-tag-fields-with-spaces-in-nocodb-anyof-filter-not-matching-tags-containing-spaces/1866)
**Author:** [@maxodors](https://community.nocodb.com/u/maxodors)\ **Replies:** 1\ **Last updated:** [May 13, 2025, 12:04pm UTC](https://community.nocodb.com/t/querying-multi-tag-fields-with-spaces-in-nocodb-anyof-filter-not-matching-tags-containing-spaces/1866 "2025-05-13T12:04:18Z")
I’m using NocoDB to store records with multi-tag fields (e.g. “Scene,” “Mood”, etc.). Tags without spaces work fine when filtering via the REST API, but tags that include spaces (e.g. “Combat – Light”) fail to match. I’d… --- ## [Need Rest API Help for connection to softr](https://community.nocodb.com/t/need-rest-api-help-for-connection-to-softr/1829)
**Author:** [@wildplumsolutions](https://community.nocodb.com/u/wildplumsolutions)\ **Replies:** 1\ **Last updated:** [April 30, 2025, 8:28pm UTC](https://community.nocodb.com/t/need-rest-api-help-for-connection-to-softr/1829 "2025-04-30T20:28:13Z")
Hi, I need some help with connecting to NocoDB Rest API from softr, i can’t seem to figure out the “pagination” bit can someone help? --- ## [How to update many to many record from n8n?](https://community.nocodb.com/t/how-to-update-many-to-many-record-from-n8n/1777)
**Author:** [@dan](https://community.nocodb.com/u/dan)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 2:15am UTC](https://community.nocodb.com/t/how-to-update-many-to-many-record-from-n8n/1777 "2025-04-07T02:15:14Z")
i tried soo many ways to update a many to many record, nothing worked. Please help! what is the right way? Image shows my table with a few records that i updated manually. I need a way to update it in n8n --- ## [Import Airtable data](https://community.nocodb.com/t/import-airtable-data/1770)
**Author:** [@jeppe](https://community.nocodb.com/u/jeppe)\ **Replies:** 4\ **Last updated:** [April 3, 2025, 11:04am UTC](https://community.nocodb.com/t/import-airtable-data/1770 "2025-04-03T11:04:32Z")
Hi everyone! I followed the instruction for importing a base in Airtable to Nocodb and I got all the tables imported, but with no data. the log gave me this error: data :: You should provide valid api key to perform th… --- ## [Create button column via API](https://community.nocodb.com/t/create-button-column-via-api/1656)
**Author:** [@Masterb12](https://community.nocodb.com/u/Masterb12)\ **Replies:** 2\ **Last updated:** [February 11, 2025, 12:16pm UTC](https://community.nocodb.com/t/create-button-column-via-api/1656 "2025-02-11T12:16:36Z")
I am successfully creating tables via the API, but I’m encountering an issue with one specific column. The column is intended to contain a button that redirects to a link, but NocoDB reports an ‘invalid field configurati… --- ## [How can I log actions into a specific table? Can I use API callbacks?](https://community.nocodb.com/t/how-can-i-log-actions-into-a-specific-table-can-i-use-api-callbacks/1498)
**Author:** [@mxmjbn](https://community.nocodb.com/u/mxmjbn)\ **Replies:** 1\ **Last updated:** [November 22, 2024, 12:13am UTC](https://community.nocodb.com/t/how-can-i-log-actions-into-a-specific-table-can-i-use-api-callbacks/1498 "2024-11-22T00:13:41Z")
I really like to “Audit logs”… the problem is we cannot search the logs and there are things that I do not want to log. My goal : for a specific set of data (one table), I’d like every modification to be logged so I can… --- ## [How to filter records by related Id field using v2 API?](https://community.nocodb.com/t/how-to-filter-records-by-related-id-field-using-v2-api/1478)
**Author:** [@reloverevolt](https://community.nocodb.com/u/reloverevolt)\ **Replies:** 1\ **Last updated:** [November 16, 2024, 10:00am UTC](https://community.nocodb.com/t/how-to-filter-records-by-related-id-field-using-v2-api/1478 "2024-11-16T10:00:20Z")
Hi everyone! I am looking for the right way for filtering records by relational Id field via API. Basic Problem: Table Books has link many-to-many field Authors I need to filter Books by related Author Ids: \[1,2\] Cu… --- ## [Upload attachment via API](https://community.nocodb.com/t/upload-attachment-via-api/1452)
**Author:** [@not-the-real-chopin](https://community.nocodb.com/u/not-the-real-chopin)\ **Replies:** 1\ **Last updated:** [October 30, 2024, 4:38am UTC](https://community.nocodb.com/t/upload-attachment-via-api/1452 "2024-10-30T04:38:48Z")
I need to create a record that contains a field of type “attachment”. The attachment field is not part of the open-api spec that contain only the other fields. Any suggestion? --- ## [It is not possible to specify the user in "created\_by" when creating a comment using the /api/v2/meta/comments method](https://community.nocodb.com/t/it-is-not-possible-to-specify-the-user-in-created-by-when-creating-a-comment-using-the-api-v2-meta-comments-method/1429)
**Author:** [@Max](https://community.nocodb.com/u/Max)\ **Replies:** 0\ **Last updated:** [October 16, 2024, 11:50am UTC](https://community.nocodb.com/t/it-is-not-possible-to-specify-the-user-in-created-by-when-creating-a-comment-using-the-api-v2-meta-comments-method/1429 "2024-10-16T11:50:17Z")
Because of this, users in the web interface lose the ability to delete or edit comments that they have created earlier through the meta api Solution options: Give the opportunity to specify the author comment through … --- ## [NocoDB Python Client](https://community.nocodb.com/t/nocodb-python-client/1386)
**Author:** [@talaat](https://community.nocodb.com/u/talaat)\ **Replies:** 1\ **Last updated:** [September 25, 2024, 7:36am UTC](https://community.nocodb.com/t/nocodb-python-client/1386 "2024-09-25T07:36:24Z")
Hello team, I’m working on a new nocodb python wrapper for the v2 of the api. If there is any helpful resources it will be great. Thanks --- ## [Having JSON trouble with Nocodb API (escaping special characters?)](https://community.nocodb.com/t/having-json-trouble-with-nocodb-api-escaping-special-characters/1364)
**Author:** [@bf7051](https://community.nocodb.com/u/bf7051)\ **Replies:** 13\ **Last updated:** [September 14, 2024, 11:44am UTC](https://community.nocodb.com/t/having-json-trouble-with-nocodb-api-escaping-special-characters/1364 "2024-09-14T11:44:25Z")
I don’t think its even required but no matter what I try I can’t seem to escape special characters like ? which are saved into the db as $. I don’t believe I even have to escape ? - but they’re not saving as expected… B… --- ## [Save simple Chinese text in nocoDB via API is not working ?!?](https://community.nocodb.com/t/save-simple-chinese-text-in-nocodb-via-api-is-not-working/811)
**Author:** [@daniel.dietze](https://community.nocodb.com/u/daniel.dietze)\ **Replies:** 3\ **Last updated:** [September 14, 2024, 5:37am UTC](https://community.nocodb.com/t/save-simple-chinese-text-in-nocodb-via-api-is-not-working/811 "2024-09-14T05:37:48Z")
Hello dear community I have a challenge in an ongoing problem that I could not solve yet. I fill the NocoDB via API with data from forms . As part of the internationalization process, I am now adding form data from chin… --- ## [Add a reference to an another table](https://community.nocodb.com/t/add-a-reference-to-an-another-table/1347)
**Author:** [@oliviern](https://community.nocodb.com/u/oliviern)\ **Replies:** 1\ **Last updated:** [September 7, 2024, 5:07am UTC](https://community.nocodb.com/t/add-a-reference-to-an-another-table/1347 "2024-09-07T05:07:14Z")
I use n8n connected to Nocodb. I can’t figure out how to add a reference to another table in a table. I can add values to stadard fields just fine. However, for link fields, I can’t manage to add the reference ID. Thank… --- ## [Self-hosted : I can't get a table record](https://community.nocodb.com/t/self-hosted-i-cant-get-a-table-record/1311)
**Author:** [@elect](https://community.nocodb.com/u/elect)\ **Replies:** 6\ **Last updated:** [August 27, 2024, 11:44am UTC](https://community.nocodb.com/t/self-hosted-i-cant-get-a-table-record/1311 "2024-08-27T11:44:37Z")
I’m trying to update a single field in a record within a table I create the base, then the columns metadata, with the following primary key "column\_name": "Primary Key", "title": "Primary Key", … [Next page](https://community.nocodb.com/c/apis/6.md?page=1)