Question
Assistance Needed: Fetching Data from Workfront Custom Report via API
Hi Team,
We've been working on fetching data from a report via the Workfront API, but have encountered some challenges. Here's a breakdown of the situation:
API Endpoint 1:
Endpoint:
https://domain.my.workfront.com/attask/api/v15.0/report/search?ID=65d8d1ac001xxxxxxxxxxxx&fields=*,definition
Response:
{
"data": {
"ID": "65d8d1ac001",
"name": "Tracking ID 2024",
"objCode": "PTLSEC",
:::::
"customerID": "57212cda00a5431b1234567",
"defaultTab": "C",
"description": "This report shows a summary of all the Tracking IDs requests and their respective CIDs",
"filterID": "65d8d1ac00122967d6705b3c457c3947",
"uiObjCode": "OPTASK",
"viewID": "65d8d1ac0012296543a71986de77c04d"
:::::
}
}
Issue: The data retrieved from this endpoint only provides metadata about the report, rather than the actual data it contains.
API Endpoint 2:
Endpoint:
https://domain.my.workfront.com/attask/api/v15.0/issue/search?customerID=57212cda00a5431b1234567&fields=parameterValues?$$FIRST=0&$$LIMIT=2000
Issue: We attempted to use this endpoint to fetch data based on the customerID obtained from Endpoint 1. However, the data retrieved doesn't match the content displayed in the report.
Request:
We need assistance in refining our approach to fetch the actual data from the "Tracking ID 2024" report via the Workfront API. Our goal is to obtain the report's data which we displayed in UI in JSON format.(attached the screenshots)
Could you please review the provided endpoints and advise on any corrections or alternative methods to achieve our objective?