'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Get Power Automate API for Stream Video View Counts
Question details
The user wants to retrieve video analytics (view counts) from Stream on SharePoint and automatically send the data to Excel Online using a Power Automate flow.
- Product
- Power Automate / Excel Online
- Device & OS
- not provided
- Scenario
- Automating data extraction from SharePoint Stream to track video performance and analyze it in a spreadsheet.
- Observed behavior
- Needs the correct Microsoft API endpoint or URI configuration to successfully retrieve video view counts within a flow.
Ensure you have an active Microsoft 365 subscription with access to Power Automate, SharePoint, and Stream, along with the appropriate permissions to view analytics data on the target site.
Consult the Microsoft Power Automate Community
Since API endpoints for Stream on SharePoint frequently update and require specific Graph API queries, the official community is the best place to get current URI configurations.
Stream on SharePoint stores videos as standard files within SharePoint Document Libraries rather than an isolated service. This means analytics are often tied to SharePoint's Graph API rather than a legacy Stream API.
Because custom API queries in Power Automate can be complex and highly specific to your tenant setup, engaging with experts in the official forums is the most reliable way to get a working configuration.
Open your web browser and navigate to the official Microsoft Power Automate Community forum.
Sign in using your active Microsoft 365 account credentials.
Use the search bar to look for 'Stream on SharePoint video analytics API' or 'SharePoint video view counts API'. Many users have previously shared working HTTP request configurations.
If no recent solution matches your exact needs, create a new post detailing your current flow, the specific analytics you need, and your target destination (Excel Online).
Manage Your Exported Data with WPS Office
While you use Power Automate to handle complex Microsoft ecosystem workflows, consider WPS Office as a free, lightweight, and highly compatible alternative for analyzing and formatting your exported spreadsheet data offline.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and Launch: Follow the on-screen instructions to install the suite, then open WPS Spreadsheet.
- 3. Open Your Analytics Data: Click 'Open' and select the .xlsx or .csv file generated by your automated flow to begin analyzing your video view counts.
Frequently Asked Questions
Can I natively extract Stream on SharePoint analytics without Power Automate?
Yes, site owners can manually view analytics within SharePoint. Simply navigate to the video file in your document library, open it, and select the 'Analytics' tab in the top right corner to see view trends and unique visitors over time.
Does WPS Office integrate directly with Microsoft Power Automate?
WPS Office does not have native connector modules within Microsoft Power Automate. However, you can export your automated flow data to standard formats like .xlsx or .csv, which WPS Office fully supports and opens seamlessly for further analysis.
Why is it difficult to find a direct API endpoint for Stream on SharePoint?
Microsoft transitioned Stream from a standalone video service (Stream Classic) to a SharePoint-integrated model. As a result, video files are now treated exactly like standard documents in SharePoint, meaning developers must use the broader Microsoft Graph API to extract item-level analytics rather than a dedicated Stream API.
