# APIs **URL:** https://community.nocodb.com/c/apis/6.md?page=1 [Latest](https://community.nocodb.com/latest.md) · [Categories](https://community.nocodb.com/categories.md) · [Tags](https://community.nocodb.com/tags.md) **Page:** 2 --- ## [Trouble with uploading csv file via API](https://community.nocodb.com/t/trouble-with-uploading-csv-file-via-api/1308)
**Author:** [@bf7051](https://community.nocodb.com/u/bf7051)\ **Replies:** 6\ **Last updated:** [August 22, 2024, 9:57pm UTC](https://community.nocodb.com/t/trouble-with-uploading-csv-file-via-api/1308 "2024-08-22T21:57:55Z")
New to Nocodb and can’t figure out how to upload a csv to the DB via API. Can anyone see anything wrong with my code? Please help! Any advice appreciated! try { // Step 1: Upload file to storage … --- ## [Response status is 422: Invalid Filter](https://community.nocodb.com/t/response-status-is-422-invalid-filter/1287)
**Author:** [@rusty.redox](https://community.nocodb.com/u/rusty.redox)\ **Replies:** 2\ **Last updated:** [July 28, 2024, 12:52am UTC](https://community.nocodb.com/t/response-status-is-422-invalid-filter/1287 "2024-07-28T00:52:54Z")
After executing the following request: https://app.nocodb.com/api/v2/tables/mrg9it4je9v0yn6/records?where=%28userid%2C%20eq%2C%201%29&limit=25&shuffle=0&offset=0 I am receiving a 422 response with the message: { "er… --- ## [Self hosted : API calls resulting only in 401 'invalid token'](https://community.nocodb.com/t/self-hosted-api-calls-resulting-only-in-401-invalid-token/1291)
**Author:** [@bluechair](https://community.nocodb.com/u/bluechair)\ **Replies:** 2\ **Last updated:** [July 26, 2024, 5:57am UTC](https://community.nocodb.com/t/self-hosted-api-calls-resulting-only-in-401-invalid-token/1291 "2024-07-26T05:57:15Z")
I can’t figure out what I’m doing wrong — yesterday, FlutterFlow was able to GET data from my tables (using my API key). Today, on a different project, nada. I’ve been testing various iterations at reqbin.com, as well, … --- ## [Is it possible to create a database via the REST Api?](https://community.nocodb.com/t/is-it-possible-to-create-a-database-via-the-rest-api/1241)
**Author:** [@elect](https://community.nocodb.com/u/elect)\ **Replies:** 4\ **Last updated:** [July 8, 2024, 11:14am UTC](https://community.nocodb.com/t/is-it-possible-to-create-a-database-via-the-rest-api/1241 "2024-07-08T11:14:32Z")
Hello, as titled, I’d like to know if it’s possible to create a database via the REST Api I didn’t find anything, but maybe I missed it Thanks in advance --- ## [Image Compression Methods for Uploads](https://community.nocodb.com/t/image-compression-methods-for-uploads/1237)
**Author:** [@Benjifrank](https://community.nocodb.com/u/Benjifrank)\ **Replies:** 1\ **Last updated:** [June 26, 2024, 1:25am UTC](https://community.nocodb.com/t/image-compression-methods-for-uploads/1237 "2024-06-26T01:25:21Z")
What Compression methods for uploaded files. Why -People upload needlessly large files that take a long tim to upload and cost us more money -This is especially true with PNG screenshots from macs … they can be compres… --- ## [API record updates are not elligible to webhook "update" triggers](https://community.nocodb.com/t/api-record-updates-are-not-elligible-to-webhook-update-triggers/1111)
**Author:** [@tomgoirand](https://community.nocodb.com/u/tomgoirand)\ **Replies:** 1\ **Last updated:** [May 24, 2024, 7:50am UTC](https://community.nocodb.com/t/api-record-updates-are-not-elligible-to-webhook-update-triggers/1111 "2024-05-24T07:50:45Z")
Hey there, It turns out record updates made from the API are not triggering webhooks. Is there any hints or workaround? --- ## [The influence of filters on rest apis](https://community.nocodb.com/t/the-influence-of-filters-on-rest-apis/1168)
**Author:** [@fi3nguyen](https://community.nocodb.com/u/fi3nguyen)\ **Replies:** 3\ **Last updated:** [May 23, 2024, 7:14pm UTC](https://community.nocodb.com/t/the-influence-of-filters-on-rest-apis/1168 "2024-05-23T19:14:17Z")
Hi everyone. I have a question need your help. I have a CMS system using nocodb and using rest api to query data. But I see an issue with my system is when I using filter or short, etc… in the UI of nocodb and back to us… --- ## [Xc-token API key auth issue on create link request](https://community.nocodb.com/t/xc-token-api-key-auth-issue-on-create-link-request/1129)
**Author:** [@tomgoirand](https://community.nocodb.com/u/tomgoirand)\ **Replies:** 1\ **Last updated:** [April 3, 2024, 1:44pm UTC](https://community.nocodb.com/t/xc-token-api-key-auth-issue-on-create-link-request/1129 "2024-04-03T13:44:16Z")
Hello there, I am using my account API Key (not user auth) with xc-token header on a create link request and the app returns a {“msg”:“Unauthorized access”} error code, but this token is accepted for other requests at t… --- ## [Linking Nocodb with FlutterFlow](https://community.nocodb.com/t/linking-nocodb-with-flutterflow/1125)
**Author:** [@Gunstro](https://community.nocodb.com/u/Gunstro)\ **Replies:** 1\ **Last updated:** [March 29, 2024, 9:24pm UTC](https://community.nocodb.com/t/linking-nocodb-with-flutterflow/1125 "2024-03-29T21:24:49Z")
I am battling to link Nocodb with FlutterFlow. I am using railway… Please could you assist me with this. --- ## [403 errors with NocoDB Cloud, v2 API docs missing?](https://community.nocodb.com/t/403-errors-with-nocodb-cloud-v2-api-docs-missing/1091)
**Author:** [@michaelatpd](https://community.nocodb.com/u/michaelatpd)\ **Replies:** 8\ **Last updated:** [March 6, 2024, 4:10pm UTC](https://community.nocodb.com/t/403-errors-with-nocodb-cloud-v2-api-docs-missing/1091 "2024-03-06T16:10:24Z")
Hi NocoDB team, Hello from \[Pipedream\](https://pipedream.com/)! We’ve built an integration to NocoDB and are currently troubleshooting a customer-raised issue, where our mutual customer is trying to Add A New Row. We ha… --- ## [How to get end point in table name instead of table id](https://community.nocodb.com/t/how-to-get-end-point-in-table-name-instead-of-table-id/1085)
**Author:** [@Aakash](https://community.nocodb.com/u/Aakash)\ **Replies:** 1\ **Last updated:** [March 2, 2024, 4:21am UTC](https://community.nocodb.com/t/how-to-get-end-point-in-table-name-instead-of-table-id/1085 "2024-03-02T04:21:15Z")
https://db/api/v2/tables/mdjigihfvwhwfrc like this but the table name is customer but the end point show like this how to get the end with table name instead of id --- ## ["You don't have permission to access this resource"](https://community.nocodb.com/t/you-dont-have-permission-to-access-this-resource/1086)
**Author:** [@Thomaswennersten](https://community.nocodb.com/u/Thomaswennersten)\ **Replies:** 2\ **Last updated:** [February 29, 2024, 2:10pm UTC](https://community.nocodb.com/t/you-dont-have-permission-to-access-this-resource/1086 "2024-02-29T14:10:16Z")
I have entered API keys but when I try the API out through swagger I get \`\`\` “You don’t have permission to access this resource” Any ideas what is missing? --- ## [Where is the documentation for Auth User API? How can I make requests that let me modify the Users? (Not base users)](https://community.nocodb.com/t/where-is-the-documentation-for-auth-user-api-how-can-i-make-requests-that-let-me-modify-the-users-not-base-users/1057)
**Author:** [@tem](https://community.nocodb.com/u/tem)\ **Replies:** 0\ **Last updated:** [February 13, 2024, 3:35am UTC](https://community.nocodb.com/t/where-is-the-documentation-for-auth-user-api-how-can-i-make-requests-that-let-me-modify-the-users-not-base-users/1057 "2024-02-13T03:35:43Z")
API documentation I am looking for endpoints that allow me to modify (CRUD) the Users of my instance? Create User Get UserByID Get UserByEmail. --- ## [Deleted Links not reflected in system field for links](https://community.nocodb.com/t/deleted-links-not-reflected-in-system-field-for-links/1055)
**Author:** [@RichardC](https://community.nocodb.com/u/RichardC)\ **Replies:** 0\ **Last updated:** [February 12, 2024, 7:36pm UTC](https://community.nocodb.com/t/deleted-links-not-reflected-in-system-field-for-links/1055 "2024-02-12T19:36:33Z")
I have a Authors table linked to a Books table. At one time I had 4 books linked to an author. Then I deleted one of the books. The NocoDB UI for the Author only shows 3 linked books. But the system field that contains a… --- ## [SMS sending platform via mobile phone tariff](https://community.nocodb.com/t/sms-sending-platform-via-mobile-phone-tariff/1050)
**Author:** [@Megasites](https://community.nocodb.com/u/Megasites)\ **Replies:** 1\ **Last updated:** [February 12, 2024, 5:49am UTC](https://community.nocodb.com/t/sms-sending-platform-via-mobile-phone-tariff/1050 "2024-02-12T05:49:00Z")
Hello, we have a client who uses your platform. We wanted to know if it is possible for the customer to be able to see and send SMS from their cell phone using their tariff plan? Thank you for your attention. Best reg… --- ## [Same function name for all Path](https://community.nocodb.com/t/same-function-name-for-all-path/966)
**Author:** [@yannhill](https://community.nocodb.com/u/yannhill)\ **Replies:** 4\ **Last updated:** [February 12, 2024, 1:49am UTC](https://community.nocodb.com/t/same-function-name-for-all-path/966 "2024-02-12T01:49:31Z")
Hi, I am new to API. I created a base and 3 different tables (users/products/cart). But looking at swagger API all of my " Paths " have the same " function name which is “records”. Is it normal ? --- ## [Record created via api returns id as null](https://community.nocodb.com/t/record-created-via-api-returns-id-as-null/1006)
**Author:** [@Osas](https://community.nocodb.com/u/Osas)\ **Replies:** 1\ **Last updated:** [January 18, 2024, 8:00am UTC](https://community.nocodb.com/t/record-created-via-api-returns-id-as-null/1006 "2024-01-18T08:00:01Z")
Record created via api returns id as null even after passing ‘pk’: true as part of request body --- ## [Post on the Cloud](https://community.nocodb.com/t/post-on-the-cloud/998)
**Author:** [@crisacosta](https://community.nocodb.com/u/crisacosta)\ **Replies:** 2\ **Last updated:** [January 3, 2024, 1:54pm UTC](https://community.nocodb.com/t/post-on-the-cloud/998 "2024-01-03T13:54:24Z")
Send my datas to https://app.nocodb.com/api/v2/tables/#####/records Database: MySQL Data is recorded, but the response is error number 400 bad request Cannot read properties of undefined (reading ‘0’) --- ## [Date not supported in REST API](https://community.nocodb.com/t/date-not-supported-in-rest-api/791)
**Author:** [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\ **Replies:** 1\ **Last updated:** [December 11, 2023, 11:27pm UTC](https://community.nocodb.com/t/date-not-supported-in-rest-api/791 "2023-12-11T23:27:13Z")
Hi As you can see in the next image, when I try to filter by a date field, I receive an not supported error. Which is the right format for dates? Thanks in advance --- ## [Super newbie help: how can I use the API to publish my NocoDB data on a node.js website?](https://community.nocodb.com/t/super-newbie-help-how-can-i-use-the-api-to-publish-my-nocodb-data-on-a-node-js-website/939)
**Author:** [@Hacking47](https://community.nocodb.com/u/Hacking47)\ **Replies:** 4\ **Last updated:** [December 3, 2023, 5:14pm UTC](https://community.nocodb.com/t/super-newbie-help-how-can-i-use-the-api-to-publish-my-nocodb-data-on-a-node-js-website/939 "2023-12-03T17:14:25Z")
My website is made with Ghost CMS. It’s node.js based. So I guess i must use the Javascript options. I tried including the snippet code provided in NocoDB. But nothing shows on my website. Looked into the swagger thing… --- ## [No longer can get nested data with API](https://community.nocodb.com/t/no-longer-can-get-nested-data-with-api/964)
**Author:** [@novianti](https://community.nocodb.com/u/novianti)\ **Replies:** 3\ **Last updated:** [December 1, 2023, 7:46am UTC](https://community.nocodb.com/t/no-longer-can-get-nested-data-with-api/964 "2023-12-01T07:46:25Z")
Before I upgraded my NocoDB, I can get informations of every records that are linked to a table using the nested API parameter ?nested\[table\_of\_related\_records\]\[fields\]=field1,field2,... and it will return array of objec… --- ## [Commas in query string](https://community.nocodb.com/t/commas-in-query-string/817)
**Author:** [@desafinadude](https://community.nocodb.com/u/desafinadude)\ **Replies:** 0\ **Last updated:** [June 5, 2023, 5:51pm UTC](https://community.nocodb.com/t/commas-in-query-string/817 "2023-06-05T17:51:27Z")
I can’t get commas to work in a where condition. The categories should be: Freedom of information and expression Data quality, sharing and security I’m sending this to the API: (Country,isnot,null)~and(Country,in,Ke… --- ## [Null not supported in REST API](https://community.nocodb.com/t/null-not-supported-in-rest-api/793)
**Author:** [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\ **Replies:** 0\ **Last updated:** [April 24, 2023, 11:31am UTC](https://community.nocodb.com/t/null-not-supported-in-rest-api/793 "2023-04-24T11:31:52Z")
Hi there. When I try to use the null value for a date field in the where query param I receive the next error message: Surprisingly, if the field type is different of date, then it works. Can anyone help me? Thanks… --- ## [Like comparison query param in NocoAPI](https://community.nocodb.com/t/like-comparison-query-param-in-nocoapi/788)
**Author:** [@bunch.capital](https://community.nocodb.com/u/bunch.capital)\ **Replies:** 1\ **Last updated:** [April 24, 2023, 9:50am UTC](https://community.nocodb.com/t/like-comparison-query-param-in-nocoapi/788 "2023-04-24T09:50:07Z")
Hey there, we use the NocoAPI to query specific information from our tables. So far I’ve used a “like” comparsion in the where query param. But this doesn’t work anymore. Now the user needs to put in the exact value of a… [Previous page](https://community.nocodb.com/c/apis/6.md)