Task Factory Google

 Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.

Google Cloud OAuth2 Connection Manager

This connection manager is used with the Google Cloud Source and Google Cloud Rest Destination. Before connecting, users must obtain a Client ID, Client Secret, a Storage Project Id, and a Redirect URL from Google's APIs & Services Credentials dashboard.

Task Factory Google Cloud OAuth2 Connection Manager

Connection Settings

OptionDescription
Client IdThe Client ID is found in Google's APIs & Services - Credentials console.
Client SecretThe Client Secret is found in Google's APIs & Services - Credentials console.
Access TokenSelect Get Token to open the Token Getter window.
Is Bearer Token?Select this option if the Access Token is a bearer token.
Access Token Expiration DateThe expiration date of the access token.

Note:  This settings is optional.
Security ProtocolThe Security Protocol used by the API.  The Default option uses the TLS version used by your .NET version by default. See the following chart for more information:
.NET VersionTLS Support Information
.NET 4.6 and aboveSupports TLS 1.2 by default.
 .NET 4.5

TLS 1.2 is supported, but you need to opt-in to use it. Execute the following code before making a connection to a secured resource to make TLS 1.2 the default:

  • ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12
.NET 4.0TLS 1.2 is not supported. If you have .NET 4.5 (or above) installed on the system, you can opt in for TLS 1.2 even if your application framework doesn’t support it. SecurityProtocolType in .NET 4.0 doesn’t have an entry for TLS1.2, so you need to use a numerical representation of this enum value:

  • ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
.NET 3.5 or belowTLS 1.2 is not supported, and there is no workaround. Upgrade your application to a more recent version of the framework.
Storage Project IdThe storage project Id for your connection.

Token Getter

Task Factory Google Cloud OAuth2 Token Getter

OptionDescription
Client IdThis field should be auto-completed from the previous window with your Client ID.
Client SecretThis field should be auto-completed from the previous window with your Client Secret.
ScopesSelects which permission to be used in the call:

  • Full Control
  • Read Write 
  • Read Only

Additional Information: For more information about Scopes, see Google's Cloud Storage Authentication.

Port for responseThe port on your local machine where you want to send the token request response.
Set your Redirect Uri toUse this as your Redirect Uri in your OAuth2 App settings.
Get Access TokenOpens a browser window to login to your Google account and grant access.

Headers

Task Factory Google Cloud OAuth2 Connection Manager Headers

You can create header names and values by entering the information in their corresponding windows.

OptionDescription
Add New HeaderSelect to add a new header name and value. Once added, you can select within the column and configure the name and the value.
Remove HeaderRemove the selected header to be included in the component's output.

Refresh Token

Task Factory Google Cloud OAuth2 Connection Manager Refresh Token

OptionDescription
Refresh TokenAuthentication information provided to you at the application's developer site.

Note:  This should match the API Key from the Connection Settings window.
Token Request UrlThe URL that returns a refresh token. Example: https://api.citrixonline.com/oauth/access_token
HeadersAllows you to add headers within the refresh token. Select Add New Header to add a header. Select Remove header to remove a header.
Results Returned InSpecifies how results are returned from the application (JSON, XML, or String.)
Access Token PathThe token path for the access token. Example: access_token
Refresh Token PathThe token path for the refresh token. Example: refresh_token
Use Token StoreThis option creates a file on your machine that saves the access token, and refresh token in an encrypted format.
Token Store IdIdentifies the Token Store Id.
Token Store Path (Optional)Identifies the Token Store path.

Client Certificate

Task Factory Google Cloud OAuth2 Connection Manager Client Certificate

OptionDescription
Use Client CertificateSelect this option if you want to use the client certificate.
Certificate Store LocationThe client store location. 
Search For CertificateEnter a certificate that you want to search for and then select Find.

Note:  Leave this section blank and select Find to view all certificates.
Certificate ThumbprintThe identifier thumbprint of the selected certificate.

Proxy

Task Factory Google Cloud OAuth2 Connection Manager Proxy

OptionDescription
Proxy HostWhen connecting to an endpoint using a proxy, you should enter the proxy URL in this field.
Proxy PortThe port number that corresponds to the URL proxy host.
Proxy User NameThe username needed to authenticate to the proxy.
Proxy PasswordThe password that allows you to authenticate to the proxy.

Advanced Options

Task Factory Google Cloud OAuth2 Connection Manager Advanced Options

OptionDescription
Ignore Ssl Certificate VerificationSelecting this option ignores the SSL Certificate notification from the API during the connection.

Note:  This option applies to APIs that require you to have an SSL Certificate. Select this option if the SSL Certificate is not needed.
Follow RedirectsSelecting this option implements a 301 redirect on configured endpoints. For example, this option would automatically send your request to an HTTPS redirect once the request has reached the http version of the site.  

Google Drive Oauth2 Connection Manager

Used with the Google Drive Source and Google Drive Destination. Before connecting, users must obtain a Client ID, Client Secret, and Redirect URL from Google's APIs & Services Credentials dashboard.

Connection Settings

To connect to Google Drive, complete the following:  

Task Factory Google Drive OAuth2 Connection Manager

OptionDescription
Client IdThe Client ID is found in Google's APIs & Services - Credentials console.
Client SecretThe Client Secret is found in Google's APIs & Services - Credentials console.
Access TokenSelect Get Token to open the Token Getter window.
Is Bearer Token?Select this option if the Access Token is a bearer token.
Access Token Expiration Date

The expiration date of the access token.

Note:  This settings is optional.

Security ProtocolThe Security Protocol used by the API.  The Default option uses the TLS version used by your .NET version by default. See the following chart for more information:

.NET VersionTLS Support Information
.NET 4.6 and aboveSupports TLS 1.2 by default.
.NET 4.5

TLS 1.2 is supported, but you need to opt-in to use it. Execute the following code before making a connection to a secured resource to make TLS 1.2 the default:

  • ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12
.NET 4.0

TLS 1.2 is not supported. If you have .NET 4.5 (or above) installed on the system, you can opt in for TLS 1.2 even if your application framework doesn’t support it. SecurityProtocolType in .NET 4.0 doesn’t have an entry for TLS1.2, so you need to use a numerical representation of this enum value:

  • ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
.NET 3.5 or belowTLS 1.2 is not supported, and there is no workaround. Upgrade your application to a more recent version of the framework.

Use Team Drive Select this option if your application uses a Team Drive to share documents with other users.

Token Getter

Task Factory Google Drive OAuth2 Token Getter

OptionDescription
Client IdThis field should be auto-completed from the previous window with your Client ID.
Client SecretThis field should be auto-completed from the previous window with your Client Secret.
ScopesSelects which permission to be used in the call:

  • Full Control
  • Read Write 
  • Read Only

Additional Information: For more information about Scopes, see Google's Cloud Storage Authentication.

Port for responseThe port on your local machine where you want to send the token request response.
Set your Redirect Uri toUse this as your Redirect Uri in your OAuth2 App settings.
Get Access TokenOpens a browser window to login to your Google account and grant access.

The Token Getter window automatically closes and the rest of the connection manager automatically completes. A browser window opens to your google account. Log in to your Google Drive application's account and select Allow to grant access.

Headers

You can create header names and values by entering the information in their corresponding windows.

Task Factory Google Drive OAuth2 Connection Manager Headers

OptionDescription
Add New HeaderSelect to add a new header name and value. Once added, you can select within the column and configure the name and the value.
Remove HeaderRemove the selected header to be included in the component's output.

Refresh Token

Task Factory Google Drive OAuth2 Connection Manager Refresh Token

OptionDescription
Refresh TokenAuthentication information provided to you at the application's developer site.

Note:  This should match the API Key from the Connection Settings window.
Token Request UrlThe URL that returns a refresh token. Example: https://api.citrixonline.com/oauth/access_token
HeadersAllows you to add headers within the refresh token. Select Add New Header to add a header. Select Remove header to remove a header.
Results Returned InSpecifies how results are returned from the application (JSON, XML, or String.)
Access Token PathThe token path for the access token. Example: access_token
Refresh Token PathThe token path for the refresh token. Example: refresh_token
Use Token StoreThis option creates a file on your machine that saves the access token, and refresh token in an encrypted format.
Token Store IdIdentifies the Token Store Id.
Token Store Path (Optional)Identifies the Token Store path.

Client Certificate

Task Factory Google Drive OAuth2 Connection Manager Client Certificate

OptionDescription
Use Client CertificateSelect this option if you want to use the client certificate.
Certificate Store LocationThe client store location. 
Search For CertificateEnter a certificate that you want to search for and then select Find.

Note:  Leave this section blank and select Find to view all certificates.
Certificate ThumbprintThe identifier thumbprint of the selected certificate.

Proxy Configuration

Select the Proxy tab to connect to your Google Drive via a proxy connection.

Task Factory Google Drive OAuth2 Connection Manager Proxy

OptionDescription
Proxy HostIdentifies the proxy address.
Proxy PortIdentifies the port used by the proxy.
Proxy User NameEnter the user name for proxies that require user authentication.
Proxy PasswordEnter the password for proxies that require user authentication.

Advanced Options

Task Factory Google Drive OAuth2 Connection Manager Advanced Options

OptionDescription
Ignore Ssl Certificate VerificationSelecting this option ignores the SSL Certificate notification from the API during the connection.

Note:  This option applies to APIs that require you to have an SSL Certificate. Select this option if the SSL Certificate is not needed.
Follow RedirectsSelecting this option implements a 301 redirect on configured endpoints. For example, this option would automatically send your request to an HTTPS redirect once the request has reached the http version of the site.  

Google Cloud Rest Source and Google Drive Rest Source

Source

Begin by creating a connection manager that connects to the service's storage container.

Task Factory Google Cloud Rest SourceGoogle Cloud Rest Source 
Task Factory Google Drive SourceGoogle Drive Source

Format

The following formats are available: 

Delimited Format

Users can manually configure the delimiter , quote identifiers, the lines to skip, and lines to scan. Select Detect Formats to configure these fields automatically. 

Task Factory Google Cloud Rest Source Format DelimitedGoogle Cloud Rest Source Format
Task Factory Google Drive Source Format DelimitedGoogle Drive Source Format
OptionDescription
DelimiterIdentifies the character that separates columns. The default value is the comma (,).
QuoteIdentifies the character used to indicate a value (if present).
Lines To SkipUsers can designate the number of lines to skip at the beginning of the delimited file.
AutoAutomatically detects which lines to skip.
Lines To Scan Determines the number of lines to scan when detecting the file.
 Detect FormatsSelect this button to begin scanning the chosen file. 

Detected Delimited View - After the format is detected, a new view appears that allows users to configure or change different properties of the file.

Json Format

Task Factory Google Cloud Rest Source Format JsonGoogle Cloud Rest Source Format Json
Task Factory Google Drive Source Format JsonGoogle Drive Source Format Json
OptionDescription
 Root Json PathJSON queries can return multiple levels, therefore, this field Identifies the root to be used.
Output ColumnsIn this window, users can add and remove columns, define their name, token path (defined within the raw data), data type, length, precision, scale, and code page.  
Date Parse HandlingSpecifies how date formatted strings are parsed when reading JSON text.

  • None - Strings are not parsed as a date type and are read as strings.
  • DateTime - Date formatted strings are parsed as DateTime.
  • DateTime Offset - Date formatted strings are parsed as DateTimeOffset.
Date Time Zone HandlingSpecifies how to treat time values converted between string and DateTime.

  • Local - Treats the time as local (UTC times will be converted to local times.)
  • Utc - Treats the time as UTC. This will convert local time to UTC.
  • Unspecified - Treats the time as local time if a DateTime is being converted to a string. If a string is being converted to DateTime, convert to a local time if a time zone is specified.
  • RoundtripKind - Time zone is preserved when converting.

Float Parse Handling 

Specifies how floating point numbers are parsed.

  • Double - Floating point numbers are parsed as a double datatype.
  • Decimal - Floating point numbers are parsed as a decimal datatype.

XML Format

Task Factory Google Cloud Rest Source Format XmlGoogle Cloud Rest Source Format Xml
Task Factory Google Drive Source Format XmlGoogle Drive Source Format Xml
OptionDescription
 Root XPath Query XML queries can return multiple levels, therefore, this field Identifies the root to be used.
Namespaces:
  • Prefix - Identifies the prefix used in an xml namespace. Example: In the element \<SalesDetails xmlns:url="http://www.site.com"> the prefix is url.
  • Uri - The url or address identified in the namespace.
ColumnsUsers can create, remove, and configure the name, index (zero-based), data type, length, precision, and scale of the columns being extracted from the file.

Output Columns

Users can select which columns to include/exclude in the output. Additionally, users can rename the columns by selecting into its corresponding output name.

Task Factory Google Cloud Rest Source Output ColumnsGoogle Cloud Rest Source Output Columns
Task Factory Google Drive Source Output ColumnsGoogle Drive Source Output Columns

Error Handling

Task Factory Google Cloud Rest Source Error HandlingGoogle Cloud Rest Source Error Handling
Task Factory Google Drive Source Error HandlingGoogle Drive Source Error Handling
OptionDescription
Not UsedError handling is not used and no error constraint is available.
Ignore FailureAll errors are ignored and the package continues to execute.
Redirect RowAll error rows are directed to an error output.
 Fail Component(Default selection) On error, the component fails and the package execution stops.

Preview

Select Preview Data after configuring the previous tabs to view an output sample.

Task Factory Google Cloud Rest Source PreviewGoogle Cloud Rest Source Preview
Task Factory Google Drive Source PreviewGoogle Drive Source Preview

Google Cloud Destination and Google Drive Destination

Target

Begin by creating a connection manager that connects to a Google Storage container. After a connection manager is created, the source window populates with files and folders.  Select the desired file to continue configuration. 

Task Factory Google Cloud Rest Destination TargetGoogle Cloud Rest Destination Target
Task Factory Google Drive Destination TargetGoogle Drive Destination Target
OptionDescription
Target Item NameDefines the name and extension of the file you would like to create when the component is executed. (For example: MyNewXmlList.xml)

Delimited Format

Task Factory Google Cloud Rest Destination Format DelimitedGoogle Cloud Rest Destination Format 
Task Factory Google Drive Destination Format DelimitedGoogle Drive Rest Destination Format
OptionDescription
DelimiterIdentifies the character that separates text.
QuoteIdentifies the character (single or double quote) that indicates value.
Include Header RowWrites the column headers at the beginning of the document.
EncodingSelects which encoding is used to create the document.
CultureUsed to identify the document's language culture.

Json Array Format

Task Factory Google Cloud Rest Destination Format JsonArrayGoogle Cloud Rest Destinaton Fomrat JsonArray
Task Factory Google Drive Destination Format JsonArrayGoogle Drive Rest Destination Format JsonArray
OptionDescription
GenerateSelect to automatically generate the Row Body metadata. (Users can also add custom header and footer data.)
EncodingSelect which encoding is used to create the document.
CultureUsed to identify the document's language culture.

XML Array Format

Task Factory Google Cloud Rest Destination Format XmlArrayGoogle Cloud Rest Destination Format XmlArray
Task Factory Google Drive Destination Format XmlArrayGoogle Drive Destination XmlArray
OptionDescription
GenerateSelect to automatically generate the Row Body metadata. Users can also add custom header and footer data.
EncodingSelect which encoding is used to create the document.
CultureUsed to identify the document's language culture.