Forum Discussion
Creating and triggering a Get Data url dynamically for an API request
MattTrollope You could put the list of user ids in a table and then iterate over that list with a function that passes in the user id and builds the URL dynamically.
Hi MattTrollope , Thank you for reaching out to the Microsoft Fabric Community Forum.
GeraldGEmerick is right, Instead of manually creating a new API request each time someone joins, you can keep a list or table of user IDs and have your connector loop through that list. The function would build the API URL dynamically for each user, fetch their time entry data and combine all the results into one dataset. That way, whenever a new user is added to the list, the process automatically includes them without any extra setup.
Function.Invoke - PowerQuery M | Microsoft Learn
Using custom functions in Power Query - Power Query | Microsoft Learn
Understanding Power Query M functions - PowerQuery M | Microsoft Learn
Using the wait-retry pattern in Power Query connectors - Power Query | Microsoft Learn
Power Query M function reference - PowerQuery M | Microsoft Learn
Connector Extensibility in Power BI - Power BI | Microsoft Learn
Thank you GeraldGEmerick for your valuable response and continued contribution in the community.
Thank you for your assistance.
As mentioned in my reply to @GeraldGEmerick I'm hoping the automatic invokation of the Get Data process for new API requests might be covererd in your subsequent reply. Also thank you for the links.
