Forum Discussion
API to access MS forms
Looking for an API to access MS forms and pull the survey results on a weekly basis.
ravipokala I'm using VBA + SeleniumBasic-2.0.9.0
You must first open the URL “https://forms.office.com/Pages/DesignPage.aspx” to obtain a token
Then you can call "https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=" + put your form ID Here + "&timezoneOffset=180&minResponseId=1&maxResponseId=1000"
This is working for me
when using https://forms.office.com/formapi/DownloadExcelFile.ashx?formid= + formID i get the following error from PowerBI
we were unable to connect because this credential type isn't supported for this resource. please choose another credential type.
what is interesting is that coping the URL to edge it downloads the form.
we were unable to connect because this credential type isn't supported for this resource. please choose another credential type.
what is interesting is that coping the URL to edge it downloads the form.
I am trying to bump this thread. What is the easiest way for getting the excel file from a specific Microsoft Forms in an automated way?
Are the Org_Settings.Forms the only permissions that are required for reading the responses to a specific form?
