Workflow UPSERT items fails to update and always inserts

Hi,

I have a workflow step that is an upsert and it's refusing to update and alwasy insert a record, i have even manually set the Lookupvalue and it still inserts.

I'm looking up on the table with a string value. Any help would be grateful.

Tim.

Hi @Fordy,

Have you manually set the ItemId on the key-value pairs to ensure that is working as expected?

1 Like

Hi @Fordy! The behavior you're describing makes it sound like the filter that you're applying - ItemId equal to B0002GV480 - isn't returning a record that can be updated. Can you confirm with a separate query that such a record exists?

Yep

It exists, it's the most strangest behaviour i have seen. I can even write a SQL statement and it updates the record. But UPSERT just won't work.

What kind of resource is this? Is it the built-in RetoolDB?

SQL server.

Can you share the equivalent raw SQL statement that is working for you?