Skip to Content
0
May 31, 2018 at 11:25 PM

REST Receiver - JSON Format - Unnamed array inside array - Remove FieldNames in structure

2264 Views Last edit Jun 01, 2018 at 02:10 PM 3 rev

Hi all,

Is there any way i can build an XML structure on SAP PI 7.5 and then convert it to JSON (using REST adapter) to generate this:

{  
   "Headers":[  
      "ID",
      "City",
      "Country"
   ],
   "Lines":[  
      [  
         12345,
         "NEWYORK",
         "USA"
      ],
      [  
         12346,
          "TORONTO",
         "CANADA"
      ],
      [  
         12347,
         "WASHINGTON",
         "USA"
      ]
   ]
}

this is the template of previous structure:

{  
   "Headers":[  
      "FieldName1",
      "FieldName2",
      "FieldName3"
   ],
   "Lines":[  
      [  
         FieldName1-Value1,
         FieldName2-"Value1",
         FieldName3-"Value1",
      ],
      [  
         FieldName1-Value2,
         FieldName2-"Value2",
         FieldName3-"Value2",
      ],
      [  
         FieldName1-Value3,
         FieldName2-"Value3",
         FieldName3-"Value3",
      ]
   ]
}

The problem is with the "Lines" structure. There is an array inside the array "Lines" but it has no name on it.

I was thinking to use JAVA mapping to generate it, but i prefer to use a standard way.

Thanks in advance.