Search for pages created after a date and specific text with Confluence REST API

[Mélanie Liguet]

Hi , 

I try to use CQL search in confluence with API REST.
I need to find all page created after 2022-01-27 AND Contains text "“https://confluence.fr.c*”

In postman, i have a result but it only takes the date criterion.

Could you helpo me ? It in possible to do multi criteria search with api rest ?

[Renzo Arriagada · Accepted solution]

Hi @Mélanie Liguet !

It is indeed possible to do multi-criteria search with api rest, you just need to set up your CQL accordingly.

I did some testing and you should be getting the results you want using this call to the API

/wiki/rest/api/search?cql=type=page AND text~"https://confluence.fr.c*" AND created > 2022-01-27

In whichever language or tool you're using to make the API call, just be sure to try the CQL you need using your browser first so its easier to see what is missing from your API call.

I hope this helps you.

Kind regards,

Renzo from Servicerocket.

[Mélanie Liguet]

thanks

the API call you gave me is correct (Status 200) but I have no result.

strange, i will find out why.