Documentation forTask Factory

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

Option Description
Client Id The Client ID is found in Google's APIs & Services - Credentials console.
Client Secret The Client Secret is found in Google's APIs & Services - Credentials console.
Access Token Select 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 Protocol The 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 Id The storage project Id for your connection.

Token Getter

Task Factory Google Cloud OAuth2 Token Getter

Option Description
Client Id This field should be auto-completed from the previous window with your Client ID.
Client Secret This field should be auto-completed from the previous window with your Client Secret.
Scopes Selects 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 response The port on your local machine where you want to send the token request response.
Set your Redirect Uri to Use this as your Redirect Uri in your OAuth2 App settings.
Get Access Token Opens 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.

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

Refresh Token

Task Factory Google Cloud OAuth2 Connection Manager Refresh Token

Option Description
Refresh Token Authentication information provided to you at the application's developer site.

Note:  This should match the API Key from the Connection Settings window.
Token Request Url The URL that returns a refresh token. Example: https://api.citrixonline.com/oauth/access_token
Headers Allows 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 In Specifies how results are returned from the application (JSON, XML, or String.)
Access Token Path The token path for the access token. Example: access_token
Refresh Token Path The token path for the refresh token. Example: refresh_token
Use Token Store This option creates a file on your machine that saves the access token, and refresh token in an encrypted format.
Token Store Id Identifies the Token Store Id.
Token Store Path (Optional) Identifies the Token Store path.

Client Certificate

Task Factory Google Cloud OAuth2 Connection Manager Client Certificate

Option Description
Use Client Certificate Select this option if you want to use the client certificate.
Certificate Store Location The client store location. 
Search For Certificate Enter 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 Thumbprint The identifier thumbprint of the selected certificate.

Proxy

Task Factory Google Cloud OAuth2 Connection Manager Proxy

Option Description
Proxy Host When connecting to an endpoint using a proxy, you should enter the proxy URL in this field.
Proxy Port The port number that corresponds to the URL proxy host.
Proxy User Name The username needed to authenticate to the proxy.
Proxy Password The password that allows you to authenticate to the proxy.

Advanced Options

Task Factory Google Cloud OAuth2 Connection Manager Advanced Options

Option Description
Ignore Ssl Certificate Verification Selecting 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 Redirects Selecting 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

Option Description
Client Id The Client ID is found in Google's APIs & Services - Credentials console.
Client Secret The Client Secret is found in Google's APIs & Services - Credentials console.
Access Token Select 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 Protocol The 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

Option Description
Client Id This field should be auto-completed from the previous window with your Client ID.
Client Secret This field should be auto-completed from the previous window with your Client Secret.
Scopes Selects 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 response The port on your local machine where you want to send the token request response.
Set your Redirect Uri to Use this as your Redirect Uri in your OAuth2 App settings.
Get Access Token Opens 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

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

Refresh Token

Task Factory Google Drive OAuth2 Connection Manager Refresh Token

Option Description
Refresh Token Authentication information provided to you at the application's developer site.

Note:  This should match the API Key from the Connection Settings window.
Token Request Url The URL that returns a refresh token. Example: https://api.citrixonline.com/oauth/access_token
Headers Allows 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 In Specifies how results are returned from the application (JSON, XML, or String.)
Access Token Path The token path for the access token. Example: access_token
Refresh Token Path The token path for the refresh token. Example: refresh_token
Use Token Store This option creates a file on your machine that saves the access token, and refresh token in an encrypted format.
Token Store Id Identifies the Token Store Id.
Token Store Path (Optional) Identifies the Token Store path.

Client Certificate

Task Factory Google Drive OAuth2 Connection Manager Client Certificate

Option Description
Use Client Certificate Select this option if you want to use the client certificate.
Certificate Store Location The client store location. 
Search For Certificate Enter 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 Thumbprint The 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

Option Description
Proxy Host Identifies the proxy address.
Proxy Port Identifies the port used by the proxy.
Proxy User Name Enter the user name for proxies that require user authentication.
Proxy Password Enter the password for proxies that require user authentication.

Advanced Options

Task Factory Google Drive OAuth2 Connection Manager Advanced Options

Option Description
Ignore Ssl Certificate Verification Selecting 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 Redirects Selecting 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 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 Delimited

Option Description
Delimiter Identifies the character that separates columns. The default value is the comma (,).
Quote Identifies the character used to indicate a value (if present).
Lines To Skip Users can designate the number of lines to skip at the beginning of the delimited file.
Auto Automatically detects which lines to skip.
Lines To Scan  Determines the number of lines to scan when detecting the file.
 Detect Formats Select 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 Json

Option Description
 Root Json Path JSON queries can return multiple levels, therefore, this field Identifies the root to be used.
Output Columns In 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 Handling Specifies 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 Handling Specifies 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 Xml

Option Description
 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.
Columns Users 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 Columns

Error Handling

Task Factory Google Cloud Rest Source Error Handling

Option Description
Not Used Error handling is not used and no error constraint is available.
Ignore Failure All errors are ignored and the package continues to execute.
Redirect Row All 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 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 Target

Option Description
Target Item Name Defines 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 Delimited

Option Description
Delimiter Identifies the character that separates text.
Quote Identifies the character (single or double quote) that indicates value.
Include Header Row Writes the column headers at the beginning of the document.
Encoding Selects which encoding is used to create the document.
Culture Used to identify the document's language culture.

Json Array Format

Task Factory Google Cloud Rest Destination Format JsonArray

Option Description
Generate Select to automatically generate the Row Body metadata. (Users can also add custom header and footer data.)
Encoding Select which encoding is used to create the document.
Culture Used to identify the document's language culture.

XML Array Format

Task Factory Google Cloud Rest Destination Format XmlArray

Option Description
Generate Select to automatically generate the Row Body metadata. Users can also add custom header and footer data.
Encoding Select which encoding is used to create the document.
Culture Used to identify the document's language culture.