3

I have a query that appears to identify 975 items per the meta information. I used the limit (100) & skip (25) parameters to get the result. However, if I try to use that same query in Excel (see below) to pull the results it appears to ignore the limit & skip parameters and therefore only returns the 100 based on the limit or 1 if no limit is specified. Is there a way to get ALL 975 items? The URL I am using is:

https://api.fda.gov/device/event.json?search=device.generic_name:%22LAPAROSCOPIC+MORCELLATOR%22+AND+device_report_product_code:HET&limit=100&skip=25

I am following some of the steps in this video to use powerquery to create a worksheet in Excel.

Improve this question
3
  • 2
    This has been answered in opendata.stackexchange.com/questions/3259/… (see the first answer).
    – RCA
    Commented Jan 12, 2015 at 17:34
  • thank you. i understand that there is a limit as well as skip. however unless i am mistaken the limit has a maximum of 100 and skip does not appear to have any impact if pulling the result via ms/excel.
    – primetime
    Commented Jan 13, 2015 at 19:10
  • I edited your title to make it clear that your problem is related to MS Excel.
    – Patrick Hoefler
    Commented Jan 21, 2015 at 22:20

1 Answer 1

Reset to default
2

I believe the limit is now 1000 with an API key. Try getting and adding an API key and changing the limit to 1000

Improve this answer

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