Workfront connector

Professional Services Firm

Near real-time updates from Workfront's API at the touch of a button

Overview

Harnessing Workfront’s webhook capabilities, together with Wokfront’s API, we created a service to update an internal database which would support reports built both in Metabase and PowerBI.

Our client required sophisticated reporting for senior management. These reports needed to go beyond Workfront’s existing capabilities, cross-referencing with other data sources and updating in real time.

To create these reports, we used Workfront’s web-hooks to build our own queue of updates utilizing Redis, so we could optimize the number of API calls to Workfront. The results were fed into an external database, in this case a Microsoft SQL Server database in Azure. In this case, we used the NestJS framework to code our integration.

Once the initial project was completed, we went further and used the integration to feed other external systems, like the client’s DAM.

About the client

One of the leading professional services networks in the world, with offices in more than 150 countries, more than 270,000 people and annual gross revenues of more than US$40 billion. With an extensive online presence, their main global website alone contains more than 50,000 pages.

Client

  • Professional Services Firm

Tech stack / Tools

  • NestJS
  • MS SQL
  • Redis

Integrations

  • Workfront
  • PowerBI
  • Metabase

Cloud setup

  • Azure
  • Bitbucket