Referencing JSON with colon in key?

App Building
1

I have an API response that is has key with a colon in it which is giving me trouble because I cannot map a table column to it. The pw:location in the code below is what is giving me trouble. Is there anyway to reference it in the current state or will I have to use a transformer to change the key so it is usable in retool? Screenshots attached. Thanks for any help!

{{pwlots.data.data[0]._embedded.pw:location.name}}
Retool state

retooltable-png-1573×545-
retooltable-png-1573×545-1899×649 152 KB

2

try this way item["pw:event"]

1 Like
3

That worked perfectly, thank you so much!

I ended up using a transformer to pull out just the data that I needed and then used that for the table source before I saw your solution. But your method is much easier.

1 Like