Professional Services Firm
Near real-time updates from Workfront's API at the touch of a button
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.
- Professional Services Firm
Tech stack / Tools
- MS SQL