You need to sign in to do that
Don't have an account?
Swapna Mistry
External lookup No Longer Working with Winter 17 update
We have an external data source to our SQL database. We have multiple objects using external lookups.
It looks like SF changed the syntax that is used for external lookups in Winter 17, which has caused serious impact to our business processes. Our DBA has informed us that Odata/Web API does not support using "starts with" on an ID field.
Does anyone know how to resolve this?
When we try to lookup a record we are getting an error:
Couldn't Connect to External Object Data
The external system responded with an HTTP error "400 Bad Request".
Here is an example of the syntax being used:
Couldn't Connect to External Object Data
The external system responded with an HTTP error "400 Bad Request". The system tried to reach this URL: https://app.e-brandid.com/wcfodata1/WcfDataService1.svc/master_shipment?$top=201&$filter=+startswith(ms_id,176646)+eq+true&$inlinecount=allpages&$select=bill_to_cust_id,ms_id,requested_ship_date,ship_to_cust_id
The proper syntax that DOES work is:
https://app.e-brandid.com/wcfodata1/WcfDataService1.svc/master_shipment?$top=201&$filter=ms_id eq 176646&$inlinecount=allpages&$select=bill_to_cust_id,ms_id,requested_ship_date,ship_to_cust_id
It looks like SF changed the syntax that is used for external lookups in Winter 17, which has caused serious impact to our business processes. Our DBA has informed us that Odata/Web API does not support using "starts with" on an ID field.
Does anyone know how to resolve this?
When we try to lookup a record we are getting an error:
Couldn't Connect to External Object Data
The external system responded with an HTTP error "400 Bad Request".
Here is an example of the syntax being used:
Couldn't Connect to External Object Data
The external system responded with an HTTP error "400 Bad Request". The system tried to reach this URL: https://app.e-brandid.com/wcfodata1/WcfDataService1.svc/master_shipment?$top=201&$filter=+startswith(ms_id,176646)+eq+true&$inlinecount=allpages&$select=bill_to_cust_id,ms_id,requested_ship_date,ship_to_cust_id
The proper syntax that DOES work is:
https://app.e-brandid.com/wcfodata1/WcfDataService1.svc/master_shipment?$top=201&$filter=ms_id eq 176646&$inlinecount=allpages&$select=bill_to_cust_id,ms_id,requested_ship_date,ship_to_cust_id
I've searched high and low for any documentation. I have yet to find anything.
The problem is, I dont have any way to define the syntax. All I can do is create the external lookup field. No where in there does it allow me to specify what syntax to use. (Or at least none that Ive found so far)
It was working fine before the Winter 17 update.
I will try to dig in later, but I have to go to a meeting now.
I have had a case open with Support for a week now. The support reps are clueless. That's why I decided to post here. Thank you for your response. I just searched for W-3179828 and found nothing via google. Should I be looking somewhere else?
I contacted the development team that introduced that change into the Winter '17 release, and they will take a look. I also gave them a link to your Support Case. Please keep an open mind - I may be mistaken and the change I am talking about may not be at all related to your issue.
Thank you so much for all your help on this.
Pardon my ignorance, but I dont see any case comment from your on my case. Also, is there a way that I can review bug W-3179828? Just to see if its related?
Unfortunately, the only way to share the Bug is to have someone validate that it's related to your issue and then repost it on our Known Issues site. The actual Bug detail text is just a list of steps to reproduce the Bug, so I think it would be difficult for you to connect the two issues. One purpose of the Known Issues site is to translate an internal detail (and reproducer) into a more descriptive text that anyone can read, search for, and understand.
If these issues are related, then you should feel free to ask your Support agent to create a Known Issue for the Bug.