Office 365 IP Address and URL Web service

Using the Office 365 IP Address and URL Web service to pull the latest information.

The website above has all the listed parameters that you can use to grab specific data, but here are the shortcuts I use for specific products:

Common parameters

These parameters are common across all the web service methods:

• format= JSON | CSV - By default, the returned data format is JSON. Use this optional parameter to return the data in comma-separated values (CSV) format.
• ClientRequestId=guid - A required GUID that you generate for client association. You should generate a GUID for each machine that calls the web service. Do not use the GUIDs shown in the following examples because they may be blocked by the web service in the future. GUID format is xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, where x represents a hexadecimal number. To generate a GUID, use the New-Guid PowerShell command.

First you need to generate a GUID, from PowerShell run the following:

New-Guid

Endpoints web method

The endpoints web method returns all records for IP address ranges and URLs that make up the Office 365 service. While the latest data from the endpoints web method should be used for network device configuration, the data can be cached for up to 30 days after it is published due to the advance notice provided for additions. We recommend you only call the endpoints web method again when the version web method indicates a new version of the data is available.

Parameters for the endpoints web method are:

• ServiceAreas= Common | Exchange | SharePoint | Skype - A comma-separated list of service areas. Valid items are Common, Exchange, SharePoint, and Skype. Because Common service area items are a prerequisite for all other service areas, the web service will always include them. If you do not include this parameter, all service areas are returned.

Skype and Teams CSV output
https://endpoints.office.com/endpoints/Worldwide?ServiceAreas=Skype&ClientRequestId=5017483f-93b2-4051-b08e-d8af77ab2f2d&Format=CSV

Exchange CSV output
https://endpoints.office.com/endpoints/Worldwide?ServiceAreas=Exchange&ClientRequestId=5017483f-93b2-4051-b08e-d8af77ab2f2d&Format=CSV

Import into Excel You can also use the above URL to import data straight into Excel
1. Open new Excel Workbook, select "Data"

2. Select "From Web"

3. Past in value for required O365 Workflow, click "OK"

4. Make any required changes to the data to be imported, click "Load"

5. Data import complete for selected O365 Workflow.

"Open File" Dialog

Migrating uses between Skype for Business and Skype Online lately and have been migrating in batches/pilot groups.

Having gotten sick of upding the filename or file location in the powershell script, i went searching and found a nice article on how to create a open file dialog box.

https://ilovepowershell.com/2017/03/08/how-to-open-a-directory-chooser-window-with-powershell/

I'm sure there is a better/easier to complete, but this worked for me.
++++++++++++++++++++++++++++++++++++++++++++
$connect = Read-host "Connect to O365 Skype Online: [Y|N]?"
if($connect -like "Y")
{
Import-Module SkypeOnlineConnector
$userCredential = Get-Credential
$sfbSession = New-CsOnlineSession -Credential $userCredential
Import-PSSession $sfbSession
}
if($userCredential.UserName -eq $nul)
{
write-host "No Crediential Set for move" -ForegroundColor Red
} 
else
{
write-host "connected user"
}

$openChooser = New-Object -TypeName System.Windows.Forms.OpenFileDialog
$openChooser.ShowDialog()
$fileimport = import-csv $openChooser.FileName
foreach($i in $fileimport)
{
write-host -ForegroundColor Cyan $i.displayname -NoNewline
write-host " is currently being migrated"
}

++++++++++++++++++++++++++++++++++++++++++++