Forum Discussion

PaulAndrew's avatar
PaulAndrew
Icon for Microsoft rankMicrosoft
Aug 30, 2018

Use Microsoft Flow to receive an email for changes to Office 365 IP Addresses and URLs

[Edit 4/16/2019: I've rewritten this article, please take a look here: https://github.com/pandrew1/Office365-IPURL-Samples/tree/master/FlowNotifications]   If you manage an enterprise network tha...
AlanPs1's avatar
AlanPs1
Copper Contributor

Great work Paul.

 

I've been looking for a decent solution for this for some time. #Kudos

 

I am now going to see if I can get the JSON output filtered in some way, looking for just the "add" FQDN, so just ignoring IPv4, IPv6 and any "remove" entries from the latest (HTTP 3) Uri.

 

An output like the following by email, in an HTML table would suit my org.

 

FQDNPorts
aadcdn.msauth.netTCP 80,443
aadcdn.msftauth.netTCP 80,443
ccscdn.msauth.netTCP 80,443
ccscdn.msftauth.netTCP 80,443
roaming.officeapps.live.comTCP 80,443
 

If anyone has any advice on converting the JSON from "HTTP 3" to an HTML table (like the above) in an email I'd be grateful. 

PaulAndrew's avatar
PaulAndrew
Icon for Microsoft rankMicrosoft
Nov 07, 2018

AlanPs1 Thanks for the feedback. We use PowerShell to create the tables at http://aka.ms/o365ip from the JSON web services output. You can run PowerShell in Flow using an Azure Function. It's a little tricky to get working and there's likely other ways to create those tables too.

-- Paul

  • AlanPs1's avatar
    AlanPs1
    Copper Contributor
    Nov 07, 2018

    Thanks for the info Paul.

     

    I'll take a look at running PowerShell as an Azure Function. I've pressed on a little with the JSON to filter out "NoIPV6" from the GET to https://endpoints.office.com/changes/worldwide. So let's see what I can get working.

     

    I'll let you know how I get on and be keen to see any new evolution from you or another. 

  • AlanPs1's avatar
    AlanPs1
    Copper Contributor
    Dec 08, 2018

    Hi Paul. Once again thank you for your excellent post.

    Here is a series I have made with 8 parts that creates an Office 365 Admin Alerts Mailbox. It calls various APIs and RSS feeds, captures the required data and sends it by email.

     

    Create Office 365 Alerts Shared Mailbox from APIs

     

    I have credited you in section 2 (Call O365 Endpoints Web Service and Return the Latest FQDNs) as your content was very helpful to me and got me off and running.

     

    Best Wishes,

    Alan

Resources