Forums

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

Access Comment Jira API Migration to /rest/api/3/search/jql

Devon Manelski
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!
September 16, 2025

I have been able to migrate from the filter to the new /rest/api/3/search/jql API.  However, my code is now failing on getting the comment("body").  Everything else works.  There is a comment on the jira and the date of the comment is successfully retrieved.

If fields.Exists("comment") Then
If fields("comment").Exists("comments") Then
For Each oComment In fields("comment")("comments")
If CDate(mConvertISODate(oComment("updated"))) > dLatestCommentDate Then
Set oLatestComment = oComment
dLatestCommentDate = CDate(mConvertISODate(oComment("updated")))
End If
Next oComment

If Not oLatestComment Is Nothing Then
sCommentUpdated = mConvertISODate(oLatestComment("updated"))
sCommentBody = oLatestComment("body")
sCommentAuthor = oLatestComment("author")("displayName")
oWS.Cells(iInt, enuColumnNumber.Comment_Date).Value = sCommentUpdated
oWS.Cells(iInt, enuColumnNumber.Comments).Value = sCommentBody & vbCrLf & vbCrLf & " Author: " & sCommentAuthor
oWS.Cells(iInt, enuColumnNumber.Comments).Font.color = RGB(255, 255, 255)
'MsgBox (sCommentUpdated & vbCrLf & vbCrLf & " - " & sCommentBody & vbCrLf & vbCrLf & " Author: " & sCommentAuthor)
End If
End If
End If

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
ENTERPRISE
TAGS
AUG Leaders

Atlassian Community Events