I have a query that is exporting the results to a json file: query = (''' query { continuousDeliveryJustifications { edg

[answerhappygod]

I have a query that is exporting the results to a jsonfile:
query = ('''
query {
continuousDeliveryJustifications {
edges {
node {
number
app {
name
}
platform
deploymentEnvironment
projectId {
number
}
subexperience {
name
owner {
name
}
}
cdModelTitle
description
openedBy {
name
}
requestor {
name
}
approval
state
automation
}
}
}
}
''')
The results are exported to a file called results.json.
I am trying to write a script that converts the json file into adataframe.
The json results look like this:
{
"data": {
"continuousDeliveryJustifications":{
"edges": [
{
"node": {
"number": "CD12345",
"app": {
"name": "store"
},
"platform": "Cloud",
"deploymentEnvironment": "Pivot",
"projectId": {
"number": "IT-00000"
},
"subexperience": {
"name": "Tool",
"owner": {
"name": "abcdef"
}
},
"cdModelTitle": "Continuous Tool ",
"description": "abcdefh",
"openedBy": {
"name": "me"
},
"requestor": {
"name": "abby"
},
"approval": "Approved",
"state": "Open",
"automation": "Founder"
}
},
{
"node": {
"number": "CD55555",
"app": {
"name": "Asset"
},
"platform": "Platform",
"deploymentEnvironment": "Google",
"projectId": {
"number": "IT-12444"
},
"subexperience": {
"name": "Automation",
"owner": {
"name": "Amy"
}
},
"cdModelTitle": "Production",
"description": "GitHub",
"openedBy": {
"name": "Todd"
},
"requestor": {
"name": "Rachel"
},
"approval": "Approved",
"state": "Open",
"automation": "Manual"
}
},
{
"node": {
"number": "CD999878",
"app": null,
"platform": "Cloud",
"deploymentEnvironment": "Store",
"projectId": null,
"subexperience": {
"name": "Camera",
"owner": {
"name":"Tyler"
}
},
"cdModelTitle": "Test",
"description": "Test 1",
"openedBy": {
"name": "Kyle"
},
"requestor": {
"name": "Eric"
},
"approval": "Approved",
"state": "Closed Complete",
"automation": "Watching"
}
},
{