This is something I picked up in on your other thread for for this workflow. While looking into this I found a bug that I have put in a fix for with the Google Sheets node that should resolve this but I am just waiting for the review process so we can get it merged and available in a future release.
Thanks @Jon
Let me see If i understood.
The syntax I’m using now is correct and there is a bug that needs to be fixed?
or the new syntax you sent me on another topic is the correct one?
Is there any workaround that can be made while fix is in development?
Looking at the code in the node you are trying to mix old code with new which can get a bit confusing, The fix I put in though will solve the unknown top-level item key: pairedItems issue. At the moment I don’t have a creating workaround for this as the data is being set by the Google Sheets node incorrectly.
Try changing the code node to something like
var replaceob = $("Webhook").first().json["body"]["items"]["1"]["item_value"].toString();
for (item of $input.all()) {
delete item.pairedItems
item.json.replaceob = replaceob.replace(/\./g, ',');
}
console.log('Done!');
return $input.all();
This will then delete the invalid pairedItems item