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

1. Create a Deputy Access Token

Follow the instructions here to create a Deputy access token.

2. 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.

3. The 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)

Import data from Intercom

Import data from Plausible.io

Import data from Auth0

Import data from Airtable

Import data from Typeform