Forum Discussion
Query Forms API to get scores or results from form submission
Hello All, May be one for the Forms/Dev Community but thought I would try here. We have a process where 4 forms are submitted weekly (Every week has 4 new forms). We currently gather responses int...
Will this work for grabbing the score results when a person submits are response, or will only ever give aggregate results for everyone?
DingkunXie
Microsoft
MicrosoftIt will aggregate results for everyone, but you can filter by user name (email address) since the results contain that identifying information.
- Great thanks, Dingkun Xie, I'll let you know when Ive gone back to it and will mark you as bets response.
- Using GetAggregateQuizData uri returns the following failure:
Unexpected response from the service
clientRequestId: 2c821506-a025-4e00-a49e-0ffdeb75bda4
Can I confirm, is the userID in the query params the owner of said form?- DingkunXie
It depends on the type of form/quiz you created. If it's a personal form, the form owner's user object ID (GUID) will be used, whereas if it's a group form, the group ID will be used. You can obtain the tenant ID and user ID through the network trace when you load the form. For example, in Edge developer mode, open the form and view the network trace sent to forms.office.com. The URLs of the APIs sent to the server will contain the tenant ID and user (group) ID of your form.