API docs [Feb 05]

Discord-Discussions
1

:raising_hand_man: gab696 asked

does anybody has used nocodb rest api with appgyver ?

2

:person_tipping_hand: o1lab replied

Docs.nocodb.com

3

:person_tipping_hand: o1lab replied

See the APIs… is straightforward

4

:raising_hand_man: jwithing replied

i am using nocodb to power my tool that collects user feedback! right now, it takes a message from discord and POSTs it to the DB.

i use the nc/j/api/v1/<table_name> endpoint.

I am getting 200 status codes on my POST attempts but i dont see new rows being created. any sense of what i may be doing incorrect?

5

:person_tipping_hand: o1lab replied

What is the response back from post?

6

:person_tipping_hand: o1lab replied

Can u paste project info here ( right top menu)

7

:raising_hand_man: jwithing replied

Node: v12.22.6

Arch: x64

Platform: linux

Docker: true

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.84.8

8

:raising_hand_man: jwithing replied

i moved on to using gsheets, but i want to use nocodb, so lettme revert my code real quick

9

:person_tipping_hand: o1lab replied

Ok

10

:person_tipping_hand: o1lab replied

What was the response ?

11

:raising_hand_man: jwithing replied

bout to get it

12

:person_tipping_hand: o1lab replied

Also have u refreshed/reloaded the table after insert?

13

:raising_hand_man: jwithing replied

[{‘id’: 1, ‘Feedback’: ‘HI there’, ‘created_at’: ‘2022-02-03T20:46:41.466Z’, ‘updated_at’: ‘2022-02-03T20:46:41.466Z’}]

Content: i hate it here

14

:raising_hand_man: jwithing replied

interesting

15

:raising_hand_man: jwithing replied

it’s getting the first row <:think:907331456890724373>

16

:raising_hand_man: jwithing replied

the post request’s content was “i hate it here”

17

:raising_hand_man: jwithing replied

instead the response was the first row

18

:raising_hand_man: jwithing replied

``` r = requests.post(feedback_db_endpoint, headers = {“xc-token”: nocodb_api_token}, json={

“Feedback”: content,

“created_at”: str(time.time()),

“updated_at”: str(time.time()),

})

print(r.status_code)

print(r.json())

print(f’Content: {content}')```

19

:raising_hand_man: jwithing replied

:thinking:

image0
image01698×1108 111 KB

20

:person_tipping_hand: o1lab replied

We will look into it