How to create a complex object in a stage file CSV by combining information from different sources i
Content
Hi experts,
I have the requirement to download some data from a BI report and also UCM files I am using two BI reports, in OIC I have two nested foreach loops I am trying to write a structure like this:
{
"PARAMETROS":{
"fecha_inicio":"2020-09-01T00:00:00.000+00:00",
"fecha_fin":"2020-09-15T00:00:00.000+00:00"
},
"EXPENSES":[
{
"EXPENSE_REPORT_ID":"300000009962077",
"EXPENSE_REPORT_DATE":"2020-08-28T00:00:00.000+00:00",
"Archivos":[
{
"FILE_NAME":"135.XML",
"CONTENT":"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmN"
}
]
},
{
"EXPENSE_REPORT_ID":"300000009962119",
"EXPENSE_REPORT_DATE":"2020-09-01T00:00:00.000+00:00",
"Archivos":[
{
"FILE_NAME":"155.XML",
"CONTENT":"PD94bWwgdmVyc2lvbj0iMS4wIiBlxyZ"
},
{
"FILE_NAME":"188.XML",
"CONTENT":"PG91bWwgdmVyc2lvbj0iMS4wIiBlOJK"