How to use the offset parameter in the Clientstore API?

[vmdominguez]

Since the Clientstore API only returns 100 clients at a time, I need to be able to use the offset parameter to retrieve the next 100 clients. However, specifying any numerical value for this parameter doesn't change the results at all.

 

Also, I opened the service in Policy Manager and noticed that it is looking for a query parameter called "queryOffset". I tried using this parameter as well, but it had no effect either.

 

I have tried with OTK 3.4 and 4.0.

 

Thanks,

Vincent Dominguez

[Joe Dascole]

Hi Vincent,

 

Are you able to provide a sample of the request? It seems to be working with the QueryOffset parameter

 

 

 

Regards,

Joe

[vmdominguez]

I noticed that the "offset" property in the response object has a value of "DISABLED", but I'm not sure why:

$ curl https://<myssg>/oauth/clientstore/get?format=json

{"values": {

        "offset": "DISABLED",

    "value": [...

[Joe Dascole]

Thank you for the update. Are you using Cassandra for your database? MySQL, Oracle? 

 

I am suspecting Cassandra which has a known limitation in this area. In this case the info is accessed via the OTK Client NoSQL GET assertion with sets this

 

<xsl:attribute name="offset">DISABLED</xsl:attribute>

 

An enhancement request is opened with our development team, ref ID US373481

 

Regards,

Joe

[vmdominguez]

Yes Cassandra is the dbsystem. Does that mean we are out of luck for this functionality with this configuration?

[Joe Dascole]

Unfortunately this is not possible with the current releases of OTK. We have an existing enhancement request opened with our development team, internal ID US373481.  

 

You may wish to post an Idea here on communities to add some visibility to this request.  

 

Regards,

Joe