Troubleshooting Connection to Data Sources with REST Endpoints

Here're some tips on addressing issues you might encounter when you connect to REST endpoints.

Creating OAC Connections to data sources with REST endpoints

• Failed to Import the file - Invalid JSON file provided
  1. Extract the connection.json file from the uploaded ZIP file.
  2. Validate the JSON using any JSON validator, and fix any syntax errors.
  3. Re-create the connection ZIP file and retry the uploading using the Import file option on the Create Connection dialog.
• Invalid REST Base URL - Check the base URL using HTTP or CURL by appending each endpoint one at a time.

• Failed to Import the file - Invalid Authentication Types - In the JSON file, make sure that the Authentication type value is set to noauth, BasicAuth, or HttpHeader.

• One Endpoint Table is Invalid - Validate each endpoint URL using HTTP or CURL, and correct any errors.
• Forbidden Access to some of the end points - Using CURL or HTTP, validate each endpoint by appending a BASE URL to it using same user credentials. Provide access to any endpoints that don't have access or remove the endpoints from the JSON file.
• Endpoint URL is invalid - Using CURL or HTTP, validate each endpoint by appending a BASE URL to it. Correct any invalid endpoints or remove the endpoints from the JSON file.
• Invalid Username/Password - Using CURL or HTTP, validate the credentials for each endpoint.
• Invalid JSON Response from REST data source - Using HTTP or CURL, connect to the REST data source, extract the response received, and validate the response using a JSON validator. If necessary, contact the administrator of the data source to correct data issues.
• URI too long - Make sure that the URIs are no more than 8000 characters in length.