Error: Invalid or Missing Auth Token
Issue
Setup tests fail with the following error:
Failed to connect to API. Server is not responding with correct response after specific retries and giving status code [401] and status message [{"message":"invalid or missing auth token"}]
Environment
Connector: Resource Management by Smartsheet
Resolution
To resolve this issue, ensure the API token you provide in the connection setup form is valid and associated with Resource Management by Smartsheet, not the general Smartsheet platform. To learn how to generate the correct token, see our Resource Management by Smartsheet setup guide.
We don't offer a dedicated Smartsheet connector. However, you can sync row-level data from a Smartsheet sheet using the Fivetran Connector SDK. For more information, see our Connector SDK examples.
Cause
This error occurs when the API token you provided while setting up your connection is:
- Missing
- Incorrect or invalid
- Intended for a different platform