REST API content search by lastmodified does not work

alexginzburg · July 17, 2020, 3:37am

We are trying to find all recently updated pages by using the /rest/api/content/search API and passing the cql=‘lastmodified>Value’ parameter.
The API used to work and returned all the pages modified after the date passed in the query.
We noticed that recently the API no longer returns the pages based on the lastmodified field.

Is there a different way to find all content that has been modified after a specified timestamp?

Thank you,
Alex

nmcginley · July 17, 2020, 9:29pm

Hi @alexginzburg, sorry you’re experiencing that. Sounds like it could be a bug. Would you mind providing some detail for me to look into?

What is the exact lastModified query that used to work that doesn’t?
If you run other CQL queries (for example, type=page) do you get results?
Do you have the URL of the confluence instance where you are seeing this?
Are you making the failing request directly in the browser on the atlassian domain or via a plugin?

Thanks,
Nora

alexginzburg · July 17, 2020, 11:31pm

Hi Nora (@nmcginley),

here is an example of the query we are making
curl -L
–header “Authorization: Bearer ${ACCESS_TOKEN}”
–header “Accept: application/json”
https://api.atlassian.com/ex/confluence/${CLOUDID}/wiki/rest/api/content/search?cql=‘LastModified>2020-07-01’ | jq .
type=page search request does return data back
hiseva.atlassian.net is our confluence instance
we are using REST API with 3LO

Please let me know if there is anything else I could provide

Thank you,
Alex

nmcginley · July 17, 2020, 11:50pm

Thanks, this is helpful @alexginzburg

If you just go to https://hiseva.atlassian.net/wiki/rest/api/content/search?cql=lastModified>“2020/07/01” does that work?

nmansilla · July 30, 2020, 3:40pm

@alexginzburg Can you share the API response you’re getting when you make that API call? (including response code from the header, and the body)