What do you mean by “flatten”? What’s the expected output format? CSV?
The expected output is typical records to load into Oracle DB
Hey @deepak.shaw,
Are you able to share a sample of the incoming data?
Hi,
Yes, Attached the incoming message.
Looking forward for your suggestion/solution.
Regards,
Deepak.
Hi @bojanvelevski , the required file is attached.
The objects contain quite a lot information, so please share some info on which are the corresponding fields that you want in your output.
It’s a bit confusing. repeatedElement it’s obviously the InvoiceLines object, but in your output sample, the objects contain only one key value pair:
{
"key": {
"@attr": "attr1",
"$": "key1"
},
"value": "value1"
}
While in the incoming data, one object contains four fields:
{
"LineNumber": "1",
"LineExtAmtExclTax": "7000",
"Employee": "Marlon Mangila",
"LineTax": "700"
}
Quickly use those fields to manually populate this output object from above, just as a reference.
Hi @bojanvelevski ,
Just to clarify here are input & output messages:
input:
[
{
"Header": {
"InvoiceNumber": "PRP100418",
"InvoiceDate": "29/04/2022",
"PaymentTermsDescription": "Net 7 days",
"CustomerRef": "C1381"
},
"InvoiceLines": [
{
"LineNumber": "1",
"LineExtAmtExclTax": "7000",
"Employee": "Marlon Mangila",
"LineTax": "700"
},
{
"LineNumber": "2",
"LineExtAmtExclTax": "800",
"Employee": "Elin Joe",
"LineTax": "150"
}
]
}
]
output:
{
"Invoice": {
"InvoiceNumber": {
"@attributeName": "PRP100418",
"$": "C1381"
},
"InvoiceLines": [
{
"LineNumber": {
"@LineExtAmtExclTax": "7000",
"$": "1"
},
"value": "Marlon Mangila"
},
{
"LineNumber": {
"@LineExtAmtExclTax": "8000",
"$": "2"
},
"value": "Elin Joe"
}
]
}
}
Looking forward to your suggestion.
Regards,
Deepak.
Done, check the pipeline and let me know if this works for you. Can be made with multiple mappers or a JSON Schema as well, but this is simpler in terms of snaps usage.
