Workfront to Airtable API integration

[Brit_Miller1]

Has anyone created an API between Workfront and Airtable? We currently use Airtable for project management/planning and sharing of projects, but creative requests/approvals go through Workfront… would be looking for one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system). I’m only familiar with Zapier to connect platforms and unfortunately Workfront is not available there, so wondering if anyone has had success connecting these two with a custom API?

TIA!

[Engjell_Sela]

Is it possible to connect Workfront with a custom API?

[Bill_French · Accepted solution]

Engjell_Sela:

Is it possible to connect Workfront with a custom API?

Yep - API: Home

Brit_Miller1:

one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system)

Yep. Did one for a client a few years ago. Task Search makes it possible to read any task-related data and push it through to Airtable based on a matching scheme. Ideally, the task IDs exist in Airtable whenever a new task is created in WorkFront. This is accomplished by creating webhooks that intercahnge data into Airtable in real-time. They are still building out some of the functionality of WorkFront but there’s enough there to build something.

The solution will require webhooks in Airtable and WorkFront.

CAUTION - this is one of the more complex APIs and building a truly integrated solution will be expensive.

[Brit_Miller1]

Thanks for this info! Yes I believe I’d need to go the route of having a custom API built and certainly understand the type of integrated solution we are seeking will be expensive. If you don’t mind me asking, what would you estimate to build this solution?

[Brit_Miller1]

Hm, yes looks like I’ll need a custom API :slightly_smiling_face: Thanks for your reply!

[Bill_French]

Brit_Miller1:

what would you estimate to build this solution?

Wild guess - if we keep the first phase narrow and successfully move data from Workfront to Airtable using a webhook architecture, we might be able to develop a success pattern quickly for about $1k setting aside all of setup and credential issues.

In my view, you first want to create a success pattern that can be used as the guideposts for additional automation that you can probably implement internally.

[Brit_Miller1]

Super helpful, thank you! Is that something you are still available to do for clients?

[joannsalomon]

Both platforms require authentication to access their APIs. Your developer will need to set up the necessary authentication methods (API keys, tokens, etc.) for secure communication. Determine the data that needs to be transferred for the "b2b data building" process from Workfront to Airtable. This includes fields like dates, final assets, and other relevant information for effective b2b data building. Map out how this data will be structured in Airtable to ensure seamless integration and accurate data organization for the b2b data building endeavor.