Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Server API - extend to cover more than 10 000 canvasses

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 

5 Comments
SeanAdams
17 - Castor
17 - Castor

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
Alteryx Community Team
Alteryx Community Team
Status changed to: Coming Soon

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
17 - Castor
17 - Castor

Thank you - that will be helpful for larger implementations!

 

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Implemented

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
17 - Castor
17 - Castor

🙂 this is great news - thank you!

Appreciate the work that went into this.