"Invalid value for sum of offset + limit API parameter" error with exports endpoint

Question

I do not see any limitations on the offset and limit parameters for the exports endpoint. However, when I make the following request:

https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=1

I get back a CSV file with only 2 rows and the 2nd row says: “Streaming interrupted due to the following error: Invalid value for sum of offset + limit API parameter: 83714 was found but <= 10000 is expected. (error_code: InvalidRESTParameterError)”

I thought the 10000 limit for offset+limit only applied to the records input. Is that wrong?

If it’s useful, I am able to retrieve the entire dataset at once:

https://data.longbeach.gov/api/explore/v2.1/catalog/datasets/lbpd-ripa-data-annual/exports/csv?offset=0

Page 1 / 1

Hi,

It seems to me that the offset parameter does not exist for the endpoint export a dataset

https://help.opendatasoft.com/apis/ods-explore-v2/#tag/Dataset/operation/exportRecords

The documentation you are referring to is for endpoint export a catalog.

Kind regards,

Reply

yier.wu · Accepted Answer

Hi,It seems to me that the offset parameter does not exist for the endpoint export a datasethttps://help.opendatasoft.com/apis/ods-explore-v2/#tag/Dataset/operation/exportRecordsThe documentation you are referring to is for endpointexporta catalog.Kind regards,

Reply

Sign up

Already have an Opendatasoft account ?

Login to the community

Already have an Opendatasoft account ?

Scanning file for viruses.

This file cannot be downloaded