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.