Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


This article describes the principal changes of Google Sheet Addon.

Google Sheet Component download section can be found at this page.

Note:

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 S17, S18 and S19 addon.

If you are using Stambia DI 2020 (S20) or higher, please refer to this article.

 

addons.google.sheets.1.0.0_20200401_132337

New Google Sheet Component

Google Sheet Component, which was included in a default designer installation, has been separated into an additional addon which must be installed separately.

The reason is first to ease the update of this Component which can now be updated separately, avoiding having to wait a new Designer to be published.

The second reason is that we worked hard recently to produce a brand-new Component for Google Sheet, which will replace the old one because Google is removing the "v3 API" we were using to communicate and operate with Google Sheet.

 

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.

 

Limitations

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.

 

 

Articles

Suggest a new Article!