Skip to main content
  • EN
Solved

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

  • May 19, 2025
  • 1 reply
  • 16 views
  • Translate
O

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,

 

 

 

View original

    Y
    Community Manager
    • yier.wu
    • Community Manager
    • 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,

     

     

     

    Translate

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    Opendatasoft Terms & Conditions Cookie settings