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:// /wiki/rest/api/content/search?cql=title="{{issue.summary.urlEncode.replaceAll("\+","%20")}}"%20AND%20space.key= When testing the web request configuration, I'm getting "invalid web request URL". The URL string looks like: https:// /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!

Hi @Robert Wen_Cprime_ I think you just need to specify the space key like: https:// /wiki/rest/api/content/search?cql=title="Feb%2017%20test%202"%20AND%20space=TEST The .key is not required

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:// /wiki/rest/api/content/search?cql=title="Feb%2017%20test%202"%20AND%20space.key=TEST" is really used?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Marc -Devoteam-

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

Martin Bayer _MoroSystems_ s_r_o__

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_

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 = "{{issue.summary.urlEncode.replace("+","%20")}}%22%20AND%20space%20=%20<key>

Thanks for all your help!

All comments

Florian Bonniec

Hi @Robert Wen_Cprime_

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

Regards

Marc -Devoteam-

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

Martin Bayer _MoroSystems_ s_r_o__

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.

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_

Let me try that. Thanks!

Robert Wen_Cprime_

nope. Same error.

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_

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

Robert Wen_Cprime_

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 = "{{issue.summary.urlEncode.replace("+","%20")}}%22%20AND%20space%20=%20<key>

Thanks for all your help!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

cql