I am attempting to pull data from a database called Wild Apricot into google sheets, and I am encountering the following error.

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