Referencing JSON with colon in key?

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!

Retool state

try this way item["pw:event"]

1 Like

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