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	https://www.concursolutions.com/net2/oauth2/Login.aspx
concur.oauthVersion	2.0
concur.refreshToken	N/A
concur.request.batchSize	1
concur.request.enableRequestHandler	true
concur.request.errorXpath	Error/Message
concur.request.splitterXpath	{entityName}s/{entityName}
concur.request.unWrapRoot	true
concur.response.enableResponseHandler	true
concur.response.limit	100
concur.response.queryResponseXpath	{entityName}s/
concur.scope	ATTEND,LIST,USER,CONFIG,EXPRPT,INSGHT,TRVREQ,TRVPRF,IMAGE,TWS,MTNG,PAYBAT,ITINER,ERECPT,EXTRCT
concur.timeZone	UTC

Dropbox

Property name	Possible value
dropbox.accessTokenValueMap	N/A
dropbox.adeptiaAccess.revokeURL	https://www.dropbox.com/account#applications
dropbox.appKey	3p0cpakqu1fpha7
dropbox.appKeySecret	7n26cskybiy6v4c
dropbox.authorizationValueMap	response_type$code,token_access_type$offline
dropbox.baseApiUrl	https://api.dropbox.com/2
dropbox.baseContentUrl	https://api-content.dropbox.com/2
dropbox.enableProduction	true
dropbox.oauth.signatureMethod	PLAINTEXT
dropbox.oauth10.accessToken	https://api.dropbox.com/1/oauth/access_token
dropbox.oauth10.authorize	https://api.dropbox.com/1/oauth/authorize
dropbox.oauth10.requestToken	https://api.dropbox.com/1/oauth/request_token
dropbox.oauth20.accessToken	https://api.dropboxapi.com/oauth2/token
dropbox.oauth20.authorize	https://www.dropbox.com/oauth2/authorize
dropbox.oauthVersion	2.0
dropbox.refreshToken	https://api.dropboxapi.com/oauth2/token
dropbox.refreshTokenValueMap	N/A
dropbox.root	dropbox

DropFile

Property name	Possible value
dropfile.api.contentType	application/json
dropfile.baseApiUrl	$dynamic$
dropfile.dateFormat	yyyy-MM-dd'T'HH:mm:ss.sss
dropfile.encoding	UTF-8
dropfile.request.dateFormat	yyyy-MM-dd'T'HH:mm:ssXXX
dropfile.request.enableRequestHandler	true
dropfile.response.dateFormat	EEE, dd MMM yyyy hh:mm:ss z
dropfile.response.enableResponseHandler	true
dropfile.source.pageSize	25
dropfile.timeZone	GMT+2

Facebook

Property name	Possible value
facebook.adeptiaAccess.revokeURL	https://www.facebook.com/settings/?tab=applications
facebook.api.contentType	application/json
facebook.appKey
facebook.appKeySecret
facebook.baseApiUrl	https://graph.facebook.com
facebook.dateFormat	yyyy-MM-dd'T'HH:mm:ss+SSSS
facebook.enableProduction	true
facebook.oauth.signatureMethod	PLAINTEXT
facebook.oauth10.accessToken	N/A
facebook.oauth10.authorize	N/A
facebook.oauth10.requestToken	N/A
facebook.oauth20.accessToken	N/A
facebook.oauth20.authorize	N/A
facebook.oauthVersion	2.0
facebook.refreshToken	N/A
facebook.request.enableRequestHandler	true
facebook.response.enableResponseHandler	true
facebook.scope	user_photos user_videos
facebook.timeZone	GMT

Freshbooks

Property name	Possible value
freshbooks.api.contentType	application/xml
freshbooks.appKey	ENC(gsYdnxM894BKuMWLTfP811P+fS0t65UVQvgLefyLly5css7504onGg2Yl0UJJWR3vLcp144LU4SaVE0C2QbLJXTAMMOGFRwBFJX9jXw8pCU=)
freshbooks.appKeySecret	ENC(w/0Ml2JxLPmGaGdbtcGdUCNVpmV8CgDAis0TqPKAPPd27wV6MIoHJvVbWJSiM/x1O8by1kGD6ac7mobC9/Iz54ZTqg6z7n9SW25UbC6JQzo=)
freshbooks.baseApiUrl	https://api.freshbooks.com
freshbooks.dateFormat	yyyy-MM-dd HH:mm:ss
freshbooks.enableProduction	true
freshbooks.oauth.signatureMethod	PLAINTEXT
freshbooks.oauth10.accessToken	https://{domain}.freshbooks.com/oauth/oauth_access.php
freshbooks.oauth10.authorize	https://{domain}.freshbooks.com/oauth/oauth_authorize.php
freshbooks.oauth10.requestToken	https://{domain}.freshbooks.com/oauth/oauth_request.php
freshbooks.oauth20.accessToken	https://api.freshbooks.com/auth/oauth/token
freshbooks.oauth20.authorize	https://my.freshbooks.com/service/auth/oauth/authorize
freshbooks.oauth20.requestToken	https://api.freshbooks.com/auth/oauth/token
freshbooks.oauthVersion	2.0
freshbooks.refreshToken	https://api.freshbooks.com/auth/oauth/token
freshbooks.request.batchSize	1
freshbooks.request.enableBatchProcessing	false
freshbooks.request.enableRequestHandler	true
freshbooks.request.errorXpath	response/error
freshbooks.request.removeEmptyTags	true
freshbooks.request.splitterXpath	request/
freshbooks.request.unWrapRoot	false
freshbooks.response.enableResponseHandler	true
freshbooks.response.queryResponseXpath	{entityName}s/
freshbooks.timeZone	EST5EDT

Google

Property name	Possible value
google.accessTokenValueMap	N/A
google.adeptiaAccess.revokeURL	https://security.google.com/settings/security/permissions
google.appKey	884462103335-qivkermsl09lnnounlksqrn116sne0iq.apps.googleusercontent.com
google.appKeySecret	c0s0M5F4ySWo5hTZBWRMK38g
google.authorizationValueMap	consent$offline
google.baseApiUrl	https://www.googleapis.com/oauth2/v1
google.baseContentUrl	https://www.googleapis.com/drive/v2
google.enableProduction	true
google.oauth.signatureMethod	PLAINTEXT
google.oauth20.accessToken	https://accounts.google.com/o/oauth2/token
google.oauth20.authorize	https://accounts.google.com/o/oauth2/auth
google.oauthVersion	2.0
google.refreshToken	https://accounts.google.com/o/oauth2/token
google.refreshTokenValueMap	N/A
google.scope	https://spreadsheets.google.com/feeds https://docs.google.com/feeds https://www.googleapis.com/auth/drive
googledrive.baseApiUrl	https://www.googleapis.com/oauth2/v1

Google Spreadsheets

Property name	Possible value
googleSpreadsheets.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
googleSpreadsheets.driverId	192168001083140180471313800008
googleSpreadsheets.driverUrl	jdbc:googlesheets
googleSpreadsheets.timeZone	GMT
googlespreadsheetsrest.baseApiUrl	https://spreadsheets.google.com/feeds
googlespreadsheetsrest.request.batchSize	1000
googlespreadsheetsrest.request.enableRequestHandler	true
googlespreadsheetsrest.request.valueInputOption	RAW
googlespreadsheetsrest.v4.baseApiUrl	https://sheets.googleapis.com/v4/spreadsheets

Hubspot

Property name	Possible value
hubspot.api.contentType	application/json
hubspot.appKey
hubspot.appKeySecret
hubspot.baseApiUrl	https://api.hubapi.com
hubspot.enableProduction	true
hubspot.lead.registeration.hapiKey	a672f6eb-9828-4046-8bd9-1ddf049c1565
hubspot.lead.registeration.listId	856
hubspot.oauth.signatureMethod	PLAINTEXT
hubspot.oauth10.accessToken	N/A
hubspot.oauth10.authorize	N/A
hubspot.oauth10.requestToken	N/A
hubspot.oauth20.accessToken	https://api.hubapi.com/oauth/v1/token
hubspot.oauth20.authorize	https://app.hubspot.com/oauth/authorize
hubspot.oauthVersion	2.0
hubspot.refreshToken	https://api.hubapi.com/oauth/v1/token
hubspot.request.batchSize	1
hubspot.request.enableBatchProcessing	true
hubspot.request.enableRequestHandler	true
hubspot.request.errorXpath	errors/error
hubspot.request.splitterXpath	{entityName}s/{entityName}
hubspot.request.unWrapRoot	true
hubspot.response.enableResponseHandler	true
hubspot.response.queryResponseXpath	{entityName}s/
hubspot.scope	contacts content

Property name	Possible value
linkedinn.api.contentType	application/xml
linkedinn.appKey	77tkp8ft8g61us
linkedinn.appKeySecret	bAATwNFDUC2CX56M
linkedinn.baseApiUrl	https://api.linkedin.com
linkedinn.oauth.signatureMethod	PLAINTEXT
linkedinn.oauth10.accessToken	N/A
linkedinn.oauth10.authorize	N/A
linkedinn.oauth10.requestToken	N/A
linkedinn.oauth20.accessToken	https://www.linkedin.com/uas/oauth2/accessToken
linkedinn.oauth20.authorize	https://www.linkedin.com/uas/oauth2/authorization
linkedinn.oauthVersion	2.0
linkedinn.refreshToken	https://www.linkedin.com/uas/oauth2/accessToken
linkedinn.request.batchSize	1
linkedinn.request.enableBatchProcessing	true
linkedinn.request.enableRequestHandler	true
linkedinn.request.errorXpath	error/message
linkedinn.request.splitterXpath	{entityName}s/{entityName}
linkedinn.request.unWrapRoot	true
linkedinn.response.enableResponseHandler	true
linkedinn.response.queryResponseXpath	{entityName}s/

Magento

Property name	Possible value
magento.api.contentType	application/xml
magento.appKey
magento.appKeySecret
magento.baseApiUrl	$dynamic$
magento.dateFormat	yyyy-MM-dd HH:mm:ss.sss
magento.nonce	true
magento.oauth.signatureMethod	PLAINTEXT
magento.oauth10.accessToken	{domain}/oauth/token
magento.oauth10.authorize	{domain}/admin/oauth_authorize
magento.oauth10.requestToken	{domain}/oauth/initiate
magento.oauth20.accessToken	N/A
magento.oauth20.authorize	N/A
magento.oauthVersion	1.0
magento.refreshToken	N/A
magento.request.batchSize	1
magento.request.enableBatchProcessing	true
magento.request.enableRequestHandler	true
magento.request.errorXpath	magento_api/messages
magento.request.splitterXpath	magento/magento_api
magento.request.unWrapRoot	true
magento.response.enableResponseHandler	true
magento.response.queryResponseXpath	magento/magento_api
magento.source.pageSize	100
magento.timestamp	true
magento.timeZone	GMT

Mailgun

Property name	Possible value
mailgun.connect.host	Adeptia Connect <support@m.adeptia.com>
mailgun.contentType	text/html
mailgun.encoding	utf-8
mailgun.key	key-18ghat8iwprtl6k0we8le5okfnwq8-03
mailgun.url	https://api.mailgun.net/v2/m.adeptia.com/messages

Marketo

Property name	Possible value
marketo.api.contentType	application/json
marketo.baseApiUrl	$dynamic$
marketo.dateFormat	yyyy-MM-dd'T'HH:mm:ss
marketo.oauth.signatureMethod	PLAINTEXT
marketo.oauth10.accessToken	N/A
marketo.oauth10.authorize	N/A
marketo.oauth10.requestToken	N/A
marketo.oauth20.accessToken	https://{domain}.mktorest.com/identity/oauth/token
marketo.oauth20.authorize	N/A
marketo.oauthVersion	2.0
marketo.refreshToken	N/A
marketo.request.batchSize	1
marketo.request.enableBatchProcessing	false
marketo.request.enableRequestHandler	true
marketo.request.errorXpath	response/error
marketo.request.splitterXpath	request/
marketo.request.unWrapRoot	false
marketo.response.enableResponseHandler	true
marketo.response.queryResponseXpath	Leads/
marketo.timeZone	CST

Microsoft Dynamics CRM

Property name	Possible value
dynamicscrm.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
dynamicscrm.driverId	192168001083140180410197500002
dynamicscrm.driverUrl	jdbc:dynamicscrm:
dynamicscrm.timeZone	GMT
dynamicscrm.version	CRM Online

Microsoft Dynamics GP

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

Microsoft SharePoint

Property name	Possible value
microsoftsharepoint.AccessTokenValueMap	resource$00000003-0000-0ff1-ce00-000000000000/{domain}.sharepoint.com@{realmId}
microsoftsharepoint.api.contentType	application/json
microsoftsharepoint.baseApiUrl	$dynamic$
microsoftsharepoint.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
microsoftsharepoint.oauth20.accessToken	https://accounts.accesscontrol.windows.net/{realmId}/tokens/OAuth/2
microsoftsharepoint.oauth20.authorize	{baseUrl}/_layouts/15/OAuthAuthorize.aspx
microsoftsharepoint.oauthVersion	2.0
microsoftsharepoint.refreshToken	https://accounts.accesscontrol.windows.net/{realmId}/tokens/OAuth/2
microsoftsharepoint.request.enableRequestHandler	true
microsoftsharepoint.request.errorXpath	m:error/m:message
microsoftsharepoint.request.unWrapRoot	true
microsoftsharepoint.response.dateFormat	EEE, dd MMM yyyy hh:mm:ss z
microsoftsharepoint.scope	Site.Manage List.Manage Web.Manage Web.Write AllSites.Manage AllProfiles.Manage
microsoftsharepoint.timeZone	GMT

NetSuite

Property name	Possible value
netsuite.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
netsuite.driverId	192168001083140180476487000010
netsuite.driverUrl	jdbc:netsuite:
netsuite.timeZone	GMT
netsuitesoap.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
netsuitesoap.recordXpath	searchResponse/platformCore:searchResult/platformCore:recordList/platformCore:record/
netsuitesoap.request.enableRequestHandler	true
netsuitesoap.retryCount	3
netsuitesoap.retryDelay	2
netsuitesoap.source.pageSize	1000
netsuitesoap.target.pageSize	100
netsuitesoap.timeZone	GMT
netsuitesoap.version	2015_1

Paychex

Property name	Possible value
paychex.api.contentType	application/json
paychex.baseApiUrl	https://api.tn2.paychex.com
paychex.enableRequestHandler	true
paychex.enableResponseHandler	true
paychex.errorXpath	errors
paychex.oauth10.accessToken	N/A
paychex.oauth10.authorize	N/A
paychex.oauth10.requestToken	N/A
paychex.oauth20.accessToken	https://api.tn2.paychex.com/auth/oauth/v2/token
paychex.oauth20.authorize	N/A
paychex.oauthVersion	2.0
paychex.refreshToken	N/A
paychex.request.batchSize	1
paychex.request.unWrapRoot	true
paychex.splitterXpath	{entityName}s/{entityName}

Quickbooks

Property name	Possible value
quickbooks.api.contentType	application/xml
quickbooks.appKey	ABW7UX1i7OvYFOKLz8A2Q2MdPyCMDbb8MsHWDTziDDAFHsHZMh
quickbooks.appKeySecret	pkUKysmGhP6UjhYLwAGr85PgLgenMD1FC3hGIO9h
quickbooks.baseApiUrl	https://quickbooks.api.intuit.com/v3
quickbooks.batch.response.errorXpath	IntuitResponse/BatchItemResponse/
quickbooks.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
quickbooks.enableProduction	false
quickbooks.encoding	UTF-8
quickbooks.minor.version	4
quickbooks.oauth.signatureMethod	HMAC-SHA1
quickbooks.oauth10.accessToken	https://oauth.intuit.com/oauth/v1/get_access_token
quickbooks.oauth10.authorize	https://appcenter.intuit.com/Connect/Begin
quickbooks.oauth10.requestToken	https://oauth.intuit.com/oauth/v1/get_request_token
quickbooks.oauth20.accessToken	https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer
quickbooks.oauth20.authorize	https://appcenter.intuit.com/connect/oauth2
quickbooks.oauthVersion	2.0
quickbooks.openId.identity	http://specs.openid.net/auth/2.0/identifier_select
quickbooks.openId.provider	https://openid.intuit.com/OpenId/Provider
quickbooks.refreshToken	https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer
quickbooks.request.batchSize	30
quickbooks.request.enableRequestHandler	true
quickbooks.request.errorXpath	LinkedHashMap/
quickbooks.request.removeEmptyTags	true
quickbooks.request.splitterXpath	quickbooks:IntuitBatchRequest/quickbooks:BatchItemRequest/
quickbooks.request.unWrapRoot	false
quickbooks.response.enableResponseHandler	true
quickbooks.response.maxResults	1000
quickbooks.response.queryResponseXpath	IntuitResponse/QueryResponse/
quickbooks.scope	com.intuit.quickbooks.accounting
quickbooks.thread.retryCount	3
quickbooks.thread.retryDelay	60
quickbooks.timeZone	GMT

Quickbooks Desktop

Property name	Possible value
qbd.request.batchSize	1
qbd.request.enableBatchProcessing	true
qbd.request.enableRequestHandler	true
qbd.request.encoding	utf-8
qbd.request.qbXmlVersion	13.0
qbd.request.removeEmptyTags	true
qbd.request.splitterXpath	QBXML/QBXMLMsgsRq/{entityName}{operation}Rq/
qbd.request.unWrapRoot	true
qbd.response.enableResponseHandler	true

RSS Feed

Property name	Possible value
rssFeeds.dateFormat	yyyy-MM-dd'T'HH:mm:ss.S
rssFeeds.driverId	192168001075140479727815800002
rssFeeds.driverUrl	jdbc:rss:
rssFeeds.timeZone	GMT

Sage One

Property name	Possible value
sageone.accessTokenValueMap	N/A
sageone.api.contentType	application/json
sageone.appKey	ENC(rjwdfjzBB22O8ShI6k78//g3zc/xGQya66F7r2BCHnjcmE97E9AWdFqDVNWBB/Cd0BJhaZnZQDZPIGmFgEJ2vMXCqbPTVKJEc3GqNo6lCgS7wfyrcp9L6g==)
sageone.appKeySecret	ENC(odg7lQP9g9xNqOv3WPmm/bgGOMoWf5ZKTJLuv/jupXI=)
sageone.authorizationValueMap	response_type$code
sageone.baseApiUrl	https://api.accounting.sage.com
sageone.countryList	GB,US
sageone.dateFormat	yyyy-MM-dd hh:mm:ss
sageone.enableProduction	true
sageone.oauth.signatureMethod	HMAC-SHA1
sageone.oauth10.accessToken	N/A
sageone.oauth10.authorize	N/A
sageone.oauth10.requestToken	N/A
sageone.oauth20.accessToken	https://oauth.accounting.sage.com/token
sageone.oauth20.authorize	https://www.sageone.com/oauth2/auth/central
sageone.oauthVersion	2.0
sageone.refreshToken	https://oauth.accounting.sage.com/token
sageone.refreshTokenValueMap	N/A
sageone.request.batchSize	1
sageone.request.enableBatchProcessing	true
sageone.request.enableRequestHandler	true
sageone.request.errorXpath	errors/error
sageone.request.splitterXpath	{entityName}s/{entityName}
sageone.request.unWrapRoot	true
sageone.response.enableResponseHandler	true
sageone.response.maxResults	20
sageone.response.queryResponseXpath	{entityName}s/
sageone.scope	full_access
sageone.signingSecret
sageone.timeZone	UTC

Salesforce

Property name	Possible value
salesforce.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
salesforce.driverId	192168001083140180460468800004
salesforce.driverUrl	jdbc:salesforce:
salesforce.productionUrl	https://login.salesforce.com/services/Soap/c/29.0
salesforce.sandboxUrl	https://test.salesforce.com/services/Soap/c/29.0
salesforce.timeZone	GMT
salesforcerest.accessTokenValueMap	N/A
salesforcerest.api.contentType	application/xml
salesforcerest.appKey
salesforcerest.appKeySecret
salesforcerest.authorizationValueMap	response_type$code
salesforcerest.baseApiUrl	$dynamic$
salesforcerest.concurrent.restApi.request.limit	5
salesforcerest.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
salesforcerest.enableProduction	true
salesforcerest.encryptionProtocol	TLSv1.2
salesforcerest.oauth.signatureMethod	PLAINTEXT
salesforcerest.oauth10.accessToken	N/A
salesforcerest.oauth10.authorize	N/A
salesforcerest.oauth10.requestToken	N/A
salesforcerest.oauth20.accessToken	https://{domain}.salesforce.com/services/oauth2/token
salesforcerest.oauth20.authorize	https://{domain}.salesforce.com/services/oauth2/authorize
salesforcerest.oauthVersion	2.0
salesforcerest.refreshToken	https://{domain}.salesforce.com/services/oauth2/token
salesforcerest.refreshTokenValueMap	N/A
salesforcerest.request.batchSize	1
salesforcerest.request.enableBatchProcessing	false
salesforcerest.request.enableRequestHandler	true
salesforcerest.request.errorXpath	Errors/Error
salesforcerest.request.removeEmptyTags	true
salesforcerest.request.splitterXpath	SalesforceRequest/
salesforcerest.request.unWrapRoot	true
salesforcerest.response.enableResponseHandler	true
salesforcerest.response.limit	25
salesforcerest.source.queueSize	100
salesforcerest.timeZone	GMT

ServiceNow

Property name	Possible value
servicenow.accessTokenValueMap	N/A
servicenow.api.contentType	application/json
servicenow.authorizationValueMap	response_type$code
servicenow.baseApiUrl	$dynamic$/api
servicenow.encoding	UTF-8
servicenow.oauth20.accessToken	https://{domain}.service-now.com/oauth_token.do
servicenow.oauth20.authorize	https://{domain}.service-now.com/oauth_auth.do
servicenow.oauthVersion	2.0
servicenow.refreshToken	N/A
servicenow.refreshTokenValueMap	N/A
servicenow.request.batchSize	1
servicenow.request.enableBatchProcessing	false
servicenow.request.enableRequestHandler	true
servicenow.request.splitterXpath	Root/
servicenow.request.unWrapRoot	true
servicenow.response.dateFormat	yyyy-MM-dd HH:mm:ss
servicenow.response.timeZone	GMT
servicenow.source.pageSize	1000

Sharepoint

Property name	Possible value
sharepoint.authScheme	NONE
sharepoint.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
sharepoint.driverId	192168001083140180513854900018
sharepoint.driverUrl	jdbc:sharepoint:
sharepoint.edition	SharePoint Online
sharepoint.timeZone	GMT

Shopify

Property name	Possible value
shopify.api.contentType	application/json
shopify.appKey
shopify.appKeySecret
shopify.baseApiUrl	$dynamic$
shopify.dateFormat	yyyy-MM-dd'T'HH:mm:ssXXX
shopify.enableProduction	true
shopify.encoding	UTF-8
shopify.oauth.signatureMethod	HMAC-SHA256
shopify.oauth10.accessToken	N/A
shopify.oauth10.authorize	N/A
shopify.oauth10.requestToken	N/A
shopify.oauth20.accessToken	https://{domain}.myshopify.com/admin/oauth/access_token
shopify.oauth20.authorize	https://{domain}.myshopify.com/admin/oauth/authorize
shopify.oauthVersion	2.0
shopify.refreshToken	N/A
shopify.request.batchSize	1
shopify.request.enableBatchProcessing	true
shopify.request.enableRequestHandler	true
shopify.request.errorXpath	errors/error
shopify.request.splitterXpath	{entityName}s/{entityName}
shopify.request.unWrapRoot	true
shopify.response.enableResponseHandler	true
shopify.response.queryResponseXpath	{entityName}s/
shopify.scope	read_orders,write_orders,read_customers,write_customers,read_shipping,write_shipping,read_products,write_products,read_content,write_content,read_themes,write_themes,read_draft_orders, write_draft_orders,read_script_tags, write_script_tags,read_fulfillments, write_fulfillments,read_analytics,read_checkouts, write_checkouts,read_reports, write_reports,read_price_rules, write_price_rules
shopify.source.bucketSize	2
shopify.source.pageSize	250
shopify.timeZone	EST5EDT
shopify.version	api/2021-01

Xero

Property name	Possible value
xero.api.contentType	application/xml
xero.appKey	B73C1FB92E5C4169A2D1F2CF2962A211
xero.appKeySecret	JfFgUakWwwkf7997meINiZ1Ad_1drbFGoCHuLAkRFzPgGA9B
xero.baseApiUrl	https://api.xero.com
xero.clientAuthentication	true
xero.clientKeystore	xeroapps.p12
xero.clientKeystorePassword
xero.clientKeystorePrivateKeyPassword
xero.clientKeystoreType	PKCS12
xero.dateFormat	yyyy-MM-dd'T'hh:mm:ss
xero.enableProduction	true
xero.encoding	UTF-8
xero.oauth.signatureMethod	RSA-SHA1
xero.oauth10.accessToken	https://api.xero.com/oauth/AccessToken
xero.oauth10.authorize	https://api.xero.com/oauth/Authorize
xero.oauth10.requestToken	https://api.xero.com/oauth/RequestToken
xero.oauth20.accessToken	https://identity.xero.com/connect/token
xero.oauth20.authorize	https://login.xero.com/identity/connect/authorize
xero.oauthVersion	2.0
xero.refreshToken	https://identity.xero.com/connect/token
xero.request.batchSize	1
xero.request.enableBatchProcessing	false
xero.request.enableRequestHandler	true
xero.request.errorXpath	ApiException/Elements
xero.request.removeEmptyTags	true
xero.request.splitterXpath	{entityName}s/
xero.request.unWrapRoot	false
xero.response.enableResponseHandler	true
xero.response.queryResponseXpath	Response/{entityName}s/
xero.scope	offline_access accounting.transactions accounting.settings accounting.contacts payroll.employees
xero.timeZone	UTC

Zendesk

Property name	Possible value
zendesk.api.contentType	application/xml
zendesk.appKey	adeptia_test
zendesk.appKeySecret	f04884c916a978326d6cbedb4dad78b79c4e24af84864968e204fb806d374dcb
zendesk.authorizationValueMap	response_type$code
zendesk.baseApiUrl	$dynamic$
zendesk.dateFormat	yyyy-MM-dd'T'HH:mm:ss'Z'
zendesk.oauth.signatureMethod	PLAINTEXT
zendesk.oauth10.accessToken	N/A
zendesk.oauth10.authorize	N/A
zendesk.oauth10.requestToken	N/A
zendesk.oauth20.accessToken	https://{domain}.zendesk.com/oauth/tokens
zendesk.oauth20.authorize	https://{domain}.zendesk.com/oauth/authorizations/new
zendesk.oauthVersion	2.0
zendesk.refreshToken	N/A
zendesk.request.batchSize	1
zendesk.request.enableBatchProcessing	true
zendesk.request.enableRequestHandler	false
zendesk.request.errorXpath	errors/error/message
zendesk.request.splitterXpath	{entityName}s/
zendesk.request.unWrapRoot	true
zendesk.response.enableResponseHandler	true
zendesk.response.queryResponseXpath	{entityName}s/
zendesk.scope	read write
zendesk.timeZone	UTC

Zoho CRM

Property name	Possible value
zohocrm.accessTokenValueMap	N/A
zohocrm.api.contentType	application/json
zohocrm.appKey
zohocrm.appKeySecret
zohocrm.authorizationValueMap	response_type$code,access_type$offline
zohocrm.baseApiUrl	https://www.zohoapis.$dynamic$/crm
zohocrm.dateFormat	yyyy-MM-dd'T'HH:mm:ssZ
zohocrm.oauth20.accessToken	https://accounts.zoho.com/oauth/v2/token
zohocrm.oauth20.authorize	https://accounts.zoho.com/oauth/v2/auth
zohocrm.oauthVersion	2.0
zohocrm.refreshToken	https://accounts.zoho.com/oauth/v2/token
zohocrm.refreshTokenValueMap	N/A
zohocrm.request.batchSize	1
zohocrm.request.enableBatchProcessing	true
zohocrm.request.enableRequestHandler	true
zohocrm.request.errorXpath	response/error
zohocrm.request.splitterXpath	{entityName}s/{entityName}
zohocrm.request.unWrapRoot	false
zohocrm.response.enableResponseHandler	true
zohocrm.response.queryResponseXpath	zohocrm/zohocrm_api
zohocrm.scope	ZohoCRM.settings.modules.ALL,ZohoCRM.settings.ALL,ZohoCRM.modules.ALL,ZohoCRM.users.ALL
zohocrm.timeZone	PST
zohocrm.version	v2