Paul Cavacas Posted March 25, 2021 Share Posted March 25, 2021 I'm looking for more information about using the REST Data Services to retrieve information out of EBX. In particular right now I'm looking for how to use the filter parameter to limit the information that is being returned, but what I'm really looking for is some place that has examples of using the various parameters. I have looked in the documentation and understand what that is saying, but am having difficulties converting that into real usable queries. I'm currently query the REST URL looks similar to https://xxx/ebx-dataservices/rest/data/v1/BMyDataSpace/MyDataSet/root/So... which is returning all of the rows from SomeObject in the below format { "rows":[ { "label":"1000-XXXXXX", "details":"https://xxx/ebx-dataservices/rest/data/v1/BMyDataSpace/MyDataSet/root/So...", "content":{ "Base":{ "content":{ "id":{ "content":"1000" }, "name":{ "content":"XXXXXX" }, "description":{ "content":"XXXXXX" } } }, ... What I'm trying to do is filter to just return were ID = 1000 Link to comment Share on other sites More sharing options...
Sanchit Sood 2 Posted April 7, 2021 Share Posted April 7, 2021 Hi, I am not sure if I understood your problem correctly but here is a way if you want to return only one row corresponding to one value. https://xxx/ebx-dataservices/rest/data/v1/BMyDataSpace/MyDataSet/root/TA...'1000'&pageSize=unbounded TABLE_A_PK is the primary key of TABLE_A, you can also use other fields of table for filtering required data, Regards Sanchit Link to comment Share on other sites More sharing options...
Sanchit Sood 2 Posted April 7, 2021 Share Posted April 7, 2021 https://xxx/ebx-dataservices/rest/data/v1/BMyDataSpace/MyDataSet/root/ TABLE_A filter=TABLE_A_PK='1000' &pageSize=unbounded Note : Had to write in different lines as it was not allowing the entire url. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now