Forum Discussion
API to access MS forms
Looking for an API to access MS forms and pull the survey results on a weekly basis.
Postman is just a tool to work with APIs
Coming back to your issue: accessing responses ... not sure that what I will say apply to forms, but for sure it applies to Customer Voice and form pro : data is available in the dataverse tables.
They are accessible via sql queries : you just need the dynamics 365 dataverse address.
There are some limitations (you cannot get translations) but it may cover most of you need
Yes, thank you. The main Approval tables are available in CDS and I can access those. However, when one creates a custom template for Approvals the additional fields are behind-the-scenes created in the Forms repository, so the data collected as part of the custom approval workflow ends up in the forms responses - not in CDS/dataverse - which is why I need to bother with Forms at all. In my opinion, a bad architectural choice by MS. Dataverse knows/stores the form template IDs associated with Approvals so it would have been better to store that data in extension tables, e.g. ApprovalTemplateQuestions, ApprovalTemplateResponses.
- Yeah there are strange architectural choices in Customer Voice. My issue for example concerns translations : they are not accessible in the Dataverse either ...
When it comes to your issue ... I am kind of lost to be sincere. no clue what are those approval workflow ...
Anyway here's a pointer to postman ... smone tried to work on that but the work is still not finished :https://www.postman.com/sakamati/workspace/customervoice/documentation/4141638-20de1ef9-5922-4a50-bf44-5737b48d8e74