Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.

 

K Khan
Sep 7, 2018
  2207
(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 CMS easy RSS feed integration library

As I've mentioned in my  previous blog post , while I was developing the Optimizely version of my blog, I tried to look for a library that could...

David Drouin-Prince | Jan 25, 2025 | Syndicated blog

Decimal numbers in Optimizely Graph

Storing prices as decimal numbers on a commerce website and planning to expose them through Optimizely Graph? It might not be as straightforward as...

Damian Smutek | Jan 23, 2025 | Syndicated blog

Find and delete non used media and blocks

On my new quest to play around with Blazor and MudBlazor I'm going back memory lane and porting some previously plugins. So this time up is my plug...

Per Nergård (MVP) | Jan 21, 2025

Optimizely Content Graph on mobile application

CG everywhere! I pull schema from our default index https://cg.optimizely.com/app/graphiql?auth=eBrGunULiC5TziTCtiOLEmov2LijBf30obh0KmhcBlyTktGZ in...

Cuong Nguyen Dinh | Jan 20, 2025