Convert fields in Bubble Table to Json to feed to API

[atgoyals]

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

But this gives me output as:

Please advice

[antoine.lemaitre]

hi @atgoyals !
have you tried something like this :

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

I hope it helps you
Antoine