Symptom
- Intermittent ETL failures occur when extracting data from various SuccessFactors API endpoints integrated with an external dashboarding platform.
- The error message displayed is: “The request has been refused. Verify that the logged-in user has appropriate permissions.”
- When the same request is re-run, it typically completes successfully without any changes to permissions or configuration.
Environment
SAP SuccessFactors HCM
- Odata API
Reproducing the Issue
- Run the ETL process in the external dashboarding platform integrated with SuccessFactors.
- Observe that for certain endpoints, the error message "The request has been refused. Verify that the logged-in user has appropriate permissions" is thrown.
- Re-run the same request without making any changes to permissions or configurations.
- Observe that the request completes successfully and produces data.
Cause
The Oauth token is expired, and the server returns a 403 response as expected behavior.
Resolution
Refer to the guide on requesting an access token: Requesting an Access Token | SAP Help Portal
- If an access token has already been requested with the same SAML assertion and the token has not expired, the server will return the same token by default with the remaining time indicated in the expire_in field.
- Use the parameter new_token=true to force the server to generate a new access token valid for 24 hours.
See Also
Keywords
successfactors, odata api, etl failures, authorization error, request refused, permissions error, oauth token, 403 error, new_token=true, intermittent issue, api endpoints, data extraction, splashbi integration, "The request has been refused. Verify that the logged-in user has appropriate permissions." , KBA , LOD-SF-INT-ODATA-OAU , ODATA OAUTH Authentication , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , How To
SAP Knowledge Base Article - Public