I am trying to use Webhooks to pass data multi-reference field data from Google Sheets to Webflow.
I’ve follow tutorials and checked other people with the issue and it looks like I have everything configured properly, but I’m still getting an error.
Data Pass-Through = False
Multi-reference fields IDs in quotes
Collection and Item IDs set properly
Can anyone help?
This is the error
Page 1 / 1
Hi @Brian16
Status code 400 is indicating that your JSON formatted code isn’t valid, try checking your JSON (in the data field) with https://jsonlint.com to verify whether you are sending proper JSON value. You can try sending static values by removing the google sheet mappings from the API step and hardcode the data and see if that works.
Thanks @robschmidt. What’s strange is I got this working but then it broke.
When I test on Webflow’s Patch Collection API tool it works for patching a single item to the skills-tags field, but with multiple item IDs it breaks. Again very strange/frustrating because I had it working yesterday.
There are double quotes at the start and end of the values.
@Troy Tessalone thanks. Sadly that doesnt seem to be the problem.
I added quotes around each value when passing in multiple. That is what every tutorial says to do for multi-reference fields and then the API adds those additional quotes automatically.
These are the values I pass in for the skill-tags field: "64a6bb15a257876f2a611c46","64a6bb177172a75c4b1fc6b9"
Then the curl output is: "skill-tags": "\"64a6bb15a257876f2a611c46\",\"64a6bb177172a75c4b1fc6b9\""
Each skill tag ID works if I add it individually on the with no quotes on the Webflow Patch Collection tool so it does definitely feel like its a formatting issue though.
When I remove all quotes I get this curl output: "skill-tags": "64a6bb15a257876f2a611c46,64a6bb177172a75c4b1fc6b9"