Forum Discussion

NargisseB's avatar
NargisseB
Regular Visitor
2 years ago

Expand Columns / Retrieve columns from Azure using Microsoft Graph API

Hello, I used Microsoft Graph API to extract users information from Azure and I'm trying to get the column AccountEnabled ( I can see the column when I export the users informations into a csv )
I used this code to get the users, but when I try to expand the columns I can't see in the expand list the column I want, I also can't see other information like the usertype ( It's directly shown in Azure ) and many others. When I try to write it manually the columns are empty. I also tried to use $select but it didnt work. 

 

let
    token = GetMSGraphToken(),

    InitialUrl = "https://graph.microsoft.com/v1.0/users",

    Source = Json.Document(Web.Contents(InitialUrl, [Headers=[Authorization="Bearer " & token]])),
    
    #"Transform to table" = Table.FromList(Source[value], Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    
    #"Expand Columns" = Table.ExpandRecordColumn(#"Transform to table" , "Column1", {"id", "displayName", "accountEnabled"}, 
    {"id", "displayName", "accountEnabled"})
in
    #"Expand Colums"

 

The only columns I can see / expand directly are :  

 

Thanks in advance for the help.

 

1 Reply

  • Have you tried using OData.Feed instead of Web.Contents?