Results 1 to 2 of 2

Thread: Odata queries dynamic URL in one database

  1. #1
    Neophyte Markusm's Avatar
    Join Date
    Oct 2020
    Posts
    1
    Articles
    0
    Excel Version
    2013

    Odata queries dynamic URL in one database



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I want to fetch Sharepoint User lists and security groups by using the Rest API.
    The URL to the odata feed is:

    http://siteURL.com/_api/Web/SiteGroups/GetById(1)

    The ID (red) is dynamic. There are different IDs for each security group. I got all IDs in another odata query.

    For now I managed to set a dynamic URL connection like stated here: https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072

    So I am able to Change the standard-value at the parameter and the Odata query (Abfrage3) changes automatically.
    ( eg. http://siteurl.com/_api/Web/SiteGroups/GetById(8) )



    My goal is to fetch all this Odata queries into one database.
    There are more than 250 IDs.... Is that possible?

    Thank you in advance!
    PS: My Power Query skills are at a beginner-level... but I am learning every day

    Thanks
    Markus

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    It would seem to me that you could put all 250 URLs into a table, open that in PQ, then have a function (similar to what you have for the dynamic URL) that you assign into a separate column, then unpack the results. Can't be more explicit as I don't know your code nor the URLs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •