Need assistance writing a web request that executes a CQL query

[Robert Wen_Cprime_]

I need a second pair of eyes for this.

I'm creating a Jira automation that creates Confluence child pages.  To get the ID of the parent page, I'm executing a web request that calls a CQL query

The URL is: https://<site>/wiki/rest/api/content/search?cql=title="{{issue.summary.urlEncode.replaceAll("\+","%20")}}"%20AND%20space.key=<key>

When testing the web request configuration, I'm getting "invalid web request URL". The URL string looks like: https://<site>/wiki/rest/api/content/search?cql=title="Feb%2017%20test%202"%20AND%20space.key=TEST

This string looks valid to me.  So, what am I missing?

Thanks in advance!

[Robert Wen_Cprime_ · Accepted solution]

OK, many thanks to Atlassian support to steer me right.

Looks like there should be quotes (") around the term of the first clause of the CQL query, but you can't use the quote characters themselves, so URL encoded ("%22").

The URL looks like this now: https://<site>/wiki/rest/api/content/search?cql=title%20=%20%22{{issue.summary.urlEncode.replace("+","%20")}}%22%20AND%20space%20=%20<key>

Thanks for all your help!

[Martin Bayer _MoroSystems_ s_r_o__ · Accepted solution]

Hi @Robert Wen_Cprime_ , when I try to open URL against my testing environment, it works fine.
Do you "log" url somewhere? Are you sure that "https://<site>/wiki/rest/api/content/search?cql=title="Feb%2017%20test%202"%20AND%20space.key=TEST" is really used?

[Robert Wen_Cprime_]

I haven't enabled this rule yet.  I'm testing the web request configuration and that's the string that's returned as part of the error message.

[Martin Bayer _MoroSystems_ s_r_o__]

I would suggest you to use "Log" action and log the

• https://<site>/wiki/rest/api/content/search?cql=title="{{issue.summary.urlEncode.replaceAll("\+","%20")}}"%20AND%20space.key=<key>

and try to check logged value

[Robert Wen_Cprime_]

Do you have what I would use to capture the URL used on the request to log?  I see the smart values to include for responses, but none for the actual request itself.

[Robert Wen_Cprime_]

I'm guessing save as a variable and use the variable on the web request itself?

[Marc -Devoteam- · Accepted solution]

Hi @Robert Wen_Cprime_ 

I think you just need to specify the space key like:

https://<site>/wiki/rest/api/content/search?cql=title="Feb%2017%20test%202"%20AND%20space=TEST

The .key is not required

[Robert Wen_Cprime_]

Let me try that.  Thanks!

[Robert Wen_Cprime_]

same error

[Marc -Devoteam-]

Hi @Robert Wen_Cprime_ 

Strange, this works on my side.

Using such an API call in the browser on my instance.

I can use the same in a web request action in an automation rule and use {{webResponse.body}} to log the result in a log action

[Florian Bonniec]

Hi @Robert Wen_Cprime_ 

Is it not  https://<site>/wiki/rest/api/v2/content/search?

Regards

[Robert Wen_Cprime_]

Not that I see in the v2 documentation.  https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-content/#api-group-content

[Robert Wen_Cprime_]

nope.  Same error.