Trouble formatting Supabase JSON response for integration with Play (need colon : format)
Hi, guys!
Building my first database but experiencing issues integrating Supabase with the Play prototyping tool. When I fetch data from a Supabase table, the returned format uses = instead of : for key-value pairs, like this:
[{ name = John; birthday = "1997-11-02"; }]
However, Play expects standard JSON syntax, like:
[{ "name": "John", "birthday": "1997-11-02" }]
This difference makes it impossible to work with the data directly in Play, since the platform does not support reformatting or parsing inside the tool.
I created an Edge Function (json-formatter) to transform the format, but it did not work and I only get empty response.
Someone from the Play team (Harcourt Allen) commented:
“Are you able to specify to Supabase how you’d like your dictionary laid out? I think that is probably the best bet, as you can’t do much with your dictionary unless it’s in the correct format, and you can’t really reformat in Play.”
Is there a native way to ensure that Supabase returns data in proper JSON format — with : instead of = — either directly from the query or via some automatic transformation?
I’ve attached screenshot from Play with JSON I get.
Thank you!
Building my first database but experiencing issues integrating Supabase with the Play prototyping tool. When I fetch data from a Supabase table, the returned format uses = instead of : for key-value pairs, like this:
[{ name = John; birthday = "1997-11-02"; }]
However, Play expects standard JSON syntax, like:
[{ "name": "John", "birthday": "1997-11-02" }]
This difference makes it impossible to work with the data directly in Play, since the platform does not support reformatting or parsing inside the tool.
I created an Edge Function (json-formatter) to transform the format, but it did not work and I only get empty response.
Someone from the Play team (Harcourt Allen) commented:
“Are you able to specify to Supabase how you’d like your dictionary laid out? I think that is probably the best bet, as you can’t do much with your dictionary unless it’s in the correct format, and you can’t really reformat in Play.”
Is there a native way to ensure that Supabase returns data in proper JSON format — with : instead of = — either directly from the query or via some automatic transformation?
I’ve attached screenshot from Play with JSON I get.
Thank you!
