Required for Remapping Data from Adobe Workfront API
Hi Support Team,
We are trying to generate an output Excel file that pulls data from the Adobe Workfront custom report. To achieve this, we are using the following API to fetch the entire custom report content:
API Endpoint
https://xxx.my.workfront.com/attask/api/v15.0/OPTASK/search?entryDate=$$TODAYby&entryDate_Mod=between&entryDate_Range=$$TODAYey&projectID=5eb2d98b02xxxx&projectID_Mod=in&queueTopicID=609ee27b0033xxxx&queueTopicID_Mod=in&customerID=57212cda00a54xxxx&fields=*,parameterValues&$$FIRST=0&$$LIMIT=2000&entryDate_Sort=descSample Response:
{
"data": [
{
"ID": "65f19f9900xxxxx",
"name": "Test promo",
"parameterValues": {
"DE:DC Tracking IDs Channel1": "soc",
"DE:DC Tracking IDs Sub Channel1": "fb"
}
}
]
}
Our goal is to remap the values for "Channel1" and "Sub Channel1" from their current codes to their corresponding descriptive labels. Specifically:
Current Output:
"DE Tracking IDs Channel1": "soc"
"DE Tracking IDs Sub Channel1": "fb"
Expected Output:
"DE Tracking IDs Channel1": "Owned social"
"DE Tracking IDs Sub Channel1": "Facebook"
We have identified an internal URL that lists the values we want to remap:
Internal URL:
https://xxx.my.workfront.com/internal/customform/data
Body
{
"objID": "66a21e5f0010e1e27::",
"objCode": "OPTASK",
"categoryIDs": [
"6570c61b001cd08d0706:::"
],
"parameterValues": {},
"withDefaultValues": false
}
Response from Internal URL:
The detailed labels we need are as follows:
For Channel:
"options": [
{"label": "Owned social", "value": "soc"},
{"label": "Paid social", "value": "psoc"}
]For Sub Channel:
"options": [
{"label": "Facebook", "value": "fb"},
{"label": "Instagram", "value": "ig"},
{"label": "LinkedIn", "value": "li"},
{"label": "Twitter", "value": "tw"},
{"label": "YouTube", "value": "yt"}
]
When we attempt to access this information via Postman, we encounter the following error message:
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<body onload="document.forms[0].submit()">
<noscript>
<p><strong>Note:</strong> Since your browser does not support JavaScript, you must press the Continue button once to proceed.</p>
</noscript>
...
</body>
</html>We are seeking guidance on how to effectively remap the values from the current output to the expected output. Is there a way to accomplish this using the provided API or internal URLs? If not, could you please advise on possible alternative solutions?
Thank you for your help.
-Sudhin