Category: How do I do X?
Updated

This solution is summarized from an archived support forum post. This information may have changed. If you notice an error, please let us know in Discord.

Using Array in API, Query?

Issue

I am new to Retool and I want to convert the array data obtained from a database select statement into a string. I tried using {{GetDeviceID.data.deviceId.toString()}}, but it's not working. Is there any other way to do it?

Resolution

The user was seeking a solution to convert an array of data retrieved from a database select statement into a string. They tried using the .toString() method, but it didn't work in Appsmith. After some exploration, they found a working solution using the .map() method to extract the desired data from the array and then using .toString() to join the extracted values into a string. The final solution was: {{GetDeviceID.data.map(item => item.deviceId).toString()}}.