One automation that updates a google spreadsheet with information from webhook stopped filling one specific column, the output is correct this column is skip on google sheets.
Are you able to share the workflow json and the data for the webhook node so we can test this? Looking at the pictures I can’t think of why it would fail although the expression syntax for that one field is not like the others so I would maybe start by updating it to use the newer expression style like the others have.
Thanks for the reply @Jon Jon
Here are the json for workflow and webhook.
I couldnt past here, so i created a link, please let me know if there is a better way to share.
I have just reproduced the sheet you are using and I am not seeing the same issue, Does it always fail or is it only with certain products?
I would still recommend replacing {{ $item("0").$node["Webhook"].json["body"]["items"]["0"]["name"] }} with the newer {{ $('Webhook').item.json.body.items[0].name }}, You are also going to have an issue with the code node after that as it looks like that has possibly always been an issue.
I just fixed the problem it was on google sheets, the column name was wrong, after i fixed it , now it is filling correctly again.
Regarding the other node, yes it is not working , but it worked before.
I need to replace the . for , using the info from webhook note, the item is an array.
The current code running is the above but i receive the following error:
ERROR: Unknown top-level item key: pairedItems [item 0]
var replaceob = $item("0").$node["Webhook"].json["body"]["items"]["1"]["item_value"].toString();
// Loop over inputs and add a new field called 'myNewField' to the JSON of each one
for (item of items) {
item.json.replaceob = replaceob.replace(/\./g, ',');
}
// You can write logs to the browser console
console.log('Done!');
return items;
I tried to replace with the new syntax you sent.
$(‘Webhook’).item.json.body.items[1].item_value
