Hello,
I am attempting to pull data from a database called Wild Apricot into google sheets, and I am encountering the following error.
"BundleValidationError
Validation failed for 1 parameter(s).
- Collection can’t be converted to text for parameter ‘1’."
I have tried all the validating options, including RAW. However, nothing seems to fix it.
Thank you for your time and help.
You’ll need to use the map() function to extract the string, number or date out of the collection wild apricot is returning.
1 Like
Hello,
I followed the video in question. I get() map() all of the data points that were giving trouble. They are no longer array’s, and should work now. However it is still producing an error.
e
Hope you’ll find a solution fast
Please look into all your mapped variables. Somewhere you have some values which are not text, and most likely need to be transformed.
1 Like
Is there a way of transforming them beyond get()map()?
No, you’ll have to map them if they are in collections / arrays.
2 Likes