Please enable JavaScript to view this site.

Exact Online Data Model

Navigation: » No topics above this level «

Provider ExactOnlineAll: Exact Online including both XML as well as REST APIs.

Scroll Comments Prev Top Next More

Exact Online including both XML as well as REST APIs.

Code for use in settings.xml: ExactOnlineAll

Alias: eol

Status: Production

Available in Editions: Paid

Technical Documentation: https://developers.exactonline.com

Provider Attributes

The following provider attributes are available for ExactOnlineAll:

Code

Description

Default Value

Set from Connection String

Set from Set SQL-Statement

Set from Providers File

api-client-id

The client ID is a unique identifier of your application. It is generated by registering an application.

 

 

api-client-secret

The client secret is to be kept confidential. Such as a password for a logon code, the client secret is the confidential part of an app identified by a client ID. It is needed during the OAuth2 Code Grant Flow together with the refresh token to get access.

***

 

api-redirect-url

The redirect URI is the website a browser session is redirected to after the OAuth2 authentication process has been completed.

 

 

api-refresh-token

Refresh Token is a security token for the OAuth2 Code Grant Flow. With a Refresh Token and client secret you can retrieve a renewed access token to access protected resources. A Refresh Token and client secret must be stored securely since once compromised allows access to your protected resources.

***

 

api-url

URL to access the API.

 

 

download-error-400-bad-request-max-tries

Maximum number of tries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-400-bad-request-sleep-initial-ms

Initial sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-400-bad-request-sleep-max-ms

Maximum sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-400-bad-request-sleep-multiplicator

Multiplication factor for sleep between retries Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-503-server-unavailable-max-tries

Maximum number of tries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-503-server-unavailable-sleep-initial-ms

Initial sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-503-server-unavailable-sleep-max-ms

Maximum sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-503-server-unavailable-sleep-multiplicator

Multiplication factor for sleep between retries Akamai reports that the API server is unavailable during retrieval of data.

 

download-error-argument-exception-max-tries

Maximum number of tries when an argument exception is returned when downloading a blob.

 

download-error-argument-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an argument exception is returned when downloading a blob.

 

download-error-argument-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an argument exception is returned when downloading a blob.

 

download-error-argument-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an argument exception is returned when downloading a blob.

 

download-error-internet-down-max-tries

Maximum number of tries when the Internet connection seems down during retrieval of data.

 

download-error-internet-down-sleep-initial-ms

Initial sleep in milliseconds between retries when the Internet connection seems down during retrieval of data.

 

download-error-internet-down-sleep-max-ms

Maximum sleep in milliseconds between retries when the Internet connection seems down during retrieval of data.

 

download-error-internet-down-sleep-multiplicator

Multiplication factor for sleep between retries when the Internet connection seems down during retrieval of data.

 

download-error-io-exception-max-tries

Maximum number of tries when a network I/O connection failure occurs during retrieval of data.

 

download-error-io-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when a network I/O connection failure occurs during retrieval of data.

 

download-error-io-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when a network I/O connection failure occurs during retrieval of data.

 

download-error-io-exception-sleep-multiplicator

Multiplication factor for sleep between retries when a network I/O connection failure occurs during retrieval of data.

 

download-error-json-exception-max-tries

Maximum number of tries when an invalid JSON body is returned.

 

download-error-json-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an invalid JSON body is returned.

 

download-error-json-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an invalid JSON body is returned.

 

download-error-json-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an invalid JSON body is returned.

 

download-error-other-exception-max-tries

Maximum number of tries when an unqualified error occurs during retrieval of data.

 

download-error-other-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data.

 

download-error-other-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data.

 

download-error-other-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an unqualified error ocurrs during retrieval of data.

 

download-error-socket-exception-max-tries

Maximum number of tries when the network connection is forcible dropped during retrieval of data.

 

download-error-socket-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data.

 

download-error-socket-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data.

 

download-error-socket-exception-sleep-multiplicator

Multiplication factor for sleep between retries when the network connection is forcible dropped during retrieval of data.

 

download-error-web-exception-max-tries

Maximum number of tries when a web connection failure occurs during retrieval of data.

 

download-error-web-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when a web connection failure occurs during retrieval of data.

 

download-error-web-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when a web connection failure occurs during retrieval of data.

 

download-error-web-exception-sleep-multiplicator

Multiplication factor for sleep between retries when a web connection failure occurs during retrieval of data.

 

exact-development-mode

True if we have to connect to the Exact development instance

 

exact-online-url

URL of Exact Online web service

 

 

hide-empty-columns

Whether to exclude columns without a value from a result set when using 'select *'

True

http-disk-cache

Action: provide 'empty' to empty HTTP disk cache.

 

 

 

http-disk-cache-compression-level

Compression level for the HTTP disk cache, ranging from 1 (little) to 9 (intense). Default is 5.

5

http-disk-cache-directory

Directory where HTTP cache is stored.

C:\Users\gle3\Invantive\Cache

http-disk-cache-max-age-sec

Maximum acceptable age in seconds for use of data in the HTTP disk cache.

2592000

http-get-timeout-ms

HTTP GET timeout (ms).

300000

http-memory-cache

Action: provide 'empty' to empty HTTP memory cache.

 

 

 

http-memory-cache-compression-level

Compression level for the HTTP memory cache, ranging from 1 (little) to 9 (intense). Default is 5.

5

http-memory-cache-max-age-sec

Maximum acceptable age in seconds for use of data in the HTTP memory cache.

14400

http-post-timeout-ms

HTTP POST timeout (ms).

300000

ignore-document-download-errors

Ignore all errors when fetching the document contents from Exact Online.

False

ignore-http-400-errors

Ignore HTTP 400 errors when exchanging results with the OData endpoint.

False

ignore-http-403-errors

Ignore HTTP 403 errors when exchanging results with the OData endpoint.

False

insert-allowed

Allow use of the BETA functionality for inserts

False

invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

True

invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

False

invantive-use-cache

Whether to cache the results of a query.

True

join-set-points-per-request

Maximum number of values in a request when executing a join set.

60

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

 

pre-request-delay-ms

Pre-request delay in milliseconds per request.

0

requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

16

result-set-cache

Action: provide 'empty' to empty.

 

 

 

slot-based-rate-limit-length-ms

Length in ms of a slot-based rate limit.

60000

 

slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit

 

 

standardize-identifiers

Rewrite all identifiers to the preferred standard casing as specified by standardize-identifiers-casing, plus yet undefined additional actions when changing a data model on a case-dependent platform.

True

standardize-identifiers-casing

Rewrite all identifiers to the preferred standard casing when changing a data model on a case-dependent platform.

True

totp-secret

Shared secret key to generate one-time password using TOTP RFC 6238. For improved security, manually enter the one-time password asked during login.

***

 

trace-native-calls

Trace native calls to data container backend.

False

update-allowed

Allow use of the BETA functionality for updates

False

use-http-disk-cache

Combination of use-http-disk-cache-read and use-http-disk-cache-write.

 

use-http-disk-cache-read

Whether to use HTTP responses from previous queries stored on disk to answer the current query.

True

use-http-disk-cache-write

Whether to memorize HTTP responses on disk.

True

use-http-memory-cache

Combination of use-http-memory-cache-read and use-http-memory-cache-write.

 

use-http-memory-cache-read

Whether to use HTTP responses from previous queries stored in memory that can answer the current query.

True

use-http-memory-cache-write

Whether to memorize HTTP responses from previous queries for use by future queries.

True

use-metadata-cache

Whether to use the metadata calculated previously

True

use-result-cache

Whether to use result sets from previous queries that can answer the current query

True