Error: You Must Select at Least 1 Primary Key

Issue

While loading a Workday webservice URL report through Fivetran, the Workday RaaS connector's setup form is unable to read the primary keys defined in your Workday report. The following error appears:

You must select at least 1 primary key.

Environment

Connector: Workday RaaS

Resolution

To resolve this error, ensure that the source Workday report does not have any filters applied that may result in very few rows. If such filters are applied, remove the filter in your Workday report, then re-run the connector's setup tests.

CSV exports

If your Workday report is in a CSV format, reach out to the Fivetran support team to resolve this error.