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..