How do I a retrieve specific value from JSON output in Python 2.7?

Question

I have a Python 2.7 script that looks like this:

import requests

    url = "https://example.net/rest/v1/m/4513452615415"

    querystring = {"client":"wzas"}

    payload = "{\r\n              \"sss\" : \""+msse+"\",\r\n\"VisitorId\":\""+mcid+"\",\r\n              \"thirdPartyId\": \""+tracking_id+"\",\r\n              \"contentAsJson\": \"true\",\r\n                             \"mbssParameters\": \r\n                             {        \r\n                             \"mboxMCGLH\": \"6\"     \r\n                             }\r\n}\r\n"
    headers = {
        'content-type': "application/json",
        'cache-control': "no-cache",
        'postman-token': "289f645d-1543-e6df-87fb-1cef88f110c5"
        }

    response = requests.request("POST", url, data=payload, headers=headers, params=querystring)

    return (response.text)

The output is sent to a CSV file and looks like this:

{"thirdPartyId":"559yZDIIs3XvFpLPhvjexK7/jYlT7ZwJXBpNc/ZS4A1saWdodG5pbmdzZWVkcw==","marketingId":"89137879111811717593914206190290951066814","edgeHost":"mrdge21.example.net","content":{"tnsVal":"931113:4:0","contentName":"examplecontent","revenue":14},"sessionId":"4513452615415"}

How would I only output the contentName and tnsVal ?

Thanks in advance Nick

HINT: Try response.json to get a dict

ayrusme
– ayrusme

2017-11-14 10:45:56 +00:00
Commented Nov 14, 2017 at 10:45 — ayrusme
– ayrusme, Commented Nov 14, 2017 at 10:45

ayrusme · Accepted Answer · 2017-11-14 10:48:23Z

3

Since it's pretty clear you're getting a JSON back, try the following line:

import json
response_json = json.loads(response.text)
print(response_json['content']['contentName'], response_json['content']['tnsVal'])

answered Nov 14, 2017 at 10:48

ayrusme

5165 silver badges17 bronze badges

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

Comments

Harsha Biyani · Accepted Answer · 2017-11-14 10:49:23Z

2

You can try:

>>> import json
>>> data = json.loads(response.text)
>>> data["content"]["tnsVal"]
'931113:4:0'
>>> data["content"]["contentName"]
'examplecontent'

answered Nov 14, 2017 at 10:49

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges

Collectives™ on Stack Overflow

How do I a retrieve specific value from JSON output in Python 2.7?

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