cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
russrimm
Microsoft
Microsoft

Return array from graph

Hi all,

I'm running a graph query to find all Azure AD secrets that are close to expiration (https://graph.microsoft.com/v1.0/applications?$select=appId,displayName,passwordCredentials)

 

I'm doing a parse json on the graph response, and as there may be multiple passwordcredentials values (since there are multiple client secret keys for a given Azure AD app).  In my apply to each I'm appending each value returned to an array variable.  When I send the e-mail, it appears like the below.  

 

["d1aa5e6a-142f-4904-ab22-abcdefg,Graph,2020-07-07T22:20:56.41Z","d1aa5e6a-142f-4904-ab22-hijklmnop,Graph,2020-07-02T21:17:15.057Z","80d5cc08-fe09-4238-ad65-qrstuvwxyz,NDES Proxy,2020-07-13T22:07:04.0639443Z","a5e16c84-3836-43f3-ba31-hijklmnop,SplunkVS,2020-07-09T19:28:29.4889316Z"]

 

I'm trying to ultimately format as html for the e-mail but struggling a bit.

 

Here's my parse json:

{
    "type""object",
    "properties": {
        "value": {
            "type""array",
            "items": {
                "type""object",
                "properties": {
                    "appId": {},
                    "displayName": {},
                    "passwordCredentials": {
                        "type""array",
                        "items": {
                            "type""object",
                            "properties": {
                                "displayName": {},
                                "endDateTime": {}
                            },
                            "required": []
                        }
                    }
                },
                "required": []
            }
        }
    }
}
 
Thanks in advance!
0 REPLIES 0

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (57,538)