support.airtable.com
Open in
urlscan Pro
52.222.236.2
Public Scan
Submitted URL: https://links.airtable.com/u/click?_t=1627610c3a6845988951459cbd28d02a&_m=649dd6ee49a949b9b40d3c936ea87612&_e=hLqpw...
Effective URL: https://support.airtable.com/docs/airtable-sync-integration-workday?utm_ID=rec3wNJBH3TxT88h1&utm_source=lifecycle_team&utm_me...
Submission: On February 08 via api from US — Scanned from DE
Effective URL: https://support.airtable.com/docs/airtable-sync-integration-workday?utm_ID=rec3wNJBH3TxT88h1&utm_source=lifecycle_team&utm_me...
Submission: On February 08 via api from US — Scanned from DE
Form analysis
0 forms found in the DOMText Content
MENU * Contact Support * Sign up for free * Contact Support * Sign up for free * * * English * English * French * German * Spanish * Contact Support * Sign up for free * Account Account overview Billing Policies * API API Overview Get your API key Documentation Troubleshooting * Integrations Resources Community * Enterprise Admin Panel Enterprise Plans Airtable Security Terms of Service Privacy Policy * Resources Community Marketplace Templates Universe Airtable SyncEnterprise Scale sync integrations Contents x No matching results found * Getting started with Airtable * Introduction to Airtable basics Updated * Airtable home screen * Glossary of Airtable terminology * Feature differences between Airtable on desktop and mobile * Filtering records using conditions Updated * Airtable Automations * Automations Overview * Getting started with Airtable Automations * Managing Airtable automations * Troubleshooting Airtable automations Updated * Automation feature walkthroughs * Integrated automation walkthroughs * Document automator setup guide * Automatically schedule Google Calendar events from Airtable * Creating custom notifications using Airtable automations * How to create a simple reminder * How to create email digests with automations * MS Teams admin approval * Airtable automation walkthroughs * Linking existing records using automations * Conditional groups of automation actions * Repeating groups of Airtable automation actions * Creating recurring records using automations * How to delay Airtable automation runs * Prevent automations from triggering by mistake * Use automations to timestamp status updates * Automation Triggers * Airtable Triggers * Airtable automation trigger: When record matches conditions * Airtable automation trigger: When a form is submitted * Airtable automation trigger: When record created * Airtable automation trigger: When record updated * Airtable automation trigger: When record enters view * Airtable automation trigger: At scheduled time * Airtable automation trigger: When webhook received * Airtable automation trigger: When a button is clicked * Integrated Triggers * Airtable automation triggers: Outlook * Airtable automation trigger: Google Workspace * Automation Actions * Airtable Actions * Airtable automation action: Send email * Airtable automation action: Create record * Airtable automation action: Update record * Airtable automation action: Find records * Airtable automation action: Run a script * Integrated Actions * Airtable automation actions: Slack * Airtable automation actions: Google Workspace Updated * Airtable automation action: Send MS Teams message * Airtable automation actions: Outlook * Airtable automation actions: Jira Cloud * Airtable automation actions: Jira Server / Data Center * Airtable automation actions: Salesforce * Airtable automation action: Create post in Facebook Pages * Airtable automation actions: GitHub Issues * Airtable automation action: Hootsuite post * Airtable automation action: Send Twilio SMS * Airtable Bases * Creating new bases * Creating and duplicating bases in Airtable Updated * Structuring your Airtable bases effectively * Base Tips & Tricks * Airtable keyboard shortcuts * Using Markdown in Airtable * Importing and adding data * Importing third-party data into Airtable Updated * Navigating your base * Tables in Airtable Updated * Airtable bases overview * Customizing a base * Deleting Airtable bases and tables * Using the fill handle in Airtable * Using insights * Airtable Betas * Using the Airtable app quick start process * Airtable public betas * Apps by Airtable (Beta) * Embed and share individual extensions (beta) * Airtable AI assist field overview * Collaborating in Airtable * Working with Collaborators * Adding a base collaborator * Airtable base collaboration overview * Adding a workspace collaborator * Creating Airtable base share links * Building and sharing forms in Airtable Updated * Managing Airtable notifications * Transferring ownership in Airtable Updated * Permissions * Airtable permissions overview Updated * Permission levels and billing * Using field and table editing permissions Updated * Workspace/base invite links and permissions * Airtable Enterprise Support * General information * Airtable user groups overview * Airtable Enterprise API Updated * Enterprise Admin Panel * Enterprise admin panel overview * Users - Airtable enterprise admin panel Updated * Groups - Airtable admin panel * Workspaces - Airtable Enterprise Admin Panel * Bases - Airtable Enterprise Admin Panel * Interfaces - Airtable Enterprise Admin Panel * Reports - Airtable admin panel * Airtable admin panel settings Updated * Using Organizations * Airtable admin panel user details * Airtable domain federation and verification * Enterprise Hub in Airtable Updated * Managing Enterprise organizations * Creating and managing data retention policies in Airtable New * eDiscovery APIs in Airtable * Deactivating and reactivating enterprise users Updated * Airtable and data loss prevention * Managing user access to workspaces and bases * Managing Enterprise admins in Admin Panel * Accessing Enterprise audit logs in Airtable * Set up Jira Server / Data Center to connect with Airtable * Airtable Enterprise Key Management * Enterprise SSO * Configuring SSO in the admin panel Updated * Configuring SSO with Okta Updated * Configuring SSO with Google Updated * Configuring SSO with OneLogin Updated * Configuring SSO with Microsoft Entra ID Updated * Configuring SSO with ADFS Updated * Managing users via IdP sync * Airtable Extensions * Extensions Overview * Airtable extensions overview * Managing and organizing extensions on a base * Extensions by Airtable * Page designer extension * Page designer extension overview Updated * Editing a page designer extension * Printing from the page designer extension * Web clipper extension * Adding and configuring the web clipper extension * Using the web clipper browser extension * Web clipper extension CSS selector examples * Scripting extension * Scripting extension overview * Data Visualization * Vega-Lite chart extension * Base schema extension * Flowchart extension * 3D space extension * Color palette extension * Map extension * Matrix extension * Org chart extension * Time-based Extensions * Time-based extensions * Reporting Extension * Airtable extensions: Chart * Pivot table extension * Summary extension * Bulk Import/Update Extension * Batch update extension * Calendar import extension * Contact import extension * CSV import extension * Dedupe extension * XML import extension * Other Extensions * Miscellaneous Airtable extensions * Integrated Extensions * Third-party Extensions * Typeform extension * Loom extension * Miro extension * Formstack Documents extension * Pexels extension * External extensions by Airtable * Jira Cloud extension * SendGrid extension * Send SMS extension * Translate extension * Vision extension * Airtable Fields * Fields Overview * Field type overview * Supported field types in Airtable overview * The primary field * Field Manager and field dependencies * Updating multiple fields with bulk field actions * Airtable field actions * Using rich text with Airtable * Attachment * Attachment fields in Airtable Updated * Airtable attachment URL behavior * Date-based Fields * Created time and Created by fields in Airtable Updated * Date field type * Duration field type * Last modified time and Last modified by fields in Airtable Updated * Formula * Getting Started with Formulas * Airtable formula field reference * Airtable formula field overview * Using array functions in Airtable * Formula Foundations * The essentials of Airtable formulas * Formula writing tips for beginners * Troubleshooting formulas * Troubleshooting common Airtable formula errors * Basic calculations * Using logical operators to compare field values in Airtable * Formula field calculations in Airtable * Conditional statements * Writing nested IF statements in Airtable * Using emojis with conditional formulas * Comparing text strings using IF statements in Airtable * Comparing numeric values using IF in Airtable * Comparing dates using conditional statements in Airtable * Logical arguments * Alternatives to IF statements using SWITCH() in Airtable * Evaluating arguments using AND() and OR() in Airtable * Identifying blank values in Airtable * Using true and false functions in Airtable * Catching errors in Airtable using logical functions * Using XOR() and NOT() functions in Airtable * Working with dates * Displaying DATETIME_FORMAT using the date field in Airtable * Working with date functions in Airtable * Calculating the difference between dates in Airtable * Supported DATETIME_DIFF unit specifiers in Airtable * Supported DATETIME_FORMAT format specifiers in Airtable * Using the DATETIME_PARSE() formula in Airtable * Working with timezones * Timezones and locales in Airtable * Supported SET_TIMEZONE timezones in Airtable * Supported SET_LOCALE modifiers in Airtable * Record functions * Returning record data in Airtable * Record function applications in Airtable * Text functions * Using REGEX() functions in Airtable Updated * Combining field values in Airtable * Changing text string appearances in Airtable * Extracting text from fields in Airtable * Finding and replacing text in Airtable * Numeric functions * Basics of numeric functions in Airtable * Common Solutions: Beginner * Using checkbox fields in formulas * Converting numbers and text in Airtable formula fields * Converting unix and epoch time in Airtable * Using formulas in Airtable's primary field * Common Solutions: Intermediate * Counting records in Airtable linked record fields * Word and character count in Airtable * Finding the sum of fields in Airtable * Common Solutions: Advanced * Displaying fiscal year quarters in Airtable * Building custom Airtable form URL fillers using ENCODE_URL_COMPONENT * Using the \n formula in Airtable * Conditionally displaying missing field values in Airtable * Linked Record Field * Limiting linked record selection to a view in Airtable * Linking to one, many, or a subset of Airtable records * Converting existing fields to Airtable linked records * Linking records in Airtable * Reordering record links in Airtable * Number-Based Fields * Number-based fields in Airtable * Other Fields * Button field * Airtable checkbox fields * Using the barcode field in Airtable Updated * Rollup, lookup, and count fields * Rollup field overview * Lookup field overview Updated * Count field overview * Applying conditions to fields in Airtable * Select and user fields * User field type * Multiple select field * Single select field * Integrating with Airtable * API * Getting started with Airtable's Web API * Creating personal access tokens Updated * Airtable Webhooks API Overview * Service accounts overview * Airtable Web API - Using filterByFormula or sort parameters * Airtable API Deprecation Guidelines * Airtable API: Common troubleshooting Updated * Airtable API key deprecation notice Updated * Managing API call limits in Airtable * Integration services * Third-party integrations via OAuth overview Updated * Troubleshooting disconnected OAuth integrations in Airtable * Options for integrating with Airtable * Third-party integrations - Common troubleshooting * Low-code integrations - Common troubleshooting * Integrating Airtable with external calendar applications * Visualizing records from Airtable in Tableau * Visualizing Airtable records in Microsoft Power BI & Power Query * Integrating HubSpot with Airtable * Using Zapier to integrate Airtable with other services * Using Zapier's Multi-Step Zaps to find and update records Updated * Using IFTTT to integrate Airtable with other services * Integrating with AWS Lambda & DynamoDB * Developer tools * Airtable resources for developers * Create your own custom extensions with Airtable Blocks SDK * Airtable Interface Designer * Interface Designer overview articles * Getting started with Airtable Interface Designer Updated * Interface Designer permissions * Managing and sharing interfaces Updated * Layouts * Airtable interface layout: Record detail Updated * Airtable interface layout: Record review * Airtable interface layout: Dashboard Updated * Airtable interface layout: Record summary * Airtable interface layout: Form * Elements * Adding and removing elements in interfaces * Adding layouts to interfaces * Formatting elements in interfaces * Interface element: Button * Interface element: Calendar Updated * Interface element: Chart * Interface element: Filter Deprecated * Interface element: Gallery Deprecated * Interface element: Grid * Interface element: Kanban * Interface element: Number * Interface element: Record picker * Interface element: Text * Interface element: Timeline * Learning and Resources * Webinars * Airtable Education resources * Airtable training and resources * View Guides * Base design decisions * Understanding linked record relationships in Airtable * Combining multiple tables into one table using views * Use case-specific guides * Creating subtasks in Airtable * Use case update records via a form * Templates * Using Airtable Templates * Airtable Universe * Airtable Universe * Managing Airtable * Account * Airtable account email verification * Managing billable collaborators from your Airtable account * Deleting data in Airtable * Enabling two-factor authentication * Resetting or updating your Airtable password * Updating your Airtable account details * Deleting your Airtable account Updated * Managing accounts integrated with Airtable * Billing * Billing * Airtable billing overview * How collaborators impact billing * Airtable invoices and receipts overview * Requesting a refund from Airtable * Workspace Plans * Airtable plans * Nonprofit and educational plans FAQs * Changes to Airtable Plans * Enterprise legacy plan information * Data recovery and deletion * Managing trash in Airtable * Taking and restoring base snapshots Updated * Miscellaneous * Receiving base activity notifications in Slack * Airtable User Authentication Challenge Page * Finding Airtable IDs * Adding descriptions in Airtable * Unsubscribing from Airtable marketing emails * Airtable technical requirements * Airtable link previews in Slack * Enforcement of URL length limit for Web API requests * Changing the language on your mobile device * Troubleshooting * Contacting Airtable Support Updated * Troubleshooting Airtable performance Updated * Airtable Policy * Regional access restrictions * Airtable’s Data Processing Addendum * HIPAA and FERPA compliance * GDPR at Airtable * Airtable security practices * Airtable Records * Record templates * Using record templates in Airtable * Record actions * Adding, duplicating, and deleting Airtable records * Grouping records in Airtable * Record coloring in Airtable * Expanded records * Record-level revision history overview Updated * Airtable Sync * Sync overview articles * Getting started with Airtable sync Updated * Two-way syncing in Airtable * Multi-source syncing overview * Airtable Sync: Converting to a synced table * Airtable sync integrations overview * Sync permissions * Data sets and verified data * Data sets and verifying data in Airtable * Standard sync integrations * Airtable Sync integration: Box * Airtable Sync integration: Google Drive * Airtable Sync integration: Google Calendar * Airtable Sync integration: Outlook Calendar * Airtable Sync integration: GitHub Issues * Airtable Sync integration: GitHub Pull Requests * Airtable Sync integration: Miro * Premium sync integrations * Airtable Sync integration: Emailed data Updated * Airtable Sync integration: Sync API * Airtable Sync integration: Tableau Online * Airtable Sync integration: Jira Cloud * Airtable Sync integration: Salesforce * Airtable sync integration: Zendesk * Enterprise Scale sync integrations * Airtable Sync integration: Jira Server / Data Center * Airtable Sync integration: Adobe Experience Manager (On-premises) * Airtable Sync integration: Snowflake New * Airtable Sync integration: Workday New * Airtable Views * View Basics * Getting started with Airtable views * Using the view share menu in Airtable * Airtable grid view * Sorting records in Airtable views * Embedding Airtable views * Shared view URL filters Updated * Using the summary bar in Airtable views * Organizing Airtable views * View Types * Calendar View * Getting started with Airtable calendar views * Form View * Getting started with Airtable form views * Prefilling a form via encoded URL * Gantt View * How to add and configure the Gantt view * Gantt view milestones, dependencies, and critical paths * Customize the appearance of an Airtable Gantt view * Working with records in the Gantt view * Gallery View * Getting started with Airtable gallery views * Kanban View * Getting started with Airtable kanban views * List view * List view overview * Timeline View * Timeline view overview * Customizing records in the Timeline view * Working with records in the Timeline view * Timeline view - Grouping * Timeline view - Summary bar * Timeline view - Resource allocation * Airtable Workspaces * Creating and deleting Airtable workspaces * Managing Airtable account and workspace settings * Workspace sharing restrictions * Moving Airtable bases between workspaces Powered by -------------------------------------------------------------------------------- Airtable Sync integration: Workday * 31 Jan 2024 * 5 Minutes to read Share this * Print * Share Email * Dark Light * PDF Contents AIRTABLE SYNC INTEGRATION: WORKDAY * Updated on 31 Jan 2024 * 5 Minutes to read * Print * Share Email * Dark Light * PDF -------------------------------------------------------------------------------- Article Summary Share feedback Thanks for sharing your feedback! Plan availability Enterprise Scale access only Permissions Owners/Creators - To create or update synced tables, you'll need to have creator permissions in the base where you are setting up the sync. Platform(s) Web/Browser, Mac app, and Windows app Related reading * Sync - Basic setup - If you haven’t set up a sync before, we recommend first reading this article to become familiarized with how the Airtable Sync feature generally works. * Airtable Sync FAQs - Answers to common questions that might help unblock you if you are encountering issues. WORKDAY SYNC REQUIREMENTS To create a Workday sync integration, you need to first create a Workday report that specifies all the data you want to fetch, and you also need to create a Workday Integration System User that has access to the report. Creating a Workday report: 1. Enable as Web Service: Ensure that the Workday report is configured to be accessible as a web service. 2. Unique Identifier Column: Your Workday report should contain at least one column that can uniquely identify each row of data. 3. Share with your Integration System User: Grant access to the report for your Workday Integration System User (ISU). This step is vital for the ISU to retrieve the data from the report. 4. Retrieve the Report URL: To establish a connection, you'll need the CSV URL of your Workday report. This URL is required for Airtable to fetch the data. Configuring the Integration System User (ISU): Your Workday Integration System User (ISU) must have the necessary permissions to access all the data within the report. Testing the Report URL: To ensure that your report is accessible using your ISU, open a web browser and enter the report URL. When prompted, input your ISU credentials. You should be able to download the report as a CSV file. Allow Incoming requests from Airtable: If your Workday has restrictions on IP ranges that are allowed to make requests to it, be sure to add the following IP addresses to the allowlist: 52.44.24.118 3.215.151.50 34.204.30.184 3.225.92.43 3.231.96.120 34.236.75.94 Plain text Copy Enable Workday sync in your enterprise Make sure Workday sync integration is not blocked in your enterprise settings. You can verify this in the Airtable admin panel. Once there: 1. On the left bar, click Settings 2. On the top bar, click Integrations & development 3. Find the Block integrations in automations and external source sync option below. Make sure this option is either turned off or that Workday is present in the allowlist. SETTING UP A WORKDAY SYNC IN AIRTABLE Step 1: Add a new synced table From a new or existing base, find the + Add or import button next to the table furthest to the right. If you have 4 or more tables in your base, then this button will simply appear as a + plus sign. Next, under “Add from other sources,” click the ## more sources option. Then, you’ll see a pop-up of other available syncs to choose from. Finally, click the Workday Reports option. Step 2: Connecting with Workday 1. After clicking to add the Workday sync you’ll be prompted to select or connect a Workday account. If this is the first time you are setting up a sync with Workday, then you’ll need to connect with a new account. 2. Enter the credentials for your Workday Integration System User. If you don’t have a Workday ISU, please create one in Workday before proceeding. 3. Next, enter the “Report URL. Once you’ve connected your Workday ISU, input your Workday report URL. If you don’t have a report URL, please follow the prerequisite steps to create one. 4. Click the Next button to move on to field configuration. Notes: * You must use the CSV report URL provided by Workday. * Depending upon the size of the worksheet, it may take some time for the next step to appear in Airtable. At the moment, Airtable can sync over a maximum of 50,000 records from a report per sync. You will see a spinner indicating that your report is being generated – do not close the window, otherwise you will have to start the process over again. Step 3: Configure fields 1. Next up, you’ll need to configure the fields that will be synced over to Airtable. This involves choosing a primary field, customizing which fields will be shown, as well as picking field types for each column (field). 2. We do our best to identify good field types for each field coming from Workday, however, sometimes you’ll want to adjust things so they make sense in your Airtable base. 3. Sometimes, columns coming from Workday will be blank. This is most likely an indication that your ISU does not have access to the data in this column, and you will need to go into Workday to configure the ISU’s security policy to access this data. When this happens, we will present the following warning. 4. Next, you need to choose a field that uniquely identifies each record. The unique field helps us accurately perform the sync by comparing the current state of your sync in Airtable to the information being held in Workday. In this case, the Worker field is not a great identifier, but changing it to Employee_ID solves this problem. If your report contains no unique fields, you can go to Workday and add a unique ID column to the report. Step 4: Configure sync settings and create 1. Before creating your synced table, there are options in the Settings section that allow you to choose whether or not you want to sync manually or automatically, and how to handle records deleted or hidden in the Workday source. 2. You can also configure which fields to bring into the sync by clicking the Edit synced fields option. 3. Once you’ve selected your desired sync settings, click the Create table button. Depending on how large the report being synced in from Workday is, it may take a few moments for the synced table to be created. SECURITY AND OAUTH SCOPES FAQS How frequently does the Workday sync run when setting the sync frequency to automatic? The sync runs every 6 hours. You can change it to only run when manually triggered. What limitations exist for this sync? The Workday sync has a record limit of 100,000 records. If your report exceeds this limit, we will only sync with the first 100,000 records from your Workday report. Why is the synced table taking so long to be created? Workday takes a long time to run large reports, especially when using computed fields. Expect to wait up to a few minutes for large reports. Which report URL types can I use? We require that the CSV report URL is used. Why are some fields blank in Airtable? Sometimes, columns coming from Workday will be blank. This is most likely an indication that your ISU does not have access to the data in this column, and you will need to go into Workday to configure the ISU’s security policy to access this data. -------------------------------------------------------------------------------- Was this article helpful? Yes No Thank you for your feedback! Our team will get back to you How can we improve this article? Your feedback Need more information Difficult to understand Inaccurate or irrelevant content Missing/broken link Others Comment Comment (Optional) Character limit : 500 Please enter your comment Email (Optional) Email Notify me about change Please enter a valid email Cancel Table of contents * Workday sync requirements * Setting up a Workday sync in Airtable * Security and OAuth scopes * FAQs * Platform * Solutions * Resources * Pricing * Contact Sales * * * * * -------------------------------------------------------------------------------- * Popular Templates * Content Calendar * Product Roadmap * Inventory Tracking * Marketing Campaign Planner * Event Planning * Social Media Calendar * Blog Editorial Calendar * Gantt * Digital Asset Management * Product Launch Calendar * See all templates Show more * Popular Extensions * Miro * Jira * * Loom * Formstack * Chart * Map * Scripting * Org Chart * Page Designer * See all apps Show more * Popular Solutions * Marketing * Product Operations * Human Resources * Sales * Operations * Content Operations * Finance * See all solutions Show more * Learn More * Webinars POPULAR * Community * Support * Articles NEW * Guides NEW * Customer Stories NEW * Company * About * Careers POPULAR * Blog * Status * Newsroom * Platform * Solutions * Resources * Pricing * Contact Sales * Security * API * Sitemap * Privacy * Terms * Do Not Sell/Share My Info Download on the App Store Get it on Google Play By clicking “Accept All”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Accept All Cookies Settings Continue without Accepting