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
-
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.
0 -
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.0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive