MySQL - JSON Array


#1

Does anyone here pull data from their MySQL or any database in JSON Array format?

If yes could you send me a Sample JSON String?


#2

Do you have simple json structure?


#3

I am currently testing with:
{“infile”: [{“field1”: 11,“field2”: 12,“field3”: 13},{“field1”: 21,“field2”: 22,“field3”: 23},{“field1”: 31,“field2”: 32,“field3”: 33}]}


#4

@Ken If using php, you can use json_encode($phpData):

https://www.dyn-web.com/tutorials/php-js/json/array.php


#5


#6

I’m creating an extension that converts JSON to CSV


#7

Thats great. Together with this tutorial and the tableview you could make really nice apps.

The data is also stored as json.


#8

Is there a way to download the entire database as JSON?
I only see a way to get the value of an individual tag.


#9

That is not possible at the moment. Maybe the developers can make that as a block. Or maybe it can be done by downloading the database.txt file. It is in json format.

{"test":"\"test\""}

#10

I have it working the way I want now:

jsonText:
[{“field1”: 11,“field2”: 12,“field3”: 13},{“field1”: 21,“field2”: 22,“field3”: 23},{“field1”: 31,“field2”: 32,“field3”: 33}]

b422d225456ccc4cef6eb202c11af1b440d0f9dd_1_690x265


#11

Great work :+1: