Scripts in nocodb [May 04] #2022
dstala
started this conversation in
Discord Threads
Replies: 1 comment
-
Its not yet avaialble
but you can use our APIs and webhooks
am I able to get information from an external api and put it on nocodb with the method get using webhooks?
```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""}```
I'm getting this msg when I try to use the webhooks :/
please paste your project info (right top menu)
Node: v12.22.12Arch: x64Platform: linuxDocker: falseDatabase: pgProjectOnRootDB: trueRootDB: pgPackageVersion: 0.90.7
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).
<@177618286756757507>
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?
please do open an issue with the detailsJoin NocoDB's community |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
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?
Beta Was this translation helpful? Give feedback.
All reactions