Storing Data to Appian db after processing json from GET api

Hi,

I am trying to save data in appian db which I am getting from an api call. API is : https://run.mocky.io/v3/ac936aeb-6ae5-46e1-ab38-b953ab3ac2a5 [Below is the body that I am getting after running API call in Appian]

[{
		"FXRateMicroservicesSuite1": [{
				"FXR": [{
						"FXRateGET": ["test step 1", "test step 2"],
						"link": "FXRateGET.com"
					},
					{
						"FXRateMiscellaneous": ["test step 1", "test step 2"],
						"link": "FXRateMiscellaneous.com"
					},
					{
						"FXRatePolicyServer": ["test step 1", "test step 2"],
						"link": "FXRatePolicyServer.com"
					},
					{
						"FXRatePOST_DELETE": ["test step 1", "test step 2"],
						"link": "FXRatePOST_DELETE.com"
					}
				]
			},
			{
				"Script2": [{
					"Test cases": ["test step 1", "test step 2"],
					"link": "Script2.com"
				}]
			}
		]
	},

	{
		"FXRateMicroservicesSuite2": [{
				"FXR2": [{
						"FXRateGET2": ["test step 1", "test step 2"],
						"link": "FXRateGET2.com"
					},
					{
						"FXRateMiscellaneous": ["test step 1", "test step 2"],
						"link": "FXRateMiscellaneous.com"
					},
					{
						"FXRatePolicyServer": ["test step 1", "test step 2"],
						"link": "FXRatePolicyServer.com"
					},
					{
						"FXRatePOST_DELETE": ["test step 1", "test step 2"],
						"link": "FXRatePOST_DELETE.com"
					}
				]
			},
			{
				"Script2_2": [{
					"Test cases": ["test step 1", "test step 2"],
					"link": "Script2_2.com"
				}]
			}
		]
	}
]

Below given is how I want to store it in database:

SuiteName Scripts SuiteID
FXRateMicroservicesSuite1 [FXR,Script2] 1
FXRateMicroservicesSuite2 [FXR2,Scrip2_2] 2

So basically, FXRateMicroservicesSuite1 object is an array of scripts which is further an array of steps as you can see in the response of the above api. However I only want to store the suiteName and then Scripts as an array in the Scripts column.

For that, I am basically writing an expression by which I can achieve the above target. However I am not getting the expected output.

Can you guyz pls help me in writing a Expression rule so that I can store it in a process variable and then can store it in database ? Below is the CDT that I am trying to save the output of the expression rule so that I can save it in appian db.

Below is the process model for the same:

 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data