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?

1 Answer 1


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 agree to our terms of service and acknowledge you have read our privacy policy.

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