Handling Pagination Limitations in Microsoft Teams Resource

💬 Queries and Resources
1

Hey All!

I'm facing an issue and I'm not sure if it's something others have encountered or if it should be a feature request.

I’m trying to pull all messages from a Microsoft Teams chat and use Retool AI to summarize them. The main issue is that the get messages query has a limitation of 50 items. It's paginated, but I can’t recursively retrieve all results because the token/auth component is handled by the Teams resource, and I can’t adjust the URI on the query as they are only selectable from a predetermined list.

The goal is to end up with an array of all the items returned from the paginated API, which I can then manipulate in Retool.

Is there a way to achieve this that I might be missing?

Possible feature requests:

  1. Ability to enter a custom URI in the Teams resource.
  2. A 'Get Token' operation from the Teams connector, which I could use to perform custom queries directly to Graph, while still letting Retool handle the user auth side of things.

Thanks :slight_smile:

2

It sounds like maybe you need to setup a resource for MsGraph and try using those apis?

And I found a way to use the pagination and get all entities from an endpoint.

1 Like