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,…

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. [2023-08-09 (1)] [2023-08-09] e [2023-08-09 (3)] [2023-08-09 (2)]

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.

Is there a way of transforming them beyond get()map()?

No, you’ll have to map them if they are in collections / arrays.

BundleValidationError

Questions

alex.newpath October 3, 2022, 8:10pm 2

You’ll need to use the map() function to extract the string, number or date out of the collection wild apricot is returning.

Topic		Replies	Views
BundleValidationError.Collection can't be converted to text for parameter '0' Questions error	3	501	June 22, 2024
Unhelpful error (BundleValidationError – Validation failed for 2 parameter(s). – Collection can't be converted to text for parameter '30' Questions error	1	95	October 8, 2024
BundleValidationError Validation failed for 1 parameter(s). Collection can't be converted to text for parameter '3' Questions google-sheets , hubspot	0	82	January 14, 2025
BundleValidationError "0" Questions error	0	72	August 8, 2024
Googlesheet conversion to text error Questions google-sheets , error	2	74	August 18, 2024

BundleValidationError

Related topics