How do I get paginated data sorted by load date from the OSHA api detailed here?

Question

http://developer.dol.gov/health-and-safety/dol-osha-enforcement/#osha_accident

Without pagination it's useless and I'm forced to download and parse the entire CSV file.

score 2 · Answer 1 · answered May 16 '16 at 20:19

You need to use the offset filter

https://data.dol.gov/get/accident/offset/0/limit/1 will give you the first result https://data.dol.gov/get/accident/offset/1/limit/1 will give you the second result https://data.dol.gov/get/accident/offset/2/limit/1 will give you the third result

...

score 1 · Answer 2 · answered Nov 03 '15 at 20:30

1

Pretty sure you just need to implement $top and $skip in your api call:
http://developer.dol.gov/accessing-the-apis-using-http-requests/#pagination

answered Nov 03 '15 at 20:30

albert

11,885
4
30
57

Tried. Doesn't do anything :-/ – CuriousG Nov 03 '15 at 22:08
can you share the url you used? just swap out your key for a fake one.... – albert Nov 03 '15 at 23:18
1

The fix is now in place. We've updated our API documentation as well. We're in the process of updating our dataset documentation as well as the feature is rolled out to all of our data sources. – Mike Pulsifer Aug 01 '16 at 12:49

score 1 · Answer 3 · answered May 18 '16 at 12:26

1

We have a patch sitting in our OCIO's office that will fix this issue. Once it navigates that maze, pagination should work.

answered May 18 '16 at 12:26

Mike Pulsifer

401
2
4

How do I get paginated data sorted by load date from the OSHA api detailed here?

3 Answers3

Linked