#Pentaho data integration json input full#
#Pentaho data integration json input zip#

That is why the Share with user email field letвЂ™s you specify the email of a user who will get full rights on the freshly created file.Д®nables to share with your whole domain (if configured in Google Drive). If the checkbox is checked then if the Spreadsheet Key specified in the field Spreadsheet key does not exist it will create a new spreadsheet within the service account drive (note that this account has no UI) This is incompatible with the create option below.Д¬reate sheet if it does not exist checkbox : If you want to create a new file, type in any key that will become the name of the worksheet in the created spreadsheetДЄppends the lines without the header to an existing spreadsheet. Worksheet Id : Should be browsed form the selected spreadsheet key. If you type in a sheet name (that does not exist in the drive) it will attempt to create a sheet it the 'create' checkbox is ticked. Lets you specify or browse for spreadsheets existing in the service account drive or for the ones that are shared with the service account email. On success you should see the following screen Spreadsheet tab Use Select Value step for this Service Account Tab I noticed that it is better to transmit STRINGS to the step so Google Sheets works well, specially numbers. That means the cells are interpreted by google after insert.

IMPORTANT NOTE : The API writes data in a 'user entered mode' as if you were typing in the cells. Lets you write data into a sheet (existing or not)

Get Fields* lets you get fields and guess their types, format, precision, decimal and group delimiter as well as trim type.

Lets you select from the fields of the sheet.ДЇields name are always defined in the first line of the google spreadsheet. LetвЂ™s you specify or browse for spreadsheets existing in the service account drive or for the ones that are shared with the service account email. On success you should see a success message.

Test button Lets you test your access to the API. Lets you pick your google service account client secret json file. The service account should be parameterized with both Google Drive and Google Spreadsheet APIвЂ™s read and write access Input step Service Account Tab You should generate your client secret file (json) for your Google service account and paste it somewhere on your machine (or server).

#Pentaho data integration json input zip#

In delivery rep you will find a zip that you can unzip in your pentaho/design-tools/data-integration/plugin folder. Pentaho Google Sheets Output : Writes a google spreadsheet.Pentaho Google Sheets Input : Reads specified fields a google spreadsheet.Jean-FranГ§ois the google Spreadsheet API V3 comes close to depreciation (march 2020) I have developed this plugin using Google Spreadsheet API V4. Pentaho Google Spreadsheet Plugin (Google Sheet API V4 / Google Drive API V3)