Forum Discussion

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...

Community Champion

5 years ago

Hello Anonymous

you can create a list (or a table) with all your IDs. Then you can transform the list, or add a new column to a table, where you use your ID as parameter for your GetById like List.Transform(YourList, each 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
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
  Community 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
    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