SaaS CMS has officially launched! Learn more now.

K Khan
Sep 7, 2018
  2092
(1 votes)

Take EPi Forms data outside of the EPi Database

You might not want to store EPiForms data in EPi Database due to GDPR or any other reason. 

I got the help of Azure Logic Apps in my POC for this purpose, where I want to generate a CSV file and upload it on blob storage.

Step 1: Change serialization format in /modules/_protected/EPiServer.Forms/Forms.config

From version 4.3, you can set up the kind of data format used before sending data to a webhook receiver by using serializingObjectUsingNameValueFormat as true or false
set to true (default) will serialize object to {name:"Foo",email:"foo@example.com"}
set to false will serialize object to [{key:"name",value:"Foo"},{key:"email", value: "foo@example.com"}, ...]

I used serializingObjectUsingNameValueFormat="false" as I want to generate a csv file and upload it on blob storage. 

Step 2: Design your logic app

Image logicapp.JPG

  • When an HTTP request is received: Creates a webhook where we can post forms data.
  • Create CSV Table: I am receiving data in Key/Value format that I want to change into CSV format first.
  • Create blob: Generate CSV file for further processing

Step 3: Setup Webhook actor and turn Off "Store form submissions

Go to your Form Settings and Turn Off "Store Form submissions" option. Set up a webhook url that was obtained in the previous step.

Sorry developers! no coding is required.

Sep 07, 2018

Comments

Please login to comment.
Latest blogs
Optimizely release SaaS CMS

Discover the future of content management with Optimizely SaaS CMS. Enjoy seamless updates, reduced costs, and enhanced flexibility for developers...

Andy Blyth | Jul 17, 2024 | Syndicated blog

A day in the life of an Optimizely Developer - London Meetup 2024

Hello and welcome to another instalment of A Day In The Life Of An Optimizely Developer. Last night (11th July 2024) I was excited to have attended...

Graham Carr | Jul 16, 2024

Creating Custom Actors for Optimizely Forms

Optimizely Forms is a powerful tool for creating web forms for various purposes such as registrations, job applications, surveys, etc. By default,...

Nahid | Jul 16, 2024

Optimizely SaaS CMS Concepts and Terminologies

Whether you're a new user of Optimizely CMS or a veteran who have been through the evolution of it, the SaaS CMS is bringing some new concepts and...

Patrick Lam | Jul 15, 2024