Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

fetch multiple odata queries into one database

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 dynam...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jimmy801 

and thank you for your answer. I'm afraid I would need a step by step help on this. All I have done for now is creating a List with my IDs.

 

Im very thankful for your help anyways.

Best,

Markus

 

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
5 years ago

Hello Anonymous 

 

you have to write a new function in the advanced editor like this

ExtractDataWithId = List.Transform(YourListBasicallyThePreviousStepName, each HeregetstheApicallThatUsesTheParameterOfTheList(_))

 

as I don't know how you are quering this api, I can't tell you exactly how to write the second parameter of List.Transform. It could also be something like this

 

Web.Contents("http://siteURL.com/_api/Web/SiteGroups/GetById(" & _ & ")")

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jimmy801 

    Thanks. I think this should be correct. Altough, I do not get what the _ stands for. This should be the ID from my list? (blue mark in picture)

     

     

    Or maybe I got that wrong..

    Thanks for patience!

     

    Markus

    • Jimmy801's avatar
      Jimmy801
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hello Anonymous 

       

      exactly... as the function transforms the items of the list, the "_" represents the list items processes. But it finally worked out?

      If so I would appreciate if you could mark my post as solution

       

      Thx

       

      Jimmy

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Jimmy801 

         

        Unfortuanelly not yet.
        Do I have to make a new query with my function as a parameter?
        Or do I have to transfer the List into a table, and make a new column and invoke my function there?

         

        What I've done so far: Right click on the List "ID" and make a function with code:

        ExtractDataWithId = List.Transform(Id, each Web.Contents("http://SiteURL.com/_api/Web/SiteGroups/GetById(" & _ & ")")

         

        But it seems not to be a function, as the symbol turns into "ABC" (A new query, not a function?) (see screenshot above)

         

        Thanks for your help again!

         

        Markus