How do I return the Owner Name instead of Owner ID?

[Kiersten_K]

I am working through a scenario to send an email picking up data from a Workfront project and would love to be able to pull in the Owner ID as the Owner Name in the body of an email.

Is there a way to be able to do this in Fusion?

[lgaertner]

Hello Kiersten,

As Fusion itself is also using the general Workfront API, it is also capable of using nested queries.

So, if you need the name of the project owner instead if the ownerID, you will just need to map to the field

owner:name

to get it.

Regards

Lars

[Kiersten_K]

Hi Lars - Are you able to show an example of this set up? I currently only see the Owner ID being available. Thank you!

[lgaertner · Accepted solution]

Hello Kiersten,

you need to "manually" add the required nested field by clicking on the map toggle button next to Outputs.

Regards

Lars

[Kiersten_K]

Thank you!