fetch-nr-apps.py

appList.csv

fetchApps.py

import requests, json, csv

graphQLEndpoint = 'https://api.newrelic.com/graphql'
#graphQLEndpoint = 'https://api.eu.newrelic.com/graphql'

#hidestream is hiding APIKey = '<API Key>'
APIKey = '<API Key>'

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

query = """
{
  actor {
    entitySearch(queryBuilder: {domain: APM}) {
      results {
        entities {
          ... on ApmApplicationEntityOutline {
            name
            applicationId
          }
        }
      }
    }
  }
}
"""
request = requests.post(
    graphQLEndpoint,
    json={'query': query}, 
    headers=headers
)

def parseIDs(request):
    jsonpayload = json.loads(request.text)
    entries = len(jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"])
    print(entries)
    for x in range(entries):
        print(jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"][x]["name"], 
        jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"][x]["applicationId"])

parseIDs(request)

def IDstoCSV(request):
    with open('appList.csv', 'w', newline='') as csvfile:
      fieldnames = ['ID', 'Name']
      writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
      jsonpayload = json.loads(request.text)
      entries = len(jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"])

      writer.writeheader()
      for x in range(entries):
        writer.writerow({'ID': jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"][x]["applicationId"], 'Name': jsonpayload["data"]["actor"]["entitySearch"]["results"]["entities"][x]["name"]})

IDstoCSV(request)

term.out

7
Application name is required. 876990294
Blog Prod 516776661
MyDotNetApp 968623920
Node Workshop 887470292
staging-blog 305164720
tic tac toe 781875136
windowshit 968641669