Workflow UPSERT items fails to update and always inserts

Workflows
1

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.

Product_UPSERT_Workflow
Product_UPSERT_Workflow840×386 27.6 KB

2

Hi @Fordy,

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

1 Like
3

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?

4

Yep

5

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.

6

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

7

SQL server.

8

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