Can't connect google app script

[Sandy Hsieh]

 Hello, I’m using the Jira Cloud REST API /rest/api/3/search/jql and constructed the payload as per the documentation:

 {
  "queries": [
    {
      "query": "assignee IN (\"accountId\") AND statusCategory IN (\"To Do\",\"In Progress\")",
      "startAt": 0,
      "maxResults": 50,
      "fields": ["assignee","summary","status","updated"]
    }
  ]
}

However, the API returns a 400 “Invalid request payload” error.
Does /search/jql not support the fields property? How should I correctly specify the fields to be returned?

[Matteo Vecchiato]

Hi @Sandy Hsieh 

Thank you for your question.

The payload has not a valid format.
The body, using the POST request of /rest/api/3/search/jql should be more similar to:

{ 
"fields": [ "assignee","summary","status","updated"], 
"fieldsByKeys": false, 
"jql": "assignee IN (\"accountId\") AND statusCategory IN (\"To Do\",\"In Progress\")", 
"maxResults": 50, 
"nextPageToken": "<string>", 
}

The "nextPageToken" is used for pagination. You can find detail doc here 

I hope it helps

[Sandy Hsieh]

Hi @Matteo Vecchiato 
Thank you for your reply
Could you help me take a look is it correct ?

const assignees = [

'"712020:83979f4e-28e0-457a-913c-95f21f9c1242"',

'"712020:4dddcd09-3250-4a73-a721-f9e03f26c5e8"'

];

const jql = `assignee IN (${assignees.join(",")}) AND statusCategory IN ("To Do","In Progress") AND updated >= -2d ORDER BY created DESC`;

const payload = {

fields: ["assignee", "summary", "status", "updated"],

fieldsByKeys: false,

jql: jql,

maxResults: 50,

};

try {

const response = UrlFetchApp.fetch(url, {

method: "post",

headers: {

"Authorization": "Basic " + Utilities.base64Encode(email + ":" + apiToken),

"Accept": "application/json"

},

contentType: "application/json",

payload: JSON.stringify(payload),

muteHttpExceptions: true

});

[Matteo Vecchiato]

Hi @Sandy Hsieh

it seems ok. You are not managing the pagination, this call get only the first result page, if there is more results, you should manage a while in your code until the nextPageToken is empty.

Regards

[Sandy Hsieh]

Got it. Thanks

[Matteo Vecchiato]

Hi @Sandy Hsieh ,

Please consider to mark this question as replied to help further users, thanks.