Categories: Azure Data Factory

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 10-minute limit on the use of the access token

Exact Online is a SaaS ERP software package, offering accounting, HRM, CRM and financial processes. It’s a Dutch company, so it’s quite popular in Belgium and The Netherlands, which is also a reason I choose this specific REST API. But most of the techniques used in the blog post series can be applied to any other REST API.

Documentation about the REST API can be found here and here (make sure you’re using a browser where you aren’t logged into Exact Online, because for some reason this messes up the documentation pages). General docs about ADF and REST API can be found here. Note that there are 3rd party vendors out there who sell connectors for ADF and Power BI. They can make your life easier, but why pay when you can do everything yourself, right?

The full series:

  1. Fetching your first refresh/access tokens
  2. Getting a new access token from ADF
  3. Retrieving the divisions
  4. Retrieving data from an endpoint
  5. Dealing with pagination
  6. Getting around the 10 Minute Limit

------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
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.

View Comments

  • Hi Koen

    You have done a great job by covering this topic, it works for other Platformas like PureCloud as well.

    Thank you so much

Recent Posts

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…

5 days ago

dataMinds Connect 2024 – Session Materials

The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…

4 weeks ago

Connect to Power BI as a Guest User in another Tenant

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…

2 months ago

How to use a Script Activity in ADF as a Lookup

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…

4 months ago

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS…

4 months ago

Speaking at dataMinds Connect 2024

I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…

5 months ago