# Struct cloudsheets::GoogleSheets

The GoogleSheets struct provides an easy way to manage spreadsheets in Google. The struct includes support for creating, deleting, updating and listing spreadsheets and sheets.

## Syntax

```text
cloudsheets::GoogleSheets
```

## Remarks

This struct provides an easy to use interface for Google Spreadsheets using version 4 of the GoogleSheets REST API. To use the struct, first set the [authorization](#authorization-property-googlesheets-struct) property to a valid OAuth token. The GoogleSheets struct can be used for creating new sheets, retrieving, deleting and updating existing ones; and several other functionalities supported by the Google Sheets API.

This struct requires authentication via OAuth 2.0. First, perform OAuth authentication using the o_auth property to set the appropriate fields for the chosen [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) and [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct).

The struct has the following defaults:

|  |  |
| --- | --- |
| Authorization Server URL | "https://accounts.google.com/o/oauth2/auth" |
| Token Server URL | "https://accounts.google.com/o/oauth2/token" |
| Scopes | "https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive" |

Below is a brief description of the different [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) and [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) values that are supported by this struct. For a more in-depth description of what needs to be set, refer to the service documentation.

### Application Profile

This profile encompasses the most basic grant types that OAuth supports. When this profile is set, all the requests and response handling is done by the struct. Depending on the grant type, this may involve launching a browser so a user can login to authenticate with a authorization server. It may also involve starting an embedded web server to receive a response from a redirect.

To start the authentication and authorization process, the [authorize](#authorize-method-googlesheets-struct) method should be called. If the authorization and authentication was successful, then the [o_auth_access_token](#o_auth_access_token-property-googlesheets-struct) property will be populated. Additionally, if a *refresh token* was provided the [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct) property will be populated as well. These values of the fields are for informational purposes. The struct will also cache these tokens along with when the [o_auth_access_token](#o_auth_access_token-property-googlesheets-struct) will be expired. When a method that makes requests to the service provider is called or the [authorize](#authorize-method-googlesheets-struct) method is called the struct will automatically check to see if the *access token* is expired. If it is, it will then automatically try to get a new [o_auth_access_token](#o_auth_access_token-property-googlesheets-struct). If the [authorize](#authorize-method-googlesheets-struct) method was not used and user interaction would be required, the struct will throw an error which can be caught. When user interaction is needed depends on what grant type is set in the [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) property. To force the component to only check the *access token* when the [authorize](#authorize-method-googlesheets-struct) method is called, the [OAuthAutomaticRefresh](#OAuthAutomaticRefresh) configuration setting can be set to false.

A brief description of the supported values for the [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) property are below. For more information, see the service documentation.

**Authorization Code**

When using the *Authorization Code* grant type, the struct will use an *authorization code* to get an *access token*. For this [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) the struct expects a [o_auth_client_id](#o_auth_client_id-property-googlesheets-struct), [o_auth_client_secret](#o_auth_client_secret-property-googlesheets-struct), [o_auth_server_auth_url](#o_auth_server_auth_url-property-googlesheets-struct), and [o_auth_server_token_url](#o_auth_server_token_url-property-googlesheets-struct) to be set. When the [authorize](#authorize-method-googlesheets-struct) method is called, the component will start the embedded web server and launch the browser so the user can authorize the application. Once the user authorizes, the service provider will redirect them to the embedded web server and the struct will parse the *authorization code*, setting the [o_auth_authorization_code](#o_auth_authorization_code-property-googlesheets-struct) property, from the redirect. Immediately, the struct will make a request to the token server to exchange the *authorization code* for an *access token*. The token server will return an *access token* and possibly a *refresh token*. If the [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct) property is set, or a *refresh token* is cached, then the struct will not launch the browser and use the *refresh token* in its request to the token server instead of an *authorization code*.

**Example: **

```csharp
GoogleSheets gsheets = new GoogleSheets();

gsheets.OAuth.ClientProfile = CloudOAuthClientProfiles.cocpApplication;
gsheets.OAuth.GrantType = OAuthSettingsGrantTypes.cogtAuthorizationCode;
gsheets.OAuth.ClientId = CLIENT_ID;
gsheets.OAuth.ClientSecret = CLIENT_SECRET;

gsheets.Authorize();
```

 **Implicit**

Note: This grant type is considered insecure and should only be used when necessary.

When using the *Implicit* grant type, the struct will request the authorization server to get an *access token*. For this [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) the struct expects a [o_auth_client_id](#o_auth_client_id-property-googlesheets-struct), [o_auth_client_secret](#o_auth_client_secret-property-googlesheets-struct), and [o_auth_server_auth_url](#o_auth_server_auth_url-property-googlesheets-struct) to be set. When the [authorize](#authorize-method-googlesheets-struct) method is called, the component will start the embedded web server and launch the browser so the user can authorize the application. Once the user authorizes, the service provider will redirect them to the embedded web server and the struct will parse the *access token* from the redirect.

A disadvantage of the grant type is that can not use a *refresh token* to silently get a new *access token*. Most service providers offer a way to silently get a new *access token*. See the service documentation for specifics. This means the struct will not be able to automatically get a fresh token once it expires.

### Web Profile

 This profile is similar to setting the struct to the Application profile and Authorization Code grant type except the struct will not launch the browser. It is typically used in situations where there is a back-end that is supporting some front end. This profile expects that [o_auth_client_id](#o_auth_client_id-property-googlesheets-struct), [o_auth_client_secret](#o_auth_client_secret-property-googlesheets-struct), [o_auth_server_auth_url](#o_auth_server_auth_url-property-googlesheets-struct), [o_auth_server_token_url](#o_auth_server_token_url-property-googlesheets-struct), and the [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct) properties to be set. Before calling the [authorize](#authorize-method-googlesheets-struct) method, the [o_auth_web_auth_url](#o_auth_web_auth_url-property-googlesheets-struct) property should be queried to get a URL. This URL should be used to redirect the user to the authorization page for the service provider. The *redirect_uri* parameter of this URL is mapped to the [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct) property. The [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct) property should be set to some web server that will parse the *authorization code* out of the query parameter from the redirect. Once the *authorization code* is parsed, it should be passed back to the server where it is then set to the [o_auth_authorization_code](#o_auth_authorization_code-property-googlesheets-struct) property. Once that is set, the [authorize](#authorize-method-googlesheets-struct) method can be called to exchange the *authorization code* for an *access token* and *refresh token* if provided. The struct will then cache these values like normal and use them to make requests. If the [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct) field is set, or a *refresh token* is cached, then the [authorize](#authorize-method-googlesheets-struct) method can immediately be called to make a request to the token server to get a new *access token*.

### External OAuth Support

 For complex profiles or grant types, or for more control of the flow, it is possible to perform OAuth authentication using a separate OAuth client. Once complete you should have an authorization string which looks like:

```text
Bearer ACCESS_TOKEN_VALUE
```

Assign this value to the [authorization](#authorization-property-googlesheets-struct) property before attempting any operations. Setting the [authorization](#authorization-property-googlesheets-struct) property will cause the struct to ignore the values set in the o_auth property.

 For Example:

```csharp
Oauth oauth = new Oauth();

oauth.ClientId = "CLIENT_ID";
oauth.ClientSecret = "CLIENT_SECRET";
oauth.AuthorizationScope = "https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive";
oauth.ServerAuthURL = "https://accounts.google.com/o/oauth2/auth";
oauth.ServerTokenURL = "https://accounts.google.com/o/oauth2/token";
oauth.GrantType = OauthGrantTypes.ogtAuthorizationCode;

gsheets.Authorization = oauth.GetAuthorization();
```

 Consult the documentation for the service for more information about supported scope values and more details on OAuth authentication.

### Creating a Spreadsheet

Use the [create_spreadsheet](#create_spreadsheet-method-googlesheets-struct) method in the GoogleSheets component to create a new spreadsheet in Google Drive. The *Name* parameter will determine the name of the new spreadsheet. The name can also be updated after creation using the [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct) method. The *Locale* and *Timezone* are optional parameters can be used to specify the timezone and locale of the new spreadsheet.

**Creating a spreadsheet:**

```csharp
gsheets.CreateSpreadsheet("NewSpreadsheet", "en_US", "UTC-03:00");
```

After creating a spreadsheet, select the spreadsheet to be edited in the spreadsheets collection, edit its fields and make a call to the [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct) method. To edit the newly created spreadsheet select the first spreadsheet in the collection, the [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct) method will always target the first spreadsheet in the collection.

**Example (Update The First Spreadsheet Of The Collection)**

```csharp
// Set properties to update
gsheets.Spreadsheets[0].Name = "UpdateSpreadsheetTest2";
gsheets.Spreadsheets[0].Locale = "en_AU";
gsheets.Spreadsheets[0].TimeZone = "Australia/Sydney";
gsheets.UpdateSpreadsheet();
```

Call [delete_spreadsheet](#delete_spreadsheet-method-googlesheets-struct) and provide the spreadsheet Id if you want to delete the spreadsheet. The spreadsheet will be removed permanently. **Example (Delete a Spreadsheet)**

```csharp
// List spreadsheets to get the target spreadsheet Id
gsheets.ListSpreadsheets();

gsheets.DeleteSpreadsheet(gsheets.Spreadsheets[0].Id)
```

### Listing Spreadsheets

Information about spreadsheets fetched by the component can be accessed through the spreadsheets properties. The spreadsheets properties is populated when the [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) method is called.

By default, the component will fetch one page of 100 spreadsheets when [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) is called. If additional spreadsheets remain in the folder, the ListSpreadsheetsMarker property will be populated and subsequent calls to [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) will fetch the next page of spreadsheets. The example below populates the spreadsheets properties with all the spreadsheets associated with the account.

```csharp
do
{
  gsheets.ListSpreadsheets();
} while (gsheets.SpreadsheetsMarker.Length > 0);
```

The calendar page size may also be changed by using the SpreadsheetsPageSize configuration setting.

### Creating Sheets

To add a new sheet use the [add_sheet](#add_sheet-method-googlesheets-struct) method. The newly added sheet will be in the beginning of the sheets properties.

**Example (Create a new sheet in a specific spreadsheet)**

```csharp
gsheets.LoadSpreadsheet(spreadsheetId);		// A spreadsheet must be loaded before calling AddSheet()

gsheets.AddSheet(1, "Second sheet");
```

 After creating a sheet with the basic information, select the sheet to be edited in the sheets collection, edit its fields and make a call to the [update_sheet](#update_sheet-method-googlesheets-struct) method. To edit the newly created sheet select the first sheet in the collection.

**Example (Update The First Sheet Of The List)**

```csharp
// Set properties to update
gsheets.Sheets[0].Title = "2ndSheetUpdated";
gsheets.Sheets[0].RightToLeft = true;
gsheets.Sheets[0].HideGridlines = true;
gsheets.Sheets[0].TotalColumnCount = 5;
gsheets.Sheets[0].TotalRowCount = 20;

gcal.UpdateSheet();
```

### Loading a Sheet

 To load a sheet in the collection, call the [load_sheet](#load_sheet-method-googlesheets-struct) method and provide the sheetId as the sole parameter. This will cause the sheet to be added to the beginning of the sheets collection

 **Example (Load Sheet)**

```csharp
int sheetId = 212121;	// Replace with actual sheet Id

gsheets.LoadSheet(sheetId);
GSSheet sheet1 = gsheets.Sheets[0];

// Access the retrieved sheet

sheet1.Title;	// Sheet title
sheet1.RightToLeft;		// True if sheet is a RTL sheet
sheet1.HideGridlines;	// True if gridlines are hidden
sheet1.TotalColumnCount;	// Total number of columns in the entire sheet
sheet1.TotalRowCount;	// Total number of rows in the entire sheet
```

### Loading a Range

 To load a range, call the [load_range](#load_range-method-googlesheets-struct) method and provide the two arguments: *SheetId* to specify the sheet to be partially loaded and *Range* to specify the range which will be loaded, the latter uses 'A1:B2' notation. (See [cell](#cell-property-googlesheets-struct))

 **Example (Load a Range)**

```csharp
int sheetId = 212121;	// Replace with actual sheet Id

gsheets.LoadRange(sheetId, "A1:D10");	// We can only work with cells inside the loaded range
GSSheet sheet1 = gsheets.Sheets[0];

// Access the retrieved sheet

gsheets.RowCount; 	// Number of rows in the loaded sheet
gsheets.ColumnCount;	// Number of columns in the loaded sheet
gsheets.Cell = "A1";	// Select the first cell
gsheets.CellValue = "1";	// Insert value in first cell
```

### Deleting a Sheet

To delete a sheet use the [delete_sheet](#delete_sheet-method-googlesheets-struct) method and provide the Id of the sheet. The sheet will be deleted permanently.

**Example (Delete Sheets)**

```csharp
// Delete all hidden sheets in the Sheets collection
foreach (GSSheet sheet in gsheets.Sheets)
{
  if (sheet.Hidden)
  {
    gsheets.DeleteSheet(sheet.SheetId);
  }
}
```

### Object Lifetime

 The *new()* method returns a mutable reference to a struct instance. The object itself is kept in the global list maintained by CloudSheets. Due to this, the GoogleSheets struct cannot be disposed of automatically. Please, call the *dispose(&mut; self)* method of GoogleSheets when you have finished using the instance.

## Property List

*The following is the full list of the properties of the struct with short descriptions. Click on the links for further details.*

|  |  |
| --- | --- |
| [authorization](#authorization-property-googlesheets-struct) | An OAuth Authorization String. |
| [cell](#cell-property-googlesheets-struct) | Represents a specific cell in a Google Sheets spreadsheet. |
| [cell_calculated_value](#cell_calculated_value-property-googlesheets-struct) | Retrieves the calculated result of a cell, based on its formula or content. |
| [cell_column_index](#cell_column_index-property-googlesheets-struct) | The column index of the selected cell. |
| [cell_note](#cell_note-property-googlesheets-struct) | Represents a note attached to a specific cell. |
| [cell_row_index](#cell_row_index-property-googlesheets-struct) | The row index of the selected cell. |
| [cell_text](#cell_text-property-googlesheets-struct) | The text currently displayed in the cell. |
| [cell_value](#cell_value-property-googlesheets-struct) | Represents the user-entered value of the cell before any formulas are applied. |
| [column_count](#column_count-property-googlesheets-struct) | The number of columns in the currently loaded sheet or range. |
| [firewall_auto_detect](#firewall_auto_detect-property-googlesheets-struct) | Whether to automatically detect and use firewall system settings, if available. |
| [firewall_type](#firewall_type-property-googlesheets-struct) | The type of firewall to connect through. |
| [firewall_host](#firewall_host-property-googlesheets-struct) | The name or IP address of the firewall (optional). |
| [firewall_password](#firewall_password-property-googlesheets-struct) | A password if authentication is to be used when connecting through the firewall. |
| [firewall_port](#firewall_port-property-googlesheets-struct) | The Transmission Control Protocol (TCP) port for the firewall Host . |
| [firewall_user](#firewall_user-property-googlesheets-struct) | A username if authentication is to be used when connecting through a firewall. |
| [first_column](#first_column-property-googlesheets-struct) | The column index of the first column in the currently loaded range. |
| [first_row](#first_row-property-googlesheets-struct) | Represents the index of the first row in the currently loaded range. |
| [o_auth_access_token](#o_auth_access_token-property-googlesheets-struct) | The access token returned by the authorization server. |
| [o_auth_authorization_code](#o_auth_authorization_code-property-googlesheets-struct) | The authorization code that is exchanged for an access token. |
| [o_auth_authorization_scope](#o_auth_authorization_scope-property-googlesheets-struct) | The scope request or response parameter used during authorization. |
| [o_auth_client_id](#o_auth_client_id-property-googlesheets-struct) | The id of the client assigned when registering the application. |
| [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) | The type of client that is requesting authorization. |
| [o_auth_client_secret](#o_auth_client_secret-property-googlesheets-struct) | The secret value for the client assigned when registering the application. |
| [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) | The OAuth grant type used to acquire an OAuth access token. |
| [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct) | Specifies the refresh token received from or sent to the authorization server. |
| [o_auth_request_refresh_token](#o_auth_request_refresh_token-property-googlesheets-struct) | Specifies whether the struct will request a refresh token during authorization. |
| [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct) | The URL where the user (browser) returns after authenticating. |
| [o_auth_server_auth_url](#o_auth_server_auth_url-property-googlesheets-struct) | The URL of the authorization server. |
| [o_auth_server_token_url](#o_auth_server_token_url-property-googlesheets-struct) | The URL of the token server used to obtain the access token. |
| [o_auth_timeout](#o_auth_timeout-property-googlesheets-struct) | The amount of time (in seconds) the struct will wait for a response from the browser in the LaunchBrowser event. |
| [o_auth_web_auth_url](#o_auth_web_auth_url-property-googlesheets-struct) | The URL to which the user should be re-directed for authorization. |
| [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) | The type of authorization to perform when connecting to the proxy. |
| [proxy_auto_detect](#proxy_auto_detect-property-googlesheets-struct) | Whether to automatically detect and use proxy system settings, if available. |
| [proxy_password](#proxy_password-property-googlesheets-struct) | A password if authentication is to be used for the proxy. |
| [proxy_port](#proxy_port-property-googlesheets-struct) | The Transmission Control Protocol (TCP) port for the proxy Server (default 80). |
| [proxy_server](#proxy_server-property-googlesheets-struct) | If a proxy Server is given, then the HTTP request is sent to the proxy instead of the server otherwise specified. |
| [proxy_ssl](#proxy_ssl-property-googlesheets-struct) | When to use a Secure Sockets Layer (SSL) for the connection to the proxy. |
| [proxy_user](#proxy_user-property-googlesheets-struct) | A username if authentication is to be used for the proxy. |
| [row_count](#row_count-property-googlesheets-struct) | Indicates the total number of rows in the currently loaded sheet or range grid. |
| [sheets_count](#sheets_count-property-googlesheets-struct) | The number of records in the Sheet arrays. |
| [sheet_column_group_control_after](#sheet_column_group_control_after-property-googlesheets-struct) | True if the column grouping control toggle is shown after the group. |
| [sheet_frozen_column_count](#sheet_frozen_column_count-property-googlesheets-struct) | The number of columns that are frozen in the grid. |
| [sheet_frozen_row_count](#sheet_frozen_row_count-property-googlesheets-struct) | The number of rows that are frozen in the grid. |
| [sheet_hidden](#sheet_hidden-property-googlesheets-struct) | True if the sheet is hidden in the UI, false if it's visible. |
| [sheet_hide_gridlines](#sheet_hide_gridlines-property-googlesheets-struct) | True if the grid isn't showing grid lines in the UI. |
| [sheet_right_to_left](#sheet_right_to_left-property-googlesheets-struct) | True if the sheet is an RTL sheet instead of an LTR sheet. |
| [sheet_row_group_control_after](#sheet_row_group_control_after-property-googlesheets-struct) | True if the row grouping control toggle is shown after the group. |
| [sheet_id](#sheet_id-property-googlesheets-struct) | The unique identifier of the sheet. |
| [sheet_index](#sheet_index-property-googlesheets-struct) | The index of the sheet within the spreadsheet. |
| [sheet_type](#sheet_type-property-googlesheets-struct) | The type of sheet. |
| [sheet_title](#sheet_title-property-googlesheets-struct) | The title of the sheet. |
| [sheet_total_column_count](#sheet_total_column_count-property-googlesheets-struct) | The total number of columns in the grid. |
| [sheet_total_row_count](#sheet_total_row_count-property-googlesheets-struct) | The total number of rows in the grid. |
| [spreadsheets_count](#spreadsheets_count-property-googlesheets-struct) | The number of records in the Spreadsheet arrays. |
| [spreadsheet_id](#spreadsheet_id-property-googlesheets-struct) | The unique identifier of the spreadsheet. |
| [spreadsheet_locale](#spreadsheet_locale-property-googlesheets-struct) | The locale of the spreadsheet, which determines regional settings such as number formatting, date formats and currency symbols. |
| [spreadsheet_name](#spreadsheet_name-property-googlesheets-struct) | Name of the spreadsheet. |
| [spreadsheet_time_zone](#spreadsheet_time_zone-property-googlesheets-struct) | The time zone of the spreadsheet, in CLDR format such as America/New_York. |
| [spreadsheet_url](#spreadsheet_url-property-googlesheets-struct) | URL of the spreadsheet in Google Drive. |
| [spreadsheets_marker](#spreadsheets_marker-property-googlesheets-struct) | A pagination marker for listing spreadsheets. |
| [ssl_accept_server_cert_effective_date](#ssl_accept_server_cert_effective_date-property-googlesheets-struct) | The date on which this certificate becomes valid. |
| [ssl_accept_server_cert_expiration_date](#ssl_accept_server_cert_expiration_date-property-googlesheets-struct) | The date on which the certificate expires. |
| [ssl_accept_server_cert_extended_key_usage](#ssl_accept_server_cert_extended_key_usage-property-googlesheets-struct) | A comma-delimited list of extended key usage identifiers. |
| [ssl_accept_server_cert_fingerprint](#ssl_accept_server_cert_fingerprint-property-googlesheets-struct) | The hex-encoded, 16-byte MD5 fingerprint of the certificate. |
| [ssl_accept_server_cert_fingerprint_sha1](#ssl_accept_server_cert_fingerprint_sha1-property-googlesheets-struct) | The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. |
| [ssl_accept_server_cert_fingerprint_sha256](#ssl_accept_server_cert_fingerprint_sha256-property-googlesheets-struct) | The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. |
| [ssl_accept_server_cert_issuer](#ssl_accept_server_cert_issuer-property-googlesheets-struct) | The issuer of the certificate. |
| [ssl_accept_server_cert_private_key](#ssl_accept_server_cert_private_key-property-googlesheets-struct) | The private key of the certificate (if available). |
| [ssl_accept_server_cert_private_key_available](#ssl_accept_server_cert_private_key_available-property-googlesheets-struct) | Whether a PrivateKey is available for the selected certificate. |
| [ssl_accept_server_cert_private_key_container](#ssl_accept_server_cert_private_key_container-property-googlesheets-struct) | The name of the PrivateKey container for the certificate (if available). |
| [ssl_accept_server_cert_public_key](#ssl_accept_server_cert_public_key-property-googlesheets-struct) | The public key of the certificate. |
| [ssl_accept_server_cert_public_key_algorithm](#ssl_accept_server_cert_public_key_algorithm-property-googlesheets-struct) | The textual description of the certificate's public key algorithm. |
| [ssl_accept_server_cert_public_key_length](#ssl_accept_server_cert_public_key_length-property-googlesheets-struct) | The length of the certificate's public key (in bits). |
| [ssl_accept_server_cert_serial_number](#ssl_accept_server_cert_serial_number-property-googlesheets-struct) | The serial number of the certificate encoded as a string. |
| [ssl_accept_server_cert_signature_algorithm](#ssl_accept_server_cert_signature_algorithm-property-googlesheets-struct) | The text description of the certificate's signature algorithm. |
| [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) | The name of the certificate store for the client certificate. |
| [ssl_accept_server_cert_store_password](#ssl_accept_server_cert_store_password-property-googlesheets-struct) | If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store. |
| [ssl_accept_server_cert_store_type](#ssl_accept_server_cert_store_type-property-googlesheets-struct) | The type of certificate store for this certificate. |
| [ssl_accept_server_cert_subject_alt_names](#ssl_accept_server_cert_subject_alt_names-property-googlesheets-struct) | Comma-separated lists of alternative subject names for the certificate. |
| [ssl_accept_server_cert_thumbprint_md5](#ssl_accept_server_cert_thumbprint_md5-property-googlesheets-struct) | The MD5 hash of the certificate. |
| [ssl_accept_server_cert_thumbprint_sha1](#ssl_accept_server_cert_thumbprint_sha1-property-googlesheets-struct) | The SHA-1 hash of the certificate. |
| [ssl_accept_server_cert_thumbprint_sha256](#ssl_accept_server_cert_thumbprint_sha256-property-googlesheets-struct) | The SHA-256 hash of the certificate. |
| [ssl_accept_server_cert_usage](#ssl_accept_server_cert_usage-property-googlesheets-struct) | The text description of UsageFlags . |
| [ssl_accept_server_cert_usage_flags](#ssl_accept_server_cert_usage_flags-property-googlesheets-struct) | The flags that show intended use for the certificate. |
| [ssl_accept_server_cert_version](#ssl_accept_server_cert_version-property-googlesheets-struct) | The certificate's version number. |
| [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) | The subject of the certificate used for client authentication. |
| [ssl_accept_server_cert_encoded](#ssl_accept_server_cert_encoded-property-googlesheets-struct) | The certificate (PEM/Base64 encoded). |
| [ssl_cert_effective_date](#ssl_cert_effective_date-property-googlesheets-struct) | The date on which this certificate becomes valid. |
| [ssl_cert_expiration_date](#ssl_cert_expiration_date-property-googlesheets-struct) | The date on which the certificate expires. |
| [ssl_cert_extended_key_usage](#ssl_cert_extended_key_usage-property-googlesheets-struct) | A comma-delimited list of extended key usage identifiers. |
| [ssl_cert_fingerprint](#ssl_cert_fingerprint-property-googlesheets-struct) | The hex-encoded, 16-byte MD5 fingerprint of the certificate. |
| [ssl_cert_fingerprint_sha1](#ssl_cert_fingerprint_sha1-property-googlesheets-struct) | The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. |
| [ssl_cert_fingerprint_sha256](#ssl_cert_fingerprint_sha256-property-googlesheets-struct) | The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. |
| [ssl_cert_issuer](#ssl_cert_issuer-property-googlesheets-struct) | The issuer of the certificate. |
| [ssl_cert_private_key](#ssl_cert_private_key-property-googlesheets-struct) | The private key of the certificate (if available). |
| [ssl_cert_private_key_available](#ssl_cert_private_key_available-property-googlesheets-struct) | Whether a PrivateKey is available for the selected certificate. |
| [ssl_cert_private_key_container](#ssl_cert_private_key_container-property-googlesheets-struct) | The name of the PrivateKey container for the certificate (if available). |
| [ssl_cert_public_key](#ssl_cert_public_key-property-googlesheets-struct) | The public key of the certificate. |
| [ssl_cert_public_key_algorithm](#ssl_cert_public_key_algorithm-property-googlesheets-struct) | The textual description of the certificate's public key algorithm. |
| [ssl_cert_public_key_length](#ssl_cert_public_key_length-property-googlesheets-struct) | The length of the certificate's public key (in bits). |
| [ssl_cert_serial_number](#ssl_cert_serial_number-property-googlesheets-struct) | The serial number of the certificate encoded as a string. |
| [ssl_cert_signature_algorithm](#ssl_cert_signature_algorithm-property-googlesheets-struct) | The text description of the certificate's signature algorithm. |
| [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) | The name of the certificate store for the client certificate. |
| [ssl_cert_store_password](#ssl_cert_store_password-property-googlesheets-struct) | If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store. |
| [ssl_cert_store_type](#ssl_cert_store_type-property-googlesheets-struct) | The type of certificate store for this certificate. |
| [ssl_cert_subject_alt_names](#ssl_cert_subject_alt_names-property-googlesheets-struct) | Comma-separated lists of alternative subject names for the certificate. |
| [ssl_cert_thumbprint_md5](#ssl_cert_thumbprint_md5-property-googlesheets-struct) | The MD5 hash of the certificate. |
| [ssl_cert_thumbprint_sha1](#ssl_cert_thumbprint_sha1-property-googlesheets-struct) | The SHA-1 hash of the certificate. |
| [ssl_cert_thumbprint_sha256](#ssl_cert_thumbprint_sha256-property-googlesheets-struct) | The SHA-256 hash of the certificate. |
| [ssl_cert_usage](#ssl_cert_usage-property-googlesheets-struct) | The text description of UsageFlags . |
| [ssl_cert_usage_flags](#ssl_cert_usage_flags-property-googlesheets-struct) | The flags that show intended use for the certificate. |
| [ssl_cert_version](#ssl_cert_version-property-googlesheets-struct) | The certificate's version number. |
| [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) | The subject of the certificate used for client authentication. |
| [ssl_cert_encoded](#ssl_cert_encoded-property-googlesheets-struct) | The certificate (PEM/Base64 encoded). |
| [ssl_provider](#ssl_provider-property-googlesheets-struct) | The Secure Sockets Layer/Transport Layer Security (SSL/TLS) implementation to use. |
| [ssl_server_cert_effective_date](#ssl_server_cert_effective_date-property-googlesheets-struct) | The date on which this certificate becomes valid. |
| [ssl_server_cert_expiration_date](#ssl_server_cert_expiration_date-property-googlesheets-struct) | The date on which the certificate expires. |
| [ssl_server_cert_extended_key_usage](#ssl_server_cert_extended_key_usage-property-googlesheets-struct) | A comma-delimited list of extended key usage identifiers. |
| [ssl_server_cert_fingerprint](#ssl_server_cert_fingerprint-property-googlesheets-struct) | The hex-encoded, 16-byte MD5 fingerprint of the certificate. |
| [ssl_server_cert_fingerprint_sha1](#ssl_server_cert_fingerprint_sha1-property-googlesheets-struct) | The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. |
| [ssl_server_cert_fingerprint_sha256](#ssl_server_cert_fingerprint_sha256-property-googlesheets-struct) | The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. |
| [ssl_server_cert_issuer](#ssl_server_cert_issuer-property-googlesheets-struct) | The issuer of the certificate. |
| [ssl_server_cert_private_key](#ssl_server_cert_private_key-property-googlesheets-struct) | The private key of the certificate (if available). |
| [ssl_server_cert_private_key_available](#ssl_server_cert_private_key_available-property-googlesheets-struct) | Whether a PrivateKey is available for the selected certificate. |
| [ssl_server_cert_private_key_container](#ssl_server_cert_private_key_container-property-googlesheets-struct) | The name of the PrivateKey container for the certificate (if available). |
| [ssl_server_cert_public_key](#ssl_server_cert_public_key-property-googlesheets-struct) | The public key of the certificate. |
| [ssl_server_cert_public_key_algorithm](#ssl_server_cert_public_key_algorithm-property-googlesheets-struct) | The textual description of the certificate's public key algorithm. |
| [ssl_server_cert_public_key_length](#ssl_server_cert_public_key_length-property-googlesheets-struct) | The length of the certificate's public key (in bits). |
| [ssl_server_cert_serial_number](#ssl_server_cert_serial_number-property-googlesheets-struct) | The serial number of the certificate encoded as a string. |
| [ssl_server_cert_signature_algorithm](#ssl_server_cert_signature_algorithm-property-googlesheets-struct) | The text description of the certificate's signature algorithm. |
| [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) | The name of the certificate store for the client certificate. |
| [ssl_server_cert_store_password](#ssl_server_cert_store_password-property-googlesheets-struct) | If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store. |
| [ssl_server_cert_store_type](#ssl_server_cert_store_type-property-googlesheets-struct) | The type of certificate store for this certificate. |
| [ssl_server_cert_subject_alt_names](#ssl_server_cert_subject_alt_names-property-googlesheets-struct) | Comma-separated lists of alternative subject names for the certificate. |
| [ssl_server_cert_thumbprint_md5](#ssl_server_cert_thumbprint_md5-property-googlesheets-struct) | The MD5 hash of the certificate. |
| [ssl_server_cert_thumbprint_sha1](#ssl_server_cert_thumbprint_sha1-property-googlesheets-struct) | The SHA-1 hash of the certificate. |
| [ssl_server_cert_thumbprint_sha256](#ssl_server_cert_thumbprint_sha256-property-googlesheets-struct) | The SHA-256 hash of the certificate. |
| [ssl_server_cert_usage](#ssl_server_cert_usage-property-googlesheets-struct) | The text description of UsageFlags . |
| [ssl_server_cert_usage_flags](#ssl_server_cert_usage_flags-property-googlesheets-struct) | The flags that show intended use for the certificate. |
| [ssl_server_cert_version](#ssl_server_cert_version-property-googlesheets-struct) | The certificate's version number. |
| [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) | The subject of the certificate used for client authentication. |
| [ssl_server_cert_encoded](#ssl_server_cert_encoded-property-googlesheets-struct) | The certificate (PEM/Base64 encoded). |

## Method List

*The following is the full list of the methods of the struct with short descriptions. Click on the links for further details.*

|  |  |
| --- | --- |
| [add_columns](#add_columns-method-googlesheets-struct) | This method adds one or more columns at the end of the sheet. |
| [add_rows](#add_rows-method-googlesheets-struct) | This method adds one or more rows at the end of the sheet. |
| [add_sheet](#add_sheet-method-googlesheets-struct) | Adds a new sheet at a given index. |
| [authorize](#authorize-method-googlesheets-struct) | Get the authorization string required to access the protected resource. |
| [clear](#clear-method-googlesheets-struct) | Clears all the values of the loaded range or sheet. |
| [config](#config-method-googlesheets-struct) | Sets or retrieves a configuration setting. |
| [create_spreadsheet](#create_spreadsheet-method-googlesheets-struct) | Creates a new spreadsheet on the server. |
| [delete_column](#delete_column-method-googlesheets-struct) | Deletes a column at the specified index. |
| [delete_row](#delete_row-method-googlesheets-struct) | Deletes a row at the given index. |
| [delete_sheet](#delete_sheet-method-googlesheets-struct) | Delete the sheet with given SheetId. |
| [delete_spreadsheet](#delete_spreadsheet-method-googlesheets-struct) | Delete the spreadsheet with the given Id. |
| [export](#export-method-googlesheets-struct) | Exports the spreadsheet to a local file using mime type according to the filename extension. |
| [insert_column](#insert_column-method-googlesheets-struct) | Inserts a single empty column at the index specified. |
| [insert_row](#insert_row-method-googlesheets-struct) | Inserts a single empty row at the index specified. |
| [interrupt](#interrupt-method-googlesheets-struct) | Interrupt the current method. |
| [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) | Lists the spreadsheets. |
| [load_range](#load_range-method-googlesheets-struct) | Load the specified range of cells in the sheet. |
| [load_sheet](#load_sheet-method-googlesheets-struct) | Load the sheet's data (all cells). |
| [load_spreadsheet](#load_spreadsheet-method-googlesheets-struct) | Load the spreadsheet properties and the sheets list from the server. |
| [reset](#reset-method-googlesheets-struct) | This method will reset the struct. |
| [send_custom_request](#send_custom_request-method-googlesheets-struct) | Send a custom HTTP request. |
| [update_sheet](#update_sheet-method-googlesheets-struct) | Update the current loaded sheet properties and the cells data. |
| [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct) | Updates properties of a spreadsheet. |

## Event List

*The following is the full list of the events fired by the struct with short descriptions. Click on the links for further details.*

|  |  |
| --- | --- |
| [on_error](#on_error-event-googlesheets-struct) | Fired when information is available about errors during data delivery. |
| [on_log](#on_log-event-googlesheets-struct) | Fired once for each log message. |
| [on_spreadsheet_list](#on_spreadsheet_list-event-googlesheets-struct) | Fired when a spreadsheet is retrieved from the server. |
| [on_ssl_server_authentication](#on_ssl_server_authentication-event-googlesheets-struct) | Fired after the server presents its certificate to the client. |
| [on_ssl_status](#on_ssl_status-event-googlesheets-struct) | Fired when secure connection progress messages are available. |
| [on_transfer](#on_transfer-event-googlesheets-struct) | Fired while a document transfers (delivers document). |

## Config Settings

*The following is a list of config settings for the struct with short descriptions. Click on the links for further details.*

|  |  |
| --- | --- |
| [SpreadsheetsPageSize](#SpreadsheetsPageSize) | Page size limit for fetching spreadsheets. |
| [XChildCount](#XChildCount) | The number of child elements of the current element. |
| [XChildName\[i\]](#XChildName[i]) | The name of the child element. |
| [XChildXText\[i\]](#XChildXText[i]) | The inner text of the child element. |
| [XElement](#XElement) | The name of the current element. |
| [XParent](#XParent) | The parent of the current element. |
| [XPath](#XPath) | Provides a way to point to a specific element in the returned XML or JSON response. |
| [XSubTree](#XSubTree) | A snapshot of the current element in the document. |
| [XText](#XText) | The text of the current element. |
| [OAuthAccessTokenExpiration](#OAuthAccessTokenExpiration) | The lifetime of the access token. |
| [OAuthAuthorizationTokenType](#OAuthAuthorizationTokenType) | The type of access token returned. |
| [OAuthAutomaticRefresh](#OAuthAutomaticRefresh) | Whether or not to refresh an expired access token automatically. |
| [OAuthBrowserResponseTimeout](#OAuthBrowserResponseTimeout) | Specifies the amount of time to wait for a response from the browser. |
| [OAuthIncludeEmptyRedirectURI](#OAuthIncludeEmptyRedirectURI) | Whether an empty redirect_uri parameter is included in requests. |
| [OAuthJWTPayload](#OAuthJWTPayload) | The payload of the JWT access token if present. |
| [OAuthJWTXChildCount](#OAuthJWTXChildCount) | The number of child elements of the current element. |
| [OauthJWTXChildName\[i\]](#OauthJWTXChildName[i]) | The name of the child element. |
| [OAuthJWTXChildXText\[i\]](#OAuthJWTXChildXText[i]) | The inner text of the child element. |
| [OAuthJWTXElement](#OAuthJWTXElement) | The name of the current element. |
| [OauthJWTXParent](#OauthJWTXParent) | The parent of the current element. |
| [OAuthJWTXPath](#OAuthJWTXPath) | Provides a way to point to a specific element in the returned payload of a JWT based access token. |
| [OAuthJWTXSubTree](#OAuthJWTXSubTree) | A snapshot of the current element in the document. |
| [OAuthJWTXText](#OAuthJWTXText) | The text of the current element. |
| [OAuthParamCount](#OAuthParamCount) | Specifies the number of additional parameters variables to include in the request. |
| [OAuthParamName\[i\]](#OAuthParamName[i]) | Specifies the parameter name at the specified index. |
| [OAuthParamValue\[i\]](#OAuthParamValue[i]) | Specifies the parameter value at the specified index. |
| [OAuthPasswordGrantUsername](#OAuthPasswordGrantUsername) | Used in the Resource Owner Password grant type. |
| [OAuthPKCEChallengeEncoding](#OAuthPKCEChallengeEncoding) | The PKCE code challenge method to use. |
| [OAuthPKCEVerifier](#OAuthPKCEVerifier) | The PKCE verifier used to generate the challenge. |
| [OAuthResetData](#OAuthResetData) | Determines if the Reset method applies to the OAuth settings. |
| [OAuthReUseWebServer](#OAuthReUseWebServer) | Determines if the same server instance is used between requests. |
| [OAuthTransferredRequest](#OAuthTransferredRequest) | The full OAuth request last sent by the client. |
| [OAuthUsePKCE](#OAuthUsePKCE) | Specifies if PKCE should be used. |
| [OAuthWebServerActive](#OAuthWebServerActive) | Specifies and controls whether the embedded web server is active. |
| [OAuthWebServerCertStore](#OAuthWebServerCertStore) | The certificate with private key to use when SSL is enabled. |
| [OAuthWebServerCertStorePassword](#OAuthWebServerCertStorePassword) | The certificate with private key to use when SSL is enabled. |
| [OAuthWebServerCertStoreType](#OAuthWebServerCertStoreType) | The certificate with private key to use when SSL is enabled. |
| [OAuthWebServerCertSubject](#OAuthWebServerCertSubject) | The certificate with private key to use when SSL is enabled. |
| [OAuthWebServerFailedResponse](#OAuthWebServerFailedResponse) | The custom response that will be displayed to the user if authentication failed. |
| [OAuthWebServerHost](#OAuthWebServerHost) | The hostname used by the embedded web server displayed in the ReturnURL. |
| [OAuthWebServerPort](#OAuthWebServerPort) | The local port on which the embedded web server listens. |
| [OAuthWebServerResponse](#OAuthWebServerResponse) | The custom response that will be displayed to the user. |
| [OAuthWebServerSSLEnabled](#OAuthWebServerSSLEnabled) | Whether the web server requires SSL connections. |
| [AcceptEncoding](#AcceptEncoding) | Used to tell the server which types of content encodings the client supports. |
| [AllowHTTPCompression](#AllowHTTPCompression) | This property enables HTTP compression for receiving data. |
| [AllowHTTPFallback](#AllowHTTPFallback) | Whether HTTP/2 connections are permitted to fallback to HTTP/1.1. |
| [Append](#Append) | Whether to append data to LocalFile. |
| [Authorization](#Authorization) | The Authorization string to be sent to the server. |
| [BytesTransferred](#BytesTransferred) | Contains the number of bytes transferred in the response data. |
| [ChunkSize](#ChunkSize) | Specifies the chunk size in bytes when using chunked encoding. |
| [CompressHTTPRequest](#CompressHTTPRequest) | Set to true to compress the body of a PUT or POST request. |
| [EncodeURL](#EncodeURL) | If set to True the URL will be encoded by the struct. |
| [FollowRedirects](#FollowRedirects) | Determines what happens when the server issues a redirect. |
| [GetOn302Redirect](#GetOn302Redirect) | If set to True the struct will perform a GET on the new location. |
| [HTTP2HeadersWithoutIndexing](#HTTP2HeadersWithoutIndexing) | HTTP2 headers that should not update the dynamic header table with incremental indexing. |
| [HTTPVersion](#HTTPVersion) | The version of HTTP used by the struct. |
| [IfModifiedSince](#IfModifiedSince) | A date determining the maximum age of the desired document. |
| [KeepAlive](#KeepAlive) | Determines whether the HTTP connection is closed after completion of the request. |
| [KerberosSPN](#KerberosSPN) | The Service Principal Name for the Kerberos Domain Controller. |
| [LogLevel](#LogLevel) | The level of detail that is logged. |
| [MaxRedirectAttempts](#MaxRedirectAttempts) | Limits the number of redirects that are followed in a request. |
| [NegotiatedHTTPVersion](#NegotiatedHTTPVersion) | The negotiated HTTP version. |
| [OtherHeaders](#OtherHeaders) | Other headers as determined by the user (optional). |
| [ProxyAuthorization](#ProxyAuthorization) | The authorization string to be sent to the proxy server. |
| [ProxyAuthScheme](#ProxyAuthScheme) | The authorization scheme to be used for the proxy. |
| [ProxyPassword](#ProxyPassword) | A password if authentication is to be used for the proxy. |
| [ProxyPort](#ProxyPort) | Port for the proxy server (default 80). |
| [ProxyServer](#ProxyServer) | Name or IP address of a proxy server (optional). |
| [ProxyUser](#ProxyUser) | A user name if authentication is to be used for the proxy. |
| [SentHeaders](#SentHeaders) | The full set of headers as sent by the client. |
| [StatusCode](#StatusCode) | The status code of the last response from the server. |
| [StatusLine](#StatusLine) | The first line of the last response from the server. |
| [TransferredData](#TransferredData) | The contents of the last response from the server. |
| [TransferredDataLimit](#TransferredDataLimit) | The maximum number of incoming bytes to be stored by the struct. |
| [TransferredHeaders](#TransferredHeaders) | The full set of headers as received from the server. |
| [TransferredRequest](#TransferredRequest) | The full request as sent by the client. |
| [UseChunkedEncoding](#UseChunkedEncoding) | Enables or Disables HTTP chunked encoding for transfers. |
| [UseIDNs](#UseIDNs) | Whether to encode hostnames to internationalized domain names. |
| [UseProxyAutoConfigURL](#UseProxyAutoConfigURL) | Whether to use a Proxy auto-config file when attempting a connection. |
| [UserAgent](#UserAgent) | Information about the user agent (browser). |
| [ConnectionTimeout](#ConnectionTimeout) | Sets a separate timeout value for establishing a connection. |
| [FirewallAutoDetect](#FirewallAutoDetect) | Tells the struct whether or not to automatically detect and use firewall system settings, if available. |
| [FirewallHost](#FirewallHost) | Name or IP address of firewall (optional). |
| [FirewallHTTPVersion](#FirewallHTTPVersion) | The HTTP version to be used when connecting through a tunneling proxy. |
| [FirewallPassword](#FirewallPassword) | Password to be used if authentication is to be used when connecting through the firewall. |
| [FirewallPort](#FirewallPort) | The TCP port for the FirewallHost;. |
| [FirewallType](#FirewallType) | Determines the type of firewall to connect through. |
| [FirewallUser](#FirewallUser) | A user name if authentication is to be used connecting through a firewall. |
| [KeepAliveInterval](#KeepAliveInterval) | The retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received. |
| [KeepAliveTime](#KeepAliveTime) | The inactivity time in milliseconds before a TCP keep-alive packet is sent. |
| [Linger](#Linger) | When set to True, connections are terminated gracefully. |
| [LingerTime](#LingerTime) | Time in seconds to have the connection linger. |
| [LocalHost](#LocalHost) | The name of the local host through which connections are initiated or accepted. |
| [LocalPort](#LocalPort) | The port in the local host where the struct binds. |
| [MaxLineLength](#MaxLineLength) | The maximum amount of data to accumulate when no EOL is found. |
| [MaxTransferRate](#MaxTransferRate) | The transfer rate limit in bytes per second. |
| [ProxyExceptionsList](#ProxyExceptionsList) | A semicolon separated list of hosts and IPs to bypass when using a proxy. |
| [TCPKeepAlive](#TCPKeepAlive) | Determines whether or not the keep alive socket option is enabled. |
| [TcpNoDelay](#TcpNoDelay) | Whether or not to delay when sending packets. |
| [UseIPv6](#UseIPv6) | Whether to use IPv6. |
| [UseNTLMv2](#UseNTLMv2) | Whether to use NTLM V2. |
| [LogSSLPackets](#LogSSLPackets) | Controls whether SSL packets are logged when using the internal security API. |
| [OpenSSLCADir](#OpenSSLCADir) | The path to a directory containing CA certificates. |
| [OpenSSLCAFile](#OpenSSLCAFile) | Name of the file containing the list of CA's trusted by your application. |
| [OpenSSLCipherList](#OpenSSLCipherList) | A string that controls the ciphers to be used by SSL. |
| [OpenSSLPrngSeedData](#OpenSSLPrngSeedData) | The data to seed the pseudo random number generator (PRNG). |
| [ReuseSSLSession](#ReuseSSLSession) | Determines if the SSL session is reused. |
| [SSLCACerts](#SSLCACerts) | A newline separated list of CA certificates to be included when performing an SSL handshake. |
| [SSLCheckCRL](#SSLCheckCRL) | Whether to check the Certificate Revocation List for the server certificate. |
| [SSLCheckOCSP](#SSLCheckOCSP) | Whether to use OCSP to check the status of the server certificate. |
| [SSLCipherStrength](#SSLCipherStrength) | The minimum cipher strength used for bulk encryption. |
| [SSLClientCACerts](#SSLClientCACerts) | A newline separated list of CA certificates to use during SSL client certificate validation. |
| [SSLEnabledCipherSuites](#SSLEnabledCipherSuites) | The cipher suite to be used in an SSL negotiation. |
| [SSLEnabledProtocols](#SSLEnabledProtocols) | Used to enable/disable the supported security protocols. |
| [SSLEnableRenegotiation](#SSLEnableRenegotiation) | Whether the renegotiation_info SSL extension is supported. |
| [SSLIncludeCertChain](#SSLIncludeCertChain) | Whether the entire certificate chain is included in the SSLServerAuthentication event. |
| [SSLKeyLogFile](#SSLKeyLogFile) | The location of a file where per-session secrets are written for debugging purposes. |
| [SSLNegotiatedCipher](#SSLNegotiatedCipher) | Returns the negotiated cipher suite. |
| [SSLNegotiatedCipherStrength](#SSLNegotiatedCipherStrength) | Returns the negotiated cipher suite strength. |
| [SSLNegotiatedCipherSuite](#SSLNegotiatedCipherSuite) | Returns the negotiated cipher suite. |
| [SSLNegotiatedKeyExchange](#SSLNegotiatedKeyExchange) | Returns the negotiated key exchange algorithm. |
| [SSLNegotiatedKeyExchangeStrength](#SSLNegotiatedKeyExchangeStrength) | Returns the negotiated key exchange algorithm strength. |
| [SSLNegotiatedVersion](#SSLNegotiatedVersion) | Returns the negotiated protocol version. |
| [SSLSecurityFlags](#SSLSecurityFlags) | Flags that control certificate verification. |
| [SSLServerCACerts](#SSLServerCACerts) | A newline separated list of CA certificates to use during SSL server certificate validation. |
| [TLS12SignatureAlgorithms](#TLS12SignatureAlgorithms) | Defines the allowed TLS 1.2 signature algorithms when SSLProvider is set to Internal. |
| [TLS12SupportedGroups](#TLS12SupportedGroups) | The supported groups for ECC. |
| [TLS13KeyShareGroups](#TLS13KeyShareGroups) | The groups for which to pregenerate key shares. |
| [TLS13SignatureAlgorithms](#TLS13SignatureAlgorithms) | The allowed certificate signature algorithms. |
| [TLS13SupportedGroups](#TLS13SupportedGroups) | The supported groups for (EC)DHE key exchange. |
| [AbsoluteTimeout](#AbsoluteTimeout) | Determines whether timeouts are inactivity timeouts or absolute timeouts. |
| [FirewallData](#FirewallData) | Used to send extra data to the firewall. |
| [InBufferSize](#InBufferSize) | The size in bytes of the incoming queue of the socket. |
| [OutBufferSize](#OutBufferSize) | The size in bytes of the outgoing queue of the socket. |
| [BuildInfo](#BuildInfo) | Information about the product's build. |
| [CodePage](#CodePage) | The system code page used for Unicode to Multibyte translations. |
| [LicenseInfo](#LicenseInfo) | Information about the current license. |
| [MaskSensitiveData](#MaskSensitiveData) | Whether sensitive data is masked in log messages. |
| [UseInternalSecurityAPI](#UseInternalSecurityAPI) | Whether or not to use the system security libraries or an internal implementation. |

# authorization property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

An OAuth Authorization String.

## Syntax

*Rust Syntax*

```text
fn authorization(&self ) -> Result<String, CloudSheetsError> fn set_authorization(&self, value : &str) ->  Option<CloudSheetsError>
fn set_authorization_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

This property is used to specify an OAuth authorization string. Setting it is a requirement for using the component.

**Example**

```text
Oauth oauth = new Oauth();

oauth.ClientId = "clientId";
oauth.ClientSecret = "clientSecret";
oauth.ServerAuthURL = "https://accounts.google.com/o/oauth2/auth";
oauth.ServerTokenURL = "https://accounts.google.com/o/oauth2/token";
oauth.AuthorizationScope = "https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive.readonly";
oauth.ClientProfile = OAuthClientProfiles.ocpApplication;
oauth.GrantType = OauthGrantTypes.ogtAuthorizationCode;

gsheets.Authorization = oauth.GetAuthorization();
```

## Data Type

String

# cell property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Represents a specific cell in a Google Sheets spreadsheet.

## Syntax

*Rust Syntax*

```text
fn cell(&self ) -> Result<String, CloudSheetsError> fn set_cell(&self, value : &str) ->  Option<CloudSheetsError>
fn set_cell_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

"A1"

## Remarks

This property is used to specify a target cell for reading or writing operations. It accepts standard A1 notation, making it easy to reference cells within a sheet. An example of A1 notation can be 'B2' which represents the cell in the second row, column B.

## Data Type

String

# cell_calculated_value property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Retrieves the calculated result of a cell, based on its formula or content.

## Syntax

*Rust Syntax*

```text
fn cell_calculated_value(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

If the cell contains a formula, this property returns the computed result instead of the formula itself.

If the cell contains plain text or numbers, this returns the same value as [cell_text](#cell_text-property-googlesheets-struct).

To get the original user input before calculation, use [cell_value](#cell_value-property-googlesheets-struct).

|  |  |
| --- | --- |
| Cell Input/Formula | CellCalculatedValue |
| John | John |
| =5+15 | 20 |
| $6.60 | 6.6 |

This property is read-only.

## Data Type

String

# cell_column_index property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The column index of the selected cell.

## Syntax

*Rust Syntax*

```text
fn cell_column_index(&self ) -> Result<i32, CloudSheetsError> fn set_cell_column_index(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The valid range for cell_column_index is from 0 up to [column_count](#column_count-property-googlesheets-struct) - 1. For example, the index for column 'A' will be 0 and the index for the last column will be [column_count](#column_count-property-googlesheets-struct) - 1.

Works together with [cell_row_index](#cell_row_index-property-googlesheets-struct) to select a cell.

## Data Type

i32

# cell_note property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Represents a note attached to a specific cell.

## Syntax

*Rust Syntax*

```text
fn cell_note(&self ) -> Result<String, CloudSheetsError> fn set_cell_note(&self, value : &str) ->  Option<CloudSheetsError>
fn set_cell_note_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

You can retrieve existing notes or assign a new note to a cell.

## Data Type

String

# cell_row_index property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The row index of the selected cell.

## Syntax

*Rust Syntax*

```text
fn cell_row_index(&self ) -> Result<i32, CloudSheetsError> fn set_cell_row_index(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The valid range for cell_row_index is from 0 up to [row_count](#row_count-property-googlesheets-struct) - 1. For example, the index for row 1 will be 0 and the index for the last row will be [row_count](#row_count-property-googlesheets-struct) - 1.

Used alongside [cell_column_index](#cell_column_index-property-googlesheets-struct) to reference a specific cell numerically.

## Data Type

i32

# cell_text property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text currently displayed in the cell.

## Syntax

*Rust Syntax*

```text
fn cell_text(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

If the cell contains a formula, CellText returns the displayed result, not the formula itself.

If you need the original input, use [cell_value](#cell_value-property-googlesheets-struct) instead.

|  |  |
| --- | --- |
| Cell Input/Formula | CellValue |
| John | John |
| =5+15 | 20 |
| $6.60 | $6.60 |

This property is read-only.

## Data Type

String

# cell_value property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Represents the user-entered value of the cell before any formulas are applied.

## Syntax

*Rust Syntax*

```text
fn cell_value(&self ) -> Result<String, CloudSheetsError> fn set_cell_value(&self, value : &str) ->  Option<CloudSheetsError>
fn set_cell_value_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

Unlike [cell_text](#cell_text-property-googlesheets-struct) or [cell_calculated_value](#cell_calculated_value-property-googlesheets-struct), this value remains unchanged until the sheet is updated on the server.

CellValue can be used when you need to access or modify the original input from the user.

Formula results are not reflected in this value; use [cell_calculated_value](#cell_calculated_value-property-googlesheets-struct) to retrieve computed results.

|  |  |
| --- | --- |
| Cell Input/Formula | CellValue |
| John | John |
| =5+15 | =5+15 |
| $6.60 | 6.6 |

## Data Type

String

# column_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The number of columns in the currently loaded sheet or range.

## Syntax

*Rust Syntax*

```text
fn column_count(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

Use with [row_count](#row_count-property-googlesheets-struct) to iterate over all cells in a selected range for updates or validation.

This property is read-only.

## Data Type

i32

# firewall_auto_detect property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Whether to automatically detect and use firewall system settings, if available.

## Syntax

*Rust Syntax*

```text
fn firewall_auto_detect(&self ) -> Result<bool, CloudSheetsError> fn set_firewall_auto_detect(&self, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

Whether to automatically detect and use firewall system settings, if available.

## Data Type

bool

# firewall_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of firewall to connect through.

## Syntax

*Rust Syntax*

```text
fn firewall_type(&self ) -> Result<i32, CloudSheetsError> fn set_firewall_type(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // None1   // Tunnel2   // SOCKS43   // SOCKS510   // SOCKS4A
```

## Default Value

0

## Remarks

The type of firewall to connect through. The applicable values are as follows:

|  |  |
| --- | --- |
| fwNone (0) | No firewall (default setting). |
| fwTunnel (1) | Connect through a tunneling proxy. [firewall_port](#firewall_port-property-googlesheets-struct) is set to 80. |
| fwSOCKS4 (2) | Connect through a SOCKS4 Proxy. [firewall_port](#firewall_port-property-googlesheets-struct) is set to 1080. |
| fwSOCKS5 (3) | Connect through a SOCKS5 Proxy. [firewall_port](#firewall_port-property-googlesheets-struct) is set to 1080. |
| fwSOCKS4A (10) | Connect through a SOCKS4A Proxy. [firewall_port](#firewall_port-property-googlesheets-struct) is set to 1080. |

## Data Type

i32

# firewall_host property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name or IP address of the firewall (optional).

## Syntax

*Rust Syntax*

```text
fn firewall_host(&self ) -> Result<String, CloudSheetsError> fn set_firewall_host(&self, value : &str) ->  Option<CloudSheetsError>
fn set_firewall_host_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The name or IP address of the firewall (optional). If a [firewall_host](#firewall_host-property-googlesheets-struct) is given, the requested connections will be authenticated through the specified firewall when connecting.

If this property is set to a Domain Name, a DNS request is initiated. Upon successful termination of the request, this property is set to the corresponding address. If the search is not successful, the struct fails with an error.

## Data Type

String

# firewall_password property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A password if authentication is to be used when connecting through the firewall.

## Syntax

*Rust Syntax*

```text
fn firewall_password(&self ) -> Result<String, CloudSheetsError> fn set_firewall_password(&self, value : &str) ->  Option<CloudSheetsError>
fn set_firewall_password_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

A password if authentication is to be used when connecting through the firewall. If [firewall_host](#firewall_host-property-googlesheets-struct) is specified, the [firewall_user](#firewall_user-property-googlesheets-struct) and [firewall_password](#firewall_password-property-googlesheets-struct) properties are used to connect and authenticate to the given firewall. If the authentication fails, the struct fails with an error.

## Data Type

String

# firewall_port property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The Transmission Control Protocol (TCP) port for the firewall Host .

## Syntax

*Rust Syntax*

```text
fn firewall_port(&self ) -> Result<i32, CloudSheetsError> fn set_firewall_port(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The Transmission Control Protocol (TCP) port for the firewall [firewall_host](#firewall_host-property-googlesheets-struct). See the description of the [firewall_host](#firewall_host-property-googlesheets-struct) property for details.

NOTE: This property is set automatically when [firewall_firewall_type](#GoogleSheets_p_FirewallFirewallType) is set to a valid value. See the description of the [firewall_firewall_type](#GoogleSheets_p_FirewallFirewallType) property for details.

## Data Type

i32

# firewall_user property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A username if authentication is to be used when connecting through a firewall.

## Syntax

*Rust Syntax*

```text
fn firewall_user(&self ) -> Result<String, CloudSheetsError> fn set_firewall_user(&self, value : &str) ->  Option<CloudSheetsError>
fn set_firewall_user_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

A username if authentication is to be used when connecting through a firewall. If [firewall_host](#firewall_host-property-googlesheets-struct) is specified, this property and the [firewall_password](#firewall_password-property-googlesheets-struct) property are used to connect and authenticate to the given [Firewall](#Type_Firewall). If the authentication fails, the struct fails with an error.

## Data Type

String

# first_column property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The column index of the first column in the currently loaded range.

## Syntax

*Rust Syntax*

```text
fn first_column(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

"A"

## Remarks

Combined with [column_count](#column_count-property-googlesheets-struct), it defines the horizontal scope of the loaded range. This is represented in A1 notation. For example, if first_column returns 'D', this would represent the the 4th column.

This property is read-only.

## Data Type

String

# first_row property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Represents the index of the first row in the currently loaded range.

## Syntax

*Rust Syntax*

```text
fn first_row(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

"1"

## Remarks

Useful for identifying the starting row when working with a specific data range or when pagination is required. This is given in A1 notation. For example, if first_row returns '8', this would represent the 8th row.

Works together with [row_count](#row_count-property-googlesheets-struct) to establish the loaded vertical range.

This property is read-only.

## Data Type

String

# o_auth_access_token property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The access token returned by the authorization server.

## Syntax

*Rust Syntax*

```text
fn o_auth_access_token(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_access_token(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_access_token_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The access token returned by the authorization server. This is set when the struct makes a request to the token server.

## Data Type

String

# o_auth_authorization_code property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The authorization code that is exchanged for an access token.

## Syntax

*Rust Syntax*

```text
fn o_auth_authorization_code(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_authorization_code(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_authorization_code_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The authorization code that is exchanged for an access token. This is required to be set when the o_auth_client_profile property is set to the Web profile. Otherwise, this field is for information purposes only.

## Data Type

String

# o_auth_authorization_scope property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The scope request or response parameter used during authorization.

## Syntax

*Rust Syntax*

```text
fn o_auth_authorization_scope(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_authorization_scope(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_authorization_scope_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The scope request or response parameter used during authorization.

## Data Type

String

# o_auth_client_id property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The id of the client assigned when registering the application.

## Syntax

*Rust Syntax*

```text
fn o_auth_client_id(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_client_id(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_client_id_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The id of the client assigned when registering the application.

## Data Type

String

# o_auth_client_profile property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of client that is requesting authorization.

## Syntax

*Rust Syntax*

```text
fn o_auth_client_profile(&self ) -> Result<i32, CloudSheetsError> fn set_o_auth_client_profile(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // Application1   // Web
```

## Default Value

0

## Remarks

The type of client that is requesting authorization. See the introduction section for more information. Possible values are:

|  |  |
| --- | --- |
| 0 (cocpApplication - Default) | The application profile is applicable to applications that are run by the user directly. For instance a windows form application would use the application profile. To authorize your application (client) using the application profile see the introduction section. |
| 1 (cocpWeb) | The Web profile is applicable to applications that are run on the server side where the user uses the application from a web browser. To authorize your application (client) using this profile follow see the introduction section. |

## Data Type

i32

# o_auth_client_secret property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The secret value for the client assigned when registering the application.

## Syntax

*Rust Syntax*

```text
fn o_auth_client_secret(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_client_secret(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_client_secret_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The secret value for the client assigned when registering the application.

## Data Type

String

# o_auth_grant_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The OAuth grant type used to acquire an OAuth access token.

## Syntax

*Rust Syntax*

```text
fn o_auth_grant_type(&self ) -> Result<i32, CloudSheetsError> fn set_o_auth_grant_type(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // AuthorizationCode1   // Implicit2   // Password3   // ClientCredentials
```

## Default Value

0

## Remarks

The OAuth grant type used to acquire an OAuth access token. See the introduction section for more information. Possible values are:

|  |  |
| --- | --- |
| 0 (cogtAuthorizationCode - Default) | Authorization Code grant type |
| 1 (cogtImplicit) | Implicit grant type |
| 2 (cogtPassword) | Resource Owner Password Credentials grant type |
| 3 (cogtClientCredentials) | Client Credentials grant type |

## Data Type

i32

# o_auth_refresh_token property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Specifies the refresh token received from or sent to the authorization server.

## Syntax

*Rust Syntax*

```text
fn o_auth_refresh_token(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_refresh_token(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_refresh_token_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

Specifies the refresh token received from or sent to the authorization server. This property is set automatically if a refresh token is retrieved from the token server. If the OAuthAutomaticRefresh configuration setting is set to true, and the o_auth_grant_type property is set to a grant that can use refresh tokens.

## Data Type

String

# o_auth_request_refresh_token property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Specifies whether the struct will request a refresh token during authorization.

## Syntax

*Rust Syntax*

```text
fn o_auth_request_refresh_token(&self ) -> Result<bool, CloudSheetsError> fn set_o_auth_request_refresh_token(&self, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

true

## Remarks

Specifies whether the struct will request a refresh token during authorization. By default, this value is *True*.

When *True*, the struct will automatically add the necessary scopes or parameters to obtain a refresh token. When *False*, this property will have no effect. If the necessary scopes or parameters are specified manually, a refresh token can still be obtained.

NOTE: This property is only applicable when the o_auth_grant_type property is set to *cogtAuthorizationCode*.

## Data Type

bool

# o_auth_return_url property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The URL where the user (browser) returns after authenticating.

## Syntax

*Rust Syntax*

```text
fn o_auth_return_url(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_return_url(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_return_url_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The URL where the user (browser) returns after authenticating. This property is mapped to the *redirect_uri* parameter when making a request to the authorization server. Typically, this is automatically set by the struct when using the embedded web server. If the OAuthWebServerPort or OAuthWebServerHost configuration settings is set, then this property should be set to match. If using the Web client profile, this should be set to the place where the authorization code will be parsed out of the response after the user finishes authorizing.

## Data Type

String

# o_auth_server_auth_url property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The URL of the authorization server.

## Syntax

*Rust Syntax*

```text
fn o_auth_server_auth_url(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_server_auth_url(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_server_auth_url_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The URL of the authorization server.

## Data Type

String

# o_auth_server_token_url property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The URL of the token server used to obtain the access token.

## Syntax

*Rust Syntax*

```text
fn o_auth_server_token_url(&self ) -> Result<String, CloudSheetsError> fn set_o_auth_server_token_url(&self, value : &str) ->  Option<CloudSheetsError>
fn set_o_auth_server_token_url_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The URL of the token server used to obtain the access token.

## Data Type

String

# o_auth_timeout property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The amount of time (in seconds) the struct will wait for a response from the browser in the LaunchBrowser event.

## Syntax

*Rust Syntax*

```text
fn o_auth_timeout(&self ) -> Result<i32, CloudSheetsError> fn set_o_auth_timeout(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

60

## Remarks

The amount of time (in seconds) the component will wait for a response from the browser in the on_launch_browser event. The default value is 60.

## Data Type

i32

# o_auth_web_auth_url property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The URL to which the user should be re-directed for authorization.

## Syntax

*Rust Syntax*

```text
fn o_auth_web_auth_url(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The URL to which the user should be re-directed for authorization. This field is used to get the URL that the user should be redirected to when using the Web client profile. See introduction section for more information.

This property is read-only.

## Data Type

String

# proxy_auth_scheme property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of authorization to perform when connecting to the proxy.

## Syntax

*Rust Syntax*

```text
fn proxy_auth_scheme(&self ) -> Result<i32, CloudSheetsError> fn set_proxy_auth_scheme(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // Basic1   // Digest2   // Proprietary3   // None4   // Ntlm5   // Negotiate
```

## Default Value

0

## Remarks

The type of authorization to perform when connecting to the proxy. This is used only when the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are set.

[proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) should be set to authNone (3) when no authentication is expected.

By default, [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is authBasic (0), and if the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are set, the struct will attempt basic authentication.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to authDigest (1), digest authentication will be attempted instead.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to authProprietary (2), then the authorization token will not be generated by the struct. Look at the configuration file for the struct being used to find more information about manually setting this token.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to authNtlm (4), NTLM authentication will be used.

For security reasons, setting this property will clear the values of [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct).

## Data Type

i32

# proxy_auto_detect property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Whether to automatically detect and use proxy system settings, if available.

## Syntax

*Rust Syntax*

```text
fn proxy_auto_detect(&self ) -> Result<bool, CloudSheetsError> fn set_proxy_auto_detect(&self, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

Whether to automatically detect and use proxy system settings, if available. The default value is *false*.

## Data Type

bool

# proxy_password property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A password if authentication is to be used for the proxy.

## Syntax

*Rust Syntax*

```text
fn proxy_password(&self ) -> Result<String, CloudSheetsError> fn set_proxy_password(&self, value : &str) ->  Option<CloudSheetsError>
fn set_proxy_password_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

A password if authentication is to be used for the proxy.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to Basic Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are Base64 encoded and the proxy authentication token will be generated in the form *Basic [encoded-user-password]*.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to Digest Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are used to respond to the Digest Authentication challenge from the server.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to NTLM Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are used to authenticate through NTLM negotiation.

## Data Type

String

# proxy_port property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The Transmission Control Protocol (TCP) port for the proxy Server (default 80).

## Syntax

*Rust Syntax*

```text
fn proxy_port(&self ) -> Result<i32, CloudSheetsError> fn set_proxy_port(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

80

## Remarks

The Transmission Control Protocol (TCP) port for the proxy [proxy_server](#proxy_server-property-googlesheets-struct) (default 80). See the description of the [proxy_server](#proxy_server-property-googlesheets-struct) property for details.

## Data Type

i32

# proxy_server property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

If a proxy Server is given, then the HTTP request is sent to the proxy instead of the server otherwise specified.

## Syntax

*Rust Syntax*

```text
fn proxy_server(&self ) -> Result<String, CloudSheetsError> fn set_proxy_server(&self, value : &str) ->  Option<CloudSheetsError>
fn set_proxy_server_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

If a proxy [proxy_server](#proxy_server-property-googlesheets-struct) is given, then the HTTP request is sent to the proxy instead of the server otherwise specified.

If the [proxy_server](#proxy_server-property-googlesheets-struct) property is set to a domain name, a DNS request is initiated. Upon successful termination of the request, the [proxy_server](#proxy_server-property-googlesheets-struct) property is set to the corresponding address. If the search is not successful, an error is returned.

## Data Type

String

# proxy_ssl property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

When to use a Secure Sockets Layer (SSL) for the connection to the proxy.

## Syntax

*Rust Syntax*

```text
fn proxy_ssl(&self ) -> Result<i32, CloudSheetsError> fn set_proxy_ssl(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // Automatic1   // Always2   // Never3   // Tunnel
```

## Default Value

0

## Remarks

When to use a Secure Sockets Layer (SSL) for the connection to the proxy. The applicable values are as follows:

|  |  |
| --- | --- |
| psAutomatic (0) | Default setting. If the URL is an https URL, the struct will use the psTunnel option. If the URL is an http URL, the struct will use the psNever option. |
| psAlways (1) | The connection is always SSL-enabled. |
| psNever (2) | The connection is not SSL-enabled. |
| psTunnel (3) | The connection is made through a tunneling (HTTP) proxy. |

## Data Type

i32

# proxy_user property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A username if authentication is to be used for the proxy.

## Syntax

*Rust Syntax*

```text
fn proxy_user(&self ) -> Result<String, CloudSheetsError> fn set_proxy_user(&self, value : &str) ->  Option<CloudSheetsError>
fn set_proxy_user_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

A username if authentication is to be used for the proxy.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to Basic Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are Base64 encoded and the proxy authentication token will be generated in the form *Basic [encoded-user-password]*.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to Digest Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are used to respond to the Digest Authentication challenge from the server.

If [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct) is set to NTLM Authentication, the [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) properties are used to authenticate through NTLM negotiation.

## Data Type

String

# row_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Indicates the total number of rows in the currently loaded sheet or range grid.

## Syntax

*Rust Syntax*

```text
fn row_count(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

Allows defining loops to iterate through all rows in a sheet.

Can be used in combination with [column_count](#column_count-property-googlesheets-struct) to process an entire sheet or loaded range dynamically.

This property is read-only.

## Data Type

i32

# sheets_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The number of records in the Sheet arrays.

## Syntax

*Rust Syntax*

```text
fn sheets_count(&self ) -> Result<i32, CloudSheetsError> fn set_sheets_count(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

This property controls the size of the following arrays:

- [sheet_column_group_control_after](#sheet_column_group_control_after-property-googlesheets-struct)
- [sheet_frozen_column_count](#sheet_frozen_column_count-property-googlesheets-struct)
- [sheet_frozen_row_count](#sheet_frozen_row_count-property-googlesheets-struct)
- [sheet_hidden](#sheet_hidden-property-googlesheets-struct)
- [sheet_hide_gridlines](#sheet_hide_gridlines-property-googlesheets-struct)
- [sheet_id](#sheet_id-property-googlesheets-struct)
- [sheet_index](#sheet_index-property-googlesheets-struct)
- [sheet_right_to_left](#sheet_right_to_left-property-googlesheets-struct)
- [sheet_row_group_control_after](#sheet_row_group_control_after-property-googlesheets-struct)
- [sheet_title](#sheet_title-property-googlesheets-struct)
- [sheet_total_column_count](#sheet_total_column_count-property-googlesheets-struct)
- [sheet_total_row_count](#sheet_total_row_count-property-googlesheets-struct)
- [sheet_type](#sheet_type-property-googlesheets-struct)

The array indices start at *0* and end at *sheets_count - 1*.

## Data Type

i32

# sheet_column_group_control_after property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

True if the column grouping control toggle is shown after the group.

## Syntax

*Rust Syntax*

```text
fn sheet_column_group_control_after(&self , SheetArrayIndex : i32) -> Result<bool, CloudSheetsError> fn set_sheet_column_group_control_after(&self, SheetArrayIndex : i32, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

True if the column grouping control toggle is shown after the group. This will only affect the visual placement of the expand/collapse button in the UI but does not change how the grouping itself works.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

bool

# sheet_frozen_column_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The number of columns that are frozen in the grid.

## Syntax

*Rust Syntax*

```text
fn sheet_frozen_column_count(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError> fn set_sheet_frozen_column_count(&self, SheetArrayIndex : i32, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The number of columns that are frozen in the grid.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

i32

# sheet_frozen_row_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The number of rows that are frozen in the grid.

## Syntax

*Rust Syntax*

```text
fn sheet_frozen_row_count(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError> fn set_sheet_frozen_row_count(&self, SheetArrayIndex : i32, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The number of rows that are frozen in the grid.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

i32

# sheet_hidden property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

True if the sheet is hidden in the UI, false if it's visible.

## Syntax

*Rust Syntax*

```text
fn sheet_hidden(&self , SheetArrayIndex : i32) -> Result<bool, CloudSheetsError> fn set_sheet_hidden(&self, SheetArrayIndex : i32, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

True if the sheet is hidden in the UI, false if it's visible.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

bool

# sheet_hide_gridlines property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

True if the grid isn't showing grid lines in the UI.

## Syntax

*Rust Syntax*

```text
fn sheet_hide_gridlines(&self , SheetArrayIndex : i32) -> Result<bool, CloudSheetsError> fn set_sheet_hide_gridlines(&self, SheetArrayIndex : i32, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

True if the grid isn't showing grid lines in the UI.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

bool

# sheet_right_to_left property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

True if the sheet is an RTL sheet instead of an LTR sheet.

## Syntax

*Rust Syntax*

```text
fn sheet_right_to_left(&self , SheetArrayIndex : i32) -> Result<bool, CloudSheetsError> fn set_sheet_right_to_left(&self, SheetArrayIndex : i32, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

True if the sheet is an RTL sheet instead of an LTR sheet. Use in combination with [update_sheet](#update_sheet-method-googlesheets-struct) to change the sheet direction.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

bool

# sheet_row_group_control_after property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

True if the row grouping control toggle is shown after the group.

## Syntax

*Rust Syntax*

```text
fn sheet_row_group_control_after(&self , SheetArrayIndex : i32) -> Result<bool, CloudSheetsError> fn set_sheet_row_group_control_after(&self, SheetArrayIndex : i32, value : bool) ->  Option<CloudSheetsError>
```

## Default Value

false

## Remarks

True if the row grouping control toggle is shown after the group. This will only affect the visual placement of the expand/collapse button in the UI but does not change how the grouping itself works.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

bool

# sheet_id property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The unique identifier of the sheet.

## Syntax

*Rust Syntax*

```text
fn sheet_id(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The unique identifier of the sheet. Must be non-negative.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

This property is read-only.

## Data Type

i32

# sheet_index property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The index of the sheet within the spreadsheet.

## Syntax

*Rust Syntax*

```text
fn sheet_index(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError> fn set_sheet_index(&self, SheetArrayIndex : i32, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The index of the sheet within the spreadsheet. When adding or updating sheet properties, if this field is excluded then the sheet is added or moved to the end of the sheet list. When updating sheet indices or inserting sheets, movement is considered in "before the move" indexes. For example, if there were three sheets (S1, S2, S3) in order to move S1 ahead of S2 the index would have to be set to 2. A sheet index update request is ignored if the requested index is identical to the sheet's current index or if the requested new index is equal to the current sheet index + 1.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

i32

# sheet_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of sheet.

## Syntax

*Rust Syntax*

```text
fn sheet_type(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError>
```

## Possible Values

```text
0   // Grid1   // Object2   // DataSource
```

## Default Value

0

## Remarks

The type of sheet. Defaults to GRID.

Possible values are:

|  |  |
| --- | --- |
| 0 (gsstGrid) | The sheet is a grid. |
| 1 (gsstObject) | The sheet has no grid and instead has an object like a chart or image. |
| 2 (gsstDataSource) | The sheet connects with an external DataSource and shows the preview of data. |

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

This property is read-only.

## Data Type

i32

# sheet_title property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The title of the sheet.

## Syntax

*Rust Syntax*

```text
fn sheet_title(&self , SheetArrayIndex : i32) -> Result<String, CloudSheetsError> fn set_sheet_title(&self, SheetArrayIndex : i32, value : &str) ->  Option<CloudSheetsError>
fn set_sheet_title_ref(&self, SheetArrayIndex : i32, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The title of the sheet. Use in combination with [update_sheet](#update_sheet-method-googlesheets-struct) to change the sheet title after creation.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

String

# sheet_total_column_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The total number of columns in the grid.

## Syntax

*Rust Syntax*

```text
fn sheet_total_column_count(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError> fn set_sheet_total_column_count(&self, SheetArrayIndex : i32, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The total number of columns in the grid.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

i32

# sheet_total_row_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The total number of rows in the grid.

## Syntax

*Rust Syntax*

```text
fn sheet_total_row_count(&self , SheetArrayIndex : i32) -> Result<i32, CloudSheetsError> fn set_sheet_total_row_count(&self, SheetArrayIndex : i32, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

The total number of rows in the grid.

The *SheetArrayIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SheetsCount](#sheets_count-property-googlesheets-struct) property.

## Data Type

i32

# spreadsheets_count property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The number of records in the Spreadsheet arrays.

## Syntax

*Rust Syntax*

```text
fn spreadsheets_count(&self ) -> Result<i32, CloudSheetsError> fn set_spreadsheets_count(&self, value : i32) ->  Option<CloudSheetsError>
```

## Default Value

0

## Remarks

This property controls the size of the following arrays:

- [spreadsheet_id](#spreadsheet_id-property-googlesheets-struct)
- [spreadsheet_locale](#spreadsheet_locale-property-googlesheets-struct)
- [spreadsheet_name](#spreadsheet_name-property-googlesheets-struct)
- [spreadsheet_time_zone](#spreadsheet_time_zone-property-googlesheets-struct)
- [spreadsheet_url](#spreadsheet_url-property-googlesheets-struct)

The array indices start at *0* and end at *spreadsheets_count - 1*.

## Data Type

i32

# spreadsheet_id property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The unique identifier of the spreadsheet.

## Syntax

*Rust Syntax*

```text
fn spreadsheet_id(&self , SpreadsheetIndex : i32) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The unique identifier of the spreadsheet.

The *SpreadsheetIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SpreadsheetsCount](#spreadsheets_count-property-googlesheets-struct) property.

This property is read-only.

## Data Type

String

# spreadsheet_locale property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The locale of the spreadsheet, which determines regional settings such as number formatting, date formats and currency symbols.

## Syntax

*Rust Syntax*

```text
fn spreadsheet_locale(&self , SpreadsheetIndex : i32) -> Result<String, CloudSheetsError> fn set_spreadsheet_locale(&self, SpreadsheetIndex : i32, value : &str) ->  Option<CloudSheetsError>
fn set_spreadsheet_locale_ref(&self, SpreadsheetIndex : i32, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The locale of the spreadsheet, which determines regional settings such as number formatting, date formats and currency symbols. The locale of the spreadsheet in one of the following formats:

- An ISO 639-1 language code such as **en**
- An ISO 639-2 language code such as **fil**
- A combination of the ISO language code and country code (If no 639-1 code exists), such as **en_US**

 Note: when updating this field, not all locales/languages are supported.

The *SpreadsheetIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SpreadsheetsCount](#spreadsheets_count-property-googlesheets-struct) property.

## Data Type

String

# spreadsheet_name property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Name of the spreadsheet.

## Syntax

*Rust Syntax*

```text
fn spreadsheet_name(&self , SpreadsheetIndex : i32) -> Result<String, CloudSheetsError> fn set_spreadsheet_name(&self, SpreadsheetIndex : i32, value : &str) ->  Option<CloudSheetsError>
fn set_spreadsheet_name_ref(&self, SpreadsheetIndex : i32, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

Name of the spreadsheet. Call [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct) to update the name after creation.

The *SpreadsheetIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SpreadsheetsCount](#spreadsheets_count-property-googlesheets-struct) property.

## Data Type

String

# spreadsheet_time_zone property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The time zone of the spreadsheet, in CLDR format such as America/New_York.

## Syntax

*Rust Syntax*

```text
fn spreadsheet_time_zone(&self , SpreadsheetIndex : i32) -> Result<String, CloudSheetsError> fn set_spreadsheet_time_zone(&self, SpreadsheetIndex : i32, value : &str) ->  Option<CloudSheetsError>
fn set_spreadsheet_time_zone_ref(&self, SpreadsheetIndex : i32, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The time zone of the spreadsheet, in CLDR format such as America/New_York. If the time zone isn't recognized, this may be a custom time zone such as GMT-07:00.

The *SpreadsheetIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SpreadsheetsCount](#spreadsheets_count-property-googlesheets-struct) property.

## Data Type

String

# spreadsheet_url property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

URL of the spreadsheet in Google Drive.

## Syntax

*Rust Syntax*

```text
fn spreadsheet_url(&self , SpreadsheetIndex : i32) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

URL of the spreadsheet in Google Drive.

The *SpreadsheetIndex* parameter specifies the index of the item in the array. The size of the array is controlled by the [SpreadsheetsCount](#spreadsheets_count-property-googlesheets-struct) property.

This property is read-only.

## Data Type

String

# spreadsheets_marker property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A pagination marker for listing spreadsheets.

## Syntax

*Rust Syntax*

```text
fn spreadsheets_marker(&self ) -> Result<String, CloudSheetsError> fn set_spreadsheets_marker(&self, value : &str) ->  Option<CloudSheetsError>
fn set_spreadsheets_marker_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

This property is populated if there are still unlisted spreadsheets after [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) is called. This contains a token that will be included in subsequent calls to [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct). This will cause the next page of spreadsheets to be listed and added to the end of the spreadsheets collection.

This can be used to navigate through large sets of spreadsheets when listing them from the server.

**Example (List All Spreadsheets): **

```text
do
{
  gsheets.ListSpreadsheets();
} while (gsheets.SpreadsheetsMarker.Length > 0);
```

## Data Type

String

# ssl_accept_server_cert_effective_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which this certificate becomes valid.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_effective_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which this certificate becomes valid. Before this date, it is not valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2000 15:00:00.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_expiration_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which the certificate expires.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_expiration_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which the certificate expires. After this date, the certificate will no longer be valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2001 15:00:00.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_extended_key_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A comma-delimited list of extended key usage identifiers.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_extended_key_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

A comma-delimited list of extended key usage identifiers. These are the same as ASN.1 object identifiers (OIDs).

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_fingerprint property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 16-byte MD5 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_fingerprint(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 16-byte MD5 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *bc:2a:72:af:fe:58:17:43:7a:5f:ba:5a:7c:90:f7:02*

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_fingerprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_fingerprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *30:7b:fa:38:65:83:ff:da:b4:4e:07:3f:17:b8:a4:ed:80:be:ff:84*

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_fingerprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_fingerprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *6a:80:5c:33:a9:43:ea:b0:96:12:8a:64:96:30:ef:4a:8a:96:86:ce:f4:c7:be:10:24:8e:2b:60:9e:f3:59:53*

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_issuer property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The issuer of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_issuer(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The issuer of the certificate. This property contains a string representation of the name of the issuing authority for the certificate.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_private_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The private key of the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_private_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The private key of the certificate (if available). The key is provided as PEM/Base64-encoded data.

NOTE: The [ssl_accept_server_cert_private_key](#ssl_accept_server_cert_private_key-property-googlesheets-struct) may be available but not exportable. In this case, [ssl_accept_server_cert_private_key](#ssl_accept_server_cert_private_key-property-googlesheets-struct) returns an empty string.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_private_key_available property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Whether a PrivateKey is available for the selected certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_private_key_available(&self ) -> Result<bool, CloudSheetsError>
```

## Default Value

false

## Remarks

Whether a [ssl_accept_server_cert_private_key](#ssl_accept_server_cert_private_key-property-googlesheets-struct) is available for the selected certificate. If [ssl_accept_server_cert_private_key_available](#ssl_accept_server_cert_private_key_available-property-googlesheets-struct) is True, the certificate may be used for authentication purposes (e.g., server authentication).

This property is read-only.

## Data Type

bool

# ssl_accept_server_cert_private_key_container property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the PrivateKey container for the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_private_key_container(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The name of the [ssl_accept_server_cert_private_key](#ssl_accept_server_cert_private_key-property-googlesheets-struct) container for the certificate (if available). This functionality is available only on Windows platforms.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_public_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The public key of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_public_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The public key of the certificate. The key is provided as PEM/Base64-encoded data.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_public_key_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The textual description of the certificate's public key algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_public_key_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The textual description of the certificate's public key algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_DH") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_public_key_length property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The length of the certificate's public key (in bits).

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_public_key_length(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The length of the certificate's public key (in bits). Common values are 512, 1024, and 2048.

This property is read-only.

## Data Type

i32

# ssl_accept_server_cert_serial_number property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The serial number of the certificate encoded as a string.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_serial_number(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The serial number of the certificate encoded as a string. The number is encoded as a series of hexadecimal digits, with each pair representing a byte of the serial number.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_signature_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of the certificate's signature algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_signature_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of the certificate's signature algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_MD5RSA") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_store property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the certificate store for the client certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_store(&self ) -> Result<Vec<u8>, CloudSheetsError> fn set_ssl_accept_server_cert_store(&self, value : Vec<u8>) ->  Option<CloudSheetsError>
fn set_ssl_accept_server_cert_store_ref(&self, value : &[u8]) ->  Option<CloudSheetsError>
```

## Default Value

"MY"

## Remarks

The name of the certificate store for the client certificate.

The [ssl_accept_server_cert_store_type](#ssl_accept_server_cert_store_type-property-googlesheets-struct) property denotes the type of the certificate store specified by [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct). If the store is password-protected, specify the password in [ssl_accept_server_cert_store_password](#ssl_accept_server_cert_store_password-property-googlesheets-struct).

[ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) is used in conjunction with the [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) property to specify client certificates. If [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) has a value, and [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) or [ssl_accept_server_cert_encoded](#ssl_accept_server_cert_encoded-property-googlesheets-struct) is set, a search for a certificate is initiated. Please see the [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) property for details.

 Designations of certificate stores are platform dependent.

The following designations are the most common User and Machine certificate stores in Windows:

|  |  |
| --- | --- |
| MY | A certificate store holding personal certificates with their associated private keys. |
| CA | Certifying authority certificates. |
| ROOT | Root certificates. |

When the certificate store type is *cstPFXFile*, this property must be set to the name of the file. When the type is *cstPFXBlob*, the property must be set to the binary contents of a PFX file (i.e., PKCS#12 certificate store).

## Data Type

Vec

# ssl_accept_server_cert_store_password property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_store_password(&self ) -> Result<String, CloudSheetsError> fn set_ssl_accept_server_cert_store_password(&self, value : &str) ->  Option<CloudSheetsError>
fn set_ssl_accept_server_cert_store_password_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

## Data Type

String

# ssl_accept_server_cert_store_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of certificate store for this certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_store_type(&self ) -> Result<i32, CloudSheetsError> fn set_ssl_accept_server_cert_store_type(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // User1   // Machine2   // PFXFile3   // PFXBlob4   // JKSFile5   // JKSBlob6   // PEMKeyFile7   // PEMKeyBlob8   // PublicKeyFile9   // PublicKeyBlob10   // SSHPublicKeyBlob11   // P7BFile12   // P7BBlob13   // SSHPublicKeyFile14   // PPKFile15   // PPKBlob16   // XMLFile17   // XMLBlob18   // JWKFile19   // JWKBlob20   // SecurityKey21   // BCFKSFile22   // BCFKSBlob23   // PKCS1199   // Auto
```

## Default Value

0

## Remarks

The type of certificate store for this certificate.

 The struct supports both public and private keys in a variety of formats. When the *cstAuto* value is used, the struct will automatically determine the type. This property can take one of the following values:

```csharp
sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11,
                               @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll",
                               "123456", // PIN
                               "CN=cert_subject");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

```csharp
certmgr.CertStoreType = CertStoreTypes.cstPKCS11;
certmgr.OnCertList += (s, e) => {
  secKeyBlob = e.CertEncoded;
};
certmgr.CertStore = @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll";
certmgr.CertStorePassword = "123456"; // PIN
certmgr.ListStoreCertificates();

sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11, secKeyBlob, "123456", "*");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

|  |  |
| --- | --- |
| 0 (cstUser - default) | For Windows, this specifies that the certificate store is a certificate store owned by the current user. NOTE: This store type is not available in Java. |
| 1 (cstMachine) | For Windows, this specifies that the certificate store is a machine store. NOTE: This store type is not available in Java. |
| 2 (cstPFXFile) | The certificate store is the name of a PFX (PKCS#12) file containing certificates. |
| 3 (cstPFXBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in PFX (PKCS#12) format. |
| 4 (cstJKSFile) | The certificate store is the name of a Java Key Store (JKS) file containing certificates. NOTE: This store type is only available in Java. |
| 5 (cstJKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in Java Key Store (JKS) format. NOTE: This store type is only available in Java. |
| 6 (cstPEMKeyFile) | The certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate. |
| 7 (cstPEMKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a private key and an optional certificate. |
| 8 (cstPublicKeyFile) | The certificate store is the name of a file that contains a PEM- or DER-encoded public key certificate. |
| 9 (cstPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a PEM- or DER-encoded public key certificate. |
| 10 (cstSSHPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains an SSH-style public key. |
| 11 (cstP7BFile) | The certificate store is the name of a PKCS#7 file containing certificates. |
| 12 (cstP7BBlob) | The certificate store is a string (binary) representing a certificate store in PKCS#7 format. |
| 13 (cstSSHPublicKeyFile) | The certificate store is the name of a file that contains an SSH-style public key. |
| 14 (cstPPKFile) | The certificate store is the name of a file that contains a PPK (PuTTY Private Key). |
| 15 (cstPPKBlob) | The certificate store is a string (binary) that contains a PPK (PuTTY Private Key). |
| 16 (cstXMLFile) | The certificate store is the name of a file that contains a certificate in XML format. |
| 17 (cstXMLBlob) | The certificate store is a string that contains a certificate in XML format. |
| 18 (cstJWKFile) | The certificate store is the name of a file that contains a JWK (JSON Web Key). |
| 19 (cstJWKBlob) | The certificate store is a string that contains a JWK (JSON Web Key). |
| 21 (cstBCFKSFile) | The certificate store is the name of a file that contains a BCFKS (Bouncy Castle FIPS Key Store). NOTE: This store type is only available in Java and .NET. |
| 22 (cstBCFKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in BCFKS (Bouncy Castle FIPS Key Store) format. NOTE: This store type is only available in Java and .NET. |
| 23 (cstPKCS11) | The certificate is present on a physical security key accessible via a PKCS#11 interface. To use a security key, create a new [Certificate](#Type_Certificate) object and pass cstPKCS11 as the [ssl_accept_server_cert_store_type](#ssl_accept_server_cert_store_type-property-googlesheets-struct), the full path of the PKCS#11 DLL as the [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct), and the PIN as the [ssl_accept_server_cert_store_password](#ssl_accept_server_cert_store_password-property-googlesheets-struct). Code Example. SSH Authentication with Security Key (without CertMgr): Alternatively, collect the necessary data using the [CertMgr](#CertMgr) struct by calling the [list_store_certificates](#CertMgr_m_ListStoreCertificates) method after setting the corresponding properties accordingly. The certificate information returned in the [on_cert_list](#CertMgr_e_CertList) event's CertEncoded parameter may be saved for later use. When using a certificate obtained with this approach, pass the previously saved security key information as the [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) and set [ssl_accept_server_cert_store_password](#ssl_accept_server_cert_store_password-property-googlesheets-struct) to the PIN. Code Example. SSH Authentication with Security Key (with CertMgr): |
| 99 (cstAuto) | The store type is automatically detected from the input data. This setting may be used with both public and private keys and can detect any of the supported formats automatically. |

## Data Type

i32

# ssl_accept_server_cert_subject_alt_names property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Comma-separated lists of alternative subject names for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_subject_alt_names(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

Comma-separated lists of alternative subject names for the certificate.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_thumbprint_md5 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The MD5 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_thumbprint_md5(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The MD5 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_thumbprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-1 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_thumbprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-1 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_thumbprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-256 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_thumbprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-256 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of UsageFlags .

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of [ssl_accept_server_cert_usage_flags](#ssl_accept_server_cert_usage_flags-property-googlesheets-struct).

This value will be one or more of the following strings and will be separated by commas:

- Digital Signature
- Non-Repudiation
- Key Encipherment
- Data Encipherment
- Key Agreement
- Certificate Signing
- CRL Signing
- Encipher Only

If the provider is OpenSSL, the value is a comma-separated list of X.509 certificate extension names.

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_usage_flags property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The flags that show intended use for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_usage_flags(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The flags that show intended use for the certificate. The value of [ssl_accept_server_cert_usage_flags](#ssl_accept_server_cert_usage_flags-property-googlesheets-struct) is a combination of the following flags:

|  |  |
| --- | --- |
| 0x80 | Digital Signature |
| 0x40 | Non-Repudiation |
| 0x20 | Key Encipherment |
| 0x10 | Data Encipherment |
| 0x08 | Key Agreement |
| 0x04 | Certificate Signing |
| 0x02 | CRL Signing |
| 0x01 | Encipher Only |

Please see the [ssl_accept_server_cert_usage](#ssl_accept_server_cert_usage-property-googlesheets-struct) property for a text representation of [ssl_accept_server_cert_usage_flags](#ssl_accept_server_cert_usage_flags-property-googlesheets-struct).

This functionality currently is not available when the provider is OpenSSL.

This property is read-only.

## Data Type

i32

# ssl_accept_server_cert_version property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate's version number.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_version(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate's version number. The possible values are the strings "V1", "V2", and "V3".

This property is read-only.

## Data Type

String

# ssl_accept_server_cert_subject property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The subject of the certificate used for client authentication.

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_subject(&self ) -> Result<String, CloudSheetsError> fn set_ssl_accept_server_cert_subject(&self, value : &str) ->  Option<CloudSheetsError>
fn set_ssl_accept_server_cert_subject_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The subject of the certificate used for client authentication.

This property must be set after all other certificate properties are set. When this property is set, a search is performed in the current certificate store to locate a certificate with a matching subject.

If a matching certificate is found, the property is set to the full subject of the matching certificate.

If an exact match is not found, the store is searched for subjects containing the value of the property.

If a match is still not found, the property is set to an empty string, and no certificate is selected.

The special value "*" picks a random certificate in the certificate store.

The certificate subject is a comma-separated list of distinguished name fields and values. For instance, "CN=www.server.com, OU=test, C=US, E=example@email.com". Common fields and their meanings are as follows:

| Field | Meaning |
| --- | --- |
| CN | Common Name. This is commonly a hostname like www.server.com. |
| O | Organization |
| OU | Organizational Unit |
| L | Locality |
| S | State |
| C | Country |
| E | Email Address |

If a field value contains a comma, it must be quoted.

## Data Type

String

# ssl_accept_server_cert_encoded property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate (PEM/Base64 encoded).

## Syntax

*Rust Syntax*

```text
fn ssl_accept_server_cert_encoded(&self ) -> Result<Vec<u8>, CloudSheetsError> fn set_ssl_accept_server_cert_encoded(&self, value : Vec<u8>) ->  Option<CloudSheetsError>
fn set_ssl_accept_server_cert_encoded_ref(&self, value : &[u8]) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate (PEM/Base64 encoded). This property is used to assign a specific certificate. The [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) and [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) properties also may be used to specify a certificate.

When [ssl_accept_server_cert_encoded](#ssl_accept_server_cert_encoded-property-googlesheets-struct) is set, a search is initiated in the current [ssl_accept_server_cert_store](#ssl_accept_server_cert_store-property-googlesheets-struct) for the private key of the certificate. If the key is found, [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) is updated to reflect the full subject of the selected certificate; otherwise, [ssl_accept_server_cert_subject](#ssl_accept_server_cert_subject-property-googlesheets-struct) is set to an empty string.

## Data Type

Vec

# ssl_cert_effective_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which this certificate becomes valid.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_effective_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which this certificate becomes valid. Before this date, it is not valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2000 15:00:00.

This property is read-only.

## Data Type

String

# ssl_cert_expiration_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which the certificate expires.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_expiration_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which the certificate expires. After this date, the certificate will no longer be valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2001 15:00:00.

This property is read-only.

## Data Type

String

# ssl_cert_extended_key_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A comma-delimited list of extended key usage identifiers.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_extended_key_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

A comma-delimited list of extended key usage identifiers. These are the same as ASN.1 object identifiers (OIDs).

This property is read-only.

## Data Type

String

# ssl_cert_fingerprint property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 16-byte MD5 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_fingerprint(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 16-byte MD5 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *bc:2a:72:af:fe:58:17:43:7a:5f:ba:5a:7c:90:f7:02*

This property is read-only.

## Data Type

String

# ssl_cert_fingerprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_fingerprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *30:7b:fa:38:65:83:ff:da:b4:4e:07:3f:17:b8:a4:ed:80:be:ff:84*

This property is read-only.

## Data Type

String

# ssl_cert_fingerprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_fingerprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *6a:80:5c:33:a9:43:ea:b0:96:12:8a:64:96:30:ef:4a:8a:96:86:ce:f4:c7:be:10:24:8e:2b:60:9e:f3:59:53*

This property is read-only.

## Data Type

String

# ssl_cert_issuer property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The issuer of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_issuer(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The issuer of the certificate. This property contains a string representation of the name of the issuing authority for the certificate.

This property is read-only.

## Data Type

String

# ssl_cert_private_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The private key of the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_cert_private_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The private key of the certificate (if available). The key is provided as PEM/Base64-encoded data.

NOTE: The [ssl_cert_private_key](#ssl_cert_private_key-property-googlesheets-struct) may be available but not exportable. In this case, [ssl_cert_private_key](#ssl_cert_private_key-property-googlesheets-struct) returns an empty string.

This property is read-only.

## Data Type

String

# ssl_cert_private_key_available property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Whether a PrivateKey is available for the selected certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_private_key_available(&self ) -> Result<bool, CloudSheetsError>
```

## Default Value

false

## Remarks

Whether a [ssl_cert_private_key](#ssl_cert_private_key-property-googlesheets-struct) is available for the selected certificate. If [ssl_cert_private_key_available](#ssl_cert_private_key_available-property-googlesheets-struct) is True, the certificate may be used for authentication purposes (e.g., server authentication).

This property is read-only.

## Data Type

bool

# ssl_cert_private_key_container property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the PrivateKey container for the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_cert_private_key_container(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The name of the [ssl_cert_private_key](#ssl_cert_private_key-property-googlesheets-struct) container for the certificate (if available). This functionality is available only on Windows platforms.

This property is read-only.

## Data Type

String

# ssl_cert_public_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The public key of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_public_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The public key of the certificate. The key is provided as PEM/Base64-encoded data.

This property is read-only.

## Data Type

String

# ssl_cert_public_key_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The textual description of the certificate's public key algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_public_key_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The textual description of the certificate's public key algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_DH") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_cert_public_key_length property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The length of the certificate's public key (in bits).

## Syntax

*Rust Syntax*

```text
fn ssl_cert_public_key_length(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The length of the certificate's public key (in bits). Common values are 512, 1024, and 2048.

This property is read-only.

## Data Type

i32

# ssl_cert_serial_number property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The serial number of the certificate encoded as a string.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_serial_number(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The serial number of the certificate encoded as a string. The number is encoded as a series of hexadecimal digits, with each pair representing a byte of the serial number.

This property is read-only.

## Data Type

String

# ssl_cert_signature_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of the certificate's signature algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_signature_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of the certificate's signature algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_MD5RSA") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_cert_store property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the certificate store for the client certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_store(&self ) -> Result<Vec<u8>, CloudSheetsError> fn set_ssl_cert_store(&self, value : Vec<u8>) ->  Option<CloudSheetsError>
fn set_ssl_cert_store_ref(&self, value : &[u8]) ->  Option<CloudSheetsError>
```

## Default Value

"MY"

## Remarks

The name of the certificate store for the client certificate.

The [ssl_cert_store_type](#ssl_cert_store_type-property-googlesheets-struct) property denotes the type of the certificate store specified by [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct). If the store is password-protected, specify the password in [ssl_cert_store_password](#ssl_cert_store_password-property-googlesheets-struct).

[ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) is used in conjunction with the [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) property to specify client certificates. If [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) has a value, and [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) or [ssl_cert_encoded](#ssl_cert_encoded-property-googlesheets-struct) is set, a search for a certificate is initiated. Please see the [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) property for details.

 Designations of certificate stores are platform dependent.

The following designations are the most common User and Machine certificate stores in Windows:

|  |  |
| --- | --- |
| MY | A certificate store holding personal certificates with their associated private keys. |
| CA | Certifying authority certificates. |
| ROOT | Root certificates. |

When the certificate store type is *cstPFXFile*, this property must be set to the name of the file. When the type is *cstPFXBlob*, the property must be set to the binary contents of a PFX file (i.e., PKCS#12 certificate store).

## Data Type

Vec

# ssl_cert_store_password property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_store_password(&self ) -> Result<String, CloudSheetsError> fn set_ssl_cert_store_password(&self, value : &str) ->  Option<CloudSheetsError>
fn set_ssl_cert_store_password_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

## Data Type

String

# ssl_cert_store_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of certificate store for this certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_store_type(&self ) -> Result<i32, CloudSheetsError> fn set_ssl_cert_store_type(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // User1   // Machine2   // PFXFile3   // PFXBlob4   // JKSFile5   // JKSBlob6   // PEMKeyFile7   // PEMKeyBlob8   // PublicKeyFile9   // PublicKeyBlob10   // SSHPublicKeyBlob11   // P7BFile12   // P7BBlob13   // SSHPublicKeyFile14   // PPKFile15   // PPKBlob16   // XMLFile17   // XMLBlob18   // JWKFile19   // JWKBlob20   // SecurityKey21   // BCFKSFile22   // BCFKSBlob23   // PKCS1199   // Auto
```

## Default Value

0

## Remarks

The type of certificate store for this certificate.

 The struct supports both public and private keys in a variety of formats. When the *cstAuto* value is used, the struct will automatically determine the type. This property can take one of the following values:

```csharp
sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11,
                               @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll",
                               "123456", // PIN
                               "CN=cert_subject");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

```csharp
certmgr.CertStoreType = CertStoreTypes.cstPKCS11;
certmgr.OnCertList += (s, e) => {
  secKeyBlob = e.CertEncoded;
};
certmgr.CertStore = @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll";
certmgr.CertStorePassword = "123456"; // PIN
certmgr.ListStoreCertificates();

sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11, secKeyBlob, "123456", "*");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

|  |  |
| --- | --- |
| 0 (cstUser - default) | For Windows, this specifies that the certificate store is a certificate store owned by the current user. NOTE: This store type is not available in Java. |
| 1 (cstMachine) | For Windows, this specifies that the certificate store is a machine store. NOTE: This store type is not available in Java. |
| 2 (cstPFXFile) | The certificate store is the name of a PFX (PKCS#12) file containing certificates. |
| 3 (cstPFXBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in PFX (PKCS#12) format. |
| 4 (cstJKSFile) | The certificate store is the name of a Java Key Store (JKS) file containing certificates. NOTE: This store type is only available in Java. |
| 5 (cstJKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in Java Key Store (JKS) format. NOTE: This store type is only available in Java. |
| 6 (cstPEMKeyFile) | The certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate. |
| 7 (cstPEMKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a private key and an optional certificate. |
| 8 (cstPublicKeyFile) | The certificate store is the name of a file that contains a PEM- or DER-encoded public key certificate. |
| 9 (cstPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a PEM- or DER-encoded public key certificate. |
| 10 (cstSSHPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains an SSH-style public key. |
| 11 (cstP7BFile) | The certificate store is the name of a PKCS#7 file containing certificates. |
| 12 (cstP7BBlob) | The certificate store is a string (binary) representing a certificate store in PKCS#7 format. |
| 13 (cstSSHPublicKeyFile) | The certificate store is the name of a file that contains an SSH-style public key. |
| 14 (cstPPKFile) | The certificate store is the name of a file that contains a PPK (PuTTY Private Key). |
| 15 (cstPPKBlob) | The certificate store is a string (binary) that contains a PPK (PuTTY Private Key). |
| 16 (cstXMLFile) | The certificate store is the name of a file that contains a certificate in XML format. |
| 17 (cstXMLBlob) | The certificate store is a string that contains a certificate in XML format. |
| 18 (cstJWKFile) | The certificate store is the name of a file that contains a JWK (JSON Web Key). |
| 19 (cstJWKBlob) | The certificate store is a string that contains a JWK (JSON Web Key). |
| 21 (cstBCFKSFile) | The certificate store is the name of a file that contains a BCFKS (Bouncy Castle FIPS Key Store). NOTE: This store type is only available in Java and .NET. |
| 22 (cstBCFKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in BCFKS (Bouncy Castle FIPS Key Store) format. NOTE: This store type is only available in Java and .NET. |
| 23 (cstPKCS11) | The certificate is present on a physical security key accessible via a PKCS#11 interface. To use a security key, create a new [Certificate](#Type_Certificate) object and pass cstPKCS11 as the [ssl_cert_store_type](#ssl_cert_store_type-property-googlesheets-struct), the full path of the PKCS#11 DLL as the [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct), and the PIN as the [ssl_cert_store_password](#ssl_cert_store_password-property-googlesheets-struct). Code Example. SSH Authentication with Security Key (without CertMgr): Alternatively, collect the necessary data using the [CertMgr](#CertMgr) struct by calling the [list_store_certificates](#CertMgr_m_ListStoreCertificates) method after setting the corresponding properties accordingly. The certificate information returned in the [on_cert_list](#CertMgr_e_CertList) event's CertEncoded parameter may be saved for later use. When using a certificate obtained with this approach, pass the previously saved security key information as the [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) and set [ssl_cert_store_password](#ssl_cert_store_password-property-googlesheets-struct) to the PIN. Code Example. SSH Authentication with Security Key (with CertMgr): |
| 99 (cstAuto) | The store type is automatically detected from the input data. This setting may be used with both public and private keys and can detect any of the supported formats automatically. |

## Data Type

i32

# ssl_cert_subject_alt_names property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Comma-separated lists of alternative subject names for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_subject_alt_names(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

Comma-separated lists of alternative subject names for the certificate.

This property is read-only.

## Data Type

String

# ssl_cert_thumbprint_md5 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The MD5 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_thumbprint_md5(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The MD5 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_cert_thumbprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-1 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_thumbprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-1 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_cert_thumbprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-256 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_thumbprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-256 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_cert_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of UsageFlags .

## Syntax

*Rust Syntax*

```text
fn ssl_cert_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of [ssl_cert_usage_flags](#ssl_cert_usage_flags-property-googlesheets-struct).

This value will be one or more of the following strings and will be separated by commas:

- Digital Signature
- Non-Repudiation
- Key Encipherment
- Data Encipherment
- Key Agreement
- Certificate Signing
- CRL Signing
- Encipher Only

If the provider is OpenSSL, the value is a comma-separated list of X.509 certificate extension names.

This property is read-only.

## Data Type

String

# ssl_cert_usage_flags property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The flags that show intended use for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_usage_flags(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The flags that show intended use for the certificate. The value of [ssl_cert_usage_flags](#ssl_cert_usage_flags-property-googlesheets-struct) is a combination of the following flags:

|  |  |
| --- | --- |
| 0x80 | Digital Signature |
| 0x40 | Non-Repudiation |
| 0x20 | Key Encipherment |
| 0x10 | Data Encipherment |
| 0x08 | Key Agreement |
| 0x04 | Certificate Signing |
| 0x02 | CRL Signing |
| 0x01 | Encipher Only |

Please see the [ssl_cert_usage](#ssl_cert_usage-property-googlesheets-struct) property for a text representation of [ssl_cert_usage_flags](#ssl_cert_usage_flags-property-googlesheets-struct).

This functionality currently is not available when the provider is OpenSSL.

This property is read-only.

## Data Type

i32

# ssl_cert_version property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate's version number.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_version(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate's version number. The possible values are the strings "V1", "V2", and "V3".

This property is read-only.

## Data Type

String

# ssl_cert_subject property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The subject of the certificate used for client authentication.

## Syntax

*Rust Syntax*

```text
fn ssl_cert_subject(&self ) -> Result<String, CloudSheetsError> fn set_ssl_cert_subject(&self, value : &str) ->  Option<CloudSheetsError>
fn set_ssl_cert_subject_ref(&self, value : &String) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The subject of the certificate used for client authentication.

This property must be set after all other certificate properties are set. When this property is set, a search is performed in the current certificate store to locate a certificate with a matching subject.

If a matching certificate is found, the property is set to the full subject of the matching certificate.

If an exact match is not found, the store is searched for subjects containing the value of the property.

If a match is still not found, the property is set to an empty string, and no certificate is selected.

The special value "*" picks a random certificate in the certificate store.

The certificate subject is a comma-separated list of distinguished name fields and values. For instance, "CN=www.server.com, OU=test, C=US, E=example@email.com". Common fields and their meanings are as follows:

| Field | Meaning |
| --- | --- |
| CN | Common Name. This is commonly a hostname like www.server.com. |
| O | Organization |
| OU | Organizational Unit |
| L | Locality |
| S | State |
| C | Country |
| E | Email Address |

If a field value contains a comma, it must be quoted.

## Data Type

String

# ssl_cert_encoded property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate (PEM/Base64 encoded).

## Syntax

*Rust Syntax*

```text
fn ssl_cert_encoded(&self ) -> Result<Vec<u8>, CloudSheetsError> fn set_ssl_cert_encoded(&self, value : Vec<u8>) ->  Option<CloudSheetsError>
fn set_ssl_cert_encoded_ref(&self, value : &[u8]) ->  Option<CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate (PEM/Base64 encoded). This property is used to assign a specific certificate. The [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) and [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) properties also may be used to specify a certificate.

When [ssl_cert_encoded](#ssl_cert_encoded-property-googlesheets-struct) is set, a search is initiated in the current [ssl_cert_store](#ssl_cert_store-property-googlesheets-struct) for the private key of the certificate. If the key is found, [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) is updated to reflect the full subject of the selected certificate; otherwise, [ssl_cert_subject](#ssl_cert_subject-property-googlesheets-struct) is set to an empty string.

## Data Type

Vec

# ssl_provider property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The Secure Sockets Layer/Transport Layer Security (SSL/TLS) implementation to use.

## Syntax

*Rust Syntax*

```text
fn ssl_provider(&self ) -> Result<i32, CloudSheetsError> fn set_ssl_provider(&self, value : i32) ->  Option<CloudSheetsError>
```

## Possible Values

```text
0   // Automatic1   // Platform2   // Internal
```

## Default Value

0

## Remarks

This property specifies the SSL/TLS implementation to use. In most cases the default value of *0* (Automatic) is recommended and should not be changed. When set to *0* (Automatic), the struct will select whether to use the platform implementation or the internal implementation depending on the operating system as well as the TLS version being used.

Possible values are as follows:

|  |  |
| --- | --- |
| 0 (sslpAutomatic - default) | Automatically selects the appropriate implementation. |
| 1 (sslpPlatform) | Uses the platform/system implementation. |
| 2 (sslpInternal) | Uses the internal implementation. |

 **Additional Notes**

In most cases using the default value (Automatic) is recommended. The struct will select a provider depending on the current platform.

When Automatic is selected, on Windows, the struct will use the platform implementation. On Linux/macOS, the struct will use the internal implementation. When TLS 1.3 is enabled via [SSLEnabledProtocols](#SSLEnabledProtocols), the struct will always try and use the platform implementation. If the platform TLS 1.3 implementation is not available, the internal implementation will be used.

## Data Type

i32

# ssl_server_cert_effective_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which this certificate becomes valid.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_effective_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which this certificate becomes valid. Before this date, it is not valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2000 15:00:00.

This property is read-only.

## Data Type

String

# ssl_server_cert_expiration_date property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The date on which the certificate expires.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_expiration_date(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The date on which the certificate expires. After this date, the certificate will no longer be valid. The date is localized to the system's time zone. The following example illustrates the format of an encoded date:

23-Jan-2001 15:00:00.

This property is read-only.

## Data Type

String

# ssl_server_cert_extended_key_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

A comma-delimited list of extended key usage identifiers.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_extended_key_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

A comma-delimited list of extended key usage identifiers. These are the same as ASN.1 object identifiers (OIDs).

This property is read-only.

## Data Type

String

# ssl_server_cert_fingerprint property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 16-byte MD5 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_fingerprint(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 16-byte MD5 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *bc:2a:72:af:fe:58:17:43:7a:5f:ba:5a:7c:90:f7:02*

This property is read-only.

## Data Type

String

# ssl_server_cert_fingerprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_fingerprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 20-byte SHA-1 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *30:7b:fa:38:65:83:ff:da:b4:4e:07:3f:17:b8:a4:ed:80:be:ff:84*

This property is read-only.

## Data Type

String

# ssl_server_cert_fingerprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_fingerprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The hex-encoded, 32-byte SHA-256 fingerprint of the certificate. This property is primarily used for keys which do not have a corresponding X.509 public certificate, such as PEM keys that only contain a private key. It is commonly used for SSH keys.

The following example illustrates the format: *6a:80:5c:33:a9:43:ea:b0:96:12:8a:64:96:30:ef:4a:8a:96:86:ce:f4:c7:be:10:24:8e:2b:60:9e:f3:59:53*

This property is read-only.

## Data Type

String

# ssl_server_cert_issuer property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The issuer of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_issuer(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The issuer of the certificate. This property contains a string representation of the name of the issuing authority for the certificate.

This property is read-only.

## Data Type

String

# ssl_server_cert_private_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The private key of the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_private_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The private key of the certificate (if available). The key is provided as PEM/Base64-encoded data.

NOTE: The [ssl_server_cert_private_key](#ssl_server_cert_private_key-property-googlesheets-struct) may be available but not exportable. In this case, [ssl_server_cert_private_key](#ssl_server_cert_private_key-property-googlesheets-struct) returns an empty string.

This property is read-only.

## Data Type

String

# ssl_server_cert_private_key_available property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Whether a PrivateKey is available for the selected certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_private_key_available(&self ) -> Result<bool, CloudSheetsError>
```

## Default Value

false

## Remarks

Whether a [ssl_server_cert_private_key](#ssl_server_cert_private_key-property-googlesheets-struct) is available for the selected certificate. If [ssl_server_cert_private_key_available](#ssl_server_cert_private_key_available-property-googlesheets-struct) is True, the certificate may be used for authentication purposes (e.g., server authentication).

This property is read-only.

## Data Type

bool

# ssl_server_cert_private_key_container property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the PrivateKey container for the certificate (if available).

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_private_key_container(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The name of the [ssl_server_cert_private_key](#ssl_server_cert_private_key-property-googlesheets-struct) container for the certificate (if available). This functionality is available only on Windows platforms.

This property is read-only.

## Data Type

String

# ssl_server_cert_public_key property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The public key of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_public_key(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The public key of the certificate. The key is provided as PEM/Base64-encoded data.

This property is read-only.

## Data Type

String

# ssl_server_cert_public_key_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The textual description of the certificate's public key algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_public_key_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The textual description of the certificate's public key algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_DH") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_server_cert_public_key_length property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The length of the certificate's public key (in bits).

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_public_key_length(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The length of the certificate's public key (in bits). Common values are 512, 1024, and 2048.

This property is read-only.

## Data Type

i32

# ssl_server_cert_serial_number property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The serial number of the certificate encoded as a string.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_serial_number(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The serial number of the certificate encoded as a string. The number is encoded as a series of hexadecimal digits, with each pair representing a byte of the serial number.

This property is read-only.

## Data Type

String

# ssl_server_cert_signature_algorithm property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of the certificate's signature algorithm.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_signature_algorithm(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of the certificate's signature algorithm. The property contains either the name of the algorithm (e.g., "RSA" or "RSA_MD5RSA") or an object identifier (OID) string representing the algorithm.

This property is read-only.

## Data Type

String

# ssl_server_cert_store property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The name of the certificate store for the client certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_store(&self ) -> Result<Vec<u8>, CloudSheetsError>
```

## Default Value

"MY"

## Remarks

The name of the certificate store for the client certificate.

The [ssl_server_cert_store_type](#ssl_server_cert_store_type-property-googlesheets-struct) property denotes the type of the certificate store specified by [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct). If the store is password-protected, specify the password in [ssl_server_cert_store_password](#ssl_server_cert_store_password-property-googlesheets-struct).

[ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) is used in conjunction with the [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) property to specify client certificates. If [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) has a value, and [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) or [ssl_server_cert_encoded](#ssl_server_cert_encoded-property-googlesheets-struct) is set, a search for a certificate is initiated. Please see the [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) property for details.

 Designations of certificate stores are platform dependent.

The following designations are the most common User and Machine certificate stores in Windows:

|  |  |
| --- | --- |
| MY | A certificate store holding personal certificates with their associated private keys. |
| CA | Certifying authority certificates. |
| ROOT | Root certificates. |

When the certificate store type is *cstPFXFile*, this property must be set to the name of the file. When the type is *cstPFXBlob*, the property must be set to the binary contents of a PFX file (i.e., PKCS#12 certificate store).

This property is read-only.

## Data Type

Vec

# ssl_server_cert_store_password property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_store_password(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

If the type of certificate store requires a password, this property is used to specify the password needed to open the certificate store.

This property is read-only.

## Data Type

String

# ssl_server_cert_store_type property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The type of certificate store for this certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_store_type(&self ) -> Result<i32, CloudSheetsError>
```

## Possible Values

```text
0   // User1   // Machine2   // PFXFile3   // PFXBlob4   // JKSFile5   // JKSBlob6   // PEMKeyFile7   // PEMKeyBlob8   // PublicKeyFile9   // PublicKeyBlob10   // SSHPublicKeyBlob11   // P7BFile12   // P7BBlob13   // SSHPublicKeyFile14   // PPKFile15   // PPKBlob16   // XMLFile17   // XMLBlob18   // JWKFile19   // JWKBlob20   // SecurityKey21   // BCFKSFile22   // BCFKSBlob23   // PKCS1199   // Auto
```

## Default Value

0

## Remarks

The type of certificate store for this certificate.

 The struct supports both public and private keys in a variety of formats. When the *cstAuto* value is used, the struct will automatically determine the type. This property can take one of the following values:

```csharp
sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11,
                               @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll",
                               "123456", // PIN
                               "CN=cert_subject");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

```csharp
certmgr.CertStoreType = CertStoreTypes.cstPKCS11;
certmgr.OnCertList += (s, e) => {
  secKeyBlob = e.CertEncoded;
};
certmgr.CertStore = @"C:\Program Files\OpenSC Project\OpenSC\pkcs11\opensc-pkcs11.dll";
certmgr.CertStorePassword = "123456"; // PIN
certmgr.ListStoreCertificates();

sftp.SSHCert = new Certificate(CertStoreTypes.cstPKCS11, secKeyBlob, "123456", "*");
sftp.SSHUser = "test";
sftp.SSHLogon("myhost", 22);
```

|  |  |
| --- | --- |
| 0 (cstUser - default) | For Windows, this specifies that the certificate store is a certificate store owned by the current user. NOTE: This store type is not available in Java. |
| 1 (cstMachine) | For Windows, this specifies that the certificate store is a machine store. NOTE: This store type is not available in Java. |
| 2 (cstPFXFile) | The certificate store is the name of a PFX (PKCS#12) file containing certificates. |
| 3 (cstPFXBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in PFX (PKCS#12) format. |
| 4 (cstJKSFile) | The certificate store is the name of a Java Key Store (JKS) file containing certificates. NOTE: This store type is only available in Java. |
| 5 (cstJKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in Java Key Store (JKS) format. NOTE: This store type is only available in Java. |
| 6 (cstPEMKeyFile) | The certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate. |
| 7 (cstPEMKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a private key and an optional certificate. |
| 8 (cstPublicKeyFile) | The certificate store is the name of a file that contains a PEM- or DER-encoded public key certificate. |
| 9 (cstPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a PEM- or DER-encoded public key certificate. |
| 10 (cstSSHPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains an SSH-style public key. |
| 11 (cstP7BFile) | The certificate store is the name of a PKCS#7 file containing certificates. |
| 12 (cstP7BBlob) | The certificate store is a string (binary) representing a certificate store in PKCS#7 format. |
| 13 (cstSSHPublicKeyFile) | The certificate store is the name of a file that contains an SSH-style public key. |
| 14 (cstPPKFile) | The certificate store is the name of a file that contains a PPK (PuTTY Private Key). |
| 15 (cstPPKBlob) | The certificate store is a string (binary) that contains a PPK (PuTTY Private Key). |
| 16 (cstXMLFile) | The certificate store is the name of a file that contains a certificate in XML format. |
| 17 (cstXMLBlob) | The certificate store is a string that contains a certificate in XML format. |
| 18 (cstJWKFile) | The certificate store is the name of a file that contains a JWK (JSON Web Key). |
| 19 (cstJWKBlob) | The certificate store is a string that contains a JWK (JSON Web Key). |
| 21 (cstBCFKSFile) | The certificate store is the name of a file that contains a BCFKS (Bouncy Castle FIPS Key Store). NOTE: This store type is only available in Java and .NET. |
| 22 (cstBCFKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in BCFKS (Bouncy Castle FIPS Key Store) format. NOTE: This store type is only available in Java and .NET. |
| 23 (cstPKCS11) | The certificate is present on a physical security key accessible via a PKCS#11 interface. To use a security key, create a new [Certificate](#Type_Certificate) object and pass cstPKCS11 as the [ssl_server_cert_store_type](#ssl_server_cert_store_type-property-googlesheets-struct), the full path of the PKCS#11 DLL as the [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct), and the PIN as the [ssl_server_cert_store_password](#ssl_server_cert_store_password-property-googlesheets-struct). Code Example. SSH Authentication with Security Key (without CertMgr): Alternatively, collect the necessary data using the [CertMgr](#CertMgr) struct by calling the [list_store_certificates](#CertMgr_m_ListStoreCertificates) method after setting the corresponding properties accordingly. The certificate information returned in the [on_cert_list](#CertMgr_e_CertList) event's CertEncoded parameter may be saved for later use. When using a certificate obtained with this approach, pass the previously saved security key information as the [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) and set [ssl_server_cert_store_password](#ssl_server_cert_store_password-property-googlesheets-struct) to the PIN. Code Example. SSH Authentication with Security Key (with CertMgr): |
| 99 (cstAuto) | The store type is automatically detected from the input data. This setting may be used with both public and private keys and can detect any of the supported formats automatically. |

This property is read-only.

## Data Type

i32

# ssl_server_cert_subject_alt_names property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Comma-separated lists of alternative subject names for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_subject_alt_names(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

Comma-separated lists of alternative subject names for the certificate.

This property is read-only.

## Data Type

String

# ssl_server_cert_thumbprint_md5 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The MD5 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_thumbprint_md5(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The MD5 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_server_cert_thumbprint_sha1 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-1 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_thumbprint_sha1(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-1 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_server_cert_thumbprint_sha256 property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The SHA-256 hash of the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_thumbprint_sha256(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The SHA-256 hash of the certificate. It is primarily used for X.509 certificates. If the hash does not already exist, it is automatically computed.

This property is read-only.

## Data Type

String

# ssl_server_cert_usage property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The text description of UsageFlags .

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_usage(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The text description of [ssl_server_cert_usage_flags](#ssl_server_cert_usage_flags-property-googlesheets-struct).

This value will be one or more of the following strings and will be separated by commas:

- Digital Signature
- Non-Repudiation
- Key Encipherment
- Data Encipherment
- Key Agreement
- Certificate Signing
- CRL Signing
- Encipher Only

If the provider is OpenSSL, the value is a comma-separated list of X.509 certificate extension names.

This property is read-only.

## Data Type

String

# ssl_server_cert_usage_flags property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The flags that show intended use for the certificate.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_usage_flags(&self ) -> Result<i32, CloudSheetsError>
```

## Default Value

0

## Remarks

The flags that show intended use for the certificate. The value of [ssl_server_cert_usage_flags](#ssl_server_cert_usage_flags-property-googlesheets-struct) is a combination of the following flags:

|  |  |
| --- | --- |
| 0x80 | Digital Signature |
| 0x40 | Non-Repudiation |
| 0x20 | Key Encipherment |
| 0x10 | Data Encipherment |
| 0x08 | Key Agreement |
| 0x04 | Certificate Signing |
| 0x02 | CRL Signing |
| 0x01 | Encipher Only |

Please see the [ssl_server_cert_usage](#ssl_server_cert_usage-property-googlesheets-struct) property for a text representation of [ssl_server_cert_usage_flags](#ssl_server_cert_usage_flags-property-googlesheets-struct).

This functionality currently is not available when the provider is OpenSSL.

This property is read-only.

## Data Type

i32

# ssl_server_cert_version property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate's version number.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_version(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate's version number. The possible values are the strings "V1", "V2", and "V3".

This property is read-only.

## Data Type

String

# ssl_server_cert_subject property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The subject of the certificate used for client authentication.

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_subject(&self ) -> Result<String, CloudSheetsError>
```

## Default Value

""

## Remarks

The subject of the certificate used for client authentication.

This property must be set after all other certificate properties are set. When this property is set, a search is performed in the current certificate store to locate a certificate with a matching subject.

If a matching certificate is found, the property is set to the full subject of the matching certificate.

If an exact match is not found, the store is searched for subjects containing the value of the property.

If a match is still not found, the property is set to an empty string, and no certificate is selected.

The special value "*" picks a random certificate in the certificate store.

The certificate subject is a comma-separated list of distinguished name fields and values. For instance, "CN=www.server.com, OU=test, C=US, E=example@email.com". Common fields and their meanings are as follows:

| Field | Meaning |
| --- | --- |
| CN | Common Name. This is commonly a hostname like www.server.com. |
| O | Organization |
| OU | Organizational Unit |
| L | Locality |
| S | State |
| C | Country |
| E | Email Address |

If a field value contains a comma, it must be quoted.

This property is read-only.

## Data Type

String

# ssl_server_cert_encoded property ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

The certificate (PEM/Base64 encoded).

## Syntax

*Rust Syntax*

```text
fn ssl_server_cert_encoded(&self ) -> Result<Vec<u8>, CloudSheetsError>
```

## Default Value

""

## Remarks

The certificate (PEM/Base64 encoded). This property is used to assign a specific certificate. The [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) and [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) properties also may be used to specify a certificate.

When [ssl_server_cert_encoded](#ssl_server_cert_encoded-property-googlesheets-struct) is set, a search is initiated in the current [ssl_server_cert_store](#ssl_server_cert_store-property-googlesheets-struct) for the private key of the certificate. If the key is found, [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) is updated to reflect the full subject of the selected certificate; otherwise, [ssl_server_cert_subject](#ssl_server_cert_subject-property-googlesheets-struct) is set to an empty string.

This property is read-only.

## Data Type

Vec

# add_columns method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

This method adds one or more columns at the end of the sheet.

## Syntax

*Rust Syntax*

```text
fn add_columns(&self, count : i32) -> Result<(), CloudSheetsError>
```

## Remarks

Adds a number of columns at the end of the sheet specified by *Count*.

[load_sheet](#load_sheet-method-googlesheets-struct) should be called before calling this method.

add_columns will still add a column at the end of the sheet even if only a specific range is loaded using [load_range](#load_range-method-googlesheets-struct), disregarding the loaded range.

**Example (Add columns to a sheet)**

```csharp
gsheets.LoadSpreadsheet(spreadsheetId);
gsheets.LoadSheet(sheetId);

gsheets.Sheets[0].TotalColumnCount = 5;
gsheets.Sheets[0].TotalRowCount = 20;

gsheets.UpdateSheet();

gsheets.AddColumns(15);
```

# add_rows method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

This method adds one or more rows at the end of the sheet.

## Syntax

*Rust Syntax*

```text
fn add_rows(&self, count : i32) -> Result<(), CloudSheetsError>
```

## Remarks

Adds a number of rows at the end of the sheet specified by *Count*. [load_sheet](#load_sheet-method-googlesheets-struct) should be called before calling this method. add_rows will still add a row at the end of the sheet even if only a specific range is loaded using [load_range](#load_range-method-googlesheets-struct), disregarding the loaded range.

**Example (Add rows to a sheet)**

```csharp
gsheets.LoadSpreadsheet(spreadsheetId);
gsheets.LoadSheet(sheetId);

gsheets.Sheets[0].TotalColumnCount = 20;
gsheets.Sheets[0].TotalRowCount = 10;

gsheets.UpdateSheet();

gsheets.AddRows(10);
```

# add_sheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Adds a new sheet at a given index.

## Syntax

*Rust Syntax*

```text
fn add_sheet(&self, index : i32, title : &str) -> Result<(), CloudSheetsError>
```

## Remarks

When this method is called a new sheet is added at the specified index, and all other subsequent sheets are incremented.

*Index* defines the index for the sheet.

*Title* sets the name for the new Sheet.

If you need to modify additional properties of the newly added sheet or customize it even further, call [load_sheet](#load_sheet-method-googlesheets-struct), modify the desired properties, then call [update_sheet](#update_sheet-method-googlesheets-struct).

**Example (Adding a New Sheet)**

```csharp
gsheets.LoadSpreadsheet(spreadsheetId);     //This spreadsheet has 5 sheets

gsheets.AddSheet(3, "New Sheet");   //Sheet 4 (previously at index 3) and sheet 5 will be moved to the right

gsheets.AddSheet(gsheets.Sheets.Count - 1, "Last Sheet")    //No sheets will be moved, new sheet will be added at the end
```

# authorize method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Get the authorization string required to access the protected resource.

## Syntax

*Rust Syntax*

```text
fn authorize(&self) -> Result<(), CloudSheetsError>
```

## Remarks

This method is used to get an access token that is required to access the protected resource. The method will act differently based on what is set in the [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) property and the [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) property. This method is **not** to be used in conjunction with the [authorization](#authorization-property-googlesheets-struct) property. It should instead be used when setting the o_auth property.

For more information, see the introduction section.

# clear method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Clears all the values of the loaded range or sheet.

## Syntax

*Rust Syntax*

```text
fn clear(&self) -> Result<(), CloudSheetsError>
```

## Remarks

This method will only clear the values of the loaded range or sheet. Before calling this method, either [load_range](#load_range-method-googlesheets-struct) or [load_sheet](#load_sheet-method-googlesheets-struct) should be called.

**Example (Clear a Sheet or Range)**

```csharp
gsheets.LoadRange(sheetId, "A1:C8");
gsheets.Clear();    //Only the specified loaded range will have their cell values clear

gsheets.LoadSheet(sheetId);
gsheets.Clear();    //All values in the sheet will be cleared
```

# config method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Sets or retrieves a configuration setting.

## Syntax

*Rust Syntax*

```text
fn config(&self, configuration_string : &str) ->  Result<String, CloudSheetsError>
```

## Remarks

config is a generic method available in every struct. It is used to set and retrieve [configuration settings](#config-settings-googlesheets-struct) for the struct.

These settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the struct, access to these *internal properties* is provided through the config method.

To set a configuration setting named *PROPERTY*, you must call *Config("PROPERTY=VALUE")*, where *VALUE* is the value of the setting expressed as a string. For boolean values, use the strings "True", "False", "0", "1", "Yes", or "No" (case does not matter).

To read (query) the value of a [configuration setting](#config-settings-googlesheets-struct), you must call *Config("PROPERTY")*. The value will be returned as a string.

# create_spreadsheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Creates a new spreadsheet on the server.

## Syntax

*Rust Syntax*

```text
fn create_spreadsheet(&self, name : &str, locale : &str, time_zone : &str) -> Result<(), CloudSheetsError>
```

## Remarks

This method is responsible for creating a new spreadsheet, the method takes three parameters. The first parameter, *Name* is the name of the new spreadsheet to be created. The second parameter, *Locale* determines the locale of the spreadsheet, when setting the *Locale* parameter, the following formats are supported:

-  ISO 639-1 language code
-  ISO 639-2 language code such as **fil** if no 639-1 code exists
-  Combination of the ISO language code and country code

 The third parameter is *Timezone* which will set the time zone of the spreadsheet, can be in CLDR format such as **America/New_York**, in the cases when the time zone is not recognized a custom time zone is accepted, such as **GMT-07:00**. When the spreadsheet is created it will be saved and found at the root of Google Drive.

**Example (Create new Spreadsheet)**

```csharp
// Specifying all parameters when creating spreadsheet
gsheets.CreateSpreadsheet("NewSpreadsheet", "en_US", "UTC-03:00");

// Only pass the name
gsheets.CreateSpreadsheet("NewSpreadsheet", "", "");
```

# delete_column method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Deletes a column at the specified index.

## Syntax

*Rust Syntax*

```text
fn delete_column(&self, index : i32) -> Result<(), CloudSheetsError>
```

## Remarks

Call the method when a sheet or range is loaded to delete a column specified *Index* .

The Index is zero based according to the beginning of a sheet, not a loaded range (see [cell_column_index](#cell_column_index-property-googlesheets-struct)). If the requested index is outside the loaded range an error will be thrown.

**Example (Delete a column)**

```csharp
// Delete a column after loading a sheet

int sheetId = gsheets.Sheets[0].SheetId;

gsheets.LoadSheet(sheetId);

gsheets.DeleteColumn(3);    // Delete column "D"

// Delete a column after loading a range

gsheets.LoadRange(sheetId, "D10:F10");

gsheets.DeleteColumn(2);    // Index is outside the loaded range (Column C)

gsheets.DeleteColumn(4);    // Deletion is successful
```

# delete_row method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Deletes a row at the given index.

## Syntax

*Rust Syntax*

```text
fn delete_row(&self, index : i32) -> Result<(), CloudSheetsError>
```

## Remarks

*Index* specifies the row that will be deleted.

When a row is deleted, the loaded worksheet or range will shrink. The *Index* is zero-based relative to the beginning of the worksheet, not the loaded range (see [cell_row_index](#cell_row_index-property-googlesheets-struct)). If the requested index is outside the loaded range or worksheet, an error will be thrown.

**Example (Delete a row)**

```csharp
// Delete a row after loading a sheet

int sheetId = gsheets.Sheets[0].SheetId;

gsheets.LoadSheet(sheetId);

gsheets.DeleteRow(3);    // Delete 4th row

// Delete a row after loading a range

gsheets.LoadRange(sheetId, "A1:F10");

gsheets.DeleteRow(12);    // Index is outside the loaded range (13th row)

gsheets.DeleteRow(4);    // Deletion is successful
```

# delete_sheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Delete the sheet with given SheetId.

## Syntax

*Rust Syntax*

```text
fn delete_sheet(&self, sheet_id : i32) -> Result<(), CloudSheetsError>
```

## Remarks

This method deletes a sheet identified by *SheetId*. The deleted sheet is deleted permanently.

# delete_spreadsheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Delete the spreadsheet with the given Id.

## Syntax

*Rust Syntax*

```text
fn delete_spreadsheet(&self, id : &str) -> Result<(), CloudSheetsError>
```

## Remarks

*Id* specifies the Id of the spreadsheet that will be deleted.

When delete_spreadsheet is called the spreadsheet is deleted permanently, the spreadsheet is also removed from the spreadsheets collection.

# export method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Exports the spreadsheet to a local file using mime type according to the filename extension.

## Syntax

*Rust Syntax*

```text
fn export(&self, spreadsheet_id : &str, local_filename : &str) -> Result<(), CloudSheetsError>
```

## Remarks

Export the spreadsheet as a local file. The *SpreadsheetId* specified the Id of the Spreadsheet that will be exported. The *LocalFilename* represents the path to where the file will be saved, including the filename and extension, the latter determines the file type. *LocalFilename* can be a relative path, the name of file and extension are required. The valid extensions are: csv, ods, pdf, tsv, xlsx, zip.

**Example (Export a spreadsheet)**

```csharp
string spreadsheetId = gsheets.Spreadsheets[0].Id;

// Providing only filename and extension
gsheets.Export(spreadsheetId, "January25.pdf");     // Spreadsheet will be saved in current directory

// Providing full path
gsheets.Export(spreadsheetId, "..\\..\\March25.pdf");
```

# insert_column method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Inserts a single empty column at the index specified.

## Syntax

*Rust Syntax*

```text
fn insert_column(&self, index : i32) -> Result<(), CloudSheetsError>
```

## Remarks

Use the insert_column to insert a column anywhere in the sheet, *Index* determines the index at which the column will be inserted. When a column is inserted, the loaded range or sheet will be extended using the cell attributes from the existing column at the index. Note that the index is zero based according to the beginning of the sheet, not a loaded range (see [cell_column_index](#cell_column_index-property-googlesheets-struct)). If the requested index is outside the loaded range or sheet, an error will be thrown.

**Example (Insert a column after loading a range)**

```csharp
// Load the first 6 columns (A-F)
gsheets.LoadRange(sheetId, "A1:F10");

gsheet.ColumnCount;     // Column count is 6

// Insert a column
gsheets.InsertColumn(3);

gsheets.ColumnCount;    // Column count is 7, the range is extended
```

# insert_row method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Inserts a single empty row at the index specified.

## Syntax

*Rust Syntax*

```text
fn insert_row(&self, index : i32) -> Result<(), CloudSheetsError>
```

## Remarks

Use the insert_row to insert a row anywhere in the sheet, the *Index* parameter determines the index at which the row will be inserted.

When a row is inserted, the loaded range or sheet will be extended using the cell attributes from the existing row at the index. Note that the index is zero based according to the beginning of the sheet, not a loaded range (see [cell_row_index](#cell_row_index-property-googlesheets-struct)). If the requested index is outside the loaded range or sheet, an error will be thrown.

**Example (Insert a row after loading a range)**

```csharp
// Load 20 rows
gsheets.LoadRange(sheetId, "A1:A20");

gsheet.RowCount;     // Row count is 20

// Insert a row
gsheets.InsertRow(10);

gsheets.RowCount;    // Row count is 21, the range is extended
```

# interrupt method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Interrupt the current method.

## Syntax

*Rust Syntax*

```text
fn interrupt(&self) -> Result<(), CloudSheetsError>
```

## Remarks

If there is no method in progress, interrupt simply returns, doing nothing.

# list_spreadsheets method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Lists the spreadsheets.

## Syntax

*Rust Syntax*

```text
fn list_spreadsheets(&self) -> Result<(), CloudSheetsError>
```

## Remarks

Lists all spreadsheets associated with the current user. The retrieved spreadsheets are added to the spreadsheets properties, which is cleared before being repopulated with the latest data. For each spreadsheet retrieved, the [on_spreadsheet_list](#on_spreadsheet_list-event-googlesheets-struct) event is fired.

# load_range method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Load the specified range of cells in the sheet.

## Syntax

*Rust Syntax*

```text
fn load_range(&self, sheet_id : i32, range : &str) -> Result<(), CloudSheetsError>
```

## Remarks

*SheetId* is used to specify the sheet to be partially loaded.

*Range* specifies the range which will be loaded. This uses 'A1:B2' notation.

When load_range is called the loaded sheet is set as the first one in the sheets collection.

If an attempt to access cells outside the loaded range is made, an error with be thrown.

**Example (Load a specific range)**

```csharp
gsheets.LoadRange(sheetId, "A10:D20");    // Loading rows from 10 to 20 and columns from A to D

gsheets.Cell = "A13";   // Any cells within A10:D20 can be modified and updated
gsheets.CellValue = "13th row";

gsheets.UpdateSheet();
```

# load_sheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Load the sheet's data (all cells).

## Syntax

*Rust Syntax*

```text
fn load_sheet(&self, sheet_id : i32) -> Result<(), CloudSheetsError>
```

## Remarks

This method loads the entire sheet, the loaded sheet is set as the first in the sheets collection.

 Use [update_sheet](#update_sheet-method-googlesheets-struct), [insert_row](#insert_row-method-googlesheets-struct), [clear](#clear-method-googlesheets-struct) or the [cell](#cell-property-googlesheets-struct) properties to modify and update the sheet or its cells.

# load_spreadsheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Load the spreadsheet properties and the sheets list from the server.

## Syntax

*Rust Syntax*

```text
fn load_spreadsheet(&self, id : &str) -> Result<(), CloudSheetsError>
```

## Remarks

This method is used to load a single spreadsheet in the spreadsheets collection, together with all its sheets and properties. If other spreadsheets exist in the collection because [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) has been called before, calling load_spreadsheet will set the specified spreadsheet at the first index in the collection. Spreadsheet properties can be modified, to update it's properties call [update_spreadsheet](#update_spreadsheet-method-googlesheets-struct)

# reset method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

This method will reset the struct.

## Syntax

*Rust Syntax*

```text
fn reset(&self) -> Result<(), CloudSheetsError>
```

## Remarks

This method will reset the struct's properties to their default values.

# send_custom_request method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Send a custom HTTP request.

## Syntax

*Rust Syntax*

```text
fn send_custom_request(&self, http_method : &str, url : &str, post_data : &str) -> Result<(), CloudSheetsError>
```

## Remarks

This method can be used to send a custom HTTP request to the server.

**Example (Send a custom request): **

```text
String data = @"{
 ""properties"": {
  ""title"": ""My new spreadsheet""
 }
}";
String url = "https://sheets.googleapis.com/v4/spreadsheets";

gsheets.SendCustomRequest("POST", url, data);
```

# update_sheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Update the current loaded sheet properties and the cells data.

## Syntax

*Rust Syntax*

```text
fn update_sheet(&self) -> Result<(), CloudSheetsError>
```

## Remarks

Call the update_sheet method after making changes to the sheet properties or the cell data. This method takes no parameters and uses the values of the first sheet in the sheets collection. Once update_sheet is called, it will automatically get back the range or sheet data with updated values.

**Example (Updating a sheet)**

```csharp
// Load the sheet we want to update
gsheets.LoadSheet(sheetId);

// Modify sheet properties
gsheets.Sheets[0].Title = "NewUpdatedTitle";
gsheets.Sheets[0].RightToLeft = true;
gsheets.Sheets[0].HideGridlines = true;
gsheets.Sheets[0].TotalColumnCount = 5;
gsheets.Sheets[0].TotalRowCount = 20;

gsheets.Cell = "A5";
gsheets.CellValue = "Jenny";
gsheets.CellNote = "Random note";

gsheets.UpdateSheet();    // Update sheet after modifying properties and/or cells
```

# update_spreadsheet method ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Updates properties of a spreadsheet.

## Syntax

*Rust Syntax*

```text
fn update_spreadsheet(&self) -> Result<(), CloudSheetsError>
```

## Remarks

This method targets the values of the first spreadsheet in the spreadsheets collection.

**Example (Update a spreadsheet)**

```csharp
// Load the spreadsheet
gsheets.LoadSpreadsheet(spreadsheetId);
// Set updated values
gsheets.Spreadsheets[0].Name = "UpdatedSpreadsheet";
gsheets.Spreadsheets[0].Timezone = "Etc/GMT";

gsheets.UpdateSpreadsheet();
```

# on_error event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired when information is available about errors during data delivery.

## Syntax

*Rust Syntax*

```text
// GoogleSheetsErrorEventArgs carries the GoogleSheets Error event's parameters.
pub struct GoogleSheetsErrorEventArgs {
  fn error_code(&self) -> i32
  fn description(&self) -> &String
}

// GoogleSheetsErrorEvent defines the signature of the GoogleSheets Error event's handler function.
pub trait GoogleSheetsErrorEvent {
  fn on_error(&self, sender : GoogleSheets, e : &mut GoogleSheetsErrorEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_error(&self) -> &'a dyn GoogleSheetsErrorEvent;
  pub fn set_on_error(&mut self, value : &'a dyn GoogleSheetsErrorEvent);
  ...
}
```

## Remarks

The on_error event is fired in case of exceptional conditions during message processing. Normally the struct fails with an error.

The *error_code* parameter contains an error code, and the *description* parameter contains a textual description of the error. For a list of valid error codes and their descriptions, please refer to the [Error Codes](#trappable-errors-googlesheets-struct) section.

# on_log event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired once for each log message.

## Syntax

*Rust Syntax*

```text
// GoogleSheetsLogEventArgs carries the GoogleSheets Log event's parameters.
pub struct GoogleSheetsLogEventArgs {
  fn log_level(&self) -> i32
  fn message(&self) -> &String
  fn log_type(&self) -> &String
}

// GoogleSheetsLogEvent defines the signature of the GoogleSheets Log event's handler function.
pub trait GoogleSheetsLogEvent {
  fn on_log(&self, sender : GoogleSheets, e : &mut GoogleSheetsLogEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_log(&self) -> &'a dyn GoogleSheetsLogEvent;
  pub fn set_on_log(&mut self, value : &'a dyn GoogleSheetsLogEvent);
  ...
}
```

## Remarks

This event is fired once for each log message generated by the struct. The verbosity is controlled by the [LogLevel](#LogLevel) setting.

*log_level* indicates the level of message. Possible values are as follows:

|  |  |
| --- | --- |
| 0 (None) | No events are logged. |
| 1 (Info - default) | Informational events are logged. |
| 2 (Verbose) | Detailed data are logged. |
| 3 (Debug) | Debug data are logged. |

The value 1 (Info) logs basic information, including the URL, HTTP version, and status details.

The value 2 (Verbose) logs additional information about the request and response.

The value 3 (Debug) logs the headers and body for both the request and response, as well as additional debug information (if any).

*message* is the log entry.

*log_type* identifies the type of log entry. Possible values are as follows:

- "Info"
- "RequestHeaders"
- "ResponseHeaders"
- "RequestBody"
- "ResponseBody"
- "ProxyRequest"
- "ProxyResponse"
- "FirewallRequest"
- "FirewallResponse"

# on_spreadsheet_list event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired when a spreadsheet is retrieved from the server.

## Syntax

*Rust Syntax*

```text
// GoogleSheetsSpreadsheetListEventArgs carries the GoogleSheets SpreadsheetList event's parameters.
pub struct GoogleSheetsSpreadsheetListEventArgs {
  fn id(&self) -> &String
  fn name(&self) -> &String
}

// GoogleSheetsSpreadsheetListEvent defines the signature of the GoogleSheets SpreadsheetList event's handler function.
pub trait GoogleSheetsSpreadsheetListEvent {
  fn on_spreadsheet_list(&self, sender : GoogleSheets, e : &mut GoogleSheetsSpreadsheetListEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_spreadsheet_list(&self) -> &'a dyn GoogleSheetsSpreadsheetListEvent;
  pub fn set_on_spreadsheet_list(&mut self, value : &'a dyn GoogleSheetsSpreadsheetListEvent);
  ...
}
```

## Remarks

The on_spreadsheet_list event is fired for each spreadsheet retrieved from the server when [list_spreadsheets](#list_spreadsheets-method-googlesheets-struct) is called.

# on_ssl_server_authentication event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired after the server presents its certificate to the client.

## Syntax

*Rust Syntax*

```text
// GoogleSheetsSSLServerAuthenticationEventArgs carries the GoogleSheets SSLServerAuthentication event's parameters.
pub struct GoogleSheetsSSLServerAuthenticationEventArgs {
  fn cert_encoded(&self) -> &[u8]
  fn cert_subject(&self) -> &String
  fn cert_issuer(&self) -> &String
  fn status(&self) -> &String
  fn accept(&self) -> bool
  fn set_accept(&self, value : bool)
}

// GoogleSheetsSSLServerAuthenticationEvent defines the signature of the GoogleSheets SSLServerAuthentication event's handler function.
pub trait GoogleSheetsSSLServerAuthenticationEvent {
  fn on_ssl_server_authentication(&self, sender : GoogleSheets, e : &mut GoogleSheetsSSLServerAuthenticationEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_ssl_server_authentication(&self) -> &'a dyn GoogleSheetsSSLServerAuthenticationEvent;
  pub fn set_on_ssl_server_authentication(&mut self, value : &'a dyn GoogleSheetsSSLServerAuthenticationEvent);
  ...
}
```

## Remarks

During this event, the client can decide whether or not to continue with the connection process. The *accept* parameter is a recommendation on whether to continue or close the connection. This is just a suggestion: application software must use its own logic to determine whether or not to continue.

 When *accept* is False, *status* shows why the verification failed (otherwise, *status* contains the string *OK*). If it is decided to continue, you can override and accept the certificate by setting the *accept* parameter to True.

# on_ssl_status event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired when secure connection progress messages are available.

## Syntax

*Rust Syntax*

```text
// GoogleSheetsSSLStatusEventArgs carries the GoogleSheets SSLStatus event's parameters.
pub struct GoogleSheetsSSLStatusEventArgs {
  fn message(&self) -> &String
}

// GoogleSheetsSSLStatusEvent defines the signature of the GoogleSheets SSLStatus event's handler function.
pub trait GoogleSheetsSSLStatusEvent {
  fn on_ssl_status(&self, sender : GoogleSheets, e : &mut GoogleSheetsSSLStatusEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_ssl_status(&self) -> &'a dyn GoogleSheetsSSLStatusEvent;
  pub fn set_on_ssl_status(&mut self, value : &'a dyn GoogleSheetsSSLStatusEvent);
  ...
}
```

## Remarks

The event is fired for informational and logging purposes only. This event tracks the progress of the connection.

# on_transfer event ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

Fired while a document transfers (delivers document).

## Syntax

*Rust Syntax*

```text
// GoogleSheetsTransferEventArgs carries the GoogleSheets Transfer event's parameters.
pub struct GoogleSheetsTransferEventArgs {
  fn direction(&self) -> i32
  fn bytes_transferred(&self) -> i64
  fn percent_done(&self) -> i32
  fn text(&self) -> &[u8]
}

// GoogleSheetsTransferEvent defines the signature of the GoogleSheets Transfer event's handler function.
pub trait GoogleSheetsTransferEvent {
  fn on_transfer(&self, sender : GoogleSheets, e : &mut GoogleSheetsTransferEventArgs);
}

impl <'a> GoogleSheets<'a> {
  pub fn on_transfer(&self) -> &'a dyn GoogleSheetsTransferEvent;
  pub fn set_on_transfer(&mut self, value : &'a dyn GoogleSheetsTransferEvent);
  ...
}
```

## Remarks

The *text* parameter contains the portion of the document text being received. It is empty if data are being posted to the server.

The *bytes_transferred* parameter contains the number of bytes transferred in this *direction* since the beginning of the document text (excluding HTTP response headers).

The *Direction* parameter shows whether the client (0) or the server (1) is sending the data.

The *PercentDone* parameter shows the progress of the transfer in the corresponding direction. If *PercentDone* can not be calculated the value will be -1.

NOTE: Events are not re-entrant. Performing time-consuming operations within this event will prevent it from firing again in a timely manner and may affect overall performance.

# Config Settings ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

 The struct accepts one or more of the following *configuration settings*. Configuration settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the struct, access to these *internal properties* is provided through the [config](#config-method-googlesheets-struct) method.

### GoogleSheets Config Settings

**SpreadsheetsPageSize**: Page size limit for fetching spreadsheets.This setting specifies the spreadsheets page size, or the maximum number of spreadsheets that will be fetched from the server in one get call.

The default value is *100*.

**XChildCount**: The number of child elements of the current element.This configuration settings specifies the number of child attributes of the current element. The XChild configuration settings will be indexed from 0 to ([XChildCount](#XChildCount) - 1).

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XChildName[i]**: The name of the child element.This configuration setting provides the name of the i-th child element of the current element.

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XChildXText[i]**: The inner text of the child element.This configuration setting provides the inner text of the i-th child element of the current element.

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XElement**: The name of the current element.This configuration setting provides the name of the current element.

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XParent**: The parent of the current element.This configuration setting provides the parent of the current element.

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XPath**: Provides a way to point to a specific element in the returned XML or JSON response.The [XPath](#XPath) setting allows you to point to specific elements in the XML or JSON response.

When [XPath](#XPath) is set to a valid path, [XElement](#XElement) points to the name of the element, with [XText](#XText), [XParent](#XParent), [XSubTree](#XSubTree), [XChildCount](#XChildCount), [XChildName\[i\]](#XChildName[i]), and [XChildXText\[i\]](#XChildXText[i]) providing other properties of the element.

XPath syntax is available for both XML and JSON documents. An XPath is a series of one or more element accessors separated by the */* character, for example, */A/B/C/D*. An XPath can be absolute (i.e., it starts with */*), or it can be relative to the current [XPath](#XPath) location.

The following are possible values for an element accessor, which operates relative to the current location specified by the XPath accessors, which proceed it in the overall XPath string:

| Accessor | Description |
| --- | --- |
| name | The first element with a particular name. Can be *. |
| [i] | The i-th element. |
| name[i] | The i-th element with a particular name. |
| [last()] | The last element. |
| [last()-i] | The element i before the last element. |
| name[@attrname="attrvalue"] | The first element with a particular name that contains the specified attribute-value pair. Supports single and double quotes. (XML Only) |
| . | The current element. |
| .. | The parent element. |

 NOTE: XPath indices are *1-based*.

For example, assume the following XML and JSON responses.

XML:

```text
<firstlevel>
  <one>value</one>
  <two>
    <item>first</item>
    <item>second</item>
  </two>
  <three>value three</three>
</firstlevel>
```

JSON:

```text
{
  "firstlevel": {
    "one": "value",
    "two": ["first", "second"],
    "three": "value three"
  }
}
```

The following are examples of valid XPaths for these responses:

| Description | XML XPath | JSON XPath |
| --- | --- | --- |
| Document root | / | /json |
| Specific element | /firstlevel/one | /json/firstlevel/one |
| i-th child | /firstlevel/two/item[2] | /json/firstlevel/two/[2] |

This list is not exhaustive, but it provides a general idea of the possibilities.

**XSubTree**: A snapshot of the current element in the document.This configuration setting provides the entirety of the current element (including its subelements).

The current element is specified through the [XPath](#XPath) configuration setting. This configuration setting is read-only.

**XText**: The text of the current element.This configuration setting provides the inner text of the current element.

The current element is specified in the [XPath](#XPath) configuration setting. This configuration setting is read-only.

### OAuth Config Settings

**OAuthAccessTokenExpiration**: The lifetime of the access token.This setting holds the lifetime of the access token in seconds. For instance the value *3600* indicates that the token will expire in one hour from the time it was generated.

**OAuthAuthorizationTokenType**: The type of access token returned.The applicable values include the following:

|  |  |
| --- | --- |
| Bearer (default) | When the access token returned by the server is a Bearer type, the authorization string returned by [authorize](#authorize-method-googlesheets-struct) will be in the format "Bearer access_token". This can be supplied as the value of the HTTP Authorization header. |

**OAuthAutomaticRefresh**: Whether or not to refresh an expired access token automatically.When this setting is set to *true* and the [authorization](#authorization-property-googlesheets-struct) property is not set, the struct will automatically get a new access token if it has the necessary properties to do so without user interaction.

For example, when using the Authorization Code grant type, the [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct) property should be set to a valid refresh token. When using the Client Credential grant type however, the struct does not need any additional properties set as it can already get a new access token without user interaction.

**OAuthBrowserResponseTimeout**: Specifies the amount of time to wait for a response from the browser.This setting specifies the amount of time (in seconds) the struct will wait for a response from the browser when requesting user authentication. The default value is *0*, meaning that the struct will wait indefinitely.

**OAuthIncludeEmptyRedirectURI**: Whether an empty redirect_uri parameter is included in requests.This setting specifies whether *redirect_uri* is included in the request made by [authorize](#authorize-method-googlesheets-struct) if it is empty.

If set to *true* (default) the *redirect_uri* will be sent in all cases. If set to *false* the *redirect_uri* will only be sent if it has a value.

**OAuthJWTPayload**: The payload of the JWT access token if present.This configuration setting provides the payload section of a JWT access token if the access token is a JWT and the struct is able to parse out the payload section. This setting only applies to **access tokens** that are returned from a service provider after successfully authorizing and authenticating with the service.

To parse the payload for specific claims, see [OAuthJWTXPath](#OAuthJWTXPath).

**OAuthJWTXChildCount**: The number of child elements of the current element.The number of child attributes of the current element. The OAuthJWTXChildCount configuration settings will be indexed from 0 to ([OAuthJWTXChildCount](#OAuthJWTXChildCount) - 1).

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OauthJWTXChildName[i]**: The name of the child element.Provides the name of the i'th child element of the current element.

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OAuthJWTXChildXText[i]**: The inner text of the child element.Provides the inner text of the i'th child element of the current element.

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OAuthJWTXElement**: The name of the current element.Provides the name of the current element.

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OauthJWTXParent**: The parent of the current element.Provides the parent of the current element.

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OAuthJWTXPath**: Provides a way to point to a specific element in the returned payload of a JWT based access token.The [OAuthJWTXPath](#OAuthJWTXPath) setting allows you to point to specific claims within the payload of a JWT based access token.

XPath syntax is available for the payload of JWT based access tokens if available. An XPath is a series of one or more element accessors separated by the */* character, for example: */A/B/C/D*.

The following are possible values for an element accessor, which operates relative to the current location specified by the XPath accessors which proceed it in the overall XPath string:

| Accessor | Description |
| --- | --- |
| name | The first element with a particular name. Can be *. |
| [i] | The i-th element. |
| name[i] | The i-th element with a particular name. |
| [last()] | The last element. |
| [last()-i] | The element i before the last element. |

 Here are some examples of valid XPaths and some common claims:

| Description | JSON XPath |
| --- | --- |
| Document root | /json |
| Specific element | /json/element_one |
| Username Claim (Microsoft Specific) | /json/preferred_username |
| Registered Application Name Claim (Microsoft Specific) | /json/app_displayname |

This is not an exhaustive list by any means, but should provide a general idea of the possibilities. To get the text of the specified element, see [OAuthJWTXText](#OAuthJWTXText).

**OAuthJWTXSubTree**: A snapshot of the current element in the document.Provides the entirety of the current element (including its sub-elements).

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OAuthJWTXText**: The text of the current element.Provides the inner text of the current element.

The current element is specified in the [OAuthJWTXPath](#OAuthJWTXPath) configuration setting. This configuration setting is read-only.

**OAuthParamCount**: Specifies the number of additional parameters variables to include in the request.This setting can be used to add query string parameters to the outgoing request. One common use for this method would be to add the "state" parameter to the request, which can be used when the [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) is cocpWeb to add user defined data. The authorization server will include the "state" parameter in the response and will be available in the post back to your server which will allow you to maintain state in your application. This is used in conjunction with OAuthParamName[i] and OAuthParamValue[i]. For instance:

```text
component.Config("OAuthParamCount=2");
component.Config("OAuthParamName[0]=myvar");
component.Config("OAuthParamValue[0]=myvalue");
component.Config("OAuthParamName[1]=testname");
component.Config("OAuthParamValue[1]=testvalue");
```

Additionally, this will also be updated to hold the parameters returned in the response.

```text
for (int i = 0; i < int.Parse(component.Config("OAuthParamCount")); i++)
{
  string name = component.Config("OAuthParamName[" + i + "]");
  string value = component.Config("OAuthParamValue[" + i + "]");
}
```

**OAuthParamName[i]**: Specifies the parameter name at the specified index.This setting can be used to retrieve or specify the parameter variable name at the index specified. See [OAuthParamCount](#OAuthParamCount) for details.

**OAuthParamValue[i]**: Specifies the parameter value at the specified index.This setting can be used to retrieve or specify the parameter variable value at the index specified. See [OAuthParamCount](#OAuthParamCount) for details.

**OAuthPasswordGrantUsername**: Used in the Resource Owner Password grant type.Used to set the username property when the [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct) is set to the password grant type and [authorize](#authorize-method-googlesheets-struct) is called.

**OAuthPKCEChallengeEncoding**: The PKCE code challenge method to use.This setting controls the PKCE code challenge method used when [OAuthUsePKCE](#OAuthUsePKCE) is set to *true*. Possible values are:

- 1 (Plain)
- 2 (S256/SHA256 - default)

**OAuthPKCEVerifier**: The PKCE verifier used to generate the challenge.This configuration setting when queried provides the PKCE verifier that is used to generate the PKCE challenge for the [authorize](#authorize-method-googlesheets-struct) method and the [o_auth_web_auth_url](#o_auth_web_auth_url-property-googlesheets-struct) field when [OAuthUsePKCE](#OAuthUsePKCE) is set to true. When using the cocpWeb [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct), the configuration setting can be set instead to allow the authorization request to be made from a different instance than the authentication (token) request.

**OAuthResetData**: Determines if the Reset method applies to the OAuth settings.If set to *true* (default), the [reset](#reset-method-googlesheets-struct) method will reset the OAuth settings including any authorization fields like [o_auth_access_token](#o_auth_access_token-property-googlesheets-struct) and [o_auth_refresh_token](#o_auth_refresh_token-property-googlesheets-struct). This means the [authorize](#authorize-method-googlesheets-struct) method must be called again to get new authorization information. When set to *false*, the [reset](#reset-method-googlesheets-struct) method will **not** reset the o_auth property and the OAuth* configuration settings. This allows for the struct to be reset without having to get authorization again.

**OAuthReUseWebServer**: Determines if the same server instance is used between requests.If set to *true* (default), the same embedded web server instance will be used for multiple requests. If set to *false* the embedded web server will be created and destroyed on each call to [authorize](#authorize-method-googlesheets-struct)

**OAuthTransferredRequest**: The full OAuth request last sent by the client.This configuration setting returns the full OAuth request last sent by the client. For performance reasons, the request is not normally saved. Set this configuration setting to ON before making a request to enable it. Following are examples of this request:

.NET

```text
Gmail gmail = new Gmail();
gmail.Config("OAuthTransferredRequest=on");
gmail.Authorize();
Console.WriteLine(gmail.Config("OAuthTransferredRequest"));
```

 C++

```text
Gmail gmail;
gmail.Config("OAuthTransferredRequest=on");
gmail.Authorize();
printf("%s\r\n", gmail.Config("OAuthTransferredRequest"));
```

**OAuthUsePKCE**: Specifies if PKCE should be used.If set to *true* (default), Proof Key for Code Exchange (PKCE) defined by RFC 7636 will be used when performing authorization. This setting applies when using the Authorization Code [o_auth_grant_type](#o_auth_grant_type-property-googlesheets-struct). The [OAuthPKCEChallengeEncoding](#OAuthPKCEChallengeEncoding) configuration setting can be used to control the code challenge method that will be used.

**OAuthWebServerActive**: Specifies and controls whether the embedded web server is active.The setting when queried will return the current state of the web server. If the webserver is active, it will return *"true"* and if it is inactive it will return *"false"*.

This setting can also be set to activate or deactivate the web server. Under normal circumstances, this would not be required as the struct will automatically start and stop the web server when [authorize](#authorize-method-googlesheets-struct) is called. In certain cases, it is required to start the webserver before calling [authorize](#authorize-method-googlesheets-struct). For example, if the [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct) needs to be set to a relay server, then you will need to start the web server manually. Another example would be when the [OAuthReUseWebServer](#OAuthReUseWebServer) is set to true, the server will not be automatically stopped, and this configuration setting must be set to *"false"* to stop the embedded web server.

**OAuthWebServerCertStore**: The certificate with private key to use when SSL is enabled.The name of the certificate store used for the embedded web server's SSL.

The [OAuthWebServerCertStoreType](#OAuthWebServerCertStoreType) property specifies the type of the certificate store specified by [OAuthWebServerCertStore](#OAuthWebServerCertStore). If the store is password protected, specify the password in [OAuthWebServerCertStorePassword](#OAuthWebServerCertStorePassword).

[OAuthWebServerCertStore](#OAuthWebServerCertStore) is used in conjunction with the [OAuthWebServerCertSubject](#OAuthWebServerCertSubject) property in order to specify the certificate to be used during SSL.

 Designations of certificate stores are platform dependent.

The following designations are the most common User and Machine certificate stores in Windows:

|  |  |
| --- | --- |
| MY | A certificate store holding personal certificates with their associated private keys. |
| CA | Certifying authority certificates. |
| ROOT | Root certificates. |

When the certificate store type is *cstPFXFile*, this property must be set to the name of the file. When the type is *cstPFXBlob*, the property must be set to the binary contents of a PFX file (i.e., PKCS#12 certificate store).

Note: This is required when [OAuthWebServerSSLEnabled](#OAuthWebServerSSLEnabled) is set to *true*.

**OAuthWebServerCertStorePassword**: The certificate with private key to use when SSL is enabled.If the certificate store is of a type that requires a password, this property is used to specify that password in order to open the certificate store.

Note: This is only applicable when [OAuthWebServerSSLEnabled](#OAuthWebServerSSLEnabled) is set to *true*.

**OAuthWebServerCertStoreType**: The certificate with private key to use when SSL is enabled.This specifies the type of certificate store. Possible values are:

|  |  |
| --- | --- |
| 0 | User - This is the default for Windows. This specifies that the certificate store is a certificate store owned by the current user. NOTE: This store type is not available in Java. |
| 1 | Machine - For Windows, this specifies that the certificate store is a machine store. NOTE: This store type is not available in Java. |
| 2 | PFXFile - The certificate store is the name of a PFX (PKCS12) file containing certificates. |
| 3 | PFXBlob - The certificate store is a string (binary or Base64-encoded) representing a certificate store in PFX (PKCS12) format. |
| 4 | JKSFile - The certificate store is the name of a Java Key Store (JKS) file containing certificates. NOTE: This store type is available only in Java. |
| 5 | JKSBlob - The certificate store is a string (binary or Base64-encoded) representing a certificate store in Java Key Store (JKS) format. NOTE: This store type is available only in Java. |
| 6 | PEMKeyFile - The certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate. |
| 7 | PEMKeyBlob - The certificate store is a string (binary or Base64-encoded) that contains a private key and an optional certificate. |
| 14 | PPKFile - The certificate store is the name of a file that contains a PPK (PuTTY Private Key). |
| 15 | PPKBlob - The certificate store is a string (binary) that contains a PPK (PuTTY Private Key). |
| 16 | XMLFile - The certificate store is the name of a file that contains a certificate in XML format. |
| 17 | XMLBlob - The certificate store is a string that contains a certificate in XML format. |

 Note: This is required when [OAuthWebServerSSLEnabled](#OAuthWebServerSSLEnabled) is set to *true*.

**OAuthWebServerCertSubject**: The certificate with private key to use when SSL is enabled.The subject of the SSL certificate.

The special value "*" picks a random certificate in the certificate store.

The certificate subject is a comma-separated list of distinguished name fields and values. For instance, "CN=www.server.com, OU=test, C=US, E=example@email.com". Common fields and their meanings are as follows:

| Field | Meaning |
| --- | --- |
| CN | Common Name. This is commonly a hostname like www.server.com. |
| O | Organization |
| OU | Organizational Unit |
| L | Locality |
| S | State |
| C | Country |
| E | Email Address |

If a field value contains a comma, it must be quoted.

Note: This is required when [OAuthWebServerSSLEnabled](#OAuthWebServerSSLEnabled) is set to *true*.

**OAuthWebServerFailedResponse**: The custom response that will be displayed to the user if authentication failed.When [authorize](#authorize-method-googlesheets-struct) is called the user will be redirected to the embedded web server upon completing authentication with the authorization server. If authentication failed, the HTML specified here will be sent to the user's browser.

**OAuthWebServerHost**: The hostname used by the embedded web server displayed in the ReturnURL.This setting specifies the hostname used by the embedded web server when [o_auth_client_profile](#o_auth_client_profile-property-googlesheets-struct) is set to cocpApplication. This specifies the interface on which the embedded web server listens, and also the value displayed in the [o_auth_return_url](#o_auth_return_url-property-googlesheets-struct). This should be set to the hostname only, not the full URL.

The default value is *localhost*.

**OAuthWebServerPort**: The local port on which the embedded web server listens.This property specifies the port on which the embedded web server listens. Setting this to *0* (default) enables the system to choose a port at random. The chosen port will be returned when this setting is queried after the server has started listening.This is only applicable when using the embedded web server.

**OAuthWebServerResponse**: The custom response that will be displayed to the user.When [authorize](#authorize-method-googlesheets-struct) is called the user will be redirected to the embedded web server upon completing authentication with the authorization server. This setting allows you to specify the HTML that will be sent to the user's browser.

**OAuthWebServerSSLEnabled**: Whether the web server requires SSL connections.This setting specifies whether the embedded web server will use SSL. If set to *True* OAuthWebServerCert* configs are required and the server will only accept SSL connections. If set to *False* only plaintext connects are supported.

### HTTP Config Settings

**AcceptEncoding**: Used to tell the server which types of content encodings the client supports.When [AllowHTTPCompression](#AllowHTTPCompression) is True, the struct adds an *Accept-Encoding* header to the request being sent to the server. By default, this header's value is "gzip, deflate". This configuration setting allows you to change the value of the *Accept-Encoding* header. NOTE: The struct only supports gzip and deflate decompression algorithms.

**AllowHTTPCompression**: This property enables HTTP compression for receiving data.This configuration setting enables HTTP compression for receiving data. When set to True (default), the struct will accept compressed data. It then will uncompress the data it has received. The struct will handle data compressed by both gzip and deflate compression algorithms.

When True, the struct adds an *Accept-Encoding* header to the outgoing request. The value for this header can be controlled by the [AcceptEncoding](#AcceptEncoding) configuration setting. The default value for this header is "gzip, deflate".

The default value is True.

**AllowHTTPFallback**: Whether HTTP/2 connections are permitted to fallback to HTTP/1.1.This configuration setting controls whether HTTP/2 connections are permitted to fall back to HTTP/1.1 when the server does not support HTTP/2. This setting is applicable only when http_version is set to "2.0".

If set to True (default), the struct will automatically use HTTP/1.1 if the server does not support HTTP/2. If set to False, the struct fails with an error if the server does not support HTTP/2.

The default value is True.

**Append**: Whether to append data to LocalFile.This configuration setting determines whether data will be appended when writing to local_file. When set to True, downloaded data will be appended to local_file. This may be used in conjunction with range to resume a failed download. This is applicable only when local_file is set. The default value is False.

**Authorization**: The Authorization string to be sent to the server.If the [Authorization](#Authorization) property contains a nonempty string, an *Authorization* HTTP request header is added to the request. This header conveys Authorization information to the server.

This property is provided so that the HTTP struct can be extended with other security schemes in addition to the authorization schemes already implemented by the struct.

The auth_scheme property defines the authentication scheme used. In the case of HTTP Basic Authentication (default), every time user and password are set, they are Base64 encoded, and the result is put in the [authorization](#authorization-property-googlesheets-struct) property in the form "Basic [encoded-user-password]".

**BytesTransferred**: Contains the number of bytes transferred in the response data.This configuration setting returns the raw number of bytes from the HTTP response data, before the component processes the data, whether it is chunked or compressed. This returns the same value as the [on_transfer](#on_transfer-event-googlesheets-struct) event, by [BytesTransferred](#BytesTransferred).

**ChunkSize**: Specifies the chunk size in bytes when using chunked encoding.This is applicable only when [UseChunkedEncoding](#UseChunkedEncoding) is True. This setting specifies the chunk size in bytes to be used when posting data. The default value is 16384.

**CompressHTTPRequest**: Set to true to compress the body of a PUT or POST request.If set to True, the body of a *PUT* or *POST* request will be compressed into gzip format before sending the request. The "Content-Encoding" header is also added to the outgoing request.

The default value is False.

**EncodeURL**: If set to True the URL will be encoded by the struct.If set to True, the URL passed to the struct will be URL encoded. The default value is False.

**FollowRedirects**: Determines what happens when the server issues a redirect.This option determines what happens when the server issues a redirect. Normally, the struct returns an error if the server responds with an "Object Moved" message. If this property is set to 1 (always), the new url for the object is retrieved automatically every time.

If this property is set to 2 (Same Scheme), the new url is retrieved automatically only if the URL Scheme is the same; otherwise, the struct fails with an error.

**Note:** Following the HTTP specification, unless this option is set to 1 (Always), automatic redirects will be performed only for *GET* or *HEAD* requests. Other methods potentially could change the conditions of the initial request and create security vulnerabilities.

Furthermore, if either the new URL server or port are different from the existing one, user and password are also reset to empty, unless this property is set to 1 (Always), in which case the same credentials are used to connect to the new server.

A on_redirect event is fired for every URL the product is redirected to. In the case of automatic redirections, the on_redirect event is a good place to set properties related to the new connection (e.g., new authentication parameters).

The default value is 0 (Never). In this case, redirects are never followed, and the struct fails with an error instead.

Following are the valid options:

- 0 - Never
- 1 - Always
- 2 - Same Scheme

**GetOn302Redirect**: If set to True the struct will perform a GET on the new location.The default value is False. If set to True, the struct will perform a *GET* on the new location. Otherwise, it will use the same HTTP method again.

**HTTP2HeadersWithoutIndexing**: HTTP2 headers that should not update the dynamic header table with incremental indexing.HTTP/2 servers maintain a dynamic table of headers and values seen over the course of a connection. Typically, these headers are inserted into the table through incremental indexing (also known as HPACK, defined in RFC 7541). To tell the component not to use incremental indexing for certain headers, and thus not update the dynamic table, set this configuration option to a comma-delimited list of the header names.

**HTTPVersion**: The version of HTTP used by the struct.This property specifies the HTTP version used by the struct. Possible values are as follows:

- "1.0"
- "1.1" (default)
- "2.0"
- "3.0"

When using HTTP/2 ("2.0") or HTTP/3 ("3.0"), additional restrictions apply. Please see the following notes for details.

**HTTP/2 Notes**

When using HTTP/2, a secure Secure Sockets Layer/Transport Layer Security (TLS/SSL) connection is required. Attempting to use a plaintext URL with HTTP/2 will result in an error.

If the server does not support HTTP/2, the struct will automatically use HTTP/1.1 instead. This is done to provide compatibility without the need for any additional settings. To see which version was used, check [NegotiatedHTTPVersion](#NegotiatedHTTPVersion) after calling a method. The [AllowHTTPFallback](#AllowHTTPFallback) setting controls whether this behavior is allowed (default) or disallowed.

**HTTP/3 Notes**

HTTP/3 is supported only in .NET and Java.

When using HTTP/3, a secure (TLS/SSL) connection is required. Attempting to use a plaintext URL with HTTP/3 will result in an error.

**IfModifiedSince**: A date determining the maximum age of the desired document.If this setting contains a nonempty string, an If-Modified-Since HTTP header is added to the request. The value of this header is used to make the HTTP request conditional: if the requested documented has not been modified since the time specified in the field, a copy of the document will not be returned from the server; instead, a 304 (not modified) response will be returned by the server and the component throws an exception

The format of the date value for IfModifiedSince is detailed in the HTTP specs. For example:

```text
Sat, 29 Oct 2017 19:43:31 GMT.
```

**KeepAlive**: Determines whether the HTTP connection is closed after completion of the request.If *true*, the component will not send the *Connection: Close* header. The absence of the Connection header indicates to the server that HTTP persistent connections should be used if supported. NOTE: Not all servers support persistent connections. If *false*, the connection will be closed immediately after the server response is received.

 The default value for [KeepAlive](#KeepAlive) is *true*.

**KerberosSPN**: The Service Principal Name for the Kerberos Domain Controller.If the Service Principal Name on the Kerberos Domain Controller is not the same as the URL that you are authenticating to, the Service Principal Name should be set here.

**LogLevel**: The level of detail that is logged.This configuration setting controls the level of detail that is logged through the [on_log](#on_log-event-googlesheets-struct) event. Possible values are as follows:

|  |  |
| --- | --- |
| 0 (None) | No events are logged. |
| 1 (Info - default) | Informational events are logged. |
| 2 (Verbose) | Detailed data are logged. |
| 3 (Debug) | Debug data are logged. |

The value 1 (Info) logs basic information, including the URL, HTTP version, and status details.

The value 2 (Verbose) logs additional information about the request and response.

The value 3 (Debug) logs the headers and body for both the request and response, as well as additional debug information (if any).

**MaxRedirectAttempts**: Limits the number of redirects that are followed in a request.When follow_redirects is set to any value other than frNever, the struct will follow redirects until this maximum number of redirect attempts are made. The default value is 20.

**NegotiatedHTTPVersion**: The negotiated HTTP version.This configuration setting may be queried after the request is complete to indicate the HTTP version used. When http_version is set to "2.0" (if the server does not support "2.0"), then the struct will fall back to using "1.1" automatically. This setting will indicate which version was used.

**OtherHeaders**: Other headers as determined by the user (optional).This configuration setting can be set to a string of headers to be appended to the HTTP request headers.

The headers must follow the format "header: value" as described in the HTTP specifications. Header lines should be separated by CRLF (*"\r\n"*) .

Use this configuration setting with caution. If this configuration setting contains invalid headers, HTTP requests may fail.

This configuration setting is useful for extending the functionality of the struct beyond what is provided.

**ProxyAuthorization**: The authorization string to be sent to the proxy server.This is similar to the [Authorization](#Authorization) configuration setting, but is used for proxy authorization. If this configuration setting contains a nonempty string, a *Proxy-Authorization* HTTP request header is added to the request. This header conveys proxy Authorization information to the server. If [proxy_user](#proxy_user-property-googlesheets-struct) and [proxy_password](#proxy_password-property-googlesheets-struct) are specified, this value is calculated using the algorithm specified by [proxy_auth_scheme](#proxy_auth_scheme-property-googlesheets-struct).

**ProxyAuthScheme**: The authorization scheme to be used for the proxy.This configuration setting is provided for use by structs that do not directly expose Proxy properties.

**ProxyPassword**: A password if authentication is to be used for the proxy.This configuration setting is provided for use by structs that do not directly expose Proxy properties.

**ProxyPort**: Port for the proxy server (default 80).This configuration setting is provided for use by structs that do not directly expose Proxy properties.

**ProxyServer**: Name or IP address of a proxy server (optional).This configuration setting is provided for use by structs that do not directly expose Proxy properties.

**ProxyUser**: A user name if authentication is to be used for the proxy.This configuration setting is provided for use by structs that do not directly expose Proxy properties.

**SentHeaders**: The full set of headers as sent by the client.This configuration setting returns the complete set of raw headers as sent by the client.

**StatusCode**: The status code of the last response from the server.This configuration setting contains the result code of the last response from the server.

**StatusLine**: The first line of the last response from the server.This setting contains the first line of the last response from the server. The format of the line will be *[HTTP version] [Result Code] [Description]*.

**TransferredData**: The contents of the last response from the server.This configuration setting contains the contents of the last response from the server.

**TransferredDataLimit**: The maximum number of incoming bytes to be stored by the struct.If [TransferredDataLimit](#TransferredDataLimit) is set to 0 (default), no limits are imposed. Otherwise, this reflects the maximum number of incoming bytes that can be stored by the struct.

**TransferredHeaders**: The full set of headers as received from the server.This configuration setting returns the complete set of raw headers as received from the server.

**TransferredRequest**: The full request as sent by the client.This configuration setting returns the full request as sent by the client. For performance reasons, the request is not normally saved. Set this configuration setting to ON before making a request to enable it. Following are examples of this request:

 .NET

```text
Http http = new Http();
http.Config("TransferredRequest=on");
http.PostData = "body";
http.Post("http://someserver.com");
Console.WriteLine(http.Config("TransferredRequest"));
```

 C++

```text
HTTP http;
http.Config("TransferredRequest=on");
http.SetPostData("body", 5);
http.Post("http://someserver.com");
printf("%s\r\n", http.Config("TransferredRequest"));
```

**UseChunkedEncoding**: Enables or Disables HTTP chunked encoding for transfers.If [UseChunkedEncoding](#UseChunkedEncoding) is set to True, the struct will use HTTP-chunked encoding when posting, if possible. HTTP-chunked encoding allows large files to be sent in chunks instead of all at once. If set to False, the struct will not use HTTP-chunked encoding. The default value is False.

NOTE: Some servers (such as the ASP.NET Development Server) may not support chunked encoding.

**UseIDNs**: Whether to encode hostnames to internationalized domain names.This configuration setting specifies whether hostnames containing non-ASCII characters are encoded to internationalized domain names. When set to True, if a hostname contains non-ASCII characters, it is encoded using Punycode to an IDN (internationalized domain name).

The default value is False and the hostname will always be used exactly as specified. NOTE: The [CodePage](#CodePage) setting must be set to a value capable of interpreting the specified host name. For instance, to specify UTF-8, set [CodePage](#CodePage) to *65001*. In the C++ Edition for Windows, the *W version of the class must be used. For instance, *DNSW* or *HTTPW*.

**UseProxyAutoConfigURL**: Whether to use a Proxy auto-config file when attempting a connection.This configuration specifies whether the struct will attempt to use the Proxy auto-config URL when establishing a connection and [proxy_auto_detect](#proxy_auto_detect-property-googlesheets-struct) is set to *True*.

When *True* (default), the struct will check for the existence of a Proxy auto-config URL, and if found, will determine the appropriate proxy to use.

**UserAgent**: Information about the user agent (browser).This is the value supplied in the HTTP User-Agent header. The default setting is "IPWorks HTTP Component - www.nsoftware.com".

Override the default with the name and version of your software.

### TCPClient Config Settings

**ConnectionTimeout**: Sets a separate timeout value for establishing a connection.When set, this configuration setting allows you to specify a different timeout value for establishing a connection. Otherwise, the struct will use timeout for establishing a connection and transmitting/receiving data.

**FirewallAutoDetect**: Tells the struct whether or not to automatically detect and use firewall system settings, if available.This configuration setting is provided for use by structs that do not directly expose Firewall properties.

**FirewallHost**: Name or IP address of firewall (optional).If a [FirewallHost](#FirewallHost) is given, requested connections will be authenticated through the specified firewall when connecting.

If the [FirewallHost](#FirewallHost) setting is set to a Domain Name, a DNS request is initiated. Upon successful termination of the request, the [FirewallHost](#FirewallHost) setting is set to the corresponding address. If the search is not successful, an error is returned.

NOTE: This setting is provided for use by structs that do not directly expose Firewall properties.

**FirewallHTTPVersion**: The HTTP version to be used when connecting through a tunneling proxy.When [FirewallType](#FirewallType) is set to a tunneling proxy, this setting dictates which HTTP version is used when connecting.

**FirewallPassword**: Password to be used if authentication is to be used when connecting through the firewall.If [FirewallHost](#FirewallHost) is specified, the [FirewallUser](#FirewallUser) and [FirewallPassword](#FirewallPassword) settings are used to connect and authenticate to the given firewall. If the authentication fails, the struct fails with an error.

NOTE: This setting is provided for use by structs that do not directly expose Firewall properties.

**FirewallPort**: The TCP port for the FirewallHost;.The [FirewallPort](#FirewallPort) is set automatically when [FirewallType](#FirewallType) is set to a valid value.

NOTE: This configuration setting is provided for use by structs that do not directly expose Firewall properties.

**FirewallType**: Determines the type of firewall to connect through.Possible values are as follows:

|  |  |
| --- | --- |
| 0 | No firewall (default setting). |
| 1 | Connect through a tunneling proxy. [FirewallPort](#FirewallPort) is set to 80. |
| 2 | Connect through a SOCKS4 Proxy. [FirewallPort](#FirewallPort) is set to 1080. |
| 3 | Connect through a SOCKS5 Proxy. [FirewallPort](#FirewallPort) is set to 1080. |
| 10 | Connect through a SOCKS4A Proxy. [FirewallPort](#FirewallPort) is set to 1080. |

NOTE: This setting is provided for use by structs that do not directly expose Firewall properties.

**FirewallUser**: A user name if authentication is to be used connecting through a firewall.If the [FirewallHost](#FirewallHost) is specified, the [FirewallUser](#FirewallUser) and [FirewallPassword](#FirewallPassword) settings are used to connect and authenticate to the Firewall. If the authentication fails, the struct fails with an error.

NOTE: This setting is provided for use by structs that do not directly expose Firewall properties.

**KeepAliveInterval**: The retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received.When set, [TCPKeepAlive](#TCPKeepAlive) will automatically be set to True. A TCP keep-alive packet will be sent after a period of inactivity as defined by [KeepAliveTime](#KeepAliveTime). If no acknowledgment is received from the remote host, the keep-alive packet will be sent again. This configuration setting specifies the interval at which the successive keep-alive packets are sent in milliseconds. This system default if this value is not specified here is 1 second.

NOTE: This value is not applicable in macOS.

**KeepAliveTime**: The inactivity time in milliseconds before a TCP keep-alive packet is sent.When set, [TCPKeepAlive](#TCPKeepAlive) will automatically be set to True. By default, the operating system will determine the time a connection is idle before a Transmission Control Protocol (TCP) keep-alive packet is sent. This system default if this value is not specified here is 2 hours. In many cases, a shorter interval is more useful. Set this value to the desired interval in milliseconds.

**Linger**: When set to True, connections are terminated gracefully.This property controls how a connection is closed. The default is True.

In the case that Linger is True (default), two scenarios determine how long the connection will linger. In the first, if [LingerTime](#LingerTime) is 0 (default), the system will attempt to send pending data for a connection until the default IP timeout expires.

In the second scenario, if [LingerTime](#LingerTime) is a positive value, the system will attempt to send pending data until the specified [LingerTime](#LingerTime) is reached. If this attempt fails, then the system will reset the connection.

The default behavior (which is also the default mode for stream sockets) might result in a long delay in closing the connection. Although the struct returns control immediately, the system could hold system resources until all pending data are sent (even after your application closes).

Setting this property to False forces an immediate disconnection. If you know that the other side has received all the data you sent (e.g., by a client acknowledgment), setting this property to False might be the appropriate course of action.

**LingerTime**: Time in seconds to have the connection linger. LingerTime is the time, in seconds, the socket connection will linger. This value is 0 by default, which means it will use the default IP timeout.

**LocalHost**: The name of the local host through which connections are initiated or accepted. The local_host setting contains the name of the local host as obtained by the *gethostname()* system call, or if the user has assigned an IP address, the value of that address.

In multihomed hosts (machines with more than one IP interface), setting LocalHost to the value of an interface will make the struct initiate connections (or accept in the case of server structs) only through that interface.

If the struct is connected, the local_host setting shows the IP address of the interface through which the connection is made in internet dotted format (aaa.bbb.ccc.ddd). In most cases, this is the address of the local host, except for multihomed hosts (machines with more than one IP interface).

**LocalPort**: The port in the local host where the struct binds. This configuration setting must be set before a connection is attempted. It instructs the struct to bind to a specific port (or communication endpoint) in the local machine.

Setting this to 0 (default) enables the system to choose a port at random. The chosen port will be shown by local_port after the connection is established.

local_port cannot be changed once a connection is made. Any attempt to set this when a connection is active will generate an error.

This configuration setting is useful when trying to connect to services that require a trusted port on the client side. An example is the remote shell (rsh) service in UNIX systems.

**MaxLineLength**: The maximum amount of data to accumulate when no EOL is found.[MaxLineLength](#MaxLineLength) is the size of an internal buffer, which holds received data while waiting for an eol string.

If an eol string is found in the input stream before [MaxLineLength](#MaxLineLength) bytes are received, the on_data_in event is fired with the *EOL* parameter set to True, and the buffer is reset.

If no eol is found, and [MaxLineLength](#MaxLineLength) bytes are accumulated in the buffer, the on_data_in event is fired with the *EOL* parameter set to False, and the buffer is reset.

The minimum value for [MaxLineLength](#MaxLineLength) is 256 bytes. The default value is 2048 bytes.

**MaxTransferRate**: The transfer rate limit in bytes per second.This configuration setting can be used to throttle outbound TCP traffic. Set this to the number of bytes to be sent per second. By default, this is not set and there is no limit.

**ProxyExceptionsList**: A semicolon separated list of hosts and IPs to bypass when using a proxy.This configuration setting optionally specifies a semicolon-separated list of hostnames or IP addresses to bypass when a proxy is in use. When requests are made to hosts specified in this property, the proxy will not be used. For instance:

*www.google.com;www.example.com*

**TCPKeepAlive**: Determines whether or not the keep alive socket option is enabled.If set to True, the socket's keep-alive option is enabled and keep-alive packets will be sent periodically to maintain the connection. Set [KeepAliveTime](#KeepAliveTime) and [KeepAliveInterval](#KeepAliveInterval) to configure the timing of the keep-alive packets.

NOTE: This value is not applicable in Java.

**TcpNoDelay**: Whether or not to delay when sending packets. When set to True, the socket will send all data that are ready to send at once. When set to False, the socket will send smaller buffered packets of data at small intervals. This is known as the Nagle algorithm.

By default, this configuration setting is set to False.

**UseIPv6**: Whether to use IPv6.When set to *0* (default), the struct will use IPv4 exclusively. When set to *1*, the struct will use IPv6 exclusively. To instruct the struct to prefer IPv6 addresses, but use IPv4 if IPv6 is not supported on the system, this setting should be set to *2*. The default value is *0*. Possible values are as follows:

|  |  |
| --- | --- |
| 0 | IPv4 only |
| 1 | IPv6 only |
| 2 | IPv6 with IPv4 fallback |

**UseNTLMv2**: Whether to use NTLM V2.When authenticating with NTLM, this setting specifies whether NTLM V2 is used. By default this value is True and NTLM V2 will be used. Set this to False to use NTLM V1.

### SSL Config Settings

**LogSSLPackets**: Controls whether SSL packets are logged when using the internal security API.When [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*, this configuration setting controls whether Secure Sockets Layer (SSL) packets should be logged. By default, this configuration setting is *False*, as it is useful only for debugging purposes.

When enabled, SSL packet logs are output using the [on_ssl_status](#on_ssl_status-event-googlesheets-struct) event, which will fire each time an SSL packet is sent or received.

Enabling this configuration setting has no effect if [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Platform*.

**OpenSSLCADir**: The path to a directory containing CA certificates.This functionality is available only when the provider is OpenSSL.

The path set by this property should point to a directory containing CA certificates in PEM format. The files each contain one CA certificate. The files are looked up by the CA subject name hash value, which must hence be available. If more than one CA certificate with the same name hash value exist, the extension must be different (e.g., 9d66eef0.0, 9d66eef0.1). OpenSSL recommends the use of the c_rehash utility to create the necessary links. Please refer to the OpenSSL man page SSL_CTX_load_verify_locations(3) for details.

**OpenSSLCAFile**: Name of the file containing the list of CA's trusted by your application.This functionality is available only when the provider is OpenSSL.

The file set by this property should contain a list of CA certificates in PEM format. The file can contain several CA certificates identified by the following sequences:

 -----BEGIN CERTIFICATE-----

 ... (CA certificate in base64 encoding) ...

 -----END CERTIFICATE-----

 Before, between, and after the certificate text is allowed, which can be used, for example, for descriptions of the certificates. Refer to the OpenSSL man page SSL_CTX_load_verify_locations(3) for details.

**OpenSSLCipherList**: A string that controls the ciphers to be used by SSL.This functionality is available only when the provider is OpenSSL.

The format of this string is described in the OpenSSL man page ciphers(1) section "CIPHER LIST FORMAT". Please refer to it for details. The default string "DEFAULT" is determined at compile time and is normally equivalent to "ALL:!ADH:RC4+RSA:+SSLv2:@STRENGTH".

**OpenSSLPrngSeedData**: The data to seed the pseudo random number generator (PRNG).This functionality is available only when the provider is OpenSSL.

By default, OpenSSL uses the device file "/dev/urandom" to seed the PRNG, and setting OpenSSLPrngSeedData is not required. If set, the string specified is used to seed the PRNG.

**ReuseSSLSession**: Determines if the SSL session is reused.

If set to True, the struct will reuse the context if and only if the following criteria are met:

- The target host name is the same.
- The system cache entry has not expired (default timeout is 10 hours).
- The application process that calls the function is the same.
- The logon session is the same.
- The instance of the struct is the same.

**SSLCACerts**: A newline separated list of CA certificates to be included when performing an SSL handshake.When [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*, this configuration setting specifies one or more CA certificates to be included with the ssl_cert property. Some servers or clients require the entire chain, including CA certificates, to be presented when performing SSL authentication. The value of this configuration setting is a newline-separated (CR/LF) list of certificates. For instance:

```text
-----BEGIN CERTIFICATE-----
MIIEKzCCAxOgAwIBAgIRANTET4LIkxdH6P+CFIiHvTowDQYJKoZIhvcNAQELBQAw
... Intermediate Cert ...
eWHV5OW1K53o/atv59sOiW5K3crjFhsBOd5Q+cJJnU+SWinPKtANXMht+EDvYY2w
F0I1XhM+pKj7FjDr+XNj
-----END CERTIFICATE-----
\r \n
-----BEGIN CERTIFICATE-----
MIIEFjCCAv6gAwIBAgIQetu1SMxpnENAnnOz1P+PtTANBgkqhkiG9w0BAQUFADBp
... Root Cert ...
d8q23djXZbVYiIfE9ebr4g3152BlVCHZ2GyPdjhIuLeH21VbT/dyEHHA
-----END CERTIFICATE-----
```

**SSLCheckCRL**: Whether to check the Certificate Revocation List for the server certificate.This configuration setting specifies whether the struct will check the Certificate Revocation List (CRL) specified by the server certificate. If set to 1 or 2, the struct will first obtain the list of CRL URLs from the server certificate's CRL distribution points extension. The struct will then make HTTP requests to each CRL endpoint to check the validity of the server's certificate. If the certificate has been revoked or any other issues are found during validation the struct fails with an error.

When set to 0 (default), the CRL check will not be performed by the struct. When set to 1, it will attempt to perform the CRL check, but it will continue without an error if the server's certificate does not support CRL. When set to 2, it will perform the CRL check and will throw an error if CRL is not supported.

This configuration setting is supported only in the Java, C#, and C++ editions. In the C++ edition, it is supported only on Windows operating systems.

**SSLCheckOCSP**: Whether to use OCSP to check the status of the server certificate.This configuration setting specifies whether the struct will use OCSP to check the validity of the server certificate. If set to 1 or 2, the struct will first obtain the Online Certificate Status Protocol (OCSP) URL from the server certificate's OCSP extension. The struct will then locate the issuing certificate and make an HTTP request to the OCSP endpoint to check the validity of the server's certificate. If the certificate has been revoked or any other issues are found during validation, the struct fails with an error.

When set to 0 (default), the struct will not perform an OCSP check. When set to 1, it will attempt to perform the OCSP check, but it will continue without an error if the server's certificate does not support OCSP. When set to 2, it will perform the OCSP check and will throw an error if OCSP is not supported.

This configuration setting is supported only in the Java, C#, and C++ editions. In the C++ edition, it is supported only on Windows operating systems.

**SSLCipherStrength**: The minimum cipher strength used for bulk encryption. This minimum cipher strength is largely dependent on the security modules installed on the system. If the cipher strength specified is not supported, an error will be returned when connections are initiated.

NOTE: This configuration setting contains the minimum cipher strength requested from the security library. The actual cipher strength used for the connection is shown by the [on_ssl_status](#on_ssl_status-event-googlesheets-struct) event.

Use this configuration setting with caution. Requesting a lower cipher strength than necessary could potentially cause serious security vulnerabilities in your application.

When the provider is OpenSSL, [SSLCipherStrength](#SSLCipherStrength) is currently not supported. This functionality is instead made available through the [OpenSSLCipherList](#OpenSSLCipherList) configuration setting.

**SSLClientCACerts**: A newline separated list of CA certificates to use during SSL client certificate validation.This configuration setting is only applicable to server components (e.g., TCPServer) see [SSLServerCACerts](#SSLServerCACerts) for client components (e.g., TCPClient). This setting can be used to optionally specify one or more CA certificates to be used when verifying the client certificate that is presented by the client during the SSL handshake when ssl_authenticate_clients is enabled. When verifying the client's certificate, the certificates trusted by the system will be used as part of the verification process. If the client's CA certificates are not installed to the trusted system store, they may be specified here so they are included when performing the verification process. This configuration setting should be set only if the client's CA certificates are not already trusted on the system and cannot be installed to the trusted system store.

The value of this configuration setting is a newline-separated (CR/LF) list of certificates. For instance:

```text
-----BEGIN CERTIFICATE-----
MIIEKzCCAxOgAwIBAgIRANTET4LIkxdH6P+CFIiHvTowDQYJKoZIhvcNAQELBQAw
... Intermediate Cert ...
eWHV5OW1K53o/atv59sOiW5K3crjFhsBOd5Q+cJJnU+SWinPKtANXMht+EDvYY2w
F0I1XhM+pKj7FjDr+XNj
-----END CERTIFICATE-----
\r \n
-----BEGIN CERTIFICATE-----
MIIEFjCCAv6gAwIBAgIQetu1SMxpnENAnnOz1P+PtTANBgkqhkiG9w0BAQUFADBp
... Root Cert ...
d8q23djXZbVYiIfE9ebr4g3152BlVCHZ2GyPdjhIuLeH21VbT/dyEHHA
-----END CERTIFICATE-----
```

**SSLEnabledCipherSuites**: The cipher suite to be used in an SSL negotiation.This configuration setting enables the cipher suites to be used in SSL negotiation.

By default, the enabled cipher suites will include all available ciphers ("*").

The special value "*" means that the struct will pick all of the supported cipher suites. If [SSLEnabledCipherSuites](#SSLEnabledCipherSuites) is set to any other value, only the specified cipher suites will be considered.

Multiple cipher suites are separated by semicolons.

Example values when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Platform* include the following:

```text
obj.config("SSLEnabledCipherSuites=*");
obj.config("SSLEnabledCipherSuites=CALG_AES_256");
obj.config("SSLEnabledCipherSuites=CALG_AES_256;CALG_3DES");
```

 Possible values when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Platform* include the following:

- CALG_3DES
- CALG_3DES_112
- CALG_AES
- CALG_AES_128
- CALG_AES_192
- CALG_AES_256
- CALG_AGREEDKEY_ANY
- CALG_CYLINK_MEK
- CALG_DES
- CALG_DESX
- CALG_DH_EPHEM
- CALG_DH_SF
- CALG_DSS_SIGN
- CALG_ECDH
- CALG_ECDH_EPHEM
- CALG_ECDSA
- CALG_ECMQV
- CALG_HASH_REPLACE_OWF
- CALG_HUGHES_MD5
- CALG_HMAC
- CALG_KEA_KEYX
- CALG_MAC
- CALG_MD2
- CALG_MD4
- CALG_MD5
- CALG_NO_SIGN
- CALG_OID_INFO_CNG_ONLY
- CALG_OID_INFO_PARAMETERS
- CALG_PCT1_MASTER
- CALG_RC2
- CALG_RC4
- CALG_RC5
- CALG_RSA_KEYX
- CALG_RSA_SIGN
- CALG_SCHANNEL_ENC_KEY
- CALG_SCHANNEL_MAC_KEY
- CALG_SCHANNEL_MASTER_HASH
- CALG_SEAL
- CALG_SHA
- CALG_SHA1
- CALG_SHA_256
- CALG_SHA_384
- CALG_SHA_512
- CALG_SKIPJACK
- CALG_SSL2_MASTER
- CALG_SSL3_MASTER
- CALG_SSL3_SHAMD5
- CALG_TEK
- CALG_TLS1_MASTER
- CALG_TLS1PRF

 Example values when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*include the following:

```text
obj.config("SSLEnabledCipherSuites=*");
obj.config("SSLEnabledCipherSuites=TLS_DHE_DSS_WITH_AES_128_CBC_SHA");
obj.config("SSLEnabledCipherSuites=TLS_DHE_DSS_WITH_AES_128_CBC_SHA;TLS_ECDH_RSA_WITH_AES_128_CBC_SHA");
```

 Possible values when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal* include the following:

- TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
- TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256
- TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
- TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
- TLS_ECDH_ECDSA_WITH_AES_256_GCM_SHA384
- TLS_RSA_WITH_AES_256_GCM_SHA384
- TLS_RSA_WITH_AES_128_GCM_SHA256
- TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256
- TLS_DHE_DSS_WITH_AES_256_GCM_SHA384
- TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
- TLS_ECDH_RSA_WITH_AES_256_GCM_SHA384
- TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256
- TLS_DHE_RSA_WITH_AES_128_GCM_SHA256
- TLS_DHE_DSS_WITH_AES_128_GCM_SHA256
- TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384
- TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256
- TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA384
- TLS_DHE_DSS_WITH_AES_256_CBC_SHA256
- TLS_RSA_WITH_AES_256_CBC_SHA256
- TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
- TLS_ECDH_RSA_WITH_AES_256_CBC_SHA384
- TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
- TLS_DHE_RSA_WITH_AES_128_CBC_SHA256
- TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
- TLS_RSA_WITH_AES_128_CBC_SHA256
- TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256
- TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256
- TLS_DHE_DSS_WITH_AES_128_CBC_SHA256
- TLS_RSA_WITH_AES_256_CBC_SHA
- TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA
- TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
- TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA
- TLS_DHE_RSA_WITH_AES_256_CBC_SHA
- TLS_ECDH_RSA_WITH_AES_256_CBC_SHA
- TLS_DHE_DSS_WITH_AES_256_CBC_SHA
- TLS_RSA_WITH_AES_128_CBC_SHA
- TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
- TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA
- TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA
- TLS_ECDH_RSA_WITH_AES_128_CBC_SHA
- TLS_DHE_RSA_WITH_AES_128_CBC_SHA
- TLS_DHE_DSS_WITH_AES_128_CBC_SHA
- TLS_ECDHE_ECDSA_WITH_3DES_EDE_CBC_SHA
- TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_ECDH_ECDSA_WITH_3DES_EDE_CBC_SHA
- TLS_ECDH_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_DHE_DSS_WITH_3DES_EDE_CBC_SHA
- TLS_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_RSA_WITH_DES_CBC_SHA
- TLS_DHE_RSA_WITH_DES_CBC_SHA
- TLS_DHE_DSS_WITH_DES_CBC_SHA
- TLS_RSA_WITH_RC4_128_MD5
- TLS_RSA_WITH_RC4_128_SHA

When TLS 1.3 is negotiated (see [SSLEnabledProtocols](#SSLEnabledProtocols)), only the following cipher suites are supported:

- TLS_AES_256_GCM_SHA384
- TLS_CHACHA20_POLY1305_SHA256
- TLS_AES_128_GCM_SHA256

[SSLEnabledCipherSuites](#SSLEnabledCipherSuites) is used together with [SSLCipherStrength](#SSLCipherStrength).

**SSLEnabledProtocols**: Used to enable/disable the supported security protocols.This configuration setting is used to enable or disable the supported security protocols.

Not all supported protocols are enabled by default. The default value is *4032* for client components, and *3072* for server components. To specify a combination of enabled protocol versions set this config to the binary *OR* of one or more of the following values:

|  |  |
| --- | --- |
| TLS1.3 | 12288 (Hex 3000) |
| TLS1.2 | 3072 (Hex C00) (Default - Client and Server) |
| TLS1.1 | 768 (Hex 300) (Default - Client) |
| TLS1 | 192 (Hex C0) (Default - Client) |
| SSL3 | 48 (Hex 30) |
| SSL2 | 12 (Hex 0C) |

Note that only TLS 1.2 is enabled for server components that accept incoming connections. This adheres to industry standards to ensure a secure connection. Client components enable TLS 1.0, TLS 1.1, and TLS 1.2 by default and will negotiate the highest mutually supported version when connecting to a server, which should be TLS 1.2 in most cases.

**SSLEnabledProtocols: Transport Layer Security (TLS) 1.3 Notes:**

By default when TLS 1.3 is enabled, the struct will first try to use the platform TLS 1.3 implementation when the [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to Automatic for all editions. If the platform TLS 1.3 implementation is not available, the internal implementation will be used.

In editions that are designed to run on Windows, [ssl_provider](#ssl_provider-property-googlesheets-struct) can be set to Platform to use the platform implementation instead of the internal implementation. When configured in this manner, please note that the platform provider is supported only on Windows 11/Windows Server 2022 and up. The default internal provider is available on all platforms and is not restricted to any specific OS version.

If set to *1* (Platform provider), please be aware of the following notes:

- The platform provider is available only on Windows 11/Windows Server 2022 and up.
- [SSLEnabledCipherSuites](#SSLEnabledCipherSuites) and other similar SSL configuration settings are not supported.
- If [SSLEnabledProtocols](#SSLEnabledProtocols) includes both TLS 1.3 and TLS 1.2, these restrictions are still applicable even if TLS 1.2 is negotiated. Enabling TLS 1.3 with the platform provider changes the implementation used for all TLS versions.

**SSLEnabledProtocols: SSL2 and SSL3 Notes: **

SSL 2.0 and 3.0 are not supported by the struct when the [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to internal. To use SSL 2.0 or SSL 3.0, the platform security API must have the protocols enabled and [ssl_provider](#ssl_provider-property-googlesheets-struct) needs to be set to platform.

**SSLEnableRenegotiation**: Whether the renegotiation_info SSL extension is supported.This configuration setting specifies whether the renegotiation_info SSL extension will be used in the request when using the internal security API. This configuration setting is *false* by default, but it can be set to *true* to enable the extension.

This configuration setting is applicable only when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*.

**SSLIncludeCertChain**: Whether the entire certificate chain is included in the SSLServerAuthentication event.This configuration setting specifies whether the Encoded parameter of the [on_ssl_server_authentication](#on_ssl_server_authentication-event-googlesheets-struct) event contains the full certificate chain. By default this value is False and only the leaf certificate will be present in the Encoded parameter of the [on_ssl_server_authentication](#on_ssl_server_authentication-event-googlesheets-struct) event.

If set to True, all certificates returned by the server will be present in the Encoded parameter of the [on_ssl_server_authentication](#on_ssl_server_authentication-event-googlesheets-struct) event. This includes the leaf certificate, any intermediate certificate, and the root certificate.

**SSLKeyLogFile**: The location of a file where per-session secrets are written for debugging purposes.This configuration setting optionally specifies the full path to a file on disk where per-session secrets are stored for debugging purposes.

When set, the struct will save the session secrets in the same format as the SSLKEYLOGFILE environment variable functionality used by most major browsers and tools, such as Chrome, Firefox, and cURL. This file can then be used in tools such as Wireshark to decrypt TLS traffic for debugging purposes. When writing to this file, the struct will only append, it will not overwrite previous values.

NOTE: This configuration setting is applicable only when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*.

**SSLNegotiatedCipher**: Returns the negotiated cipher suite.This configuration setting returns the cipher suite negotiated during the SSL handshake.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedCipher[connId]");
```

**SSLNegotiatedCipherStrength**: Returns the negotiated cipher suite strength.This configuration setting returns the strength of the cipher suite negotiated during the SSL handshake.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedCipherStrength[connId]");
```

**SSLNegotiatedCipherSuite**: Returns the negotiated cipher suite.This configuration setting returns the cipher suite negotiated during the SSL handshake represented as a single string.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedCipherSuite[connId]");
```

**SSLNegotiatedKeyExchange**: Returns the negotiated key exchange algorithm.This configuration setting returns the key exchange algorithm negotiated during the SSL handshake.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedKeyExchange[connId]");
```

**SSLNegotiatedKeyExchangeStrength**: Returns the negotiated key exchange algorithm strength.This configuration setting returns the strength of the key exchange algorithm negotiated during the SSL handshake.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedKeyExchangeStrength[connId]");
```

**SSLNegotiatedVersion**: Returns the negotiated protocol version.This configuration setting returns the protocol version negotiated during the SSL handshake.

NOTE: For server components (e.g., TCPServer), this is a per-connection configuration setting accessed by passing the ConnectionId. For example:

```csharp
server.Config("SSLNegotiatedVersion[connId]");
```

**SSLSecurityFlags**: Flags that control certificate verification.The following flags are defined (specified in hexadecimal notation). They can be ORed together to exclude multiple conditions:

|  |  |
| --- | --- |
| 0x00000001 | Ignore time validity status of certificate. |
| 0x00000002 | Ignore time validity status of CTL. |
| 0x00000004 | Ignore non-nested certificate times. |
| 0x00000010 | Allow unknown certificate authority. |
| 0x00000020 | Ignore wrong certificate usage. |
| 0x00000100 | Ignore unknown certificate revocation status. |
| 0x00000200 | Ignore unknown CTL signer revocation status. |
| 0x00000400 | Ignore unknown certificate authority revocation status. |
| 0x00000800 | Ignore unknown root revocation status. |
| 0x00008000 | Allow test root certificate. |
| 0x00004000 | Trust test root certificate. |
| 0x80000000 | Ignore non-matching CN (certificate CN non-matching server name). |

This functionality is currently not available when the provider is OpenSSL.

**SSLServerCACerts**: A newline separated list of CA certificates to use during SSL server certificate validation.This configuration setting is only used by client components (e.g., TCPClient) see [SSLClientCACerts](#SSLClientCACerts) for server components (e.g., TCPServer). This configuration setting can be used to optionally specify one or more CA certificates to be used when connecting to the server and verifying the server certificate. When verifying the server's certificate, the certificates trusted by the system will be used as part of the verification process. If the server's CA certificates are not installed to the trusted system store, they may be specified here so they are included when performing the verification process. This configuration setting should be set only if the server's CA certificates are not already trusted on the system and cannot be installed to the trusted system store.

The value of this configuration setting is a newline-separated (CR/LF) list of certificates. For instance:

```text
-----BEGIN CERTIFICATE-----
MIIEKzCCAxOgAwIBAgIRANTET4LIkxdH6P+CFIiHvTowDQYJKoZIhvcNAQELBQAw
... Intermediate Cert...
eWHV5OW1K53o/atv59sOiW5K3crjFhsBOd5Q+cJJnU+SWinPKtANXMht+EDvYY2w
F0I1XhM+pKj7FjDr+XNj
-----END CERTIFICATE-----
\r \n
-----BEGIN CERTIFICATE-----
MIIEFjCCAv6gAwIBAgIQetu1SMxpnENAnnOz1P+PtTANBgkqhkiG9w0BAQUFADBp
... Root Cert...
d8q23djXZbVYiIfE9ebr4g3152BlVCHZ2GyPdjhIuLeH21VbT/dyEHHA
-----END CERTIFICATE-----
```

**TLS12SignatureAlgorithms**: Defines the allowed TLS 1.2 signature algorithms when SSLProvider is set to Internal.This configuration setting specifies the allowed server certificate signature algorithms when [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal* and [SSLEnabledProtocols](#SSLEnabledProtocols) is set to allow TLS 1.2.

When specified the struct will verify that the server certificate signature algorithm is among the values specified in this configuration setting. If the server certificate signature algorithm is unsupported, the struct fails with an error.

The format of this value is a comma-separated list of hash-signature combinations. For instance:

```csharp
component.SSLProvider = TCPClientSSLProviders.sslpInternal;
component.Config("SSLEnabledProtocols=3072"); //TLS 1.2
component.Config("TLS12SignatureAlgorithms=sha256-rsa,sha256-dsa,sha1-rsa,sha1-dsa");
```

 The default value for this configuration setting is *sha512-ecdsa,sha512-rsa,sha512-dsa,sha384-ecdsa,sha384-rsa,sha384-dsa,sha256-ecdsa,sha256-rsa,sha256-dsa,sha224-ecdsa,sha224-rsa,sha224-dsa,sha1-ecdsa,sha1-rsa,sha1-dsa*.

To not restrict the server's certificate signature algorithm, specify an empty string as the value for this configuration setting, which will cause the signature_algorithms TLS 1.2 extension to not be sent.

**TLS12SupportedGroups**: The supported groups for ECC.This configuration setting specifies a comma-separated list of named groups used in TLS 1.2 for ECC.

The default value is *ecdhe_secp256r1,ecdhe_secp384r1,ecdhe_secp521r1*.

When using TLS 1.2 and [ssl_provider](#ssl_provider-property-googlesheets-struct) is set to *Internal*, the values refer to the supported groups for ECC. The following values are supported:

- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1" (default)

**TLS13KeyShareGroups**: The groups for which to pregenerate key shares.This configuration setting specifies a comma-separated list of named groups used in TLS 1.3 for key exchange. The groups specified here will have key share data pregenerated locally before establishing a connection. This can prevent an additional roundtrip during the handshake if the group is supported by the server.

The default value is set to balance common supported groups and the computational resources required to generate key shares. As a result, only some groups are included by default in this configuration setting.

NOTE: All supported groups can always be used during the handshake even if not listed here, but if a group is used that is not present in this list, it will incur an additional roundtrip and time to generate the key share for that group.

In most cases, this configuration setting does not need to be modified. This should be modified only if there is a specific reason to do so.

The default value is *ecdhe_x25519,ecdhe_secp256r1,ecdhe_secp384r1,ffdhe_2048,ffdhe_3072*

The values are ordered from most preferred to least preferred. The following values are supported:

- "ecdhe_x25519" (default)
- "ecdhe_x448"
- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1"
- "ffdhe_2048" (default)
- "ffdhe_3072" (default)
- "ffdhe_4096"
- "ffdhe_6144"
- "ffdhe_8192"

**TLS13SignatureAlgorithms**: The allowed certificate signature algorithms.This configuration setting holds a comma-separated list of allowed signature algorithms. Possible values include the following:

- "ed25519" (default)
- "ed448" (default)
- "ecdsa_secp256r1_sha256" (default)
- "ecdsa_secp384r1_sha384" (default)
- "ecdsa_secp521r1_sha512" (default)
- "rsa_pkcs1_sha256" (default)
- "rsa_pkcs1_sha384" (default)
- "rsa_pkcs1_sha512" (default)
- "rsa_pss_sha256" (default)
- "rsa_pss_sha384" (default)
- "rsa_pss_sha512" (default)

 The default value is *rsa_pss_sha256,rsa_pss_sha384,rsa_pss_sha512,rsa_pkcs1_sha256,rsa_pkcs1_sha384,rsa_pkcs1_sha512,ecdsa_secp256r1_sha256,ecdsa_secp384r1_sha384,ecdsa_secp521r1_sha512,ed25519,ed448*. This configuration setting is applicable only when [SSLEnabledProtocols](#SSLEnabledProtocols) includes TLS 1.3.

**TLS13SupportedGroups**: The supported groups for (EC)DHE key exchange.This configuration setting specifies a comma-separated list of named groups used in TLS 1.3 for key exchange. This configuration setting should be modified only if there is a specific reason to do so.

The default value is *ecdhe_x25519,ecdhe_x448,ecdhe_secp256r1,ecdhe_secp384r1,ecdhe_secp521r1,ffdhe_2048,ffdhe_3072,ffdhe_4096,ffdhe_6144,ffdhe_8192,mlkem_512,mlkem_768,mlkem_1024,x25519_mlkem_768,secp256r1_mlkem_768*

The values are ordered from most preferred to least preferred. The following values are supported:

- "ecdhe_x25519" (default)
- "ecdhe_x448" (default)
- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1" (default)
- "ffdhe_2048" (default)
- "ffdhe_3072" (default)
- "ffdhe_4096" (default)
- "ffdhe_6144" (default)
- "ffdhe_8192" (default)
- "mlkem_512" (default)
- "mlkem_768" (default)
- "mlkem_1024" (default)
- "x25519_mlkem_768" (default)
- "secp256r1_mlkem_768" (default)

Post-quantum algorithms (*mlkem_512,mlkem_768,mlkem_1024,x25519_mlkem_768,secp256r1_mlkem_768*) in our components rely on the operating system's underlying cryptographic primitives. The following platforms are currently supported:

-  Windows Server 2025
-  Windows 11 24H2
-  Windows 11 25H2

### Socket Config Settings

**AbsoluteTimeout**: Determines whether timeouts are inactivity timeouts or absolute timeouts.If [AbsoluteTimeout](#AbsoluteTimeout) is set to True, any method that does not complete within timeout seconds will be aborted. By default, *AbsoluteTimeout* is False, and the timeout is an inactivity timeout.

NOTE: This option is not valid for User Datagram Protocol (UDP) ports.

**FirewallData**: Used to send extra data to the firewall.When the firewall is a tunneling proxy, use this property to send custom (additional) headers to the firewall (e.g., headers for custom authentication schemes).

**InBufferSize**: The size in bytes of the incoming queue of the socket.This is the size of an internal queue in the Transmission Control Protocol (TCP)/IP stack. You can increase or decrease its size depending on the amount of data that you will be receiving. In some cases, increasing the value of the *InBufferSize* setting can provide significant improvements in performance.

Some TCP/IP implementations do not support variable buffer sizes. If that is the case, when the struct is activated the *InBufferSize* reverts to its defined size. The same happens if you attempt to make it too large or too small.

**OutBufferSize**: The size in bytes of the outgoing queue of the socket.This is the size of an internal queue in the TCP/IP stack. You can increase or decrease its size depending on the amount of data that you will be sending. In some cases, increasing the value of the *OutBufferSize* setting can provide significant improvements in performance.

Some TCP/IP implementations do not support variable buffer sizes. If that is the case, when the struct is activated the *OutBufferSize* reverts to its defined size. The same happens if you attempt to make it too large or too small.

### Base Config Settings

**BuildInfo**: Information about the product's build.When queried, this setting will return a string containing information about the product's build.

**CodePage**: The system code page used for Unicode to Multibyte translations.The default code page is Unicode UTF-8 (65001).

The following is a list of valid code page identifiers:

|  |  |
| --- | --- |
| Identifier | Name |
| 037 | IBM EBCDIC - U.S./Canada |
| 437 | OEM - United States |
| 500 | IBM EBCDIC - International |
| 708 | Arabic - ASMO 708 |
| 709 | Arabic - ASMO 449+, BCON V4 |
| 710 | Arabic - Transparent Arabic |
| 720 | Arabic - Transparent ASMO |
| 737 | OEM - Greek (formerly 437G) |
| 775 | OEM - Baltic |
| 850 | OEM - Multilingual Latin I |
| 852 | OEM - Latin II |
| 855 | OEM - Cyrillic (primarily Russian) |
| 857 | OEM - Turkish |
| 858 | OEM - Multilingual Latin I + Euro symbol |
| 860 | OEM - Portuguese |
| 861 | OEM - Icelandic |
| 862 | OEM - Hebrew |
| 863 | OEM - Canadian-French |
| 864 | OEM - Arabic |
| 865 | OEM - Nordic |
| 866 | OEM - Russian |
| 869 | OEM - Modern Greek |
| 870 | IBM EBCDIC - Multilingual/ROECE (Latin-2) |
| 874 | ANSI/OEM - Thai (same as 28605, ISO 8859-15) |
| 875 | IBM EBCDIC - Modern Greek |
| 932 | ANSI/OEM - Japanese, Shift-JIS |
| 936 | ANSI/OEM - Simplified Chinese (PRC, Singapore) |
| 949 | ANSI/OEM - Korean (Unified Hangul Code) |
| 950 | ANSI/OEM - Traditional Chinese (Taiwan; Hong Kong SAR, PRC) |
| 1026 | IBM EBCDIC - Turkish (Latin-5) |
| 1047 | IBM EBCDIC - Latin 1/Open System |
| 1140 | IBM EBCDIC - U.S./Canada (037 + Euro symbol) |
| 1141 | IBM EBCDIC - Germany (20273 + Euro symbol) |
| 1142 | IBM EBCDIC - Denmark/Norway (20277 + Euro symbol) |
| 1143 | IBM EBCDIC - Finland/Sweden (20278 + Euro symbol) |
| 1144 | IBM EBCDIC - Italy (20280 + Euro symbol) |
| 1145 | IBM EBCDIC - Latin America/Spain (20284 + Euro symbol) |
| 1146 | IBM EBCDIC - United Kingdom (20285 + Euro symbol) |
| 1147 | IBM EBCDIC - France (20297 + Euro symbol) |
| 1148 | IBM EBCDIC - International (500 + Euro symbol) |
| 1149 | IBM EBCDIC - Icelandic (20871 + Euro symbol) |
| 1200 | Unicode UCS-2 Little-Endian (BMP of ISO 10646) |
| 1201 | Unicode UCS-2 Big-Endian |
| 1250 | ANSI - Central European |
| 1251 | ANSI - Cyrillic |
| 1252 | ANSI - Latin I |
| 1253 | ANSI - Greek |
| 1254 | ANSI - Turkish |
| 1255 | ANSI - Hebrew |
| 1256 | ANSI - Arabic |
| 1257 | ANSI - Baltic |
| 1258 | ANSI/OEM - Vietnamese |
| 1361 | Korean (Johab) |
| 10000 | MAC - Roman |
| 10001 | MAC - Japanese |
| 10002 | MAC - Traditional Chinese (Big5) |
| 10003 | MAC - Korean |
| 10004 | MAC - Arabic |
| 10005 | MAC - Hebrew |
| 10006 | MAC - Greek I |
| 10007 | MAC - Cyrillic |
| 10008 | MAC - Simplified Chinese (GB 2312) |
| 10010 | MAC - Romania |
| 10017 | MAC - Ukraine |
| 10021 | MAC - Thai |
| 10029 | MAC - Latin II |
| 10079 | MAC - Icelandic |
| 10081 | MAC - Turkish |
| 10082 | MAC - Croatia |
| 12000 | Unicode UCS-4 Little-Endian |
| 12001 | Unicode UCS-4 Big-Endian |
| 20000 | CNS - Taiwan |
| 20001 | TCA - Taiwan |
| 20002 | Eten - Taiwan |
| 20003 | IBM5550 - Taiwan |
| 20004 | TeleText - Taiwan |
| 20005 | Wang - Taiwan |
| 20105 | IA5 IRV International Alphabet No. 5 (7-bit) |
| 20106 | IA5 German (7-bit) |
| 20107 | IA5 Swedish (7-bit) |
| 20108 | IA5 Norwegian (7-bit) |
| 20127 | US-ASCII (7-bit) |
| 20261 | T.61 |
| 20269 | ISO 6937 Non-Spacing Accent |
| 20273 | IBM EBCDIC - Germany |
| 20277 | IBM EBCDIC - Denmark/Norway |
| 20278 | IBM EBCDIC - Finland/Sweden |
| 20280 | IBM EBCDIC - Italy |
| 20284 | IBM EBCDIC - Latin America/Spain |
| 20285 | IBM EBCDIC - United Kingdom |
| 20290 | IBM EBCDIC - Japanese Katakana Extended |
| 20297 | IBM EBCDIC - France |
| 20420 | IBM EBCDIC - Arabic |
| 20423 | IBM EBCDIC - Greek |
| 20424 | IBM EBCDIC - Hebrew |
| 20833 | IBM EBCDIC - Korean Extended |
| 20838 | IBM EBCDIC - Thai |
| 20866 | Russian - KOI8-R |
| 20871 | IBM EBCDIC - Icelandic |
| 20880 | IBM EBCDIC - Cyrillic (Russian) |
| 20905 | IBM EBCDIC - Turkish |
| 20924 | IBM EBCDIC - Latin-1/Open System (1047 + Euro symbol) |
| 20932 | JIS X 0208-1990 & 0121-1990 |
| 20936 | Simplified Chinese (GB2312) |
| 21025 | IBM EBCDIC - Cyrillic (Serbian, Bulgarian) |
| 21027 | Extended Alpha Lowercase |
| 21866 | Ukrainian (KOI8-U) |
| 28591 | ISO 8859-1 Latin I |
| 28592 | ISO 8859-2 Central Europe |
| 28593 | ISO 8859-3 Latin 3 |
| 28594 | ISO 8859-4 Baltic |
| 28595 | ISO 8859-5 Cyrillic |
| 28596 | ISO 8859-6 Arabic |
| 28597 | ISO 8859-7 Greek |
| 28598 | ISO 8859-8 Hebrew |
| 28599 | ISO 8859-9 Latin 5 |
| 28605 | ISO 8859-15 Latin 9 |
| 29001 | Europa 3 |
| 38598 | ISO 8859-8 Hebrew |
| 50220 | ISO 2022 Japanese with no halfwidth Katakana |
| 50221 | ISO 2022 Japanese with halfwidth Katakana |
| 50222 | ISO 2022 Japanese JIS X 0201-1989 |
| 50225 | ISO 2022 Korean |
| 50227 | ISO 2022 Simplified Chinese |
| 50229 | ISO 2022 Traditional Chinese |
| 50930 | Japanese (Katakana) Extended |
| 50931 | US/Canada and Japanese |
| 50933 | Korean Extended and Korean |
| 50935 | Simplified Chinese Extended and Simplified Chinese |
| 50936 | Simplified Chinese |
| 50937 | US/Canada and Traditional Chinese |
| 50939 | Japanese (Latin) Extended and Japanese |
| 51932 | EUC - Japanese |
| 51936 | EUC - Simplified Chinese |
| 51949 | EUC - Korean |
| 51950 | EUC - Traditional Chinese |
| 52936 | HZ-GB2312 Simplified Chinese |
| 54936 | Windows XP: GB18030 Simplified Chinese (4 Byte) |
| 57002 | ISCII Devanagari |
| 57003 | ISCII Bengali |
| 57004 | ISCII Tamil |
| 57005 | ISCII Telugu |
| 57006 | ISCII Assamese |
| 57007 | ISCII Oriya |
| 57008 | ISCII Kannada |
| 57009 | ISCII Malayalam |
| 57010 | ISCII Gujarati |
| 57011 | ISCII Punjabi |
| 65000 | Unicode UTF-7 |
| 65001 | Unicode UTF-8 |

 The following is a list of valid code page identifiers for Mac OS only:

|  |  |
| --- | --- |
| Identifier | Name |
| 1 | ASCII |
| 2 | NEXTSTEP |
| 3 | JapaneseEUC |
| 4 | UTF8 |
| 5 | ISOLatin1 |
| 6 | Symbol |
| 7 | NonLossyASCII |
| 8 | ShiftJIS |
| 9 | ISOLatin2 |
| 10 | Unicode |
| 11 | WindowsCP1251 |
| 12 | WindowsCP1252 |
| 13 | WindowsCP1253 |
| 14 | WindowsCP1254 |
| 15 | WindowsCP1250 |
| 21 | ISO2022JP |
| 30 | MacOSRoman |
| 10 | UTF16String |
| 0x90000100 | UTF16BigEndian |
| 0x94000100 | UTF16LittleEndian |
| 0x8c000100 | UTF32String |
| 0x98000100 | UTF32BigEndian |
| 0x9c000100 | UTF32LittleEndian |
| 65536 | Proprietary |

**LicenseInfo**: Information about the current license.When queried, this setting will return a string containing information about the license this instance of a struct is using. It will return the following information:

- Product: The product the license is for.
- Product Key: The key the license was generated from.
- License Source: Where the license was found (e.g., RuntimeLicense, License File).
- License Type: The type of license installed (e.g., Royalty Free, Single Server).
- Last Valid Build: The last valid build number for which the license will work.

**MaskSensitiveData**: Whether sensitive data is masked in log messages.In certain circumstances it may be beneficial to mask sensitive data, like passwords, in log messages. Set this to *true* to mask sensitive data. The default is *true*.

**UseInternalSecurityAPI**: Whether or not to use the system security libraries or an internal implementation. When set to *false*, the struct will use the system security libraries by default to perform cryptographic functions where applicable.

Setting this configuration setting to *true* tells the struct to use the internal implementation instead of using the system security libraries.

 On Windows, this setting is set to *false* by default. On Linux/macOS, this setting is set to *true* by default.

 To use the system security libraries for Linux, OpenSSL support must be enabled. For more information on how to enable OpenSSL, please refer to the [OpenSSL Notes](platforms.md) section.

# Trappable Errors ([GoogleSheets](#struct-cloudsheetsgooglesheets) Struct)

### GoogleSheets Errors

|  |  |
| --- | --- |
| 1301 | Invalid Input Error. |