Forum Discussion

Doranarni's avatar
Doranarni
Icon for Microsoft rankMicrosoft
Nov 28, 2018

Is 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.
microsoft forms
ProtivitiDan's avatar
ProtivitiDan
Copper Contributor
Sep 01, 2021

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}/responses

 

Get the {formid} from the /forms API call.

 

waltksfc's avatar
waltksfc
Copper Contributor
Sep 02, 2021

ProtivitiDan - thanks for the reply.  Yep - that works.  Successfully retrieved JSON-formatted questions and responses - but only after logging in/authenticating in our O365 tenant.  I can see that the Forms design page is making AJAX calls to the API, but it looks like it's passing some sort of access tokens in the request headers/cookie.  It would be nice if Microsoft would publish some information about this, and allow some kind of persistent access token in the url/path for an API call - as they do when they provide a shared collaboration link.

 

At this point, I've already created a process to ingest the responses from a downloadable Excel sheet, so there's probably no advantage for me to use the API (since I have to be authenticated before it will work).

Thanks again - appreciate you taking the time to respond.

 

Resources