Issue in fetching sorted data from SIM API in Quicksuite Flow

Created a Quick Flow to retrieve open tickets from SIM (taskie) folder. Due to API limitations, only 100 records are returned per query. And I attempted to sort results by last_updated_date in ascending order to identify the oldest/stale tickets before applying the 100-record limit, but the API appears to return tickets in random order regardless of sort parameters specified in the prompt. Attaching the SC for your reference.

Please let me know if this can be resolved or suggest any alternative ways.

Hi @bagapriy,

In regard to the 100 record rollout behavior you are facing, I do believe this is indeed a current limitation within Quick Flows. Just in case though, please feel free to also create a support ticket with AWS Support to see if there is a viable workaround. I will still make sure to leave this post marked as a Feature Request for a little bit longer so that someone from the AWS Team may address this in the future.

For the sorting, what I would recommend for now is that, although you can only get 100 entries at a time, you might be able to add an additional Flow step so sort that list and get the same intended behavior.

Hi @bagapriy,

Just checking back in since we haven’t heard from you in a bit. Were you able to see my most recent reply and/or find a solution yourself in the meantime? If you still have any additional questions related to your initial post, please feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thanks!

Hi @bagapriy,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thanks!