How to convert a list of Json string to Json Array in Python?

Question

I have a list which is like

DecomposeTables = ['{ attr:["C", "A", "B"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:13, }', '{ attr:["C", "A", "B"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:13, }', '{ attr:["C", "A", "B"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:13, }']

i want to send it as json for api response i have tried

jsonpickle.encode(DecomposeTables,unpicklable=False)

but on front end i am reciving only one object as json other are null

data: 
["{ attr:["C", "B", "A"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:6, }", "{ attr:["C", "B", "A"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:6, }", "{ attr:["C", "B", "A"],fds:[[["A"], ["A"]], [["C"], ["B"]]],normalForm:"BCNF",pid:1,id:6, }"]

How much control do you have over DecomposeTables? Things would be a lot easier if the keys were in quotes, viz. '{ "attr": ["C", "A", "B"], "fds": ... }' — user3456014
– user3456014, Commented Jun 15, 2020 at 9:57
i can change that ,what shoud i do after that If i have the above format as you say @mrblewog — bhoomeendra
– bhoomeendra, Commented Jun 15, 2020 at 10:14
If you found the answer useful -- stackoverflow.com/help/someone-answers — user3456014
– user3456014, Commented Jun 19, 2020 at 7:56

user3456014 · Accepted Answer · 2020-06-15 10:19:32Z

Picking up from the comments.... assuming that you can put the keys in quotes.

(I'm using Python 3.8.1)

import ast
import json

# Note "attr" not attr, and so on.
# Each string is actually a string representation of a Python dictionary.
DecomposeTables = [
    '{ "attr":["C", "A", "B"],"fds":[[["A"], ["A"]], [["C"], ["B"]]],"normalForm":"BCNF","pid":1,"id":13 }', 
    '{ "attr":["C", "A", "B"],"fds":[[["A"], ["A"]], [["C"], ["B"]]],"normalForm":"BCNF","pid":1,"id":13 }', 
    '{ "attr":["C", "A", "B"],"fds":[[["A"], ["A"]], [["C"], ["B"]]],"normalForm":"BCNF","pid":1,"id":13 }'
    ]

# https://docs.python.org/3/library/ast.html => safely evaluate each string as a Python dictionary
as_dicts = [ast.literal_eval(x) for x in DecomposeTables]

# Now as_dicts is a Python list with Python dictionaries in it.
# You might be able to just send that object with Flask,
# but as an example here I'm writing the list as a json string
as_json = json.dumps(as_dicts)
print(as_json)

gives

[{"attr": ["C", "A", "B"], "fds": [[["A"], ["A"]], [["C"], ["B"]]], "normalForm": "BCNF", "pid": 1, "id": 13}, {"attr": ["C", "A", "B"], "fds": [[["A"], ["A"]], [["C"], ["B"]]], "normalForm": "BCNF", "pid": 1, "id": 13}, {"attr": ["C", "A", "B"], "fds": [[["A"], ["A"]], [["C"], ["B"]]], "normalForm": "BCNF", "pid": 1, "id": 13}]

Collectives™ on Stack Overflow

How to convert a list of Json string to Json Array in Python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related