Webhook automation issue

1

I have a webhook set up with Coda Webhook. Everything seems to work fine. Except on the Doc where i have the automation for addormodifyrows. No matter what i try, i can’t get the key mathces to identify, so it creates a new entry for rows that should be matching with my keys.
Example of formula
addormodifyrows(target.table, target.order = ParseJSON(thisRow.[Step 1 Result], “order”),
target.[order] ParseJSON(thisRow.[Step 1 Result].ToText(), “order”),
target.[line], ParseJSON(thisRow.[Step 1 Result].ToText(), “line”),
target.[qty], ParseJSON(thisRow.[Step 1 Result].ToText(), "Qty”).

I tried doing text() trim()

Any ideas on why it won’t match the inbound data?

1 Like
2

Hello Thomas, just an idea for something to try :

Does it fail too if you create a variable for ParseJSON(thisRow.[Step 1 Result], “order”) using Let() before calling AddOrModifyRows ?

1 Like
3

I haven’t figured it out yet. but i will try that. actually found a better way. Cross Doc with 2 way edit and send immediately is doing what i need on an hourly basis.

1 Like