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:
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:
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…
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