I am trying to look at the Novartis medicines on openFDA open data on drug labeling for a given period.

I tried this:

https://api.fda.gov/drug/label.json?search=spl_patient_package_insert:"Novartis"& spl_product_data_elements&effective_time:[20110601+TO+20181231]&limit=1

But I end up getting an error:

    "error": {
    "code": "BAD_REQUEST",
    "message": "Invalid parameter:  spl_product_data_elements"

What am doing wrong? What is the correct field to get Novartis?


Here is the corrected query:


You need to use +AND+ instead of & and _exists_ to ensure a particular field is present in the document. More information about the syntax of openFDA queries can be found on our website.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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