Question

Write Records Service showing inconsistent behavior

hello all,

I am trying t write to a table using write records smart service.

The data is being written in DB table but I do not have the records updated captured in my output variables of node.

I am doing a single entry at a time and record has no relationship defined.

One thing to note here that we have configured triggers on this table which updates some columns for the same table.

We are using Postgres DB.

has anyone else experienced the same situation.

Node Configurations:

Brainy

With 23.3 "Records Updated" only returns the primary keys. To get the full record, you need a separate query.

I covered that in my blog post: appian.rocks/.../

Hi Stefan,

We are not getting primary key back after writing after to DB, we are facing this in 23.2 and 23.3 release also.

Brainy

Then we need more details. This is pretty low level, so please be generous.

Hey kirang,

I also faced the same issues. You can over come this issue by querying the data and then using them in the process. That works fine,

Sign up