run new relic nerdgraph query

nrdgrph.py

import requests, json, csv

graphQLEndpoint = 'https://api.newrelic.com/graphql'
#graphQLEndpoint = 'https://api.eu.newrelic.com/graphql'
APIKey = '<NRAK Key>'

headers = { 
    "Content-Type": 'application/json',
    "API-Key": APIKey
}

query = """
{
  actor {
    account(id: 1147177) {
      nrql(query: "FROM PageView SELECT apdex(duration) facet appName since 7 days ago") {
        results
      }
    }
  }
}

"""
request = requests.post(
    graphQLEndpoint,
    json={'query': query}, 
    headers=headers
)

def runQuery(request):
    jsonpayload = json.loads(request.text)
    entries = len(jsonpayload["data"]["actor"]["account"]["nrql"]["results"])
    for x in range(entries):
        print(jsonpayload["data"]["actor"]["account"]["nrql"]["results"][x]["facet"], 
            jsonpayload["data"]["actor"]["account"]["nrql"]["results"][x]["score"])

runQuery(request)

def makeCSV(request):
    with open('apdex.csv', 'w', newline='') as csvfile:
      fieldnames = ['Name', 'Score']
      writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
      jsonpayload = json.loads(request.text)
      entries = len(jsonpayload["data"]["actor"]["account"]["nrql"]["results"])

      writer.writeheader()
      for x in range(entries):
        writer.writerow({'Name': jsonpayload["data"]["actor"]["account"]["nrql"]["results"][x]["facet"], 'Score': jsonpayload["data"]["actor"]["account"]["nrql"]["results"][x]["score"]})

makeCSV(request)