Salesforce Odata error when 'Validate External Object: DW_Customers

  • 23Views
  • Last Post 31 March 2020
0
votes
Rackspace Admin posted this 27 March 2020

I am new to Odata setup within Skyvia, and need to know what this error means:

 

EXTERNAL_OBJECT_EXCEPTION: We encountered an error while querying the external data. Contact your administrator. Error received from the external system: Illegal character in path at index 64: https://connect.skyvia.com/2v2mel0d/DW_Customers(CustomerID=\'%1B[D%1B[DI\',SourceID=\'01\')

I'm at a loss to figure out how to fix it.  Have I misconfigured something?

Attached Files

0
votes
Dmitriy Muzurov posted this 31 March 2020

Hello,

Thank you for submitting a ticket with us.

The URL is constructed incorrectly. We can take the example from a test OData service at odata.org.

 If we try to get an existing customer, it returns the result with the requested customer data.

If we try to get a customer that does not exist, the message "Resource not found for the segment 'Customers'" is returned.

Finally, when we copy the part from Salesforce log to URL request and send it, we get the error: Bad Request - Invalid URL.

Make sure the URL is constructed correctly.

We are looking forward to hearing from you, should you have any questions.

Close