lib_GoogleSheet

This is the Google Sheet Connector for Convertigo. use this library to connect to your no code apps to Google Sheets

For more technical informations : documentation

• Installation
• Sequences
  • checkAccessTokenGoogle
  • ClearRefreshToken
  • forms_AddRow
  • formssource_GetTableData
  • getApiKey
  • getRefreshToken
  • loginGoogleWithCode
  • SheetAddRow
  • SheetGetRange
  • TestLogin
• Mobile Library
  • Shared Actions
    • DisplayGoogleDrivePicker

Installation

1. In your Convertigo Studio click on to import a project in the treeview

2. In the import wizard

   

   paste the text below into the Project remote URL field:

   Usage	Click the copy button at the end of the line
   To contribute	lib_GoogleSheet=https://github.com/convertigo/c8oprj-lib-googlesheets.git:branch=8.3.0
   To simply use	lib_GoogleSheet=https://github.com/convertigo/c8oprj-lib-googlesheets/archive/8.3.0.zip

3. Click the Finish button. This will automatically import the lib_GoogleSheet project

Sequences

checkAccessTokenGoogle

Checks is a valid access token is held by the current users' session for Google

This as to be called by client apps to decide whenever or not they have to display an OAuth login screen

ClearRefreshToken

Remove any RefreshToken and GoogleSheetAcessTokne form the session and user profile

forms_AddRow

Add a row to a table in a Google Sheet. Each column of the table must have the same name as the technicalID
of a field on the form.

This action can also be used to update some data in a table. In this case, set
the Where Clause variable to a condition and set the Update variable to the columns you want to update.

variables

name	comment
doc
forms_config	Creates a row in a table with a given configuration
forms_update	Will be use only if the WHERE clause is not empty. Give here separated by commas the fields = value to define the columns to be updated by the given values. The fields must be the technical identifiers of the fields of your form. For example: inputText1 = 'value1', inputText2 = 'value2'. Of course values can be dragged and dropped from the list of fields.
forms_where	If this field is not empty, the action will use the WHERE clause to filter the record to update. The WHERE clause must be a valid ''SQL like'' WHERE clause without the WHERE keyword. A Where clause can be for example : inputText1 = ''value1'' AND inputText1 > ''Other Value'' Values must be surrounded by single quotes ''. You can use AND/OR operators (in uppercase) but you cannnot combine AND and OR in the same clause.
model
originalDoc

formssource_GetTableData

Get data from a Google sheet table for a data grid. Each column of the Google Sheet will be displayed as the same column in the data grid

variables

name	comment
forms_config	Returns the rows of the table with a given configuration
forms_tableFilter	Filters
model	If true, just return one line of data so that No Code studio can compte the table model

getApiKey

Utility to get from the server the Googler Drive picker api key

getRefreshToken

Gets the google oAuth refresh token previsously stored in user profile. Used to get the rToken to be stored in the Forms data source configuration

loginGoogleWithCode

Perform the OAuth flow for Google

If the token is valid, it will be stored in the user's session to be used when calling Microsoft APIs.

Also if the token is valid, setAuthenticatedUser step is executed to flag this session as authenticated.

variables

name	comment
client_id
code
keySecret
redirect_uri

SheetAddRow

Add a row of cells to a Google Sheet.

variables

name	comment
dataRow	The data to be added
Range	The Cell range to read. (examples, A1:D7 or Class Data!A2:E)
SheetID	The Sheet id as found in the google sheet URL
update	a JSON array of field, values
where	A Google Sheet Where clause

SheetGetRange

Get a range of cells from a Google Sheet.

variables

name	comment
FirstRowHeader	Set this to true if the first row a header
Query	A Query in google Query language Syntax such as SELECT * WHERE A contains('this pattern')
Range	The Cell range to read. (examples, A1:D7 or Sheet!A2:E). leave empty to return all the sheet data
SheetID	The Sheet id as found in the google sheet URL

TestLogin

This only to have the test application logged in to be able to add Attributes to user accounts

Mobile Library

Test and demo app to show Google Sheet capacities

Shared Actions

DisplayGoogleDrivePicker

Displays the Google Drive fille picker to browse available spread sheets This needs an API key to be configured in the symbols :

lib_GoogleSheet.picker.apikey.secret

The Api key can be found at :

https://console.developers.google.com/apis/credentials?organizationId=22050485893&project=convertigo-form-builder