Forum Discussion

Emal amiri's avatar
Emal amiri
Copper Contributor
Aug 14, 2017

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...
powershell
SharePoint Online
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Aug 15, 2017
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
  • Emal amiri's avatar
    Emal amiri
    Copper Contributor
    Aug 15, 2017
    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.
    • Rati Ranjan's avatar
      Rati Ranjan
      Copper Contributor
      Jan 30, 2020
      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

Resources