Monthly Archives: March 2020

Getting Group owners using MS Graph API in Power Automate

The call is made using the MS Graph API call. https://docs.microsoft.com/en-us/graph/api/group-list-owners?view=graph-rest-1.0&tabs=http Q:How does the MS Graph API work? A: The following are the steps. Register an Azure AD app with the following API permission granted and consented. Microsoft Graph (2) … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Graph Security API

I have been working on the Microsoft Security Graph API to get the reports. I have created a PostMan collection put it on the GitHub Repo. https://github.com/pankajsurti/MicrosoftGraphSecurityAPIPostMan  I have found following articles very useful. https://aka.ms/GraphSecurityDocs https://aka.ms/GraphSecurityAPICode https://aka.ms/GraphSecuritySolutionsConnectors https://aka.ms/GraphSecurityWhitePaperSevenWays https://aka.ms/GraphSecurityQuickStarts https://aka.ms/GraphSecuritySDKContinue reading

Posted in Uncategorized | Leave a comment

Bulk Load Excel file to the SQL

I wrote this sample console program to read Excel file and bulk load to the SQL. It uses the ExcelDataReader NuGet package. The source is located on GitHub. Enjoy! https://github.com/pankajsurti/BulkLoadExcelData2SQL  

Posted in Uncategorized | Leave a comment

Office 365 Usage Reports Postman Collection

I have created Postman collection for the Office 365 Usage Reports. Enjoy! https://github.com/pankajsurti/O365UsageReportsAPIs Office 365 Usage Reports – https://docs.microsoft.com/en-us/graph/api/resources/report?view=graph-rest-1.0 Office 365 Usage Analytics Adaption Package is located below. https://docs.microsoft.com/en-us/office365/admin/usage-analytics/usage-analytics?view=o365-worldwide Microsoft 365 usage analytics data model https://docs.microsoft.com/en-us/office365/admin/usage-analytics/usage-analytics-data-model?view=o365-worldwide

Posted in Uncategorized | Leave a comment

Microsoft Virtual Assitant

https://docs.botframework.com  Virtual Assistant Overview *** Useful YouTube Learning links *** A deep-dive into conversational AI using Azure Bot Service and Cognitive Services | BRK4001 https://www.youtube.com/watch?v=j2-FWeIqYOg Building enterprise ready scalable AI solutions using Azure Cognitive Services | BRK3029 https://www.youtube.com/watch?v=630F60EfPcQ Learn to … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Bot Framework Composer

The following links can help you further on Composer. Bot Framework Composer https://www.youtube.com/watch?v=Aiv95e2-Yn0 Bot Framework Composer – Build a Weather Bot https://www.youtube.com/watch?v=ZNcfIgO8biw The Bot Framework Composer tutorials https://github.com/microsoft/BotFramework-Composer/blob/stable/docs/tutorial/tutorial-introduction.md  

Posted in Uncategorized | Leave a comment