Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

Workfront api to fetch custom report data

Avatar

Level 1

Is there an API in Workfront to fetch custom report data.

I see a request https://XXX.XXX.workfront.com/internal/qslist which is fetching the data but i need an API

Eg: /attask/api/v14.0/PTLSEC?

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

It's unclear what you are hoping to get in the response payload.

Calling on /attask/api/v14.0/PTLSEC? will return a list of reports, not the actual data that those reports display when viewed in a browser.

If you have a report that you view in browser and you're wanting to fetch the same data that's displayed in that report via API, you need to reconstruct the logic of the report into your query parameters, and call on the object type being reported.

E.g., if you have a project report that displays all active projects owned by John Doe, with columns for status and planned completion date, and you want to get those same results via API, then you need to build that same logic into your query: 

 

https://domain.my.workfront.com/attask/api/v15.0/PROJ/search?ownerID=John's_ID&status=CUR&fields=status,plannedCompletionDate 

 


Suggest reading this article for more examples:
https://experienceleague.adobe.com/docs/workfront/using/adobe-workfront-api/api-general-information/... 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

It's unclear what you are hoping to get in the response payload.

Calling on /attask/api/v14.0/PTLSEC? will return a list of reports, not the actual data that those reports display when viewed in a browser.

If you have a report that you view in browser and you're wanting to fetch the same data that's displayed in that report via API, you need to reconstruct the logic of the report into your query parameters, and call on the object type being reported.

E.g., if you have a project report that displays all active projects owned by John Doe, with columns for status and planned completion date, and you want to get those same results via API, then you need to build that same logic into your query: 

 

https://domain.my.workfront.com/attask/api/v15.0/PROJ/search?ownerID=John's_ID&status=CUR&fields=status,plannedCompletionDate 

 


Suggest reading this article for more examples:
https://experienceleague.adobe.com/docs/workfront/using/adobe-workfront-api/api-general-information/... 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf