page through the targets pharos graphql api

pharos-targets.py

import json, requests

QUERY = """{
   targets %s {
     count
     targets(top:%d, skip:%d) {
        sym
        name
        tdl
        novelty
        description
        expressionCounts {
          name
          value
        }
      }
   }
}"""

if __name__ == "__main__":
    top = 10 # number of rows per fetch
    skip = 0
    total = 0
    filter = """(filter: {
        facets: [
          { facet: "tdl", values: ["Tclin", "Tchem"] }
        ]
        order: "!tdl_info.JensenLab PubMed Score"
     })"""    
    while True:
        query = QUERY % (filter, top, skip)
        #print ('>>> %s' % query)
        res = requests.post('https://pharos-api.ncats.io/graphql',
                            json={'query': query})
        if 200 == res.status_code:
            data = res.json()
            # now do something with the data
            print (json.dumps(data, indent=2))
            cnt = len(data['data']['targets']['targets'])
            skip = skip + cnt
            if cnt < top:
                # we're done
                break
        else:
            break
    print ('%d target(s) fetched!' % skip)