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

[ThoreEhrich]

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

[_Manish_Singh]

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]

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]

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

[Sven-iX]

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. 

[_Manish_Singh]

It makes sense now. Thanks!