Hi! Just trying Wappler for the 1st time and loving it so far. However, there is one feature that I can’t seem to get working. I have a MySQL database with some json fields in it. I would like to be able to use these fields as objects and update them. So far I am able to select the field but I can only get the output as a string.
Is there any way to maintain the json object or convert the string output to an object and back again to a string when updating?
good question…
That is a very good question, altought I think it can be already done, we were looking to implement this more natively, so that all conversion ms happen automatically.
Maybe @patrick can advise for current solution, I think it can be done with data formatters, that will handle the conversion.
Hi George,
Can you comment on this?
Many thanks,
Alex
Hi George,
Any thoughts on reviving this topic?
Many thanks,
Alex
Maybe this will help in the interim
https://community.wappler.io/t/server-connect-api-that-consumes-json/28341/5?u=mebeingken
Thx Ken
Hi Alex,
Stringify would need to be a formatter (as Ken suggests through the linked post), just in case you have other uses for formatters, instructions to create your own can be found here:
Many thanks!