Unanswered

Graph API or Kusto

Like (0) Share

Report

Posted on 5 Nov 2021 21:32:51 by Vishal1 Microsoft Employee

HI All,

Does anyone has created or called MS GRAPH API via PowerApps, I would like to retrieve user alias, email address, display name, Manager, Skip level, etc.

All responses (12)

Answers (0)

Vishal1 Microsoft Employee on 18 Nov 2021 at 21:55:26

Like (0)

Report

Re: Graph API or Kusto

if thats the case, how to get Manager hierarchy, chain?
StalinPonnusamy Super User 2024 Season 1 on 18 Nov 2021 at 21:53:28

Like (0)

Report

Re: Graph API or Kusto

Hi @Vishal1

Beta was released in Aug this year. As of now, there is no announcement for this release. I'm confident that will be only released next year.

Thanks,
Stalin - Learn To Illuminate
Vishal1 Microsoft Employee on 18 Nov 2021 at 21:46:49

Like (0)

Report

Re: Graph API or Kusto

Any idea when Graph Beta is coming? existing graph explorer doesnt give me manager chain or hierachy.
StalinPonnusamy Super User 2024 Season 1 on 09 Nov 2021 at 03:42:06

Like (0)

Report

Re: Graph API or Kusto

Hi @Vishal1

https://docs.microsoft.com/en-us/graph/api/user-list-manager?view=graph-rest-1.0&tabs=http#code-try-8

The Beta version is not for production. MS exploring and can break anything and not guaranteed. For now, we can explore as POC and expect this in the future release.
Vishal1 Microsoft Employee on 09 Nov 2021 at 03:14:41

Like (0)

Report

Re: Graph API or Kusto

the screenshot you have attached, looks like I don't have access to get manager hierarchy may be due to vendor? and not sure on the beta version.
StalinPonnusamy Super User 2024 Season 1 on 09 Nov 2021 at 01:13:10

Like (1)

Report
Re: Graph API or Kusto

Hi @Vishal1

Graph API V1.0 does not have status. Here is the to get manager hiereachy

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=max;$select=id,displayName)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled&$count=true

Bete version has more properties compared to V 1.0
https://graph.microsoft.com/beta/me

Thanks,
Stalin - Learn To Illuminate
Vishal1 Microsoft Employee on 08 Nov 2021 at 21:58:13

Like (0)

Report

Re: Graph API or Kusto

Thank you again, I see you have added account enabled? i wonder if we have column like employee status or employee active or not? and also, how to get manager next level (boss).
StalinPonnusamy Super User 2024 Season 1 on 08 Nov 2021 at 21:52:19

Like (0)

Report
Re: Graph API or Kusto

Hi @Vishal1

We can get employees account status

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=1;$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled&$count=true

Thanks,
Stalin - Learn To Illuminate
Vishal1 Microsoft Employee on 08 Nov 2021 at 21:33:15

Like (1)

Report

Re: Graph API or Kusto

Stalin, thank you, can you try to get me employee status as well and skip level is nothing but my manager boss info.
StalinPonnusamy Super User 2024 Season 1 on 08 Nov 2021 at 01:03:13

Like (1)

Report
Re: Graph API or Kusto

Hi @Vishal1

We can combine the attributes like below

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=1;$select=displayName,employeeid,userPrincipalName,mail,mailNickname)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname&$count=true

Not sure about skip level.

Thanks,
Stalin - Learn To Illuminate