How to dynamically create a JSON string?

Question

I am trying to create a JSON string that I can send in a PUT request but build it dynamically. For example, once I am done, I'd like the string to look like this:

{
    "request-id": 1045058,
    "db-connections":
        [
            {
                "db-name":"Sales",
                "table-name":"customer"
            }
        ]
}

I'd like to use constants for the keys, for example, for request-id, I'd like to use CONST_REQUEST_ID. So the keys will be,

CONST_REQUEST_ID = "request-id"
CONST_DB_CONNECTIONS = "db_connections"
CONST_DB_NAME = "db-name"
CONST_TABLE_NAME = "table-name"

The values for the keys will be taken from various variables. For example we can take value "Sales" from a var called dbname with the value "Sales".

I have tried json.load and getting exception. Help would be appreciated please as I am a bit new to Python.

You mean something like "db-name" : dbname?

AAA
– AAA

2019-07-18 23:59:47 +00:00
Commented Jul 18, 2019 at 23:59 — AAA
– AAA, Commented Jul 18, 2019 at 23:59

Shadow · Accepted Answer · 2019-07-19 00:03:07Z

1

Create a normal python dictionary, then convert it to JSON.

raw_data = {
    CONST_DB_NAME: getDbNameValue()
}

# ...

json_data = json.dumps(raw_data)
# Use json_data in your PUT request.

answered Jul 19, 2019 at 0:03

Shadow

9,5474 gold badges50 silver badges60 bronze badges

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

Comments

Fan Zeng · Accepted Answer · 2019-07-19 00:17:05Z

You can concat the string using + with variables.

CONST_REQUEST_ID = "request-id"
CONST_DB_CONNECTIONS = "db_connections"
CONST_DB_NAME = "db-name"
CONST_TABLE_NAME = "table-name"

request_id = "1045058"
db_name = "Sales"
table_name = 'customer'

json_string = '{' + \
    '"' + CONST_REQUEST_ID + '": ' + request_id \
    + ',' + \
    '"db-connections":' \
    +   '[' \
    +       '{' \
    +            '"' + CONST_DB_NAME +'":"' + db_name +  '",' \
    +           '"' + CONST_TABLE_NAME + '":"' + table_name + '"' \
    +        '}' \
    +    ']' \
    + '}'

print json_string

And this is the result

python st_ans.py 
{"request-id": 1045058,"db-connections":[{"db-name":"Sales","table-name":"customer"}]}

Collectives™ on Stack Overflow

How to dynamically create a JSON string?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related