You can use Import Scripts to import data from your Deputy account directly into an Equals workbook.

Create a Deputy Access Token

Follow the instructions here to create a Deputy access token.

Add the key to a secret group

Copy the access token from the prior step. Then create a new secret group and paste the key into a new secret named deputy_api_key.

Example code

Once you’ve completed the prior steps, create a new workbook, add a new import script to a sheet and copy + paste the script below. Once pasted select your secret group in the toolbar (make sure the key in the secret group is called deputy_api_key). Note that you’ll want to change the URL below to reflect your Deputy information. For example, https://simonssambos.au.deputy.com is an installation called simonssambos and is present in the Australian geographic region. There are four possible regions for a Deputy installation currently:

AU (Australia)
EU (Europe)
UK (United Kingdom)
US (United States)

More details can be found on the Deputy API page here or by contacting their API support team.

const equals = require("equals");
var axios = require('axios');

const apiKey = equals.getSecret("deputy_api_key");

var config = {
 method: 'get',
 url: 'https://simonsambos.au.deputy.com/api/v1/supervise/employee',
 headers: { 
    'Authorization': 'Bearer ${apiKey}'
  }
};

const response = await axios(config)
equals.addRows(response.data)

Auth0 Github

Getting Started

Connect and transform data

Explore data

Analyze data

Report on data

Deputy

Create a Deputy Access Token

Add the key to a secret group

Example code

​Create a Deputy Access Token

​Add the key to a secret group

​Example code

Create a Deputy Access Token

Add the key to a secret group

Example code