Workfront Advanced Connector - Unable to pull Array values (when more than one array value)

HI,

I have a Workfront back end and use the Domo Workfront Advanced Connector to pull values from Project and Task tables. I have an issue with fields that return array values ["Value1", "Value2", "Value3"]. In Domo such arrays are just imported as the string value "List".

I think the Domo connector is at fault. Is there any way to pull the actual values in the array when using the Workfront Advanced Connector?

Comments

  • Jarvis
    Jarvis 🟠

    Hi Jorli,

     

    I found some docuementation on the Workfront Advanced connector that you might find useful. It says in here that when you pull in multiple fields that you can specify the column type. You might find use in these.

     

    https://knowledge.domo.com/?cid=workfrontadvanced

     

    Here is Workfront's API documentations as well.

     

    https://developers.attask.com/api-docs/

     

    If you don't find anything there, you can reach out to Workfront and see if that's possible with the API.

  • Thanks,

    I investigated with both Workfront and Domo support and it has been deemed that the Domo connector doesn't handle arrays other than return "List" and Domo support is looking into customizing the connector to allow it to fetch the data better.

    Support wrote:
    When a dataset imports a column with only the value 'List' this indicates that the column could be expanded to retrieve all values from the column. However, this would result in additional duplicate rows and values. Because of this, our Development team will only call on the minimized report.

    I can completely understand why you would want to be able to import the actual values from this list. This would require that we contact your Account Team to start the Connector Enhancement process. They will contact you for more details on the request and then place this request with our Development team for resolution.