How to get Values of one JSON object into the Values of another with Python

Question

Closed. This question needs debugging details. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65903050/how-to-get-values-of-one-json-object-into-the-values-of-another-with-python

Answer 1

You need to unpack the JSON objects, add them together(see code), and then put them back into a new JSON object.
Code:

import json
d4=json.loads(payload4)
d5=json.loads(payload5)
d4["Values"].extend(d5["Values"])
newpayload=json.dumps(d4)

Output:

>>> print(newpayload)
{"Values": [{"Name": "projectionLength", "Attribute": "Test"}, {"Name": "projectionHeight", "Attribute": "Test"}, {"Name": "projectionLength", "Attribute": "Test5"}, {"Name": "projectionHeight", "Attribute": "Test6"}]}

Nicer looking version just to give you a feel of whats stored in newpayload(this is not the real JSON text):

>>> import pprint
>>> pprint.pprint(d4)
{'Values': [{'Attribute': 'Test', 'Name': 'projectionLength'},
            {'Attribute': 'Test', 'Name': 'projectionHeight'},
            {'Attribute': 'Test5', 'Name': 'projectionLength'},
            {'Attribute': 'Test6', 'Name': 'projectionHeight'}]}