# Scripts in nocodb \[May 04\]

**URL:** <https://community.nocodb.com/t/scripts-in-nocodb-may-04/416>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416 "2022-11-03T09:31:46Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/1 "2022-11-03T09:31:46Z")

</div>

> 🙋‍♂️ **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?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/2 "2022-11-03T09:31:47Z")

</div>

> 💁 **o1lab** _replied_

#### Its not yet avaialble

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/3 "2022-11-03T09:31:48Z")

</div>

> 💁 **o1lab** _replied_

#### but you can use our APIs and webhooks

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/4 "2022-11-03T09:31:49Z")

</div>

> 🙋‍♂️ **CaptainKranch** _replied_

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

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/5 "2022-11-03T09:31:50Z")

</div>

> 🙋‍♂️ **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"”}

#### ```

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/6 "2022-11-03T09:31:51Z")

</div>

> 🙋‍♂️ **CaptainKranch** _replied_

#### I’m getting this msg when I try to use the webhooks 😕

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/7 "2022-11-03T09:31:53Z")

</div>

> 💁 **o1lab** _replied_

#### please paste your project info (right top menu)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/8 "2022-11-03T09:31:54Z")

</div>

> 🙋‍♂️ **CaptainKranch** _replied_

#### Node: **v12.22.12**

#### Arch: **x64**

#### Platform: **linux**

#### Docker: **false**

#### Database: **pg**

#### ProjectOnRootDB: **true**

#### RootDB: **pg**

#### PackageVersion: **0.90.7**

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/9 "2022-11-03T09:31:56Z")

</div>

> 🙋‍♂️ **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).

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/10 "2022-11-03T09:31:57Z")

</div>

> 🙋‍♂️ **BoMBx** _replied_

#### \<@177618286756757507\>

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/11 "2022-11-03T09:31:58Z")

</div>

> 🙋‍♂️ **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?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:31am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/12 "2022-11-03T09:31:59Z")

</div>

> 💁 **o1lab** _replied_

#### please do open an issue with the details

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:32am UTC](https://community.nocodb.com/t/scripts-in-nocodb-may-04/416/13 "2022-11-03T09:32:00Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/968232693437464726)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)