Webhook error [Jun 03]

:raising_hand_man: Bergi9 asked

What should I response back to the webhook url trigger? A json format or just a string with “success”? The webhook is successful consumed but nocodb throws on logs:


This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason:

error: 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, DEFAULT, $10, CURRENT_TIMESTAMP) - invalid input syntax for type boolean: “{“method”:“POST”,“path”:”*“,“headers”:[{“name”:“Authorization”,“value”:”“,“enabled”:true}],“body”:”{{ json data }}“}”

at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:287:98)

at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:126:29)

at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:39:38)

at Socket. (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)

at Socket.emit (events.js:314:20)

at Socket.EventEmitter.emit (domain.js:506:15)

at addChunk (_stream_readable.js:297:12)

at readableAddChunk (_stream_readable.js:272:9)

at Socket.Readable.push (_stream_readable.js:213:10)

at TCP.onStreamRead (internal/stream_base_commons.js:188:23)


:man_bald: dstala replied

<@269909921724629004> Error appears to be internal to NocoDB. You can ignore. Let us know NocoDB version & way to reproduce if you can to help us fix it.

:raising_hand_man: Bergi9 replied

Node: v12.22.12

Arch: x64

Platform: linux

Docker: true

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.91.1

Webhook url trigger with {{ json data }} as body.

:man_bald: dstala replied

<@269909921724629004> need a favour. try & let us know if you still find this issue on latest release (v0.91.7).

Autogenerated from discord

Join NocoDB’s community