Using the API to search for drugs by target

Data Access GraphQL API
1

I’m searching for a way to find all drugs/compounds for a given target. When I click on the endpoint link on the API page, I just get an error message. Is there swagger documentation for the end point?

1 Like
2

Hello @Mark_Fortner!

Thank you for your enquiry and welcome to the Open Targets Community.

The information you are looking for is described in the Known Drugs table of the platform. For example, for the target ENSG00000142192 (APP), in this table you can see all the drugs that have APP as a target and their indications.

The way to access this table in the GraphQL API is by accessing the knownDrugs endpoint from target.

Using the same example - all drugs targeting APP (ENSG00000142192) and their indications- the API query would be:

query targetDrugAssociations {
  target(ensemblId: "ENSG00000142192") {
    knownDrugs {
      uniqueDrugs
      rows {
        label
        prefName
        drugId
      }
    }
  }
}

Run this query in the GraphQL Playground.

A very handy way to consult the different API endpoints is through the Docs tab of GraphQL Playground. From there you can browse through all the fields exposed in the API and consult the description of each field.

I hope I could answer your question!
Please feel free to comment below if you have any further ones.

Best,
Irene

1 Like
3

Is there any way to query by UniProt accession, or Entrez Gene ID?

1 Like
4

Hi Irene, the query above is generating an error message when I run in playground:

Screen Shot 2021-09-16 at 4.02.22 PM
Screen Shot 2021-09-16 at 4.02.22 PM996×168 10 KB

“error”: “Unexpected token < in JSON at position 1”

Can you see what’s wrong?

-Will

1 Like
5

Hi @Mark_Fortner!

No, unfortunately you cannot query the target endpoint by UniProt accession or Entrez gene ID. We only support Ensembl gene IDs.

Cheers,

Andrew :slight_smile:

1 Like
6

Hi @William_Chen! :wave:

Welcome to the Open Targets Community! :tada:

Can you please try and rerun the following query?

query findKnownDrugsForAGivenTarget {
  target(ensemblId: "ENSG00000142192") {
    knownDrugs {
      uniqueDrugs
      rows {
        drug{
          id
          isApproved
          yearOfFirstApproval
          hasBeenWithdrawn
          blackBoxWarning
          name
        }
        disease{
          name
          id
        }
        phase
        status
        ctIds
      }
    }
  }
}

Run this query in our GraphQL API playground

If you continue to encounter an error, please upload a screenshot and we can investigate further.

Thank you!

Cheers,

Andrew :slight_smile:

7

Indeed this works - thanks a lot!