Workfront External Lookup field to return Data Store Data from Workfront Fusion | Community
Skip to main content
Level 2
March 19, 2025
Solved

Workfront External Lookup field to return Data Store Data from Workfront Fusion

  • March 19, 2025
  • 2 replies
  • 746 views

Hi Community, 

 

We want to connect an External Lookup field from Workfront to return data from a Data Store from Workfront Fusion. We were not able to find the correct Base API URL to reach out to Fusion. 

 

For example to get data from Workfront Planning you have the following Base API URL: $$HOST/maestro/api/v1/records/search?recordTypeId={recordTypeID}

For Fusion do we need to change the Solution name from Maestro to Fusion and to change the version accordingly? 

 

Does someone did that before or can assist?

 

Thanks and kind regards

Best answer by Sven-iX

Hello @thoreehrich 

 

You can't simply "connect to Fusion".

To read from a Fusion data store, you have to have a scenario that responds. That means a scenario that has

  • webhook (which you use in your Base API URL field + query parameters)
  • Data store search
  • possibly something that formats the JSON data 
  • webhook response that returns the response body (the results to display)

Does that help? 

2 replies

_Manish_Singh
Level 9
March 19, 2025

Hello @thoreehrich - External lookup fields retrieve data from API end points. For example, "records" is an end point in your planning example. Since Fusion API are unknown, I believe it might not be possible. Other community members may have a solution.

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 19, 2025

Hello @thoreehrich 

 

You can't simply "connect to Fusion".

To read from a Fusion data store, you have to have a scenario that responds. That means a scenario that has

  • webhook (which you use in your Base API URL field + query parameters)
  • Data store search
  • possibly something that formats the JSON data 
  • webhook response that returns the response body (the results to display)

Does that help? 

_Manish_Singh
Level 9
March 19, 2025

Nice idea @sven-ix, but how will the scenario be triggered when someone wants to fill in the external lookup field?

Sven-iX
Community Advisor
Community Advisor
March 19, 2025

The scenario is your "API" - it'll respond with the data. 

 

Use the External Lookup documentation for "external API" 

 

The caveat is that the API usually is fast, and that Fusion is - meh. So performance may not be optimal, but it sure works. Had to implement this approach (driving external lookups via Fusion) at a client.