> ## Documentation Index
> Fetch the complete documentation index at: https://www.domo.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Workfront Connector

## Intro

Workfront (formerly called AtTask) develops web-based work management and project management software. Use Domo's Workfront connector to retrieve data for a selected Workfront object. To learn more about the Workfront API, visit their page ([https://support.workfront.com/hc/en-us/articles/220633507-API-Explorer](https://support.workfront.com/hc/en-us/articles/220633507-API-Explorer)).

The Workfront connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking **Cloud App** in the toolbar at the top of the window.

You connect to your Workfront account in the Data Center. This topic discusses the fields and menus that are specific to the Workfront connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/docs/s/article/360042926274).

<table border="1" cellpadding="1" cellspacing="1">
  <thead>
    <tr>
      <th colspan="1" rowspan="1">
        <p />
      </th>

      <th colspan="1" rowspan="1">
        <p />
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td colspan="1" rowspan="1"><p><b>Primary Use Cases</b></p></td>
      <td colspan="1" rowspan="1"><p>Use this connector to pull data about the status of projects and the individual tasks that apply to those projects.</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p><b>Primary Metrics</b></p></td>
      <td colspan="1" rowspan="1"><p>- Project status - Start and complete dates - Hours per project - User hours - Resources - Common issues</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p><b>Primary Company Roles</b></p></td>
      <td colspan="1" rowspan="1"><p>- Project manager - Operations</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p><b>Average Implementation Time</b></p></td>
      <td colspan="1" rowspan="1"><p>5-10 hours for basic implementation</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p><b>Ease of Use (on a 1-to-10 scale with 1 being easiest)</b></p></td>
      <td colspan="1" rowspan="1"><p>5</p></td>
    </tr>
  </tbody>
</table>

## Best Practices

* Reports should typically be run using "Replace." Users are limited to 10 concurrent running reports, so you should avoid having 10 or more DataSets scheduled to run at the same time.
* You will need to have a good understanding of the data in your Workfront account to get useful data from the connector.

## Prerequisites

To connect to your Workfront account and create a DataSet, you must have the following:

* The username and password or the API key associated with your Workfront account. You must update the API key in your connector when it expires.
* The URL for your Workfront server (for example, [https://yourcompany.workfront.com](https://yourcompany.workfront.com)).
* You also need to select the API version.

Note that some users may have attask domains, while others may have workfront domains.

## Connecting to Your Workfront Account

This section enumerates the options in the **Credentials**, **Details**, and **Advanced** panes in the Workfront Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/docs/s/article/360042926274).

### Credentials Pane

This pane contains fields for entering credentials to connect to your Workfront account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1">
  <thead>
    <tr>
      <th colspan="1" rowspan="1"><p>Field</p></th>
      <th colspan="1" rowspan="1"><p>Description</p></th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td colspan="1" rowspan="1"><p>Username</p></td>
      <td colspan="1" rowspan="1"><p>Enter the username to log into your Workfront account. You must provide a username and password OR an API Key.</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>Password</p></td>
      <td colspan="1" rowspan="1"><p>Enter the password to log into your Workfront account. You must provide a username and password OR an API Key.</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>API Key</p></td>
      <td colspan="1" rowspan="1"><p>Enter your Workfront API key. You must update the API key in the connector connection when it expires. You must provide a username and password OR an API Key.</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>URL</p></td>
      <td colspan="1" rowspan="1"><p>Enter the URL for your AtTask/Workfront server (for example, <a href="https://yourcompany.attask-ondemand.com">[https://yourcompany.attask-ondemand.com](https://yourcompany.attask-ondemand.com)</a>>).</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>API Version</p></td>
      <td colspan="1" rowspan="1"><p>Choose the API version to connect to.</p></td>
    </tr>
  </tbody>
</table>

Once you have entered valid Workfront credentials, you can use the same account any time you go to create a new Workfront DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/docs/s/article/360042926054).

### Details Pane

This pane contains options for selecting a Workfront object and configuring filter fields, date range, etc.

<table border="1" cellpadding="1" cellspacing="1">
  <thead>
    <tr>
      <th colspan="1" rowspan="1"><p>Parameter</p></th>
      <th colspan="1" rowspan="1"><p>Description</p></th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td colspan="1" rowspan="1"><p>Report</p></td>
      <td colspan="1" rowspan="1"><p>Select the Workfornt report you want to run. The following reports are available:</p><table class="zebra-striped bordered"><tr><td><b>Report</b></td><td><b>Description</b></td></tr><tr><td>Approval</td><td>Returns a list of approvals for the account.</td></tr><tr><td>Assignment</td><td>Returns a list of assignments, including assigner, assignee, project, workload, and status details.</td></tr><tr><td>Baseline</td><td>Returns a list of project baselines, including project ID, dates, customer ID, budget, and planned hours.</td></tr><tr><td>Category</td><td>Returns a list of categories used in custom data forms.</td></tr><tr><td>Group</td><td>Returns a list of groups, including group ID, customer ID, and description.</td></tr><tr><td>Hour</td><td>Returns the number of hours entered by users in the account.</td></tr><tr><td>Hour Type</td><td>Returns a list of hour types used in the account, including name and description.</td></tr><tr><td>Issue</td><td>Returns a list of issues, including dates, assignee, status, description, planned hours, and team.</td></tr><tr><td>Job Role</td><td>Returns a list of job roles used in the account, including name, description, and cost per hour.</td></tr><tr><td>Milestone</td><td>Returns a list of milestones, including name, description, and customer ID.</td></tr><tr><td>Milestone Path</td><td>Returns a list of milestone paths, including name, description, and customer ID.</td></tr><tr><td>Note</td><td>Returns a list of notes, including subject, content, project, and owner.</td></tr><tr><td>Parameter</td><td>Returns a list of parameters used in custom data forms.</td></tr><tr><td>Portfolio</td><td>Returns a list of portfolios, including name, customer, and entry date.</td></tr><tr><td>Program</td><td>Returns a list of programs, including name, owner, and description.</td></tr><tr><td>Project</td><td>Returns a list of projects, including name, budget, costs, hours, status, and owner.</td></tr><tr><td>Project User</td><td>Returns a list of project users, including customer ID, project ID, and user ID.</td></tr><tr><td>Resource Allocation</td><td>Returns resource allocation details for projects and customers, including scheduled and budgeted hours.</td></tr><tr><td>Resource Pool</td><td>Returns a list of resource pools, including customer ID and description.</td></tr><tr><td>Schedule</td><td>Returns a list of schedules in the account.</td></tr><tr><td>Task</td><td>Returns a list of tasks, including dates, assignee, status, description, planned hours, and team.</td></tr><tr><td>Team</td><td>Returns a list of teams in the account.</td></tr><tr><td>Templates</td><td>Returns a list of templates in the account.</td></tr><tr><td>Timesheet</td><td>Returns timesheet data for all users in the account.</td></tr><tr><td>Users</td><td>Returns information about all users in the account, including name, title, email, and billing details.</td></tr><tr><td>Work</td><td>Returns work details, including costs, duration, revenue, and expenses.</td></tr></table></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>Custom Fields</p></td>
      <td colspan="1" rowspan="1"><p>Enter the custom fields for your report, separated by commas</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>Reference Fields</p></td>
      <td colspan="1" rowspan="1"><p>Enter the reference fields for your report as a comma-separated list.  Format: <span class="mt-font-courier-new">reference object:reference field</span></p></td>
    </tr>
  </tbody>
</table>

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/docs/s/article/360042926274).

## FAQs

<AccordionGroup>
  <Accordion title="Can I use the same account to create multiple DataSets?">
    Yes.
  </Accordion>

  <Accordion title="How often can the data be updated?">
    DataSets can be updated as often as once an hour.
  </Accordion>

  <Accordion title="Are there any API limits I should be aware of?">
    Workfront is limited to 10 concurrent DataSets.
  </Accordion>

  <Accordion title="Why do I need to add DE: as a prefix for custom fields?">
    To learn about adding prefixes for custom fields, see the following: [https://support.workfront.com/hc/en-...ng-custom-data](https://support.workfront.com/hc/en-us/articles/115003574147-API-Basics#retrieving-custom-data "https://support.workfront.com/hc/en-us/articles/115003574147-API-Basics#retrieving-custom-data").
  </Accordion>
</AccordionGroup>
