Scripts in nocodb [May 04]

Discord-Discussions
1

:raising_hand_man: CaptainKranch asked

Hello guys, I need to use an external api with the information that I have on nocodb. It’s possible to write a python or jscript to do so? In gsheets there is an option called apps scripts that let me do so… is this possible on nocodb?

2

:person_tipping_hand: o1lab replied

Its not yet avaialble

3

:person_tipping_hand: o1lab replied

but you can use our APIs and webhooks

4

:raising_hand_man: CaptainKranch replied

am I able to get information from an external api and put it on nocodb with the method get using webhooks?

5

:raising_hand_man: CaptainKranch replied

```json

{“msg”:“insert into "nc_hook_logs_v2" ("base_id", "created_at", "event", "execution_time", "id", "notification", "operation", "payload", "project_id", "response", "test_call", "triggered_by", "type", "updated_at") values ($1, CURRENT_TIMESTAMP, $2, $3, $4, $5, $6, $7, $8, DEFAULT, $9, $10, $11, CURRENT_TIMESTAMP) - invalid input syntax for type integer: "460.735"”}

```

6

:raising_hand_man: CaptainKranch replied

I’m getting this msg when I try to use the webhooks :confused:

7

:person_tipping_hand: o1lab replied

please paste your project info (right top menu)

8

:raising_hand_man: CaptainKranch replied

Node: v12.22.12

Arch: x64

Platform: linux

Docker: false

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.90.7

9

:raising_hand_man: BoMBx replied

According to this error message, it means you passing the wrong type of parameter. The input need interger type (…,-2,-1,0,1,2,…) but you pass the float (460.735). Or another way, just go to change type in your field of table on database into decimal type (or type which allow floating number).

10

:raising_hand_man: BoMBx replied

<@177618286756757507>

11

:raising_hand_man: CaptainKranch replied

I do not think thats the issue, I created a new table with no rows tried to use the webhook to give me a notification through email but it displays the same error… I saw that in github there are some similar errors should I open an issue on github?

12

:person_tipping_hand: o1lab replied

please do open an issue with the details

13

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs