Exact Online

Exact Online is a cloud-based platform that supports all major business processes such as production, logistics, finance & administration, HR, sales and marketing.

Data integration: Skyvia supports importing data to and from Exact Online, exporting Exact Online data to CSV files, replicating Exact Online data to relational databases, and synchronizing Exact Online data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Exact Online.

Query: Skyvia Query supports Exact Online.

Establishing Connection

To create a connection to Exact Online, select the region and sign in with Exact Online.

Creating Connection

To connect to Exact Online, perform the following steps:

exactonline-connection

  1. Select the region from the list.
  2. Click Sign in with Exact Online.
  3. Enter the user name and password.

exactonline-credentials

Additional Connection Parameters

Division

The name of the company you want to access.

Metadata Cache

You can specify the time when the Metadata Cache expires.

Exact Online provides only one refresh token at a time. If someone logs in with the same credentials and gets their own set of tokens, the existing ones will be invalid.

Connector Specifics

API Limits

Consider the following API limits when querying Exact Online objects:

  • Minutely limit: 60 API calls, per company, per minute.

  • Daily limit: 5,000 API calls, per company, per day.

  • No more than 10 errors per API key (code 400, 401, 403, and 404) - The block will automatically be lifted after one hour and will gradually increase when you continue making these errors.

  • A single HTTP POST request to the Exact Online API has a size limit of 10 MB.

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for objects that have UpdatedDate or CreatedDate fields.

Skyvia supports Synchronization for objects that support the INSERT and UPDATE operations and have the UpdatedDate or CreatedDate fields.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE AccountInvolvedAccounts, AccountOwners, InvolvedUserRoles, InvolvedUsers, SolutionLinks, TaskTypes, DepreciationMethods, DirectDebitMandates, Accounts, Addresses, BankAccounts, Contacts, Opportunities, QuotationLines, QuotationOrderChargeLines, Quotations, DocumentFolders, Documents, DocumentTypeFolders, ExchangeRates, AccountClassificationMappings, GLAccounts, Journals, Costcenters, Costunits, AssemblyBillOfMaterialHeader, AssemblyBillOfMaterialMaterials, BatchQuantitiesPerWarehouses, ItemWarehouses, StockBatchNumbers, StockCountLines, StockCounts, StockSerialNumbers, Warehouses, WarehouseTransferLines, WarehouseTransfers, CustomerItems, Items, SalesItemPrices, SupplierItem, Mailboxes, BillOfMaterialMaterials, BillOfMaterialRoutings, BillOfMaterialVersions, EmployeeWorkcenters, OperationResources, Operations, ProductionAreas, ShopOrderMaterialPlans, ShopOrderRoutingStepPlans, ShopOrders, TimedTimeTransactions, ManufacturingTimeTransactions, Workcenters, CostTransactions, EmployeeRestrictionItems, InvoiceTerms, ProjectAccountMutations, ProjectClassifications, ProjectHourBudgets, ProjectPlanning, ProjectPlanningRecurring, ProjectRestrictionEmployeeItems, ProjectRestrictionEmployees, ProjectRestrictionItems, ProjectRestrictionRebillings, Projects, TimeCorrections, TimeTransactions, WBSActivities, WBSDeliverables, WBSExpenses, PurchaseInvoices, PurchaseEntries, PurchaseEntryLines, PurchaseOrderLines, PurchaseOrders, SalesChannels, SalesEntries, SalesEntryLines, SalesInvoiceLines, SalesInvoiceOrderChargeLines, SalesInvoices, PlannedSalesReturns, SalesOrders, SalesOrderLines, SalesOrderOrderChargeLines, Subscriptions, SubscriptionLines, VATCodes, WebhookSubscriptions
INSERT, UPDATE MailMessages, VariableMutations, GoodsReceipts, PurchaseReturns, DropShipments, GoodsDeliveries
UPDATE, DELETE PlannedSalesReturnLines
INSERT CommunicationNotes, Complaints, Events, ServiceRequests, Tasks, PaymentConditions, OfficialReturns, BankEntryLines, CashEntryLines, GeneralJournalEntryLines, MailMessageAttachments, MailMessagesSent, ByProductReceipts, ByProductReversals, MaterialIssues, MaterialReversals, ShopOrderReceipts, ShopOrderReversals, StageForDeliveryReceipts, StageForDeliveryReversals, SubOrderReceipts, SubOrderReversals
UPDATE Payments, Receivables, ShopOrderPriorities, PurchaseReturnLines, DropShipmentLines, GoodsDeliveryLines
DELETE Divisions

Stored Procedures

Skyvia represents part of the supported Exact Online features as stored procedures. You can call a stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.

UserHasRights

To view what actions a user can perform against the object, use the command

call UserHasRights(:object)

For example, the call UserHasRights('SalesOrders') displays the operations, the user can run against the SalesOrder object.

To see if a particular action is available for a user, use the command

call UserHasRights(:object, :action)

For example, the call UserHasRights('SalesOrders', 'POST') displays if the user can run the POST action against the SalesOrder object.

GetTablesInfo

The following command displays the general information about all Exact Online objects: object name, supported operations, endpoint.

call GetTablesInfo

The following command displays the general information about the specific object.

call GetTablesInfo(:object)

Supported Actions

Skyvia supports all the common actions for Exact Online.

On This Page