Skip to main content
Known Participant
Sep 15, 2023 1:10 PM UTC
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:

6 replies

stefanhelzle0001
Brainy
Sep 15, 2023 1:22 PM UTC

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/.../

Known Participant
Sep 15, 2023 1:26 PM UTC

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.

stefanhelzle0001
Brainy
Sep 15, 2023 1:44 PM UTC

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

rishikeshr4182
Inspiring
Sep 15, 2023 1:38 PM UTC

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,

Rishikesh