Python & Json: Multiline input data into Json

Question

I have a problem regarding my python code that needs to create a multiline JSON type of data.

def get_json_data(response):
 x ={}
 f ={}
 for report in response.get('reports', []):
    columnHeader = report.get('columnHeader', {})
    dimensionHeaders = columnHeader.get('dimensions', [])
    metricHeaders = columnHeader.get('metricHeader', {}).get('metricHeaderEntries', [])
    for row in report.get('data', {}).get('rows', []):
        dimensions = row.get('dimensions', [])
        dateRangeValues = row.get('metrics', [])

        for header, dimension in zip(dimensionHeaders, dimensions):
            x[header.replace('la:','')] = dimension

            for i, values in enumerate(dateRangeValues):
                for metricHeader, value in zip(metricHeaders, values.get('values')):
                    x[metricHeader.get('name').replace('la:','')] = value

        f['dashboard'] = x
        print (json.dumps(f))
 print (json.dumps(f))

Currently, it is showing these data

{
  "dashboard": 
      {"bounces": "12", "userType": "Returning Visitor", "users": "3"}
}

But what I want the output is to display this kind of data

{
 "dashboard": 
     {"bounces": "10", "userType": "New Visitor", "users": "15"},
     {"bounces": "12", "userType": "Returning Visitor", "users": "3"}
}

Netwave · Accepted Answer · 2018-06-26 10:55:57Z

2

Your output data example is not a valid json, nevertheless this would fix it:

def get_json_data(response):
 x ={}
 f ={'dashboad' : []}
 ...
        f['dashboard'].append(x)
        print (json.dumps(f))
 print (json.dumps(f))

The dashboard value should be a list so then you can append the different x results

answered Jun 26, 2018 at 10:55

Netwave

43.2k6 gold badges69 silver badges111 bronze badges

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

1 Comment

Abdul Rahim Over a year ago

Thank man. You are the great. Thank for help to solve my problem

Nihal · Accepted Answer · 2018-06-26 11:13:57Z

2

you format should be like this

df1 = {
    "dashboard":
        [{"bounces": "10", "userType": "New Visitor", "users": "15"},
         {"bounces": "12", "userType": "Returning Visitor", "users": "3"}]
}

otherwise it will give error

answered Jun 26, 2018 at 11:13

Nihal

5,3547 gold badges26 silver badges41 bronze badges

2 Comments

Abdul Rahim Over a year ago

thank for the help on structure error. but this not the answer

Nihal Over a year ago

yes, i know. answer was given by netwave already. and i don't want to post the same thing

vipul prajapati · Accepted Answer · 2018-06-26 10:58:41Z

0

You cannot build this kind of structure because python does not allow this. Just type this in your terminal you'll get idea about structure error

{
 "dashboard": 
     {"bounces": "10", "userType": "New Visitor", "users": "15"},
     {"bounces": "12", "userType": "Returning Visitor", "users": "3"}
}

answered Jun 26, 2018 at 10:58

vipul prajapati

2931 gold badge2 silver badges8 bronze badges

1 Comment

Abdul Rahim Over a year ago

Owh thank for emphasis on structure error for json code thank you.

Collectives™ on Stack Overflow

Python & Json: Multiline input data into Json

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related