Sync Agile Accelerator custom objects from Salesforce to Jira (included threaded comments)

Requirements:

Sync Work items from Agile Accelerator module from Salesforce to Jira issues
Ensure that the threaded comments on the Work in Salesforce and synced to jira

Comment

CommentAdd your comment...

1 answer

Please use the following code snippet on the Salesforce outgoing script to ensure that the threaded replies are sent over as well:

if(entity.entityType == "agf__ADM_Work__c") {
replica.key            = entity.Id
replica.summary        = entity.agf__Subject__c
replica.description    = entity.Description
replica.comments       = entity.comments.findAll {
    comment ->
    def res = httpClient.get("/services/data/v54.0/query/?q=SELECT+Name+from+User+where+id=%27${comment.author.key}%27")
    comment.body = nodeHelper.stripHtml(res.records.Name[0] + ": " + comment.body)
}
replica.attachments    = entity.attachments
replica.Status         = entity.Status

//Get the threadedComments of all chatter threads in this Work
def threadedComments = httpClient.get("/services/data/v54.0/query/?q=SELECT+Id%2CCommentBody%2CInsertedById+from+FeedComment+where+ParentId=%27${entity.Id}%27")

//For each threadedComment, read all the replies and append usernames to it
//Create a comment object with this info and add to the replica
for(int i=0; i<threadedComments.records.size(); i++){
        def res = httpClient.get("/services/data/v54.0/query/?q=SELECT+Name+from+User+where+id=%27${threadedComments.records[i].InsertedById}%27")
        def c = new com.exalate.basic.domain.hubobject.v1.BasicHubComment()
        c.body = res.records.Name[0] + " commented--: " + nodeHelper.stripHtml(threadedComments.records[i].CommentBody)
        c.id = threadedComments.records[i].Id
        replica.comments += c
        }
}