Rest API - Querying for users modified

[sbhanji]

Hello,

Can some share how to query for users who have been modified from a certain date using the timeLastMod attribute, something to the effect of 

GET https://gwserver:9710/list/user?timeLastMod>600790683000

Is there such a uri that can be used?

Thanks.

[DaveHansen]

There are a couple of options to specify time formats. It can be done using milliseconds:

Get all users that have a last modified time after millisecond value 1600822800000 (ie. September 23, 2020 1:00:00 AM)
curl -k -u <admin name>:<admin password> "https://<admin service IP address>:<admin service port>/gwadmin-service/list/USER?filter=timeLastMod%20gt%20'1600822800000'"

or it can be done using human-readable date and time:

Get all users that have a last modified time after September 23, 2020 1:00:00 AM
curl -k -u <admin name>:<admin password> "https://<admin service IP address>:<admin service port>/gwadmin-service/list/USER?filter=timeLastMod%20gt%20'2020-09-23T01:00:00'"

where the human-readable time is formatted YYYY-MM-DDThh:mm:ss. The operators should be lt, eq, gt.

Hope that helps!

[sbhanji]

Thanks that worked!

Can a filter be applied to other calls? What I am trying to achieve is also filtering modifications to Groups that have occured.

Thanks. 

[DaveHansen]

You can do the same thing with all Group objects by USER to GROUP, or you can get all Group Membership changes by changing USER to GROUP_MEMBER. You can also filter Group Memberships for a specific Group with

curl -k -u <admin name>:<admin password> "https://<admin service IP address>:<admin service port>/gwadmin-service/domains/<domain name>/postoffices/<post office name>/groups/<group name>/members?filter=timeLastMod%20gt%20'2020-09-23T01:00:00'"

Is that what you were looking for?

[sbhanji]

Exactly what I was looking for. Awesome, thanks!

[Rimser]

Hi @sbhanji

if you like Dave's reply and even got a solution, do not forget to show it! So it's easier to get the right information in case of searches.