Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a complex object in a stage file CSV by combining information from different sources i

edited Oct 2, 2020 6:14PM in Integration 6 comments

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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!