Database insert’s identity returning “INSERT”

[scottclee]

Wappler Version: 4.2.0
Operating System: macOS Catalina (10.15.7)

Expected behavior

What do you think should happen?
I would expect to be able to use the identity value which gets returned from an INSERT call

Actual behavior

What actually happens?

When I try to use the identity of the newly added record in a follow on command I get the following message:
message: "select * from "a_demandrail" where "a_demandrail"."id" = $1 limit $2 - invalid input syntax for type integer: "INSERT""

I've searched the forum and found the below entry. I'm using exactly the same configuration: nodejs & postgresql.

Database insert's identity called from repeat returning "INSERT"

Wappler Version: Latest Operating System: W10Pro latest Server Model: NodeJS Expected behaviour This SC script is supposed to insert a product record in the database and update that record’s images field to contain all uploaded image’s file names: [image] The returned Identity value of the database insert (insert_product) action is expected to be an integer (product_id in this case, generated automatically since this field is an increments field for the products table). Actual behavior The…

How to reproduce

The attached screenshot shows my failing API Action.

[borbinka2]

This happens to me as well.

Wappler 4.2.2.
Nodejs & postgres

Let me know if any logs would help.

[borbinka2]

Update: manually adding "returning": "user_id", in the json solved the problem, as described here: Nodejs: Identity returned by Insert is a nested object. It doens't return id anymore

[patrick]

The returning property is indeed something that is needed for postgres databases, it should normally be added automatically to the json.

[ErnestPeguy]

I am also having the same issue in version 4.4.2
How can I bypass it?

[borbinka2]

Hi,

You need to edit the json file (right click on the server action and open in code view) and add the returning property to your query.

[ErnestPeguy]

I did that, it however still does not return the identity

[borbinka2]

Please check out the linked topic to see an example. Nodejs: Identity returned by Insert is a nested object. It doens't return id anymore

I believe that you added it at the wrong place.

[sid]

@patrick Just encountered this bug with NodeJS & Postgres.
The column in question is of type UUID in our case.
Adding the returning key-value pair manually in the JSON returns the inserted row’s identity - otherwise it returns “INSERT”.
On Wappler 5.8.2.

There are other older SAs with insert queries which have this setup running correctly - but it seems to have broken in some version after that.
We tried creating a new SA with just the insert query, and it fails.
The DB manager shows the field’s data type as UUID correctly as well.
Please help.