I am trying to Send an array into a string column, Do we have any escaper or way to do this from bubble?

Hi All,

I’m facing an issue while trying to save the data from the bubble into my database. As there is a data type mismatch between data types i.e string and array, the system is returning an API error. Is there any way to convert “array” data into “string” before passing it from bubble.

:join with

Hi Jici, Thanks for replying. The data I’m having is not a list. I want to send the below mentioned data into a string column.

[
{
“education_statuses”: [
11,
3,
6,
8,
9
]
},
{
“interests”: [
{
“id”: “6003002193982”,
“name”: “Amazon.com
},
{
“id”: “6003257148486”,
“name”: “Alibaba.com
},
{
“id”: “6011604327964”,
“name”: “eBay Fashion”
},
{
“id”: “6013245178610”,
“name”: “Amazon.com/Fashion
}
]
},
{
“interests”: [
{
“id”: “6002975539059”,
“name”: “Ralph Lauren”
},
{
“id”: “6002984797619”,
“name”: “Fendi”
},
{
“id”: “6002985978968”,
“name”: “Lacoste”
},
{
“id”: “6003011259419”,
“name”: “TAG Heuer”
},
{
“id”: “6003081223797”,
“name”: “Seiko”
},
{
“id”: “6003138083061”,
“name”: “Calvin Klein”
},
{
“id”: “6003165411122”,
“name”: “Gucci”
},
{
“id”: “6003200432882”,
“name”: “Givenchy”
},
{
“id”: “6003202336613”,
“name”: “Hermès”
},
{
“id”: “6003241714213”,
“name”: “Burberry”
},
{
“id”: “6003246053342”,
“name”: “Prada”
},
{
“id”: “6003246597567”,
“name”: “Hublot”
},
{
“id”: “6003257903088”,
“name”: “Hugo Boss”
},
{
“id”: “6003279451780”,
“name”: “Chanel”
},
{
“id”: “6003368599202”,
“name”: “Louis Vuitton”
},
{
“id”: “6003370901535”,
“name”: “G-Shock”
},
{
“id”: “6003405508406”,
“name”: “Rado (watch)”
},
{
“id”: “6003431493391”,
“name”: “Bulgari”
},
{
“id”: “6003435546331”,
“name”: “Versace”
},
{
“id”: “6003455176744”,
“name”: “Tissot”
},
{
“id”: “6003508325964”,
“name”: “Tiffany & Co.”
},
{
“id”: “6003531450398”,
“name”: “Dolce & Gabbana”
},
{
“id”: “6003587678073”,
“name”: “Rolex”
},
{
“id”: “6003713880583”,
“name”: “Armani”
},
{
“id”: “6003746294946”,
“name”: “Christian Dior”
},
{
“id”: “6003762134517”,
“name”: “Cartier (jeweler)”
}
]
}
]

What do you mean by string column? Maybe you can provide the api endpoint doc url?