User Profile
waltksfc
Copper Contributor
Joined Aug 17, 2021
User Widgets
Recent Discussions
Re: Is there an API to read Microsoft forms data
marshall smith At this point my need to use the Form has evaporated, so I haven't done anything with it lately. The process I ended up with still had a couple manual steps, and as they were very application-specific, I doubt that it would help you much. I abandoned the attempt to use the API, because it would only work when I was already online and authenticated in a browser (and couldn't use it a server-based web app). There was another post in this thread that had a workaround for this, but it seemed too complicated for me based on the temporary nature of my app. My manual process was to download the spreadsheet with form results, then import it into a SQL Server table using BCP. The download and BCP import were manual steps that only took a minute to run, but I had to do it every day to refresh the data (so I never did get to realtime form results). Once it was in a SQL table in raw form, I had some other automated steps that transformed the raw data, linked it with other tables in the database, and became the data source for a .Net Core web app. Sorry I don't have more helpful advice. Honestly, it would have been easier to just develop a custom web app from scratch than try to incorporate the Forms data (but using Forms for my particular use case was "suggested" by management).22KViews0likes0CommentsRe: Is there an API to read Microsoft forms data
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.48KViews0likes3Comments
Recent Blog Articles
No content to show