K Khan
Sep 7, 2018
  1545
(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 SendGrid SMTP host is deprecated

SendGrid is a services for sending email that is included in Optimizely DXP. Previously smtp.episerver.net was the recommended SMTP server to use,...

Tomas Hensrud Gulla | Dec 4, 2022 | Syndicated blog

Hosting Optimizely CMS 12 on Docker Engine

Since Optimizely CMS can now be deployed as a Docker container, here is a demonstration of building, running and scaling an Optimizely CMS 12 site ...

Stefan Holm Olsen | Dec 4, 2022 | Syndicated blog

How to use CacheTagHelper with content areas in Optimizely CMS 12

I might be going out on a limb here - if you have a better solution, feel very free to share it!  Upgrading your Optimizely web application from .N...

Andreas J | Dec 2, 2022

The 1001st Piece in your 1000 Piece Puzzle: .NET Default Interface Functions

I was recently working with a client who wanted a reasonably large subsystem added to Optimizely that would add automated management to their...

Greg J | Nov 28, 2022 | Syndicated blog