0

I am trying to look up data on the ingredient milbemycin oxime, and I want results that contain only milbemycin oxime as the active ingredient.

https://api.fda.gov/animalandveterinary/event.json?search=drug.active_ingredients.name.exact:"milbemycin+oxime"&limit=1000

returns 0 results. This cannot be the case as there are several pet medicines with milbemycin oxime as the sole active ingredient for which I know adverse reaction events have been reported.

I also tried "spinosad" (Comfortis single active ingredient) and again 0 results.

However, there are many results when a query allows for multiple active ingredients.

Thanks in advance!

Improve this question
3
  • api.fda.gov/animalandveterinary/… (capitalization counts). You can also remove the .exact to get results
    – Barry Carter
    Jun 13, 2022 at 14:09
  • right, but the point is to get results with only the single ingredient. And if you remove the .exact, then all AEs with any drugs containing that ingredient are returned, which is way too many to manually sort through. Also, they are generic ingredients, so no capitalization necessary
    – thecatguy
    Jun 13, 2022 at 19:11
  • The link I gave works to get the data you want. Apparently, 'exact' requires capitalization
    – Barry Carter
    Jun 14, 2022 at 16:08

1 Answer 1

Reset to default
1

I'm Violet Wren, Senior Engineer on the openFDA team. In this case, @barrycarter is correct that .exact is case sensitive. The feature you're looking for - returning results with only one active ingredient (the one you're searching for) is not currently possible within our API. However, I'll add this feature request to the queue and review the possibility of enhancing the API with this behavior.

Thanks, Vi (they/she)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.