Select/Dropdown with json as value

App Building
1

I have a query resource that has this sql query

select label, jsondata from table

Now I'm trying to build a select/dropdown that is mapped to above query resource.

However, when I map the query's jsondata to the dropdown's value I get this error:
image

How can I fix this to be able to use json as value?

2

It looks like your JSON contains some empty strings. If they are always empty, cleaning up the JSON would help. If they are dynamic, you sometimes have to push through the errors.

3

@Chris_Skiles good point and I double checked. I have 5 rows returned by the query and all fields are populated... I wonder if this is a bug... Perhaps the json field name companyid makes retool think there are duplicates? Not sure...

image
image2317×873 131 KB

4

if you narrow it down to item.jsondata.companyid, does the error go away?

5

:wink: item.jsondata[0].companyid

1 Like
6

What about it you stringify the JSON?

7

Thanks @Chris_Skiles and @bobthebear. Using item.jsondata[0].companyid made the error go away!

1 Like
8

happy to see you found a solution!! feel free to mark @Chris_Skiles's post as the solution so other searching can easily find this... if you don't mind and have the time that is :beers:

1 Like