# BundleValidationError

**URL:** <https://community.make.com/t/bundlevalidationerror/4479>\
**Category:** Questions\
**Created:** [October 3, 2022, 5:08pm UTC](https://community.make.com/t/bundlevalidationerror/4479 "2022-10-03T17:08:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![NHI\_Office\_of\_Admiss](https://avatars.discourse-cdn.com/v4/letter/n/ecb155/32.png) [@NHI\_Office\_of\_Admiss](https://community.make.com/u/NHI_Office_of_Admiss)\
**Post date:** [October 3, 2022, 5:08pm UTC](https://community.make.com/t/bundlevalidationerror/4479/1 "2022-10-03T17:08:30Z")

</div>

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.

 ![2022-10-03](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/b/b044d09b94cb897b3d2ead63e96537febe13c728.png)

---

<div class="post-metadata">

**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\
**Post date:** [October 3, 2022, 8:10pm UTC](https://community.make.com/t/bundlevalidationerror/4479/2 "2022-10-03T20:10:16Z")

</div>

You’ll need to use the [map()](https://community.make.com/t/extract-an-item-from-array-get-and-map-function-make-beginners-guide/2134) function to extract the string, number or date out of the collection wild apricot is returning.

---

<div class="post-metadata">

**Author:** ![NHI\_Office\_of\_Admiss](https://avatars.discourse-cdn.com/v4/letter/n/ecb155/32.png) [@NHI\_Office\_of\_Admiss](https://community.make.com/u/NHI_Office_of_Admiss)\
**Post date:** [August 9, 2023, 3:20pm UTC](https://community.make.com/t/bundlevalidationerror/4479/3 "2023-08-09T15:20:28Z")

</div>

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)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/3/31705ee27f955d1d80242657101a6e4fd57dacf8.png)  
 ![2023-08-09](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/1/160c9523c1a59a057206dc7eb042c048bb9a2fa1.png)  
e  
 ![2023-08-09 (3)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/5/5fe9fadd3454a34d71c5c8f30f224d6af71b77f6.png)  
 ![2023-08-09 (2)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/d/d27183ca08e2ae32ca55db9df8377aeed2b9200e.png)

---

<div class="post-metadata">

**Author:** ![Dan\_Gabbay](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@Dan\_Gabbay](https://community.make.com/u/Dan_Gabbay)\
**Post date:** [August 16, 2023, 1:21pm UTC](https://community.make.com/t/bundlevalidationerror/4479/4 "2023-08-16T13:21:25Z")

</div>

Hope you’ll find a solution fast

---

<div class="post-metadata">

**Author:** ![Bjorn.drivn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/bjorn.drivn/32/4503_2.png) [@Bjorn.drivn](https://community.make.com/u/Bjorn.drivn)\
**Post date:** [August 17, 2023, 3:27pm UTC](https://community.make.com/t/bundlevalidationerror/4479/5 "2023-08-17T15:27:53Z")

</div>

Please look into all your mapped variables. Somewhere you have some values which are not text, and most likely need to be transformed.

---

<div class="post-metadata">

**Author:** ![NHI\_Office\_of\_Admiss](https://avatars.discourse-cdn.com/v4/letter/n/ecb155/32.png) [@NHI\_Office\_of\_Admiss](https://community.make.com/u/NHI_Office_of_Admiss)\
**Post date:** [August 17, 2023, 3:29pm UTC](https://community.make.com/t/bundlevalidationerror/4479/6 "2023-08-17T15:29:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bjorn.drivn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/bjorn.drivn/32/4503_2.png) [@Bjorn.drivn](https://community.make.com/u/Bjorn.drivn)\
**Post date:** [August 17, 2023, 3:32pm UTC](https://community.make.com/t/bundlevalidationerror/4479/7 "2023-08-17T15:32:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 7, 2023, 3:09pm UTC](https://community.make.com/t/bundlevalidationerror/4479/9 "2023-12-07T15:09:15Z")

</div>


