Accessing Nested arrays in JSON dictionary

Question

Hey there I am trying to extract items in an array inside a json dictionary but I'm getting the below error. Thank you in advance for your help.

Error:

    for r in data[p]['reportDetails']:
TypeError: unhashable type: 'dict'

The code snippet is below:

def XeroExtractReports(cred_fp):
    with open(cred_fp, 'r') as json_file:
        data = json.load(json_file)
        for p in data['credentials']:
            client_id = p['clientId']
            client_secret = p['clientSecret']
            old_refresh_token = p['refreshToken']

            for r in data[p]['reportDetails']:
                get_url = 'https://api.xero.com/api.xro/2.0/' + r['reportName']
                response = requests.get(get_url,
                                       headers = {
                                           'Authorization': 'Bearer ' + new_tokens[0],
                                           'Xero-tenant-id': xero_tenant_id,
                                           'Accept': 'application/json'
                                       })
                json_response = response.json()
                print(json_response)
                print('\n')

JSON Dictionary:

{
    "credentials": [{
        "clientName": "C1",
        "clientId": "null",
        "clientSecret": "null",
        "redirectUrl": "http://localhost:8080/callback",
        "scopes": "offline_access accounting.transactions.read",
        "reportType": "null",
        "refreshToken": "null",
        "reportDetails": [
            {
                "reportName": "BankTransactions",
                "reportFilename": "/BankTransactions.txt"
            },
            {
                "reportName": "BankTransfers",
                "reportFilename": "/BankTransfers.txt"
            }
        ]
    }]
}

ncica · Accepted Answer · 2020-05-08 20:05:44Z

4

you are trying to access values on a wrong way

instead of:

for r in data[p]['reportDetails']:
    ...

use:

for r in p['reportDetails']:
    ...

answered May 8, 2020 at 20:05

ncica

7,2161 gold badge19 silver badges41 bronze badges

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

Comments

Andrea Baldini · Accepted Answer · 2020-05-08 20:10:07Z

1

You don't need to use data[p] to get value of reportDetails.

You already got the dict when you set p

Change the second loop with:

for r in p['reportDetails']

answered May 8, 2020 at 20:10

Andrea Baldini

1,0492 gold badges8 silver badges19 bronze badges

Collectives™ on Stack Overflow

Accessing Nested arrays in JSON dictionary

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