Workfront api to fetch custom report data | Community
Skip to main content
A
adfasd
February 25, 2023
Solved

Workfront api to fetch custom report data

  • February 25, 2023
  • 1 reply
  • 2039 views

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?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by William--

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/api-basics.html?lang=en 

1 reply

William--
Community Advisor
William--Community AdvisorAccepted solution
Community Advisor
February 25, 2023

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/api-basics.html?lang=en 

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

    Loading footer...