Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

Store AEM Forms as a Cloud Service submission data to an Azure storage account.

Avatar

Level 2

Hi All,

 

I have connected AEM as a cloud service with an Azure storage account to store the data of the adaptive form which is connected with data form model.

In my Azure storage account the data is stored in JSON format but I want that data in CSV file format

Whether it is possible to export the data as a CSV format or can we connect the Forms as Cloud service with relational database (PostgreSQL).

 

Anandhi1132_0-1703591649850.png

Anandhi1132_1-1703592300420.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 2

Thank you for your response it's really very helpful, in addition to that I want to know whether "I can convert the JSON format data into CSV file format." in Azure storage account.

View solution in original post

4 Replies

Avatar

Employee Advisor

When you use form data model to connect to azure you will always get data in json format 

 

Avatar

Employee Advisor

To add more information - when you submit an adaptive form based on core components the data will always be in JSON format

 

Avatar

Correct answer by
Level 2

Thank you for your response it's really very helpful, in addition to that I want to know whether "I can convert the JSON format data into CSV file format." in Azure storage account.

Avatar

Employee Advisor

Try if any power automate actions can convert to csv format