Workfront

sudhin_123 · 7/29/24

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=desc

Sample 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

JyotiNa · 7/29/24

Not sure if you have already tried ...Instead of trying to remap values try to add a calculate field to the customform for ex : calc DE Tracking IDs Channel1 and add code as shown below to map all expected values using IF statement.