Coda Packs allow you to seamlessly connect your docs to the external tools and apps your team relies on. With the Workday Pack, you can sync any custom reports into Coda tables. From there, you can organize, visualize, and analyze the data - right within your doc.
Unlike most other Coda Packs, this Pack requires some initial setup steps from an Enterprise org admin. Once the setup and configuration is complete, org members can then use the Workday Pack in their docs. This article will explain the steps required to configure this Pack, as well as how users can get started once the configuration is complete.
ℹ️ The Workday Pack is only available to customers on our Enterprise tier. You must be an Enterprise org admin in order to complete the setup and configuration steps explained in this article.
Within this article, you’ll find...
Configure the Workday Pack for your org
Before the Workday Pack can be used successfully by org members, an org admin must complete some initial steps to create a configuration for the Pack. This process has 3 main parts: Initiating the configuration in Coda, accessing info from Workday, and finalizing the config in Coda.
Part 1: Initiate the configuration in Coda
To kick things off, follow the steps below:
Navigate to your Coda workspace home at coda.io/docs
Click on Admin settings in the upper left
Navigate to - or search for - the Org Pack approvals tab
Scroll down to the list of Packs, and enter Workday into the search bar
Click into the Workday Pack option, and select + Add new configuration
Next, you’ll need to head over to Workday to collect some necessary info. Continue to Part 2 to learn more.
Part 2: Access necessary info from Workday
For this next part, you’ll jump over to Workday. Note that you will need to be a Workday Security Admin in order to follow these steps:
Within Workday, search for “API client”
Select Register API Client from the options
Fill in the following info for the new client:
Client Name: for instance, “Coda Workday Pack”
Client Grant Type: Authorization Code Grant
Access Token Type: Bearer
Refresh Token Timeout: fill out depending on your preferences, or make non-expiring if desired
Scope: choose which resources you want available to this API client
Redirection URI: https://coda.io/packsAuth/oauth2/40119
Click OK to save all info
From the next screen, locate the following pieces of info (you’ll need these for Part 3):
Client ID
Client Secret
Workday Rest API Endpoint (note that you will only need the first portion of this URL, up through workday.com )
Token Endpoint
Authorization Endpoint
Keep this screen from Workday open while you head over to Coda once again to complete the configuration.
Part 3: Finalize configuration in Coda
With the necessary info from Workday, you can now complete the configuration in Coda:
With your new configuration ready to edit, add the following code:
{ "connection": {
"endpoint": {
"url": "insert domain here - see details below"
}
}
}
For the URL portion of the code, you will need to grab the domain from Workday. To do this, locate the Workday Rest API Endpoint in Workday (previously accessed in Part 2 of this process) and copy just the first portion of this URL, up through workday.com. Paste this into the configuration code.
Click Save and next
On the next screen, fill in the necessary fields with the corresponding information from Workday
For instance, copy the Client ID from Workday and paste it in the Client ID field in Coda. Continue for Client secret, Authorization URL, and Token URL.
Click Save
Start using the Workday Pack in your doc
Once an org admin has created the configuration for the Workday Pack, workspace members can begin using the Pack in their doc.
To get started, simply type /Workday on any blank line in your doc. Select the Workday Pack from the options, and click Add to doc.
From there, you can add a Custom report table to your doc to sync in any of your reports from Workday. You can either find this table in the Pack settings and drag it onto the canvas, or type /custom report on any blank line of your doc. You will then be prompted to add the URL of the Workday report. To find the report URL, follow these steps:
Open the report in Workday
Click on the three-dot menu at the top of the report, select Web Service, then select View URLs.
If you need to add any parameters, do so here. Then click OK.
Scroll down to the JSON section, click the three-dot menu next to JSON, and select Copy URL.
Head over to Coda and paste this report URL where prompted.
That’s it. You’ve now successfully created a Custom Report sync table in Coda. To learn more about using Packs and Pack sync tables, check out this article.
Related resources
Workday Pack | Pack listing page