Converting XML Format data to JSON Format and performing data Operations using Azure Logic app

 TASK :

Convert the XML format data into JSON Format and retrieve only the required data from it using Azure Logic apps.

Sample XML data:


This is the sample data, we need to convert this data into JSON first after that we need to perform Transformations.

Expected output:

Solution:



Here I have taken a total of 4 activities HTTP trigger, Get blob content, and Compose.

To trigger the logic app I have taken an HTTP trigger.


Here I am retrieving an XML file from the blob by using the Get blob content Activity.


After getting file content from the blog we need to convert the data format XML to JSON. So I have taken Compose activity and I have written Expression to convert XML to JSON.


Expression :

       


After this activity, the entire data will be converted into a JSON format as mentioned below


But we need to get the data from ENO to Position Title for that I have taken one more Compose activity and there I have written one expression to get the required data. 


Expression:

outputs('Compose')['soap-env:Envelope']['soap-env:Body']['n0:ZhrRfcStaffMasterDataResponse']  ['PeEmployee']

The soap-env: Envelope, soap-env: Body, n0:ZhrRfcStaffMasterDataResponse, and PeEmployee parameters will be there in the XML data itself.

By using this method we can easily convert XML to JSON and also we can able to retrieve the particular Data what we want.


 











   


















Comments

Post a Comment

Popular posts from this blog

Loading Multiple JSON Files Into Different Tables Using AZURE DATA FACTORY

Image
TASK: Loading Multiple JSON Files Into Azure SQL Using AZURE DATA FACTORY SOLUTION: In Azure first we need load the given files into blob ,after that we need to create a pipeline . The following will show you that entire pipe line diagram.  Here I have used several activities namely GETMETA DATA, FILTERS,FOREACH,COPY ACTIVITY, STORED PROCEDURES etc.           GETMETA DATA   à  it will give different properties of data , and it will give    acknowledgement for loaded multiple files.           FILTERS   à  Filters will used to filter the files based on the given requirements like   ‘File starting name’, ‘file ending name’ and some string functions etc.         FOR EACH   à  For each activity is loop the process means if we need to do same  operation more than one time at that time we will use FOR EACH Activity.       COPY ACTIVITY   à  ...
Read more

Getting application error details in Logic Apps using Chat GPT in exception handling

Image
 Problem Statement:       if you are using any API and Azure logic app if it got failed we will get an error message. Sometimes In order to understand the errors we will copy and paste the error into google and we will search for the error. By following the below method we can print the summary of the error and suggestions to fix the issue. services used: 1) Azure Logic App 2)Chat GPT connector Step 1:  I have used an HTTP trigger here I am not passing anybody to trigger this URL the logic will execute. Step 2: Here I am using the exception handling concept here I have taken the scope in scope I have taken HTTP action(NOTE: for sample test case I have taken HTTP  based on your requirement you can add action) Step 3: After HTTP I have taken response Action it will give the response when HTTP action gets successful. Step 4: if Scope1 got failed Scope 2 will be triggered in scope to I am using this chat GPT activity.  the input for chat GPT failure body o...
Read more