Hi there,
I am setting up a webhook invoked automation, which pulls data into a Coda table. I would like to pull all values/columns that come from the webhook, and there are quite a few so it’s a bit inefficient to set the ParseJSON() for each one individually. Is there a way to automatically populate all fields in the Coda table without defining each value/column individually?
Do my column headings need to match the JSON values exactly or just be listed in the same order?
And a nice-to-have that has also been giving me trouble: When I ParseJSON() a value that has come from a select list, I’ve noticed that what I get is the XML value not the label - for example if the options the user sees in the source application are “Option 1”, “Option 2”, “Option 3”, what comes into Coda is “option_1”, “option_2”, “option_3”.
Is it possible to get the labels not the XML values?
Thank you!