Server API - extend to cover more than 10 000 canvasses

[SeanAdams]

We use the Server API to manage our server environment - and we recently noticed that the Workflows API (/admin/v1/workflows) ignores any canvasses after the 10 000'th submission.

For example:

• If we don't use any offsets or limits - then we get 10 000 applications
• If we use an offset of 5000 with a limit of 10000 - we get 5000 applications (i.e. anything after canvas 10 000 is being ignored)
• if we use an offset of 9990 with a limit of 100 - we get 10 rows returned (i.e. anything after canvas 10 000 being ignored)

By querying Mongo directly (appinfos collection) we know that we have 18 800 or so unique applications in our environment.

Please can you remove this cap from the API so that it can be used to query any number of canvasses on a larger environment?

cc: 

+  @Hemanth @marydest24 @Shreyasi @Sotoll @Kosi @revathi @Bethanyturner012  @TanyaS 

[SeanAdams]

When using the server API to list the workflows on the server (/admin/v1/users) - only the first 10 000 canvasses are returned.

• If you ask for all canvasses - only 10 000 returned
• If you ask for an offset of 9000; limit of 2000 - only 1000 are returned (taking you up to row 10 000)
• If you ask for an offset of 9950; limit of 1000 - only 50 rows are returned (taking you up to row 10 000)

It seems as if there is an internal constraint built into this API call that only considers the first 10 000 rows irrespective of how the query is structured.

Please could you eliminate this constraint so that we can query all the canvasses in our environment?    Right now the only alternative is to query MongoDB directly which is not a preferred option.

Many thanks

Sean

cc: @TanyaS 

[KylieF]

Thank you for your feedback!

We're updated the Server API, which will include this request, in an upcoming release! This idea will be updated again once this release is publicly available for download.

[SeanAdams]

Thank you - that will be helpful for larger implementations!

[KylieF]

Hi All!

Thank you for your feedback! We've updated the API to allow for more then 10,000 canvases in our newest release of Server, 2020.2, which you can download here!

[SeanAdams]

🙂 this is great news - thank you!

Appreciate the work that went into this.