Forum Academy Marketplace Showcase Pricing Features

Convert fields in Bubble Table to Json to feed to API

I have a simple table in bubble with two fields ‘Player’ and ‘Amount’. I need to convert this data to JSON format like
{
“John”: “12.00”,
“Mark”:"25.00,
.
.
.
}

Total number of rows in the table will never exceed 100.

I tried JSONata plugin
image

But this gives me output as:
image

Please advice

hi @atgoyals !
have you tried something like this :



image

listtext can be a list then you can use add instead of =

I hope it helps you :slight_smile:
Antoine