superset api endpoint - /api/v1/dataset/ results limited ?

[Scope0910]

hey folks,

I have a question. I use the superset api with endpoint "/api/v1/dataset/" to get the ids for the datasets. We have 25 datasets configured but the result getting from api call only return 20 results as json. Is there a config or something else which limit the resultset from api call ? I dont use rison to query the api or something.

Any ideas ?
Greets

[fasilu]

same issue here is there any limit ?

[dkrat7]

API returns datasets by pages. There are "page" and "page_size" parameters (default page size is 20). You can set higher values (I think 100 is page_size upper limit)

Check API specs

[bronz3beard]

You can try something like this it works for us.

    const response = await axios.get(`${SUPERSET_BASE}/api/v1/dataset/`, {
      headers,
      params: {
        page: 0,
        page_size: 300
      },
      paramsSerializer: (params) => `q=${encodeUrl(JSON.stringify(params))}`
    });
    ```

[mistercrunch]

I just checked to make sure it's documented, but seems pretty comprehensive in the API docs

[mistercrunch]

Closing as answer is clear in the comments, and discoverable in docs

[christiaan]

The default of "20" is not in the docs. Instead the value of "0" implied to me that by default no limit or pagination is applied.