Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling Object AQL API fails when value being filtered on contains a double quote

Girish Reddy
Contributor
December 6, 2024

I am calling Object AQL API to filter on a value. But the API returns a "token recognition error" when the value being filtered has a double quote in it.

When my body looks like this, the API returns successfully:

{

"qlQuery": "ObjectType = Suppliers AND Name = Test"

}
However when the value has a double quote e.g. T"est, the API errors out. I've tried various ways to encode including using single quotes, etc. None seem to work.
{

"qlQuery": "ObjectType = Suppliers AND Name = T\"est"

}

 

1 answer

1 vote
Girish Reddy
Contributor
December 9, 2024

Heard back from developer support and the right way to escape such values is: 

T\\\"est
Jakub Talarczyk
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 25, 2025

thx, man, you saved my day!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, confluence, loom, atlassian intelligence, ai notes, ai-powered meeting notes, atlassian community events, ace, confluence ai, loom ai integration, ai note-taking, atlassian ai features, team '25, atlassian live learning, confluence automation

Unlock AI-powered meeting notes: Join our live learning session! 📹

Did you catch the news at Team ‘25? With Loom, Confluence, Atlassian Intelligence, & even Jira 👀, you won’t have to worry about taking meeting notes again… unless you want to. Join us to explore the beta & discover a new way to boost meeting productivity.

Register today!
AUG Leaders

Atlassian Community Events