Add multiple values to Json String

Question

I have a For loop that extracts objects from your database query. Now I'm looking for a way to add these objects to an existing JSON string.

My list looks like this:

i = [(2, 23322323, 'object1name', 'example1'),(3, 2323232, 'object2name', 'example2'),(4, 12312312, 'object3name','example3')]

My For loop looks like this:

count = 1
for item in i:
    object = item[2], item[3]
    print("Object",count, item[2], item[3])
    count = count + 1

My JSON String looks like this:

payload = json.dumps({'intent': 'test', 'message': message, 'url':imageURL})

I would like to have the following JSON output:

payload = json.dumps({'intent': 'test', 'message': message, 'url':imageURL, 'objetc1':object1, 'object2': object2})

I have tried to add the objects with:

payload['object'] = item[2], item[3]

But unfortunately I don't know how to add all objects and additionally the ascending numbering so Object1, Object2 and so on.

Thanks for your help.

My answer as per below. Please use my method to convert payload from string to dictionary to add elements. — AnswerSeeker
– AnswerSeeker, Commented Oct 14, 2019 at 6:18

csoham · Accepted Answer · 2019-10-14 06:11:23Z

2

First of all, you do not need to keep track of the count. This is because python has a useful enumerate function which returns both the item in the list and its position. So instead, you can do something like this:

fruits=['Apple', 'Banana', 'Mango']
for i, fruit in enumerate(fruits):
    print(i, fruit)

This will give an output like:

0 Apple
1 Banana
2 Mango

So now that you have the count, you can use the count to keep track of the object count in your json key.

fruits=['Apple', 'Banana', 'Mango']
d={}
for i, fruit in enumerate(fruits):
    d['fruit'+str(i)]=fruit
d

This is going to give an output like:

{'fruit0': 'Apple', 'fruit1': 'Banana', 'fruit2': 'Mango'}

Just replace fruits with the items in your database and you are good to go!

answered Oct 14, 2019 at 6:11

csoham

1407 bronze badges

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

Comments

AnswerSeeker · Accepted Answer · 2019-10-14 06:34:40Z

1

Since json has dumped the value into payload, note payload is of type string. Need to convert payload to type dictionary to add elements.

# Loads payload back to dictionary
p = json.loads(payload)

# Add objects accordingly as per below
for index, item in enumerate(i):
    p['object' + str(index)] = item[2], item[3]

edited Oct 14, 2019 at 6:34

answered Oct 14, 2019 at 6:17

AnswerSeeker

2981 silver badge10 bronze badges

4 Comments

Timothy_Goodman Over a year ago

Thanks, this works perfect. How can I remove the brackets from the items in the JSON string?

AnswerSeeker Over a year ago

Sounds good! That item[2], item[3] belongs together as mentioned in your code. Those are grouped together as type of "tuple". If you want to separate it, I suggest you can alter my code to be p['object' + str(index)] = item[2] and next line will be p['example' + str(index)] = item[3]

Timothy_Goodman Over a year ago

Ok perfect, now I have understand it. Thanks a lot for your help. :)

AnswerSeeker Over a year ago

Glad to help! :)

soheshdoshi · Accepted Answer · 2019-10-14 05:55:33Z

0

I don't know what is your object structure but i think this will help you.

a={'intent': 'test', 'message': 'message', 'url':'imageURL'}
i=["ssdds","rajkot","baroda"]
count = 1
for item in range(len(i)):
  a["object"+str(item+1)]=i[item]
print(a)

answered Oct 14, 2019 at 5:55

soheshdoshi

6343 gold badges9 silver badges24 bronze badges

1 Comment

Timothy_Goodman Over a year ago

I add a sample datastructure

rdas · Accepted Answer · 2019-10-14 05:55:41Z

0

Try this:

for index, item in enumerate(i):
    payload['object' + str(index)] = item

answered Oct 14, 2019 at 5:55

rdas

21.4k6 gold badges39 silver badges48 bronze badges

Collectives™ on Stack Overflow

Add multiple values to Json String

4 Answers 4

Comments

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related