Forum Discussion
Powershell for reading data from excel survey
Hello Community,
I need help for a powershell script to read data of excel survey form, I am planning some automation and I love to see if its possible connect to a sharepoint excel survevy form and get those information then I can use it for AD purpose.
thanks
3 Replies
- Not sure if this is possible since I'm not aware of how you can get Excel Survey Data by means of an API you could use in PowerShell
- Hi Juan,
The Excel Survey data is going to an excel file at either onedrive or sharepoint not the only thing remain is to have a powershell script running on sharepoint module to get the data out of that excel file.- Check if Graph's Drive API workbook endpoint can be of use.
https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
