JIRA HTTP call - invalid json

(0) Share

Report

Posted on by aorro933

Hello,

I am making a call to Jira, using Search for issues using JQL (POST), but when I enter the filter in the "jql" field in JQL language, I get the error "Enter a valid json".

The filter a use in Jira:

project = "PMO" AND status = "PMO Backlog" OR status = "Preparation" OR status = "solutiondesign" OR status = "Implementation" OR status = "Rampup" OR status = "In Operation" OR status = "Final invoice"

And using the documentatio, this is the doby of the HTTP call:

{
"expand": [
"names",
"schema",
"operations"
],
"fields": [
"summary",
"status",
"assignee"
],
"fieldsByKeys": false,
"jql": {"project = "PMO" AND status = "PMO Backlog" OR status = "Preparation" OR status = "solutiondesign" OR status = "Implementation" OR status = "Rampup" OR status = "In Operation" OR status = "Final invoice""},
"maxResults": 100,
"startAt": 0
}

Anybody knows how I should to implement the filters in the body call?

Thanks.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Since it says invalid JSON I took the string and put it into Notepad++ and try to format it as JSON and I get more information

So I looked at closely and I notice that you have
jgl: { longstring }

What you should have occurrding to the CURL examples is
"jql" : "string" NOT jql: { "string" } which is invalid JSON anyway

After changing that you still have the issue that you aren't escaping the double quotes, which I added escapes for.
So here is the updated json

{ "expand": [ "names", "schema", "operations" ], "fields": [ "summary", "status", "assignee" ], "fieldsByKeys": false, "jql": "project = \"PM\" AND status = \"PMO Backlog\" OR status = \"Preparation\" OR status = \"solutiondesign\" OR status = \"Implementation\" OR status = \"Rampup\" OR status = \"In Operation\" OR status = \"Final invoice\"", "maxResults": 100, "startAt": 0 }

Please note that this has nothing to do with Power Automate though and I just searched for the correct format and gave it to you.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Hello,

Thank you for your reply. The JSON is working now but I'm getting a new error:

{"errorMessages":["The value 'PMO' does not exist for the field 'project'."],"warningMessages":[]}
But the projects "PMO" does exit in the tenant. Do you have any idea which could be the issue?

Was this reply helpful? Yes No