Load JSON data from table media column

Anvil Q&A
6

I don’t understand what you mean by loading a json file.

I made this example app with:

  • a file uploader that allows you to select a file from your computer, upload it, convert the text to json and save it to a Simple Object column
  • a button that allows you to get the json value from the database and show it in an alert.

I created a server module to write and read from the database rather than giving read and write access to the form because working with tables directly from the form is possible, but is unsafe and slower than accessing the database from the server and returning only the required data.

https://anvil.works/build#clone:JFNX5HTD6VZSSQAC=JPXJKMTFMP2XVGG7VA2X5OJR
The table has two columns key and value. The app uses the text "key" for both writing to and reading from the table.

2 Likes