Data from API, display nested json?

💬 App Building
1

Hello!

I can access the api and show data in a table, but i have a object with customer address which is splitted by streetAddress, City and postCode. How do i get this to be displayed as plain text comma seperated inside the table/box? Can i use Mapper on the column or some kind of transformer on the query itself?

retool support
retool support1250×712 48.5 KB

2

Hi @Jolor you can use Custom Column and mapper. Please follow these steps.

  1. Create a new custom column and name it Address

  2. You can hide the real one

  3. In the mapper field, you can use {{currentRow.address.streetAddress+","+currentRow.address.streetAddressLine2}}

  4. By this way you can concatenate the object properties.

Please have a look at the custom column documentation

2 Likes
3

Perfect, thanks alot!

1 Like