Skip to main content
Solved

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

  • May 19, 2025
  • 1 reply
  • 33 views

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

Best answer by yier.wu

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,

 

 

 

1 reply

yier.wu
Community Manager
  • Community Manager
  • 30 replies
  • Answer
  • May 21, 2025

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,