How to loop on JSON Output in SAP MII?
I have a scenario where I am receiving a JSON output from an external system
in to MII. This JSON contains data in a form of rows. I want to store this JSON
data in to my MII database table ( SQL Server 2008). Each row in JSON would be
1 record in my table
Option1 I have is to can convert this JSON to XML by using JSON to XML
converter action block and loop on this XML to insert this record to MII Table.
I am looking for some other options where I can directly use this JSON data
to store in my table either by looping this JSON directly or some other ways.
Please advise, if loop on JSON is possible in MII or suggest any other way
to get this data stored in to MII Table.