Details
-
Bug
-
Resolution: Done
-
Blocker
-
fuse-7.9-GA
-
False
-
False
-
%
-
+
-
Automated
-
Undefined
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"}]}]]
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.