UltiPro | Connectors | Tray Documentation (2024)

UltiPro | Connectors | Tray Documentation (1)

UltiPro is a cloud-based platform providing one system of record for HR, payroll, and talent management.

  • On this page
  • UltiPro
  • Overview
  • Authentication
  • Available Operations

Overview

Copy

UltiPro is a cloud-based platform that delivers human capital management to organizations across all industries.

Authentication

Copy

PLEASE NOTE: As of version 2.0, depending on which Ultipro module you will be using, you can choose between 'Login Token Authentication' and 'Basic Authentication Headers' to authenticate. The input fields for these methods are similar and the only difference is that for the 'Basic Authentication Headers', you do not need to provide the 'User access key'

When using the UltiPro connector, the first thing you will need to do is go to your Tray.io account page, and select the workflow you wish to work on. Once in the workflow builder itself, search and drag the UltiPro connector from the connectors panel (on the left hand side) onto your workflow.

With the new UltiPro connector step highlighted, in the properties panel on the right, click on 'New Authentication' which is located under the 'Settings' heading.

UltiPro | Connectors | Tray Documentation (2)UltiPro | Connectors | Tray Documentation (3)

This will result in a Tray.io authentication pop-up window. The first page will ask you to name your authentication, and state which type of authentication you wish to create ('Personal' or 'Organisational').

As you can see, the next page asks you for your 'Username', 'Password', 'Client access key', 'User access key' and 'Base service URL' credentials.

UltiPro | Connectors | Tray Documentation (4)UltiPro | Connectors | Tray Documentation (5)

Username and password are the username and the password of your UltiPro Service Account.

The 'Client Access Key' & the 'User Access Key' can be found on your UltiPro Web Service administrative page.

PLEASE NOTE:The Client Access Key is also known as the Customer API Key, and theUser Access Key is also known as the User API Key.

IMPORTANT!: You must make sure you have the appropriate permissions granted to the ServiceAccount, for the Reports-as-a-Service service. Before a service account can access BI viaReports-as-a-Service or Report Exports, you need to submit a service case from the CustomerSuccess Portal to request this.

The Base Service URL can be found on your UltiPro Web Service administrative page as well. It can be retrieved from the list of links of the service endpoints. Example of the Base Service URL – 'service2.ultipro.com'

UltiPro | Connectors | Tray Documentation (6)UltiPro | Connectors | Tray Documentation (7)

Once you have added these fields to your Tray.io authentication popup window, click on the 'Create authentication' button. Go back to your settings authentication field (within the workflow builder properties panel), and select the recently added authentication from the dropdown options now available.

Your connector authentication setup should now be complete.

Available Operations

Copy

The examples below show one or two of the available connector operations in use.

Please see the Full Operations Reference at the end of this page for details on all available operations for this connector.

Using the Raw HTTP Request ('Universal Operation')

Copy

As of version 2.0, you can effectively create your own operations.

This is a very powerful feature which you can put to use when there is an endpoint in Ultipro which is not used by any of our operations.

To use this you will first of all need to research the endpoint in the Ultipro API documentation, to find the exact format that Ultipro will be expecting the endpoint to be passed in.

Note that you will only need to add the suffix to the endpoint, as the base URL will be automatically set (the base URL is picked up from the value you entered when you created your authentication).

The base URL for Ultipro is: [BASE-SERVICE-URL]

For example, say that you would like to use the 'Employment Details Service', an endpoint that do not exist in our Ultipro connector. You would use the Ultipro API docs to find the relevant endpoint - which in this case is a GET request called: /personnel/v1/employment-details.

More details about this endpoint can be found here.

UltiPro | Connectors | Tray Documentation (8)UltiPro | Connectors | Tray Documentation (9)

Method: GET

Endpoint: /personnel/v1/employment-details

Final outcome being: [BASE-SERVICE-URL]/personnel/v1/employment-details

UltiPro | Connectors | Tray Documentation (10)UltiPro | Connectors | Tray Documentation (11)

{{/rawHTTPSection}}

Example Usage

Copy

TRAY POTENTIAL: Tray.io is extremely flexible. By design there is no fixed way of working with it - you can pull whatever data you need from other services and work with it using our core and helper connectors. This demo which follows shows only one possible way of working with Tray.io and the UltiPro connector. Once you've finished working through this example please see our Introduction to working with data and jsonpaths page and Data Guide for more details.

Below is an example of a way in which you could potentially use the UltiPro connector, to retrieve a report.

The steps will be as follows:

  1. Setup using a manual trigger and use the UltiPro connector to send a list of associated reports through.

  2. Get information on each report listed.

The final outcome should look like this:

UltiPro | Connectors | Tray Documentation (12)UltiPro | Connectors | Tray Documentation (13)

1 - Setup Trigger & add 'List reports'

Copy

Once you have clicked 'Create new workflow' from your main Tray.io dashboard named it, select the Manual trigger from the trigger options available:

UltiPro | Connectors | Tray Documentation (14)UltiPro | Connectors | Tray Documentation (15)

After you have been redirected to the Tray.io workflow dashboard, from the connectors panel on the left, add a UltiPro connector to your second step. Set the operation to 'List reports'.

UltiPro | Connectors | Tray Documentation (16)UltiPro | Connectors | Tray Documentation (17)

When run, this workflow will list all reports in your UltiPro account.

2 - Get report

Copy

Add a new UltiPro connector step and select the operation 'Get report':

UltiPro | Connectors | Tray Documentation (18)UltiPro | Connectors | Tray Documentation (19)

Use the connector-snake to assign the 'Report path' field to the 'Report path' array, that is produced by the 'List reports' step. Update the index of the required report:

JSONPATHS: For more information on what jsonpaths are and how to use jsonpaths with Tray, please see our pages on Basic data concepts and Mapping data between steps

CONNECTOR-SNAKE: The simplest and easiest way to generate your jsonpaths is to use our feature called the Connector-snake. Please see the main page for more details.

When run, this workflow will now retrieve the requested report.

UltiPro | Connectors | Tray Documentation (20)UltiPro | Connectors | Tray Documentation (21)

You can expand the contents of the report like so:

UltiPro | Connectors | Tray Documentation (22)UltiPro | Connectors | Tray Documentation (23)

BEST PRACTICES: Whenever you do decide to create your own workflow, be sure to check out some of our key articles such as:

  • Using callable workflows

  • Pagination

  • Data transformation guide

NextOperations
UltiPro | Connectors | Tray Documentation (2024)

References

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Patricia Veum II

Last Updated:

Views: 5833

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Patricia Veum II

Birthday: 1994-12-16

Address: 2064 Little Summit, Goldieton, MS 97651-0862

Phone: +6873952696715

Job: Principal Officer

Hobby: Rafting, Cabaret, Candle making, Jigsaw puzzles, Inline skating, Magic, Graffiti

Introduction: My name is Patricia Veum II, I am a vast, combative, smiling, famous, inexpensive, zealous, sparkling person who loves writing and wants to share my knowledge and understanding with you.