How to make a valid format JSON in python?

Question

I want to make JSON to get queries from elastic search. I'm usgin this code to build the query:

search_doc = {}
        search_doc.update({"sort": [{"re_max": {"order": "desc"}}]})
        search_doc.update({"from": 0})
        search_doc.update({"size": 100})
        search_doc.update({"filter": {"and": [{"term": {"country_id": "10"}},{"range": {"pub_date": {"gte": "2014-06-07T00:00:00.0", "lte": "2014-06-07T23:59:59.0"}}}]}})

as you see I've used double quotation in all my strings, but look at the printed result:

{'sort': [{'re_max': {'order': 'desc'}}], 'filter': {'and': [{'term': {'country_id': '10'}}, {'range': {'pub_date': {'gte': '2014-06-07T00:00:00.0', 'lte': '2014-06-07T23:59:59.0'}}}]}, 'from': 0, 'size': 100}

All with single quotation which is invalid in JSON format or at least Elastic search will not accept it. Is there a way to make my strings in a valid JSON format? I think this is not a good way to replace single quotations with double quotations. please help me if there is a way.

user2357112 · Accepted Answer · 2014-06-13 05:16:55Z

5

Don't print the dict. Get a valid JSON string using the json module:

import json
json_string = json.dumps(search_doc)

The module also lets you perform the opposite conversion, turning JSON into Python data structures:

reparsed_dict = json.loads(json_string)
# reparsed_dict == search_doc

answered Jun 13, 2014 at 5:16

user2357112

286k32 gold badges490 silver badges569 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ragingSloth · Accepted Answer · 2014-06-13 05:24:06Z

1

The dictionaries you're using are not JSON but python internal objects. You can use json.dumps() to create proper JSON strings. The python standard is single quotes which is why you see them when you print it. If you need quotation marks inside the string itself, you can escape them using the backslash, e.g. '\"order\"'

answered Jun 13, 2014 at 5:24

ragingSloth

1,1048 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to make a valid format JSON in python?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related