Expand my Community achievements bar.

Required for Remapping Data from Adobe Workfront API

Avatar

Level 1

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

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 2

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.

IF({DE:DE Tracking IDs Channel1}="soc","Owned Social",IF({DE:DE Tracking IDs Channel1}="psoc","Paid Social","no match"))

And then read the "calc DE Tracking IDs Channel1" field which would return  "Paid Social" label value.