Pesticide Product Label System (PPLS) Application Program Interface (API)
- Pesticide product label system application program interface
- Data service API
- Constructing a search
- Working with the output
- Assistance or questions
Pesticide Product Label System Application Program Interface
Pesticide Product Label System (PPLS) provides a single point of access to U.S. EPA environmental data contained in the U.S. EPA databases. Interested parties from state and local governments, EPA, or federal agencies, or individuals can search for information about a pesticide product that may help or affect human, health and environment via Application Program Interface (API).
Data Service API
PPLS has developed a RESTful data service API to all of internal data holding. This functionality provides a user of PPLS with the ability to query any data through the use of a URL by EPA Registration Number. The default output is in JSON (JavaScript Object Notation). The database is being updated every 12 hours (noon and midnight EDT).
Constructing a Search
To retrieve pesticide product information, users create a URL with a specific set of parameter. This is done by creating a string using the following format:
To search by EPA Registration Number:
https://ordspub.epa.gov/ords/pesticides/ppls/[Company Number-Product Number]
- COMPANY_NUMBER = six (6) digit company number part of registration number.
- PRODUCT_NUMBER = five (5) digit product number part of registration number.
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ppls/66551-1
To Search by Product Name:
https://ordspub.epa.gov/ords/pesticides/pplstxt/[Product_Name]
- PRODUCT_NAME = Name of product, must be spelled correctly and it’s not case sensitive.
Example: https://ordspub.epa.gov/ords/pesticides/cswu/pplstxt/RAID%20CWR%20BAIT%20STATIONS
To Search by Distributor Product Number:
https://ordspub.epa.gov/ords/pesticides/ppldist/[Company_Number-Product_Number-Distributor_Number]
- COMPANY_NUMBER = six (6) digit company number part of registration number.
- PRODUCT_NUMBER = five (5) digit product number part of registration number.
- DISTRIBUTOR_NUMBER = five (5) digit distributor number part of registration number.
Example: https://ordspub.epa.gov/ords/pesticides/cswu/pplsdist/67702-6-11204
To search by Partial Product Name
- PARTIAL_PRODUCT_NAME = Partial product name text that can appear anywhere in the product name. Not case sensitive.
https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/partialprodsearch/v2/[searchType]/[searchVal] - searchType = "riname"
https://ordspub.epa.gov/ords/pesticides/ProductSearch/partialprodsearch/riname/[Partial_Product_Name]
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/partialprodsearch/riname/IODORITE
To search by Partial Product Number:
- PARTIAL_PRODUCT_NUMBER = Partial product registration number. It can be either Company number, Product number or distributor number.
https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/partialprodsearch/v2/[searchType]/[searchVal] - searchType = "regnum"
https://ordspub.epa.gov/ords/pesticides/ProductSearch/partialprodsearch/regnum/[Partial_Product_Number]
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/partialprodsearch/regnum/1258
To Search by Ingredient Name:
https://ordspub.epa.gov/ords/pesticides/ProductSearch/searchWithIngName/v1/[IngName]
- IngName - Ingredient Name = Full or partial name of ingredient name, not case sensitive.
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/searchWithIngName/v1/Acrolein
To Search by PC Code:
https://ordspub.epa.gov/ords/pesticides/ProductSearch/searchWithPcCode/v1/[PcCode]
- PcCode - Pesticide Chemical Code = EPA assigned pesticide chemical code (six digits)
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/searchWithPcCode/v1/101101
To Search by CAS Number:
https://ordspub.epa.gov/ords/pesticides/ProductSearch/searchWithCasNum/v1/[CasNumber]
- CASNumber - Chemical Abstract Service Number = 9999999-99-9, max length of 12, 1-7 digits before first hyphen
Example: https://ordspub.epa.gov/ords/pesticides/cswu/ProductSearch/searchWithCasNum/v1/21087-64-9
Working with the Output
The result set is JSON that can be ported into an application or used as part of a Web mash-up. This is an example of what the output looks like with a return of pesticide product information from the PPLS database:
| Element Name | Description | Data Type |
|---|---|---|
| EPAREGNO | EPA Registration Number | VARCHAR(2) |
| PRODUCTNAME | Product Name | VARCHAR(2) |
| PRODUCT_STATUS | Current Status: Pending, Active, or Cancelled | VARCHAR(2) |
| PRODUCT_STATUS_DATE | Product Status Date (Month Day, Year) | Date |
| COMPANYINFO (NODE) | ||
| NAME | Company Name | VARCHAR(2) |
| CONTACT_PERSON | Company Contact Person | VARCHAR(2) |
| DIVISION_NAME | Company Division Name | VARCHAR(2) |
| PHONE | Company Phone Number | VARCHAR(2) |
| FAX | Company Fax Number | VARCHAR(2) |
| Company Email Address | VARCHAR(2) | |
| STREET | Company Street Address | VARCHAR(2) |
| PO_BOX | Company P.O. Box | VARCHAR(2) |
| CITY | Company City Name | VARCHAR(2) |
| STATE | Company State | VARCHAR(2) |
| ZIP_CODE | Company Zip Code | VARCHAR(2) |
| COMPANYAGENTINFO (NODE) | ||
| NAME | Agent Name | VARCHAR(2) |
| CONTACT_PERSON | Agent Contact Person | VARCHAR(2) |
| PHONE | Agent Phone Number | VARCHAR(2) |
| FAX | Agent Fax Number | VARCHAR(2) |
| Agent Email Address | VARCHAR(2) | |
| STREET | Agent Street Address | VARCHAR(2) |
| PO_BOX | Agent P.O. Box | VARCHAR(2) |
| CITY | Agent City Name | VARCHAR(2) |
| STATE | Agent State | VARCHAR(2) |
| ZIP_CODE | Agent Zip Code | VARCHAR(2) |
| SIGNAL_WORD | Signal word: Danger, Warning, Caution, or No Signal Word | VARCHAR(2) |
| RUP_YN | Restricted Use (Yes/No) | VARCHAR(2) |
| FORMULATIONS (NODE) | ||
| FORMULATION | Physical Form | VARCHAR(2) |
| ACTIVE_INGREDIENTS (NODE) | ||
| PC_CODE | EPA assigned pesticide chemical code | VARCHAR(2) |
| ACTIVE_ING | Active Ingredient | VARCHAR(2) |
| CAS_NUMBER | EPA assigned CAS Number | VARCHAR(2) |
| ACTIVE_ING_PERCENT | Active Ingredient percentage appearing in the pesticide product formulation | VARCHAR(2) |
| INACTIVE_BRAND_NAMES (NODE) | ||
| INACTIVE_BRAND_NAME | List inactive brand name associated with this product | VARCHAR(2) |
| PDFFILES (NODE) | ||
| PDFFILE | List of PDF files for each product | VARCHAR(2) |
| PDFFILE_ACCEPTED_DATE | Accepted Date (Month Day, Year) | Date |
| ALTBRANDNAMES (NODE) | ||
| ALTBRANDNAME | Product Alternative brand Name | VARCHAR(2) |
| SITES (NODE) | ||
| SITE | List site associated with a pesticide product | VARCHAR(2) |
| PESTS | ||
| PEST | List pest associate with a pesticide product | VARCHAR(2) |
| TYPES(NODE) | ||
| TYPE | List of Pesticide Type | VARCHAR(2) |
| EPADISTNO | EPA Distributor Product Number | VARCHAR(2) |
| SEC3RINUM | Section 3 Registration Number of the Distributor product | VARCHAR(2) |
| DISTRIBUTOR _STATUS | Current Status: Pending, Active, or Cancelled | VARCHAR(2) |
| DISTRIBUTOR_STATUS_DATE | Status Date (Month Day, Year) | DATE |
For Assistance or Questions
If you have any questions or need further assistance, please contact Abu Muyeen (muyeen.abu@epa.gov)