Supabase got rows problem

Someone please help. Everytime I want to get data from supabase using got rows block, I’m always getting the brackets, braces, parenthesis. How should I get rid of it?

Hey DEXTER,

Welcome to kodular community

Legend himself RayzZz :raising_hands::raising_hands:covered a lot of things in this guide, have you tried it, if not take a good look. It’s well explained,

It’s not like am saying the way you are using isn’t good, but there’s no current guide/public topic :raising_hands:

Also you can show us how you are handling the blocks and we can see what you’re trying to do and how to help

1 Like

Hi both,

And welcome to the Kodular community, Dexter

Thank you very much Ibrahim for mentioning my guide :heart_hands:

However, I understand that it’s important to start learning how the new Supabase component works.
I checked the documentation and, as we can see


the output is a list.

From my testing, you do receive a list, but it contains a JSON string.
So, you’ll need to use the Web component to decode that string.


Once decoded, you’ll get a list of dictionaries

List of pairs to dictionary doesn’t work correctly
blocks(3)
So technically it’s a list of lists :nerd_face:

, where each dictionary contains the column names as keys and the corresponding values for each row (index) of your Supabase table.


So you can select rows from the table using selectListItem, and then use getValueForKey (with the column name you want) to retrieve the value.

Alternatively, you can loop through all the items in the list using a for each item in list and for example, create dynamic components by selecting values dynamically from the list.

2 Likes

The problem still exist sir… braces and brackets disappeared but parenthesis still there and I can’t find a way to remove it. Even if i use Json decode it does not solve the problem. It think it is a database issue, so I use firebase for my database and today it works very well, no need to decode

By the way thanks for your kind help.:hand_with_index_finger_and_thumb_crossed:t2:

Hi dear,

There’s one important thing to keep in mind, the parentheses you see are not just plain text, they represent a LISP list, which is the format used by Kodular (and similar platforms) to represent lists of elements.

Whenever you’re unsure whether something is actually a list or not, you can use the lists_is_list block to check.

ok thanks for that