Application Settings - Connector

Active Directory

Property name	Possible value
activedirectory.dateFormat	yyyy-MM-dd'T'HH:mm:ss
activedirectory.driverId	192168001181150303450005300002
activedirectory.driverUrl	jdbc:activedirectory
activedirectory.timeZone	GMT

Amazon Redshift

Property name	Possible value
amazonredshift.batchSize	1000
amazonredshift.dateFormat	yyyy-MM-dd HH:mm:ss.
amazonredshift.driverId	192168001162152827474621800002
amazonredshift.driverUrl	jdbc:redshift
amazonredshift.timeZone	GMT

Amazon S3

Property name	Possible value
amazon.auth.algorithm	HMAC-SHA256
amazon.auth.dateFormat	yyyyMMdd
amazon.auth.dateTimeFormat	yyyyMMdd'T'HHmmss'Z
amazon.auth.hashAlgorithm	SHA-256
amazon.auth.scheme	AWS4
amazon.auth.signatureMethod	HmacSHA256
amazon.auth.terminator	aws4_request
amazonS3.api.contentType	application/xml
amazonS3.appKey	AKIAIN24AS5QO3HYRDOA
amazonS3.appKeySecret	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
amazonS3.baseApiUrl	https://s3.amazonaws.com
amazonS3.bucket.name	adeptia-core
amazonS3.BucketUrl	https://{BucketName}.s3.amazonaws.com
amazonS3.encoding	UTF-8
amazonS3.endPoint	s3.amazonaws.com
amazonS3.qbd.intermediateDataBucket.appKey	AKIAIN24AS5QO3HYRDOA
amazonS3.qbd.intermediateDataBucket.appKeySecret	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
amazonS3.qbd.intermediateDataBucket.endPoint	s3.amazonaws.com
amazonS3.qbd.intermediateDataBucket.name	adeptia-qbddata
amazonS3.region	us-east-1
amazonS3.request.batchSize	1
amazonS3.request.enableBatchProcessing	true
amazonS3.request.enableRequestHandler	true
amazonS3.request.errorXpath	ErrorResponse/Error
amazonS3.request.unWrapRoot	true
amazonS3.response.dateFormat	yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
amazonS3.response.enableResponseHandler	true
amazonS3.response.timeZone	UTC

Apache Cassandra

Property name	Possible value
apachecassandra.dateFormat	yyyy-MM-dd'T'HH:mm:ss.S
apachecassandra.driverId	192168001079147324142916400002
apachecassandra.driverUrl	jdbc:cassandra:
apachecassandra.timeZone	GMT

Azure Blob

Property name	Possible value
microsoftazure.appKey	ENC(oAoyEUGZ0n9WN5RSilz9nAqgVpl2Rul4kYnkn9xj6RycFzV3Q0CuxWJrEvrSSgXd)
microsoftazure.appKeySecret	45BOF1fsSovZEFNWuJ26j2TCmgkXmz738MC1gBx55FuJC7xV3c8Z2qS3bvNMc8Ou
microsoftazure.dateFormat	EEE, d MMM yyyy hh:mm:ss z
microsoftazure.enableProduction	true
microsoftazure.encoding	UTF-8
microsoftazure.oauth20.accessToken	https://login.microsoftonline.com/{domain}/oauth2/v2.0/token
microsoftazure.oauth20.authorize	https://login.microsoftonline.com/{domain}/oauth2/v2.0/authorize
microsoftazure.oauthVersion	2.0
microsoftazure.refreshToken	https://login.microsoftonline.com/{domain}/oauth2/v2.0/token
microsoftazure.request.enableBatchProcessing	true
microsoftazure.request.enableRequestHandler	true
microsoftazure.response.enableResponseHandler	true
microsoftazure.scope	openid offline_access https://storage.azure.com/user_impersonation
microsoftazure.SecretId
microsoftazure.timeZone	GMT

BambooHR

Property name	Possible value
bamboohr.api.contentType	application/xml
bamboohr.baseApiUrl	$dynamic$
bamboohr.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
bamboohr.encoding	UTF-8
bamboohr.request.batchSize	1
bamboohr.request.enableBatchProcessing	false
bamboohr.request.enableRequestHandler	true
bamboohr.request.removeEmptyTags	true
bamboohr.request.unWrapRoot	true
bamboohr.response.dateFormat	EEE, dd MMM yyyy HH:mm:ss z
bamboohr.response.enableResponseHandler	true
bamboohr.response.queryResponseXpath	{entityName}s/
bamboohr.source.queueSize	10
bamboohr.thread.retryCount	3
bamboohr.thread.retryDelay	2
bamboohr.timeZone	UTC

BigCommerce

Property name	Possible value
bigcommerce.api.contentType	application/xml
bigcommerce.baseApiUrl	$dynamic$
bigcommerce.dateFormat	EEE, dd MMM yyyy HH:mm:ss z
bigcommerce.encoding	UTF-8
bigcommerce.oauth.signatureMethod	HMAC-SHA256
bigcommerce.oauth10.accessToken	N/A
bigcommerce.oauth10.authorize	N/A
bigcommerce.oauth10.requestToken	N/A
bigcommerce.oauth20.accessToken	https://login.bigcommerce.com/oauth2/token
bigcommerce.oauth20.authorize	https://login.bigcommerce.com/oauth2/authorize
bigcommerce.oauthVersion	2.0
bigcommerce.refreshToken	N/A
bigcommerce.request.batchSize	1
bigcommerce.request.enableBatchProcessing	false
bigcommerce.request.enableRequestHandler	true
bigcommerce.request.errorXpath	errors/error/
bigcommerce.request.removeEmptyTags	true
bigcommerce.request.splitterXpath	{entityName}s/
bigcommerce.request.unWrapRoot	true
bigcommerce.response.enableResponseHandler	true
bigcommerce.response.queryResponseXpath	{entityName}s/
bigcommerce.source.pageSize	250
bigcommerce.thread.retryCount	3
bigcommerce.thread.retryDelay	60
bigcommerce.timeZone	GMT

Box

Property name	Possible value
box.accessTokenValueMap
box.appKey
box.appKeySecret
box.authorizationValueMap	consent$offline,response_type$code
box.baseApiUrl	https://api.box.com/2.0
box.baseContentUrl	https://upload.box.com/api/2.0
box.enableProduction	true
box.event.limit	100
box.oauth.signatureMethod	PLAINTEXT
box.oauth10.accessToken	N/A
box.oauth10.authorize	N/A
box.oauth10.requestToken	N/A
box.oauth20.accessToken	https://www.box.com/api/oauth2/token
box.oauth20.authorize	https://www.box.com/api/oauth2/authorize
box.oauthVersion	2.0
box.refreshToken	https://www.box.com/api/oauth2/token
box.refreshTokenValueMap	N/A

Concur

Property name	Possible value
concur.api.contentType	application/xml
concur.appKey
concur.apKeySecret
concur.baseApiUrl	https://www.concursolutions.com
concur.dateFormat	yyyy-MM-dd'T'HH:mm:ss.sss
concur.enableProduction	false
concur.oauth.signatureMethod	PLAINTEXT
concur.oauth10.accessToken	N/A
concur.oauth10.authorize	N/A
concur.oauth10.requestToken	N/A
concur.oauth20.accessToken	https://www.concursolutions.com/net2/oauth2/GetAccessToken.ashx
concur.oauth20.authorize
concur.oauthVersion
concur.refreshToken
concur.request.batchSize
concur.request.enableRequestHandler
concur.request.errorXpath
concur.request.splitterXpath
concur.request.unWrapRoot
concur.response.enableResponseHandler
concur.response.limit
concur.response.queryResponseXpath
concur.scope
concur.timeZone

Dropbox

Property name	Description	Default value	Possible value
dropbox.accessTokenValueMap
dropbox.adeptiaAccess.revokeURL
dropbox.appKey
dropbox.appKeySecret
dropbox.authorizationValueMap
dropbox.baseApiUrl
dropbox.baseContentUrl
dropbox.enableProduction
dropbox.oauth.signatureMethod
dropbox.oauth10.accessToken
dropbox.oauth10.authorize
dropbox.oauth10.requestToken
dropbox.oauth20.accessToken
dropbox.oauth20.authorize
dropbox.oauthVersion
dropbox.refreshToken
dropbox.refreshTokenValueMap
dropbox.root

DropFile

Property name	Description	Default value	Possible value
dropfile.api.contentType
dropfile.baseApiUrl
dropfile.dateFormat
dropfile.encoding
dropfile.request.dateFormat
dropfile.request.enableRequestHandler
dropfile.response.dateFormat
dropfile.response.enableResponseHandler
dropfile.source.pageSize
dropfile.timeZone

Facebook

Property name	Description	Default value	Possible value
facebook.adeptiaAccess.revokeURL
facebook.api.contentType
facebook.appKey
facebook.appKeySecret
facebook.baseApiUrl
facebook.dateFormat
facebook.enableProduction
facebook.oauth.signatureMethod
facebook.oauth10.accessToken
facebook.oauth10.authorize
facebook.oauth10.requestToken
facebook.oauth20.accessToken
facebook.oauth20.authorize
facebook.oauthVersion
facebook.refreshToken
facebook.request.enableRequestHandler
facebook.response.enableResponseHandler
facebook.scope
facebook.timeZone

Freshbooks

Property name	Description	Default value	Possible value
freshbooks.api.contentType
freshbooks.appKey
freshbooks.appKeySecret
freshbooks.baseApiUrl
freshbooks.dateFormat
freshbooks.enableProduction
freshbooks.oauth.signatureMethod
freshbooks.oauth10.accessToken
freshbooks.oauth10.authorize
freshbooks.oauth10.requestToken
freshbooks.oauth20.accessToken
freshbooks.oauth20.authorize
freshbooks.oauth20.requestToken
freshbooks.oauthVersion
freshbooks.refreshToken
freshbooks.request.batchSize
freshbooks.request.enableBatchProcessing
freshbooks.request.enableRequestHandler
freshbooks.request.errorXpath
freshbooks.request.removeEmptyTags
freshbooks.request.splitterXpath
freshbooks.request.unWrapRoot
freshbooks.response.enableResponseHandler
freshbooks.response.queryResponseXpath
freshbooks.timeZone

Google

Property name	Description	Default value	Possible value
google.accessTokenValueMap
google.adeptiaAccess.revokeURL
google.appKey
google.appKeySecret
google.authorizationValueMap
google.baseApiUrl
google.baseContentUrl
google.enableProduction
google.oauth.signatureMethod
google.oauth20.accessToken
google.oauth20.authorize
google.oauthVersion
google.refreshToken
google.refreshTokenValueMap
google.scope
googledrive.baseApiUrl

Google Spreadsheets

Property name	Description	Default value	Possible value
googleSpreadsheets.dateFormat
googleSpreadsheets.driverId
googleSpreadsheets.driverUrl
googleSpreadsheets.timeZone
googlespreadsheetsrest.baseApiUrl
googlespreadsheetsrest.request.batchSize
googlespreadsheetsrest.request.enableRequestHandler
googlespreadsheetsrest.request.valueInputOption
googlespreadsheetsrest.v4.baseApiUrl

Hubspot

Property name	Description	Default value	Possible value
hubspot.api.contentType
hubspot.appKey
hubspot.appKeySecret
hubspot.baseApiUrl
hubspot.enableProduction
hubspot.lead.registeration.hapiKey
hubspot.lead.registeration.listId
hubspot.oauth.signatureMethod
hubspot.oauth10.accessToken
hubspot.oauth10.authorize
hubspot.oauth10.requestToken
hubspot.oauth20.accessToken
hubspot.oauth20.authorize
hubspot.oauthVersion
hubspot.refreshToken
hubspot.request.batchSize
hubspot.request.enableBatchProcessing
hubspot.request.enableRequestHandler
hubspot.request.errorXpath
hubspot.request.splitterXpath
hubspot.request.unWrapRoot
hubspot.response.enableResponseHandler
hubspot.response.queryResponseXpath
hubspot.scope

Property name	Description	Default value	Possible value
linkedinn.api.contentType
linkedinn.appKey
linkedinn.appKeySecret
linkedinn.baseApiUrl
linkedinn.oauth.signatureMethod
linkedinn.oauth10.accessToken
linkedinn.oauth10.authorize
linkedinn.oauth10.requestToken
linkedinn.oauth20.accessToken
linkedinn.oauth20.authorize
linkedinn.oauthVersion
linkedinn.refreshToken
linkedinn.request.batchSize
linkedinn.request.enableBatchProcessing
linkedinn.request.enableRequestHandler
linkedinn.request.errorXpath
linkedinn.request.splitterXpath
linkedinn.request.unWrapRoot
linkedinn.response.enableResponseHandler
linkedinn.response.queryResponseXpath

Magento

Property name	Description	Default value	Possible value
magento.api.contentType
magento.appKey
magento.appKeySecret
magento.baseApiUrl
magento.dateFormat
magento.nonce
magento.oauth.signatureMethod
magento.oauth10.accessToken
magento.oauth10.authorize
magento.oauth10.requestToken
magento.oauth20.accessToken
magento.oauth20.authorize
magento.oauthVersion
magento.refreshToken
magento.request.batchSize
magento.request.enableBatchProcessing
magento.request.enableRequestHandler
magento.request.errorXpath
magento.request.splitterXpath
magento.request.unWrapRoot
magento.response.enableResponseHandler
magento.response.queryResponseXpath
magento.source.pageSize
magento.timestamp
magento.timeZone

Mailgun

Property name	Description	Default value	Possible value
mailgun.connect.host
mailgun.contentType
mailgun.encoding
mailgun.key
mailgun.url

Marketo

Property name	Description	Default value	Possible value
marketo.api.contentType
marketo.baseApiUrl
marketo.dateFormat
marketo.oauth.signatureMethod
marketo.oauth10.accessToken
marketo.oauth10.authorize
marketo.oauth10.requestToken
marketo.oauth20.accessToken
marketo.oauth20.authorize
marketo.oauthVersion
marketo.refreshToken
marketo.request.batchSize
marketo.request.enableBatchProcessing
marketo.request.enableRequestHandler
marketo.request.errorXpath
marketo.request.splitterXpath
marketo.request.unWrapRoot
marketo.response.enableResponseHandler
marketo.response.queryResponseXpath
marketo.timeZone

Microsoft Dynamics CRM

Property name	Description	Default value	Possible value
dynamicscrm.dateFormat
dynamicscrm.driverId
dynamicscrm.driverUrl
dynamicscrm.timeZone
dynamicscrm.version

Microsoft Dynamics GP

Property name	Description	Default value	Possible value
dynamicsgp.dateFormat
dynamicsgp.driverId
dynamicsgp.driverUrl
dynamicsgp.timeZone

Microsoft SharePoint

Property name	Description	Default value	Possible value
microsoftsharepoint.AccessTokenValueMap
microsoftsharepoint.api.contentType
microsoftsharepoint.baseApiUrl
microsoftsharepoint.dateFormat
microsoftsharepoint.oauth20.accessToken
microsoftsharepoint.oauth20.authorize
microsoftsharepoint.oauthVersion
microsoftsharepoint.refreshToken
microsoftsharepoint.request.enableRequestHandler
microsoftsharepoint.request.errorXpath
microsoftsharepoint.request.unWrapRoot
microsoftsharepoint.response.dateFormat
microsoftsharepoint.scope
microsoftsharepoint.timeZone

NetSuite

Property name	Description	Default value	Possible value
netsuite.dateFormat
netsuite.driverId
netsuite.driverUrl
netsuite.timeZone
netsuitesoap.dateFormat
netsuitesoap.recordXpath
netsuitesoap.request.enableRequestHandler
netsuitesoap.retryCount
netsuitesoap.retryDelay
netsuitesoap.source.pageSize
netsuitesoap.target.pageSize
netsuitesoap.timeZone
netsuitesoap.version

Paychex

Property name	Description	Default value	Possible value
paychex.api.contentType
paychex.baseApiUrl
paychex.enableRequestHandler
paychex.enableResponseHandler
paychex.errorXpath
paychex.oauth10.accessToken
paychex.oauth10.authorize
paychex.oauth10.requestToken
paychex.oauth20.accessToken
paychex.oauth20.authorize
paychex.oauthVersion
paychex.refreshToken
paychex.request.batchSize
paychex.request.unWrapRoot
paychex.splitterXpath

Quickbooks

Property name	Description	Default value	Possible value
quickbooks.api.contentType
quickbooks.appKey
quickbooks.appKeySecret
quickbooks.baseApiUrl
quickbooks.batch.response.errorXpath
quickbooks.dateFormat
quickbooks.enableProduction
quickbooks.encoding
quickbooks.minor.version
quickbooks.oauth.signatureMethod
quickbooks.oauth10.accessToken
quickbooks.oauth10.authorize
quickbooks.oauth10.requestToken
quickbooks.oauth20.accessToken
quickbooks.oauth20.authorize
quickbooks.oauthVersion
quickbooks.openId.identity
quickbooks.openId.provider
quickbooks.refreshToken
quickbooks.request.batchSize
quickbooks.request.enableRequestHandler
quickbooks.request.errorXpath
quickbooks.request.removeEmptyTags
quickbooks.request.splitterXpath
quickbooks.request.unWrapRoot
quickbooks.response.enableResponseHandler
quickbooks.response.maxResults
quickbooks.response.queryResponseXpath
quickbooks.scope
quickbooks.thread.retryCount
quickbooks.thread.retryDelay
quickbooks.timeZone

Quickbooks Desktop

Property name	Description	Default value	Possible value
qbd.request.batchSize
qbd.request.enableBatchProcessing
qbd.request.enableRequestHandler
qbd.request.encoding
qbd.request.qbXmlVersion
qbd.request.removeEmptyTags
qbd.request.splitterXpath
qbd.request.unWrapRoot
qbd.response.enableResponseHandler

RSS Feed

Property name	Description	Default value	Possible value
rssFeeds.dateFormat
rssFeeds.driverId
rssFeeds.driverUrl
rssFeeds.timeZone

Sage One

Property name	Description	Default value	Possible value
sageone.accessTokenValueMap
sageone.api.contentType
sageone.appKey
sageone.appKeySecret
sageone.authorizationValueMap
sageone.baseApiUrl
sageone.countryList
sageone.dateFormat
sageone.enableProduction
sageone.oauth.signatureMethod
sageone.oauth10.accessToken
sageone.oauth10.authorize
sageone.oauth10.requestToken
sageone.oauth20.accessToken
sageone.oauth20.authorize
sageone.oauthVersion
sageone.refreshToken
sageone.refreshTokenValueMap
sageone.request.batchSize
sageone.request.enableBatchProcessing
sageone.request.enableRequestHandler
sageone.request.errorXpath
sageone.request.splitterXpath
sageone.request.unWrapRoot
sageone.response.enableResponseHandler
sageone.response.maxResults
sageone.response.queryResponseXpath
sageone.scope
sageone.signingSecret
sageone.timeZone

Salesforce

Property name	Description	Default value	Possible value
salesforce.dateFormat
salesforce.driverId
salesforce.driverUrl
salesforce.productionUrl
salesforce.sandboxUrl
salesforce.timeZone
salesforcerest.accessTokenValueMap
salesforcerest.api.contentType
salesforcerest.appKey
salesforcerest.appKeySecret
salesforcerest.authorizationValueMap
salesforcerest.baseApiUrl
salesforcerest.concurrent.restApi.request.limit
salesforcerest.dateFormat
salesforcerest.enableProduction
salesforcerest.encryptionProtocol
salesforcerest.oauth.signatureMethod
salesforcerest.oauth10.accessToken
salesforcerest.oauth10.authorize
salesforcerest.oauth10.requestToken
salesforcerest.oauth20.accessToken
salesforcerest.oauth20.authorize
salesforcerest.oauthVersion
salesforcerest.refreshToken
salesforcerest.refreshTokenValueMap
salesforcerest.request.batchSize
salesforcerest.request.enableBatchProcessing
salesforcerest.request.enableRequestHandler
salesforcerest.request.errorXpath
salesforcerest.request.removeEmptyTags
salesforcerest.request.splitterXpath
salesforcerest.request.unWrapRoot
salesforcerest.response.enableResponseHandler
salesforcerest.response.limit
salesforcerest.source.queueSize
salesforcerest.timeZone

ServiceNow

Property name	Description	Default value	Possible value
servicenow.accessTokenValueMap
servicenow.api.contentType
servicenow.authorizationValueMap
servicenow.baseApiUrl
servicenow.encoding
servicenow.oauth20.accessToken
servicenow.oauth20.authorize
servicenow.oauthVersion
servicenow.refreshToken
servicenow.refreshTokenValueMap
servicenow.request.batchSize
servicenow.request.enableBatchProcessing
servicenow.request.enableRequestHandler
servicenow.request.splitterXpath
servicenow.request.unWrapRoot
servicenow.response.dateFormat
servicenow.response.timeZone
servicenow.source.pageSize

Sharepoint

Property name	Description	Default value	Possible value
sharepoint.authScheme
sharepoint.dateFormat
sharepoint.driverId
sharepoint.driverUrl
sharepoint.edition
sharepoint.timeZone

Shopify

Property name	Description	Default value	Possible value
shopify.api.contentType
shopify.appKey
shopify.appKeySecret
shopify.baseApiUrl
shopify.dateFormat
shopify.enableProduction
shopify.encoding
shopify.oauth.signatureMethod
shopify.oauth10.accessToken
shopify.oauth10.authorize
shopify.oauth10.requestToken
shopify.oauth20.accessToken
shopify.oauth20.authorize
shopify.oauthVersion
shopify.refreshToken
shopify.request.batchSize
shopify.request.enableBatchProcessing
shopify.request.enableRequestHandler
shopify.request.errorXpath
shopify.request.splitterXpath
shopify.request.unWrapRoot
shopify.response.enableResponseHandler
shopify.response.queryResponseXpath
shopify.scope
shopify.source.bucketSize
shopify.source.pageSize
shopify.timeZone
shopify.version

Xero

Property name	Description	Default value	Possible value
xero.api.contentType
xero.appKey
xero.appKeySecret
xero.baseApiUrl
xero.clientAuthentication
xero.clientKeystore
xero.clientKeystorePassword
xero.clientKeystorePrivateKeyPassword
xero.clientKeystoreType
xero.dateFormat
xero.enableProduction
xero.encoding
xero.oauth.signatureMethod
xero.oauth10.accessToken
xero.oauth10.authorize
xero.oauth10.requestToken
xero.oauth20.accessToken
xero.oauth20.authorize
xero.oauthVersion
xero.refreshToken
xero.request.batchSize
xero.request.enableBatchProcessing
xero.request.enableRequestHandler
xero.request.errorXpath
xero.request.removeEmptyTags
xero.request.splitterXpath
xero.request.unWrapRoot
xero.response.enableResponseHandler
xero.response.queryResponseXpath
xero.scope
xero.timeZone

Zendesk

Property name	Description	Default value	Possible value
zendesk.api.contentType
zendesk.appKey
zendesk.appKeySecret
zendesk.authorizationValueMap
zendesk.baseApiUrl
zendesk.dateFormat
zendesk.oauth.signatureMethod
zendesk.oauth10.accessToken
zendesk.oauth10.authorize
zendesk.oauth10.requestToken
zendesk.oauth20.accessToken
zendesk.oauth20.authorize
zendesk.oauthVersion
zendesk.refreshToken
zendesk.request.batchSize
zendesk.request.enableBatchProcessing
zendesk.request.enableRequestHandler
zendesk.request.errorXpath
zendesk.request.splitterXpath
zendesk.request.unWrapRoot
zendesk.response.enableResponseHandler
zendesk.response.queryResponseXpath
zendesk.scope
zendesk.timeZone

Zoho CRM

Property name	Description	Default value	Possible value
zohocrm.accessTokenValueMap
zohocrm.api.contentType
zohocrm.appKey
zohocrm.appKeySecret
zohocrm.authorizationValueMap
zohocrm.baseApiUrl
zohocrm.dateFormat
zohocrm.oauth20.accessToken
zohocrm.oauth20.authorize
zohocrm.oauthVersion
zohocrm.refreshToken
zohocrm.refreshTokenValueMap
zohocrm.request.batchSize
zohocrm.request.enableBatchProcessing
zohocrm.request.enableRequestHandler
zohocrm.request.errorXpath
zohocrm.request.splitterXpath
zohocrm.request.unWrapRoot
zohocrm.response.enableResponseHandler
zohocrm.response.queryResponseXpath
zohocrm.scope
zohocrm.timeZone
zohocrm.version