ADF BC REST Services–III – Using Row Finder

In this post, we will see how to use Row Finder in ADF BC REST services.

Open REST resource VO and create a View Criteria as shown below having 2 bind variables for Department name and Location ID.

Go to Row Finders section and create new one with searhByDeptName.

Here we can observe that above VC is selected by default. In Variables section as shown below, we can also set whether bind variable is allowed to be passed in REST resource URL along with Required settings.

Deploy the application and use any REST client to test GET method using the following urls. Observe the usage of row finder and bind variables.

Passing single bind variable:

http://localhost:7001/departmentApi/rest/r1/departments?finder=searchByDeptName;bindDeptName=A

Passing both bind variables:

http://localhost:7001/departmentApi/rest/r1/departments?finder=searchByDeptName;bindDeptName=A,bindLocId=1800

Now mark bindLocId variable as required and try to test without using it in the URL and you will observe the error as shown below.

8 Responses to “ADF BC REST Services–III – Using Row Finder”

Feed for this Entry Trackback Address

1 Bhavna Sharma January 23, 2018 at 4:59 PM

Can I associate more than one View Criteria with a specific row finder? I have a business use case for this.

- 2 svgonugu January 23, 2018 at 5:21 PM
  
  Not exactly… I think In one view ceriteria you can other use VC as inline view criteria . It should solve ur use case
  
3 Jasprit Singh February 2, 2017 at 5:54 PM

Hi Siva,
Can we apply multiple RowFinders (multiple filters ) in the REST service ?

Thanks,

- 4 svgonugu February 8, 2017 at 6:17 PM
  
  As a fact i never tried.you can try once using the separator
  
- 5 Alex February 15, 2017 at 2:35 AM
  
  Did you get this to work?
  
- 6 Bhavna Sharma January 23, 2018 at 5:00 PM
  
  Yes we can have multiple row finders.
  
  - 7 svgonugu January 23, 2018 at 5:22 PM
    
    We can have multiple row finders but when using in url we can’t use more than one..

1 ADF BC REST Services Articles | Siva's Blog Trackback on January 11, 2016 at 12:17 PM

Siva's Blog