Hello Everyone,
There is an issue in Write Records Smart Service
Its not giving as output with/of primary keys in the Output section
It works for a record which takes single value as input but not working for array pv!
Please ping if anyone has faced this issue before, We,ve tried everything but nothing is working
Thanks in advance.
Discussion posts and replies are publicly visible
I support Juraj Buc in when the documentation says "omit OR set to NULL", that setting it to NULL will work as expected.
Thanks for the heads-up, Peter Lewis, but this looks like a different issue.
1. it occurred on MariaDB (Appian Cloud Database)
2. Write Records node is actually successfully executed and it writes new row into the database, it just doesn't return new generated PK in the Outputs
This was a bug actually and it was corrected in 24.2. Meanwhile you can avoid the issue by leaving the PK field off your variable instead of including it with a NULL value. Write Records will still create the PK of course and include it in the output. Sorry for any inconvenience caused by the issue!
Perfect, good to know that the issue was already addressed. I will check our upgrade schedule.
Thanks for the update, Laura.
Mystery solved! Thanks to everybody who joined the discussion.