How to process JSON emails

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi, 
I want to process email which has JSON text in it. I found a link to use "Read JSON Document" action. However my question is how can I process multiple blocks of JSON text because number of block will be different in each JSON formatted email. Below is a sample reference email text

{
  "data": [
    {
      "applicationName": "Test App", 
      "Status": "Green", 
      "account": "1111", 
      "Duration_AppLoad": "10.10", 
      "dbCluster": "Test_Cluster", 
    }, 
    {
      "applicationName": "Test App1", 
      "Status": "Red", 
      "account": "2222", 
      "Duration_AppLoad": "11.11", 
      "dbCluster": "Test_Cluster2"
    }
  ]
}

I want to insert value of applicationName, Status, account, duration_appload and dbcluster fields in the DB. I have used below format to fetch data

/json/data/[1]/applicationName = %applicationName%
/json/data/[2]/applicationName = %applicationName%

How can we replace [1], [2] to make it dynamic?

Thank you for help.

Regards

Edited by mitesh281 - 31 May 2021 at 12:07pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mitesh281 Members Profile Send Private Message Find Members Posts Add to Buddy List Professional Joined: 24 Feb 2009 Location: India Points: 71	Post Options Post Reply Quote mitesh281 Report Post Thanks(0) Quote Reply Topic: How to process JSON emails Posted: 31 May 2021 at 12:01pm
	Hi, I want to process email which has JSON text in it. I found a link to use "Read JSON Document" action. However my question is how can I process multiple blocks of JSON text because number of block will be different in each JSON formatted email. Below is a sample reference email text { "data": [ { "applicationName": "Test App", "Status": "Green", "account": "1111", "Duration_AppLoad": "10.10", "dbCluster": "Test_Cluster", }, { "applicationName": "Test App1", "Status": "Red", "account": "2222", "Duration_AppLoad": "11.11", "dbCluster": "Test_Cluster2" } ] } I want to insert value of applicationName, Status, account, duration_appload and dbcluster fields in the DB. I have used below format to fetch data /json/data/[1]/applicationName = %applicationName% /json/data/[2]/applicationName = %applicationName% How can we replace [1], [2] to make it dynamic? Thank you for help. Regards Edited by mitesh281 - 31 May 2021 at 12:07pm