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.
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.