GET /buckets/{id}/errorFile
When loading data into a table, Workday validates the data against the defined schema.
If the value for a field doesn’t match the field type or other field attributes (such as date format), then Workday marks the entire row as invalid and doesn’t include the row in the table. Instead, Workday sends the row to an error file that you can download.
Use the error file to get a list of all rows that failed to load into the table. You can fix the errors in the data, remove the extra fields that Workday adds, and load the fixed data into the table.
The error file:
- Is a CSV file.
- Includes all fields defined in the table schema plus fields for troubleshooting:
- Error Code
- Error Message
- Includes all failed rows up to a maximum of 10,000 rows. If there are more than 10,000 error rows, then Workday rejects the load with a status of Failed.
| Secured by |
| ---------- |
- Prism: Tables Manage domain in the Prism Analytics functional area.
- Prism: Tables Owner Manage domain in the Prism Analytics functional area.
- Prism: Delete Table Data domain in the Prism Analytics functional area
- Prism: Insert Table Data domain in the Prism Analytics functional area
- Prism: Truncate Table Data domain in the Prism Analytics functional area
- Prism: Update Table Data domain in the Prism Analytics functional area
Servers
- https://<tenantHostname>/api/prismAnalytics/v3/{tenant}
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
id |
String | Yes |
A reference to a Prism Analytics bucket. Example: The ID of the bucket. |
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.