Finally we’ve come to the core of this blog post series: extracting data from a REST API endpoint. Just to recap, you need the following: an access token that is currently valid. See this blog post. a list of divisions. See the previous blog post. As an example, we’re going to read from the Projects […]
Author: Koen Verbeeck
Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.
Azure Data Factory and the Exact Online REST API – Retrieving the Divisions
In many ERP software you have the concept of “companies” or “divisions”, a way of logically dividing resources and assets. For example, if you have a company and a sister-company, you can create two divisions to keep everything separate. When you read data from an Exact Online API endpoint, you need to specify for which […]
Azure Data Factory and the Exact Online REST API – Getting a new access token from ADF
Before we create pipelines to fetch data from the REST API, we need to create a helper pipeline that will fetch a new access token. This pipeline has the following format: Get the last known refresh token from the database (or whatever storage you use). You need to have manually retrieved the first pair of […]
Azure Data Factory and the Exact Online REST API – Fetching your first refresh/access tokens
UPDATE 1: the layout seems to have been updated, but at the time of writing (Feb 2026), you can still revert back to the old layout which is consistent with the screenshots UPDATE 2: going to the app centre from your exact online app might not work when you’re using inprivate browsing To get data […]
Azure Data Factory and the Exact Online REST API – Introduction
I’m going to do a small blog post series on how to extract data from a REST API using Azure Data Factory. I’m going to use the Exact Online REST API, because it has a series of challenges: a complicated process to get your first access token endpoints with more data will use pagination a […]
Techorama 2021 – Session Materials
You can find the slides and the scripts used at Github. Hopefully we’ll see each other next year at an in-person event.
The GREATEST new T-SQL Function
If the title isn’t obvious enough, this blog post is about the new function GREATEST, and it’s sibling LEAST. But wait, how come there’s a new T-SQL function? There isn’t a new release of SQL Server! That’s right, those two new functions are released in Azure SQL DB, Azure SQL Managed Instance and Azure Synapse […]
Speaking about Snowflake at Techorama 2021
I’m delighted to announce I’m selected to give an introduction to Snowflake on Azure at the virtual Techorama event. You can find more info about the session here. The agenda of the event looks very promising. There are many great sessions related to the Microsoft Data Platform, but the other categories are great as well. […]
Book review: Calling Bullshit – The Art of Skepticism in a Data-Driven World
I recently finished the book Calling Bullshit – The Art of Skepticism in a Data-Driven World by Carl T. Bergstrom & Jevin D. West. I found it a very entertaining read, and especially useful in this day and age of social media, fake news and deep fakes. Calling out bullshit has been necessary for a […]
#TSQL2sday 136 – Your Favorite Data Type
It’s T-SQL Tuesday time again, and this month’s honor to host the blog party goes to Brent Ozar. The topic is data types: Mad about money? Feverish about float? Tell us what you use your favorite data type for, and what people need to know before they get started using it. Data types have so many interesting […]