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
0
votes
1 answer

Analyze data volume of API calls with Invantive SQL

The SQL engine hides away all nifty details on what API calls are being done. However, some cloud solutions have pricing per API call. For instance: select * from transactionlines retrieves all Exact Online transaction lines of the current…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Retrieve list of accounts with specific classification

I want to retrieve a list of customer names and a list of the assigned account manager and region as registered using a custom property. Using the following query, I get multiple lines per customer: select accountclassifications_account_name , …
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
0 answers

Exact Online Authorization

I have registered two apps(app target as 'Test') on Exact online,redirect url for one of these application is azure hosted site and other with locally hosted site. App with locally hosted site authorizes properly and returns token…
Bhagyashri
  • 1
  • 2
0
votes
1 answer

Exact Online Picqer Stock request

I'm trying to build an import function for exact online to Magento. I want to read out all products (Items) in exact online and add the right Stock and Sale Price to a loop. However I cant get it to work because of the different errors i get. Can…
Lex
  • 49
  • 6
0
votes
1 answer

Retrieve list of General Ledger transaction lines without error itgenugs026

When I run the following query on Exact Online, I receive an error itgenugs026: The requested number of 1,396 columns is not supported. select * from GLTransactionLines t How can I get the list of general ledger transactions through the XML…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Query to get list of shipped serial numbers in Exact Online

We ship item per serial number using Exact Online as ERP system. I seem unable to find the column names to retrieve a list of shipments of serial numbers and associated invoices.
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

How to upload a document with attachments into Exact Online using REST API

I want to upload files as attachment to a document in Exact Online. The following SQL has been used to create the document: insert into exactonlinerest..documents ( salesinvoicenumber , type , subject , account ) select 16700001 , 10 , …
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Upload XML payload into multiple Exact Online companies

Using a query as below, you get output in the XML format required for Exact Online. These XML messages can be put in many files on disk using: local export documents in filecontents to "c:\temp\in" filename column filename And then loaded into…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Performance of many Exact Online excel formulas for sales transactions

We have an Excel spread sheet which has horizontally all financial periods considered (13, one year plus one month) and vertically a list of article codes. The intersecting cells contain the sold quantity in that period of an article, using General…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
2 answers

Log HTTP request and response executed by a 3rd party NuGet package

I use a API client NuGet package that sends HTTP requests and receives responses from a third party API. How can I capture and log the HTTP requests and responses executed by that NuGet package in order to store them in a log database? Example: var…
Korneel
  • 1,487
  • 14
  • 40
0
votes
1 answer

Quantity in stock in stock locations in Exact Online

Using the following query, I found that for items that have a stock location, there are multiple rows returned from the REST API StockLocations of Exact Online: select spn.item_code_attr || '-' || spn.warehouse_code_attr || '-' || stn.code key , …
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

upload file xml via API

I try to create a php script to send a xml file via an API exact online . My file is on /tmp/xxx.xml php code (connexion on exact online api) :
FAPM
  • 1
  • 6
0
votes
1 answer

How to perform GET/POST request using OmniAuth

Am using omniauth-exact gem to authenticate the user to ExactOnline, it works perfectly good but after authenticating the user I also need to query back to ExactAPI and fetch some data which in case am supposed to use either GET,POST method. The…
Little Phild
  • 785
  • 1
  • 6
  • 17
0
votes
1 answer

How to retrieve data from an Api using Faraday gem

Am trying to access data from Exact Online API Using Faraday Gem and it is returning the status of "401" meaning am not authorized to access that link before I login, but I had already been authenticated and I logged in successfully in a different…
Little Phild
  • 785
  • 1
  • 6
  • 17
0
votes
1 answer

Weird response from Exact Online API using Auth 2.0

I was able to download some PHP code from exact online to connect to their API. Using this, I get logged in and get all the data such as my access token. Now, when I do a simple http get on start.exactonline.nl/api (exactly as stated on their…
Tijn Snijders
  • 83
  • 1
  • 8
1 2 3
…
10
11