Alfresco Audit REST API

[pedwards99]

Hello,

I'm trying to use the REST API to retrieve audit data from Alfresco. In particular I want to return audit entries created after a specific date. The api-explorer gives some examples of returning audit data between dates using:

where=(createdAt BETWEEN ('first date', 'second date'))

This works, but what are the other operators? 

I've tried AFTER, BEFORE, GREATERTHAN, > etc, but nothing seems to work.

Does anyone know if there are any other operators and where they are documented?

Many thanks

Paul

[pedwards99 · Accepted solution]

To answer my own question...

I managed to track down the source code for the Audit API in GitHub. It seems that the only supported operators are =, AND and BETWEEN.

I've changed my code to use BETWEEN('start date', 'now') to return me all audit entries created after 'start date'

Regards

Paul

[silversky]

Hi

I ran the REST API in the following way and succeeded.

where=(createdAt BETWEEN('2019-01-28T00:00:00.000Z','2019-01-29T14:59:59.000Z'))

Perhaps it is necessary to put it completely including time.

[akash251998]

Will you please give step by step process of how to do site audit.

Thanks in Advance

[EddieMay]

Hi @pedwards99 

Well done on finding a solution - & thanks for updating us, really helpful to other users.

Cheers,