Example Drugs@FDA queries

To help get you started, we have provided some query examples below. Use the Run query button to call the Application Programming Interface and get back results. You can experiment by editing the example queries in the black text box.

Example query

One application

This query searches for all applications, and asks for a single one.

  1. Search for all applications.

  2. Limit to 1 application.

Example query

One lotion product

This query searches all applications with lotion products, and returns a single application.

Double quotation marks " " surround phrases that must match exactly.

  1. Search for all applications which have a product with dosage_form exactly equal to 'LOTION'.

  2. Limit to 1 record.

Example query

Count of sponsors

This query searches the endpoint for all applications, and tells the Application Programming Interface to count how many included each sponsor_name.

  1. Count the field sponsor_name.