Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: rest api

Planview Portfolios REST API with ADF – Retrieving Actual Data

May 26, 2024May 26, 2024 Koen Verbeeck Leave a comment

In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST API using Azure Data Factory. Any tool that can send HTTPS requests can work with the REST API, but our focus here is ADF (which can also be Synapse Pipelines or Fabric Pipelines). In the […]

Read More

Planview Portfolios REST API with ADF – Fetching the Access Token

May 26, 2024May 26, 2024 Koen Verbeeck Leave a comment

In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios RESET API using Azure Data Factory. Any tool that can send HTTPS requests can work with the REST API, but our focus here is ADF (which can also be Synapse Pipelines or Fabric Pipelines). In the […]

Read More

Planview Portfolios REST API with ADF – The OData Feed

May 26, 2024May 26, 2024 Koen Verbeeck Leave a comment

In the introduction, I explained the setup of the use case and why we need to use the OData feed: to get the list of Project IDs, because the REST API doesn’t have an endpoint for this. Weird, right? In this part of the series, we’ll dive into the Lookup activity, which uses the OData […]

Read More

Reading AFAS REST API Data with Azure Logic Apps

February 26, 2023February 26, 2023 Koen Verbeeck Leave a comment

Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process is mostly the same as reading the data with Azure Data Factory (check out this blog post to learn more): There’s a minor difference in how […]

Read More

Extracting Data from the AFAS REST API with Azure Data Factory

March 7, 2022March 7, 2022 Koen Verbeeck 8 Comments

AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the service using a REST API (there are also SOAP web services available for those who appreciate the trip down memory lane). In this blog post I’ll show you how you can get data out of […]

Read More

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

May 25, 2021May 25, 2021 Koen Verbeeck 7 Comments

This is the final blog post of this series on how to extract data from the Exact Online REST API with Azure Data Factory. I’ve you followed along with the previous posts, you’ve seen how you can request new refresh/access tokens from the API, how you can extract data from an endpoint for multiple divisions […]

Read More

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

May 25, 2021May 25, 2021 Koen Verbeeck 16 Comments

Some endpoints don’t have that much data, both others certainly will, for example financial transactions. The REST API limits the number of records it returns, and for most endpoints this is 60 records. After the first 60 records, you get a link at the bottom of the response that points to the next 60 records. […]

Read More

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

May 24, 2021May 25, 2021 Koen Verbeeck 2 Comments

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 […]

Read More

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

May 24, 2021May 25, 2021 Koen Verbeeck 2 Comments

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 […]

Read More

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

May 24, 2021May 25, 2021 Koen Verbeeck 6 Comments

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 […]

Read More

Posts pagination

1 2 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress