Forum Discussion
Doranarni
Microsoft
MicrosoftIs there an API to read Microsoft forms data
is it possible to read Microsoft forms submitted data . we are exploring concepts and would like to get data of submitted forms using API.
Until the long awaited API is released, a short term workaround could be to use Power Automate (formerly Microsoft Flow) to trigger when a new form is submitted, and to save the results into a SharePoint list, or Excel file, etc and to manipulate the data from there.
Power Automate puts some pretty cool options for not only extracting the Forms data but to also initiate other actions that can benefit you (e.g. put the results into a Word doc template and email to someone, etc).
Well worth a look!
Cheers
Damien
There now appears to be an API for getting some information from Microsoft Forms at https://forms.office.com/formapi/api. I'm not sure when it was released, and I'm having trouble finding documentation on it, but I can at least pull some information in my browser this way. After going to https://forms.office.com/ to login (which sets a token in the browser), I can then browse to https://forms.office.com/formapi/api to get a list of operations or to a specific operation like https://forms.office.com/formapi/api/forms to get a list of my Forms.
ProtivitiDan Any more information about this? I can get JSON responses as you did, but was not successful getting form responses. Wondering if any documentation has appeared anywhere.
waltksfc I abandoned my attempts at the time, but looking at it again now I see that I can get info on a specific form with:
https://forms.office.com/formapi/api/forms/{formid}Then I can get the questions or responses on that form with these:
https://forms.office.com/formapi/api/forms/{formid}/questions https://forms.office.com/formapi/api/forms/{formid}/responsesGet the {formid} from the /forms API call.
Unfortunately, now in 2023 the useful calls to forms API to get responses, now just doesn't work.
This works to get ID and other bumpf:
https://forms.office.com/formapi/api/forms
However, to get very useful form and responses:
https://forms.office.com/formapi/api/forms/{form id}
https://forms.office.com/formapi/api/forms/{form id}/reponses
.....using the "form id" from the https://forms.office.com/formapi/api/forms
.... now does not work. I tried all sorts of variants methodically.
I guess Microsoft is desperate for people to get tied into their very old asynch/dynamics infrastructure and go through "PowerAutomate" aka "Flow" instead, to output raw data to an incredibly slow SharePoint list, or an archaic Excel with all the bugs!
Ah! Why is so much in Microsoft-land so disappointing!
Data Scientists want the raw data on-tap!
Why force developers into another inefficient Microsoft infrastructure that's built to tie the customer into a poor solution?
