Skip to main content

Targeting Google Sheets

For Google Sheets, add a target system in Bravura Security Fabric (Manage the System > Resources > Target systems).

  • Type is Google Sheets.

  • Address uses options described below.

    The address is entered in the following syntax:

    {server=<google api server>; port=<secure port number>; proxy=<proxy server>:<port>; impersonate=<administrator id>@<domain name>;domain=<domain name>; checkCert=<true|false>; cfgpath=<config file>;}

    For example:

    {server=www.googleapis.com; port=443; proxy=10.0.0.1:80;impersonate=google_admin@id-privilege.net; domain=id-privilege.net;checkCert=false; cfgpath=agtgsheet.CFG;}

The full list of target system parameters is explained in Target System Options .

Table 1. Google Sheets address configuration

Option

Description

Options marked with a redstar.png are required.

Server redstar.png

The IP address/domain name of the Google API server. This is set to www.googleapis.com by default.

(key: server)

Port

Default is 443.

(key: port)

Connection over SSL

(optional) Select to enforce SSL connections. Default is "true".

(key: ssl)

Validate the server’s certificate when connecting

Determines whether to validate the server’s security certificate for SSL connections. Default is "true".

(key: checkCert)

HTTP Network Proxy

(optional) specifies a proxy URL to use for connecting.

(key: proxy)

Impersonate redstar.png

Email address of the Google Sheets owner.

(key: impersonate)

Domain redstar.png

External domain name, used to map to the Google Sheets API.

(key: domain)

Config file path redstar.png

specify the name of the configuration file. It must be located in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory.

(key: file)



Setting the administrator credentials

A Google Sheets target requires two sets of administrative credentials. One must use a system password. For the first administrator, add the following:

  • ID Full path to the .P12 encryption file (the C: drive is recommended)

  • Password The private key’s password given with the .P12 file.

For the second administrator, add the following:

The target should now be able to connect and interact with the Google Sheets API.

In this section: