Stack Overflow
Stack Overflow

Questions tagged [exact-online]

Exact Online is an online accounting program. It has a CSV, XML and REST API to communicate with.

Exact Online is an online accounting program. It has over 1.000 CSV, XML and REST API's to communicate with. Many APIs offer DML features.

Some useful resources to start programming against the XML and REST API of Exact Online:

156 questions
1
vote
1 answer

How to deal with ratelimit off booked project hours - Exact Online

My goal is to get the hours booked on projects for the years 2020-2021 from Exact Online. Currently, I am trying to get the right data with Postman and afterward I want to implement it in Python. I use the project/TimeTransaction API. The API call I…
RvZenden
  • 13
  • 3
1
vote
3 answers

Exact Online API - Fetch child entity attributes in same call as parent

Request Url: https://start.exactonline.nl/docs/HlpRestAPIResourcesDetails.aspx?name=CRMAccounts While fetching all CRMAccounts, I would also like to fetch some fields stored in AccountManager. I have tried to use the 'expand' query parameter for…
Michel Rummens
  • 459
  • 3
  • 9
1
vote
1 answer

Exact API - SalesOrderLines (Item Mandatory: Unit) even when the unit is there

We import orders into Exact API which works for UK, NL but now we are trying to import DE orders too. We have everything setted up, but when we are trying to import orders we get an error which looks like this: Item Mandatory: Unit Even when we…
Dominik
  • 11
  • 2
1
vote
2 answers

Problem with getting the sales price of item in Exact Online

I am trying to use the exact online API, my web application can connect with the API and create Accounts, Items and all the other things. But now, inside off my web application I need those Accounts and Items etcetera, I got it done to select all…
Xxx red
  • 45
  • 1
  • 2
  • 11
1
vote
1 answer

ExactOnline - Error 403: Forbidden - The division is blocked

I am using ExactOnline API to fetch the transactions, my API is working fine, but suddenly the Error 403: Forbidden - The division is blocked error occurs and API return the empty result. Please help. Thanks.
Tks Tkstest
  • 11
  • 1
1
vote
1 answer

Updating record from PHP Client library for Exact Online

I had used PHP Client library for Exact Online. I need to store the record, based on the condition if it exists or not. Since records are saving successfully. But unfortunately records are not updating. $customer = [ 'address' =>…
Nɪsʜᴀɴᴛʜ ॐ
  • 2,756
  • 4
  • 33
  • 57
1
vote
1 answer

Budget and actual rows not merged on full outer join

The following query: select coalesce(to_number(bl.division_code), bud.division) division , coalesce(bud.glaccountcode, bl.costcenter_costanalysis_period_periods_year_years_balance_code_attr) glaccountcode , coalesce(bud.costcenter,…
H Jansen
  • 319
  • 1
  • 8
1
vote
1 answer

How to get Division for api (exact online)

i'm wondering how to get the division that is required for most api calls to the exact online platform. Also the documentation suggests that I use api/v1/current/Me to be the first call however when running this I receive the following (which is…
NealVDV
  • 2,302
  • 3
  • 26
  • 51
1
vote
1 answer

How to call update request using exact online API

i am using exact online PHP SDK. i am able to create record using POST Request. How to send update request to update SalesOrder DeliveryDate using Orderid?
zakku za
  • 41
  • 6
1
vote
1 answer

The attachments is empty in mailmessageattachments

When I execute the query as shown the attachment is always empty. I would expect that the contents of the attachment with name AttachmentFileName would be in the column Attachment. How do I retrieve the blob of the file? select /*+ join_set(mat,…
user9461953
1
vote
1 answer

itgendch033: Backing databases require Invantive Data Replicator to restrict the number of columns to 1,000 for 'ExactOnlineXML.XML.SubscriptionLines'

When executing the batch script to replicate my data from Exact Online, I get the following error: Error itgencun016: Exclamation itgendch033: Backing databases require Invantive Data Replicator to restrict the number of columns to 1,000 for…
KPI Solutions
  • 47
  • 3
1
vote
1 answer

Connecting R Studio to Exact Online API

I am trying to establish a connection with the Exact Online API and am following the steps listed at the Exact Online community page: https://support.exactonline.com/community/s/knowledge-base#All-All-DNO-Task-oauth-eol-oauth-dev-oauth2tut. I…
Stan
  • 480
  • 1
  • 5
  • 18
1
vote
1 answer

itgendid012: Last part of the SQL statement has not been recognized on distributed Exact Online query

When I connect to a distributed database containing one Exact Online country (alias 'eol') and SQL Server (alias 'sqlserver'), I get an error when executing the following query to get the RGS balances from the current company over 2017: select *…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
1
vote
3 answers

Exact online REST API: POST call not working

I am trying to make a post call in Exact Online REST API. I'm trying to create a SalesInvoiceLine. I can perfectly do a GET call via my browser. I am logged in in Exact Online so I don't need authentication since this should be passed via a cookie.…
user9395660
1
vote
1 answer

Retrieve Assortments (Dutch: "Assortimenten") on Exact Online

For a CSV dump of articles with stock and price information from Exact Online, I need to restrict the list of articles the CSV to articles in an Assortment (Dutch: "Assortiment"). The REST-APIs do not seem to offer this information. It is possible…
Goombah
  • 2,835
  • 2
  • 12
  • 22
1 2 3
…
10 11