Hello, Everyone
I have lots of forms on kentico. And each one has lots of submission data. Now i want to export the data so that i can use them in external tools for analytics and other use cases. Can anybody suggest me how can i achieve. I have outline simple workflows as below
First one is as follow
- Extract all form submission data [I want to extract in csv format for each form. So separate csv for each forms]. FOr this i have seen some kentico example in personal data collection guide [https://docs.kentico.com/guides/development/data-protection/data-collectors-find-contact-personal-data#collect-data]
- I am planning to create a content type called form submission which will hold this csv
- Whole process will be trigger using custom schedule task and author will get the data in content hub
Second one
Same as above
Instead of content type i will attach the csv to email
Send an email to the list authors [needs to be dynamic and configured at admin level]
- For this i want to know if i can use current sendgrid configuration provided by saas platform. If so then how??
Whole process will be trigger using custom schedule task
Let me know if any other workflow which is better and efficient
Environment
Xperience by Kentico version: [30.10.1]
.NET version: [8]
Execution environment: [SaaS|Private cloud (Azure/AWS/Virtual machine)]
Link to relevant Xperience by Kentico documentation