Extract values from Json code using Python

Question

I'm trying to extract the values from the following json code in this format by displaying each device in a different row. Any ideas on how to do it? Thanks in advance

device1 : 232323 Completed
device2 : 345848 Completed etc

I tried the below which gives me the following output:

[{'cid': 631084346, 'data': [[{'text': 'device1'}], [{'text': '732536:Completed.'}], [{'text': '1'}]], 'id': 1750501182}, {'cid': 1891684718, 'data': [[{'text': 'device2'}], [{'text': '732536:Completed.'}], [{'text': '1'}]], 'id': 2218910703}

api_readable = api_response.json()
    computer_name = str(api_readable['data']['result_sets'][0]['rows'])
   # computer_name = re.sub("[{},':]", "", computer_name)
    print(computer_name)

Sample Json used

{
    "data": {
        "max_available_age": "",
        "now": "2020/01/09 22:43:58 GMT-0000",
        "result_sets": [{
            "age": 0,
            "archived_question_id": 0,
            "columns": [{
                    "hash": 3409330187,
                    "name": "Computer Name",
                    "type": 1
                },
                {
                    "hash": 1792443391,
                    "name": "Action Statuses",
                    "type": 1
                },
                {
                    "hash": 0,
                    "name": "Count",
                    "type": 3
                }
            ],
            "error_count": 0,
            "estimated_total": 129,
            "expire_seconds": 3660,
            "filtered_row_count": 11,
            "filtered_row_count_machines": 11,
            "id": 2880628,
            "issue_seconds": 0,
            "item_count": 11,
            "mr_passed": 129,
            "mr_tested": 129,
            "no_results_count": 0,
            "passed": 128,
            "question_id": 2880628,
            "report_count": 233,
            "row_count": 11,
            "row_count_machines": 11,
            "rows": [{
                        "cid": 631084346,
                        "data": [
                            [{
                                "text": "device1"
                            }],
                            [{
                                "text": "732536:Completed."
                            }],
                            [{
                                "text": "1"
                            }]
                        ],
                        "id": 1750501182
                    },
                    {
                        "cid": 1891684718,
                        "data": [
                            [{
                                "text": "device2"
                            }],
                            [{
                                "text": "732536:Completed."
                            }],
                            [{
                                "text": "1"
                            }]
                        ],
                        "id": 2218910703
                    }

https://docs.python.org/3/library/json.html + the proposed duplicate. — tevemadar, Jan 09 '20 at 23:07
@tevemadar How would it? They have *already* parsed their JSON and their question has nothing to do with JSON. — Stefan Pochmann, Jan 09 '20 at 23:08
@StefanPochmann You can be right, but I do not see actual parsing, and I see a commented regexp. — tevemadar, Jan 09 '20 at 23:11
@tevemadar It's clearly already parsed and in the `api_readable` variable. — Stefan Pochmann, Jan 09 '20 at 23:17

Barmar · Answer 1 · 2020-01-11T00:07:17.053

0

api_readable['data']['result_sets'][0]['rows'] is a list, you can simply loop over it and print the items you want.

for row in api_readable['data']['result_sets'][0]['rows']:
    print(f"{row['data'][0][0]['text']} : {row['data'][1][0]['text']}");

edited Jan 11 '20 at 00:07

answered Jan 09 '20 at 23:07

Barmar

741,623
53
500
612

It doesn't seem to work I get this error now : – Alex Paraschin Jan 11 '20 at 00:02
print(f"{row['data'][0]['text']} : {row['data'][1]['text']}"); TypeError: list indices must be integers or slices, not str – Alex Paraschin Jan 11 '20 at 00:02
For some reason, each dictionary in `data` is nested in an extra list with just one element. I've added the extra indexing. – Barmar Jan 11 '20 at 00:07

Extract values from Json code using Python

1 Answers1