pythonjson数据解析_通过URL解析python2.7中的json数据

我觉得我很亲近，但我无法解决这个问题。我只想打印字段tpnc的数值结果。只有一个数字要打印。在

我的代码是：import httplib, urllib, base64, json, requests

headers = {

# Request headers

'Ocp-Apim-Subscription-Key': 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',

}

barcode = input("Enter a barcode:")

params = urllib.urlencode({

# Request parameters

'gtin': str(barcode),

'tpnb': '{string}',

'tpnc': '{string}',

'catid': '{string}',

})

#try:

conn = httplib.HTTPSConnection('dev.tescolabs.com')

conn.request("GET", "/product/?%s" % params, "{body}", headers)

response = conn.getresponse()

data = response.read()

json = json.loads(data)

print json ["products"]['tpnc']

以下是我收到的错误：

^{pr2}$

在我看来，产品是关键，然后是tpnc，但这可能是我弄错的地方。这是返回的原始Json（在下面的第6行）。在{

"products": [

{

"gtin": "05057373842824",

"tpnb": "059266919",

"tpnc": "297243995",

"description": "Tesco Light Mayonnaise 450Ml",

"brand": "TESCO",

"qtyContents": {

"quantity": 450.0,

"totalQuantity": 450.0,

"quantityUom": "ml",

"drainedWeight": "-;-",

"netContents": "450ml e (PET);650ml e (PET)"

},

"productCharacteristics": {

"isFood": true,

"isDrink": false,

"healthScore": 50,

"isHazardous": false,

"storageType": "Ambient",

"isNonLiquidAnalgesic": false,

"containsLoperamide": false

},

"ingredients": [

"Water",

"Rapeseed Oil (28%), Sugar, Modified Maize Starch, Spirit Vinegar, Free Range Pasteurised Egg Yolk (4%), Potassium Chloride, Lemon Juice From Concentrate, Salt, Preservative (Sorbic Acid), Stabilisers (Xanthan Gum, Guar Gum), Mustard Seed, Acidity Regulator (Citric Acid), Turmeric Powder, Antioxidant (Rosemary Extract).

"

],

"gda": {

"gdaRefs": [

{

"gdaDescription": "Guideline Amounts Per Serv",

"headers": [

"Each tablespoon contains"

],

"footers": [

"*Reference intake of an average adult (8400 kJ / 2000 kcal)",

"Typical values per 100ml: Energy 1271.56kJ (307.72kcal)"

],

"values": [

{

"name": "Energy",

"values": [

"191kJ",

"46kcal"

],

"percent": "2"

},

{

"name": "Fat",

"values": [

"4.4g"

],

"percent": "6",

"rating": "high"

},

{

"name": "Saturates",

"values": [

"0.4g"

],

"percent": "2",

"rating": "medium"

},

{

"name": "Sugars",

"values": [

"0.8g"

],

"percent": "1",

"rating": "medium"

},

{

"name": "Salt",

"values": [

"0.1g"

],

"percent": "2",

"rating": "medium"

}

]

}

]

},

"calcNutrition": {

"per100Header": "100ml contains",

"perServingHeader": "Each tablespoon (15ml) contains",

"calcNutrients": [

{

"name": "Energy (kJ)",

"valuePer100": "1271.56",

"valuePerServing": "190.73"

},

{

"name": "Energy (kcal)",

"valuePer100": "307.72",

"valuePerServing": "46.16"

},

{

"name": "Fat (g)",

"valuePer100": "29",

"valuePerServing": "4.35"

},

{

"name": "Saturates (g)",

"valuePer100": "2.5",

"valuePerServing": ".38"

},

{

"name": "Carbohydrate (g)",

"valuePer100": "11.1",

"valuePerServing": "1.67"

},

{

"name": "Sugars (g)",

"valuePer100": "5.23",

"valuePerServing": ".78"

},

{

"name": "Fibre"

},

{

"name": "Protein (g)",

"valuePer100": ".58",

"valuePerServing": ".09"

},

{

"name": "Salt (g)",

"valuePer100": ".97",

"valuePerServing": ".15"

}

]

},

"allergenAdvice": {

"allergenText": "For allergens, see ingredients in bold."

},

"storage": [

"Store in a cool, dry place. Once opened, keep refrigerated and consume within 28 days."

],

"marketingText": "Made with Free Range Eggs",

"pkgDimensions": [

{

"no": 1,

"height": 19.3,

"width": 8.1,

"depth": 5.5,

"dimensionUom": "cm",

"weight": 502.0,

"weightUom": "g",

"volume": 859.815,

"volumeUom": "cc"

}

],

"productAttributes": [

{

"category": [

{

"lifestyle": [

{

"lifestyle": {

"name": "Lifestyle",

"value": "Suitable for Vegetarians"

}

}

]

}

]

}

]

}

]

}