As part of our requirement, i created one BCS connection which retrieves data from a SQL stored procedure which acceppts two input paramaters. I was able to create a external list out of it. But when i try to access the data using REST API i.e, https://siteurl/_api/Web/lists/GetByTitle('listname')/GetItems?$filter = Filter1 eq x and Filter2 eq 'xxxx' , i am unable to see any data.

If i provide the input from the view settings, i am able to see the data. The above url is working if i access a list which is connected to BCS entity with stored procedure having 1 input.

Could any one please let me know if there is any limitation for stored procedures with multiple parameters? Any information would be a great help..


You are using endpoint incorrectly. GetItems endpoint must be used with CAML query param. Use "items" endpoint instead.
Like this:

https://siteurl/_api/Web/lists/GetByTitle('listname')/items?$filter = Filter1 eq x and Filter2 eq 'xxxx'

You can see this way in official documentation.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.