Forum Discussion

Copper Contributor

Jun 15, 2020

API to access MS forms

Looking for an API to access MS forms and pull the survey results on a weekly basis.

microsoft forms

Copper Contributor

Nov 07, 2020

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

Copper Contributor

Nov 30, 2020

Leandro_Abade could you please highlight on how did you obtain the token? Did you have to register in app in Azure portal or by some other way. I am implementing something similar and stuck with the first pre-requisite of obtaining token.

Leandro_Abade
Copper Contributor
Nov 30, 2020
Hi ssahal ! You just need access the URL “https://forms.office.com/Pages/DesignPage.aspx”, then in same section you calls "https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=" + [put your form ID Here] + "&timezoneOffset=180&minResponseId=1&maxResponseId=1000"

The token is automatically generated in the site section.

So, unfortunately, you need to use a browser to use the API. I tried everything to get files using code and nothing worked.

If you find out how to generate the token by code, please share it with us! Tks
- ssahal
  Copper Contributor
  Nov 30, 2020
  Sure thing. I am trying to generate the code so I could further process the forms data in an internal workflow. Once I have the full picture will share it with community 🙂
  - JimmyStewart
    Brass Contributor
    Dec 07, 2020
    Looking forward to seeing what you come up with. Power Automate is often just to picking up that a form was submitted. So I'm looking at alternatives. Thanks.

Resources