Azure Data Factory and the Exact Online REST API – Getting around the 10 Minute Limit

4 years ago

This is the final blog post of this series on how to extract data from the Exact Online REST API…

Azure Data Factory and the Exact Online REST API – Dealing with Pagination

4 years ago

Some endpoints don't have that much data, both others certainly will, for example financial transactions. The REST API limits the…

Azure Data Factory and the Exact Online REST API – Retrieving Data from an Endpoint

4 years ago

Finally we've come to the core of this blog post series: extracting data from a REST API endpoint. Just to…

Azure Data Factory and the Exact Online REST API – Retrieving the Divisions

4 years ago

In many ERP software you have the concept of "companies" or "divisions", a way of logically dividing resources and assets.…

Azure Data Factory and the Exact Online REST API – Getting a new access token from ADF

4 years ago

Before we create pipelines to fetch data from the REST API, we need to create a helper pipeline that will…

Azure Data Factory and the Exact Online REST API – Fetching your first refresh/access tokens

4 years ago

To get data out of the REST API of Exact Online, we first need to authenticate ourselves. With APIs, typically…

Azure Data Factory and the Exact Online REST API – Introduction

4 years ago

I'm going to do a small blog post series on how to extract data from a REST API using Azure…

Techorama 2021 – Session Materials

4 years ago

You can find the slides and the scripts used at Github. Hopefully we'll see each other next year at an…

The GREATEST new T-SQL Function

4 years ago

If the title isn't obvious enough, this blog post is about the new function GREATEST, and it's sibling LEAST. But…

Speaking about Snowflake at Techorama 2021

4 years ago

I'm delighted to announce I'm selected to give an introduction to Snowflake on Azure at the virtual Techorama event. You…