Here’s an overview of common Excel connector errors, their conditions, and associated error messages:
S.No | Connector Name | Condition | Error Message |
1 | MS Excel | If Sheet Name is wrong | Workbook or worksheet not found |
2 | MS Excel | If User Name (Login) is wrong | Unsupported User Type 'Unknown' |
3 | MS Excel | If password is wrong | Error validating credentials due to invalid username or password |
4 | MS Excel | If ClientId is wrong | Application with identifier 'clientid' was not found in the directory 'Organization Name' |
5 | MS Excel | If File URL is wrong | Response status code does not indicate success: 404 (Not Found) |
6 | MS Excel | If cell range value is higher than 100 | Please do not enter a row value higher than 100 |
7 | MS Excel | If cell range value is wrong | Please enter the appropriate CellRange |
8 | MS Excel | If MFA (Multi-Factor Authentication) is enabled | Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication... |
9 | MS Excel | If too many requests are made in a short time (Rate limiting) | 429 Too Many Requests |
10 | MS Excel | If user does not have access to the file | Response status code does not indicate success: 403 (Forbidden) |
11 | MS Excel | If any required field is missing | Value does not exist for property: property name |
This table can be used to quickly identify common errors and troubleshoot them based on the connector conditions.