Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-15756

DataMapper map only one element from GoogleSpreadsheet sheets collection

    XMLWordPrintable

Details

    Description

      We have integration which takes spreadsheet properties and publish sheet titles into AMQ.
      Steps:
      Get spreadsheet properties -> Log -> DataMapper -> Log -> Publish message
      Example of JMS message:

      {"sheets":[{"sheet":"id"}]}
      

      Example of GoogleSpreadsheet (what the first step returns) according to integration log:

      Body: [[GoogleSpreadsheet [spreadsheetId=1_OLTcj_y8NwST9KHhg8etB10xr6t3TrzaFXwW2dhpXw, title=Test-Data, url=https://docs.google.com/spreadsheets/d/1_OLTcj_y8NwST9KHhg8etB10xr6t3TrzaFXwW2dhpXw/edit, sheets=[GoogleSheet [sheetId=0, index=0, title=Sheet1], GoogleSheet [sheetId=274107068, index=1, title=sheet2], GoogleSheet [sheetId=31438639, index=2, title=pivot-columns], GoogleSheet [sheetId=789378340, index=3, title=pivot rows], GoogleSheet [sheetId=1430313962, index=4, title=chart], GoogleSheet [sheetId=1812574774, index=5, title=Chart4352]]]]] 
      

      Here is how the mapping looks like:

      In syndesis version (20210201), the result message contains all sheet titles.

      Body: [[{"sheets":[{"sheet":"Sheet1"}, {"sheet":"sheet2"}, {"sheet":"pivot-columns"}, {"sheet":"pivot rows"}, {"sheet":"chart"}, {"sheet":"Chart4352"}]}]] 
      

      But after AtlasMap update, in Syndesis version 20210210, the result message contains only one sheet title.

      Body: [[{"sheets":[{"sheet":"Sheet1"}]}]]
      


      The mapping is the same

      I don't know whether that is a bug or I should change something in the integration according to AtlasMap changes.

      I can send exported integration directly via gChat since it contains credentials to our Google Sheets so I have not uploaded it to the attachments.

      Attachments

        1. sheet_log_old.png
          sheet_log_old.png
          65 kB
        2. sheet_log_new.png
          sheet_log_new.png
          50 kB
        3. sheet_dm_old.png
          sheet_dm_old.png
          41 kB
        4. sheet_dm_new.png
          sheet_dm_new.png
          69 kB

        Activity

          People

            toigaras@redhat.com tomohisa igarashi
            mkralik@redhat.com Matej Kralik
            Matej Kralik Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: