This article describes the principal changes of Google Sheet plugin.
Google Sheet Component download section can be found at this page.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This article is dedicated to Stambia DI 2020 (S20.x.x) or higher.
If you are using Stambia DI S17, S18, S19 please refer to this article.
Google V4 API filters
A limitation was introduced when migrating to Google Sheets "v4 API", the ability to filter data directly when extracting data from Google Sheets was not possible anymore, because of the changes of Google's API.
Filtering was still possible in Mappings and Processes, but it was performed after retrieving data, by using a filter in "staging area" location.
We unlocked this limitation by supporting again filtering directly on "source" location when extracting data from Google Sheets.
JDBC Drivers classes and URLs
- Stambia DI Designer 2020 (S20.2.0) or higher
Stambia DI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.
This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.
The component example project can now be imported directly in the "New" menu of the Project Explorer.
Google v4 API support
Stambia's Google Sheet Component was originally using Google's "v3 API" to communicate and operate with Google Sheet.
This API is planned to be removed by Google soon which advise to now use the currently supported "v4 API" instead.
You can find more information about the removal of this Google API at the following Google article, which explains when it will be removed.
We therefore worked on this new Component which will use the new currently supported "v4 API".
This new version requires a migration which is explained in a dedicated migration article.
You can find the complete procedure in this article.
The new Google "v4 API" changes a lot how to perform operations on Google Sheets and offers better performances.
There are however some limitations on this version due to the changes that you must have in mind:
- When reading data from Google Sheets in a Mapping or Process, it is not possible to use filters yet to filter the data returned
- Google's "v4 API" does not allow to retrieve all the sheets of a given user as it was possible before, so for now you cannot reverse the list of Google Sheets in Metadata, but only standalone Sheets by specifying their identifier.
We are working on those limitations to unlock them in a future version.