If I test a finder through the designer interface I can get a list of all vfilers, volumes, qtrees across all of the arrays depending on what finder I select. However, if I try to do the same tests via the REST API I only get the first 100.
Looking at the wfa_finders.log I can see the log output one below the other and the only difference is the number of rows returned - for the API it's always 100! We plan to use the lists of vfilers, volumes, qtrees etc to validate user requests and build appropriate parameter lists for our provisioning workflows. Without a complete list, we are unable to do what we planned. Any suggestion? Or is there a setting somewhere I can use to increase the number of items returned?
Using the designer interface:-
23:19:41,463 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) ========================================================================================
23:19:41,463 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Executing finder 'Finder{id=322, name='List all vfilers', dictionaryEntry=vFiler}', parameters '{}'
23:19:41,463 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Executing local filter 'Get All vfilers', parameters '{}', query 'SELECT
vfiler.name AS 'name',
array.ip AS 'array.ip'
FROM
storage.vfiler AS vfiler
JOIN
storage.array AS array
ON vfiler.array_id = array.id
WHERE
vfiler.name <> 'vfiler0'
and UCASE(vfiler.name) NOT LIKE 'PH_%''
23:19:41,479 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Local filter 'Get All vfilers' successfully executed, rows affected '272'
23:19:41,479 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Finder 'List all vfilers' successfully executed, rows returned '272'
23:19:41,479 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) ========================================================================================
Using the REST API:-
Query : http://MyTestWFAServer/rest/finders/705450e3-8eac-403c-a1a5-55317174f57b/test
Log:-
23:20:56,750 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) ========================================================================================
23:20:56,750 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Executing finder 'Finder{id=322, name='List all vfilers', dictionaryEntry=vFiler}', parameters '{}'
23:20:56,765 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Executing local filter 'Get All vfilers', parameters '{}', query 'SELECT
vfiler.name AS 'name',
array.ip AS 'array.ip'
FROM
storage.vfiler AS vfiler
JOIN
storage.array AS array
ON vfiler.array_id = array.id
WHERE
vfiler.name <> 'vfiler0'
and UCASE(vfiler.name) NOT LIKE 'PH_%''
23:20:56,765 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Local filter 'Get All vfilers' successfully executed, rows affected '272'
23:20:56,781 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) Finder 'List all vfilers' successfully executed, rows returned '100'
23:20:56,781 DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-executor-threads - 25) ========================================================================================