Forum Discussion
MicrosoftIs there an API to read Microsoft forms data
MicrosoftOh_No_Its_Microsoft Hi Dan, let me to introduce the things be clearer. Web requests "https://forms.office.com/formapi/api/forms/..." were designed for Forms Web application, they're not published as APIs for other applications. You can use https://forms.office.com/formapi/api/{tenantid}/users/{userid}/light/forms; https://forms.office.com/formapi/api/{tenantid}/users/{userid}/light/forms(formid)/responses; web requests to retrieve data as Forms web application is doing. But these web requests are not promised not be changed. For APIs published for all developers, they need object model stabling, backward versions compatible, throttled and continues, easily authentication for different applications, administrator/data owner consenting etc. The upcoming Microsoft Graph APIs for Forms are aiming for it. These APIs will make sure integration applications/solutions be stable and effective. These APIs will be published via Microsoft Graph endpoint, and the 1st wave of APIs will be published in 3 months.
GideonHuang Is there an update for this APIs for Microsoft Forms you mentioned here? You said three months, but I haven t seen anything new as for today.
Thank you
Yes I also looked into google forms and I was able to easily get everything I needed from it. Just set up a webhook to post the info to power automate...
AndreaMXT - I'm no fan of Google, but simply use Google Forms instead of Microsoft Forms. Google Forms have great APIs that connect to the data seamlessly through R and Python. They work well. I was up and running in 15 minutes compared to hours of head scratching with Microsoft Forms. Crucial for your workflow is the ability to pass variables - this is possible using Google Forms unlike Microsoft Forms. You can of course "upgrade" to Microsoft Dynamics Customer Voice but this is stupidly expensive for what you can get for free elsewhere. After my investigations, for robust solutions, Google Forms are simply easier to setup, straightforward to make secure, a doddle to extract data from, flexible and powerful. I can secure personal data with hashes unlike Microsoft Forms. I'm sorry to say I've ditched Microsoft Forms as a solution because they are just management toys in comparison.
Microsoft! Listen to your customers - Microsoft Forms needs to catch-up - it's about 10 years behind the competition.
1. Allow passing of variables into Forms - it's essential for scalability, low admin, robust workflows and security.
2. Develop an API that works like the competition! (eg employ someone to write a decent API so we can extract the data automatically for once! - and I'm not talking about the incredibly slow and low featured "Power"Automate! I'm talking about Python or R interfaces for Data Scientists.
Thank you
