Jira Servicenow Integration , Bulk Import

mdshahvez11
Tera Contributor

Hello everyone,

I'm currently working on a bulk migration from Jira to ServiceNow.

While I'm able to fetch the data successfully, I'm encountering an issue with the comments.

For each Jira issue, I’ve created a separate subflow where I pass the Issue ID and fetch all related comments. This part works — I'm able to retrieve all comments from Jira.

However, when I try to update them into a string field in the staging table, only one comment (out of 4–5) gets stored.

I’ve attached screenshots of the subflow and execution logs for reference.

Any insights on why only one comment is being saved and how I can store all comments properly would be appreciated.



mdshahvez11_0-1749550362843.pngmdshahvez11_1-1749550366713.png

 

10 REPLIES 10

Anil Nemmikanti
Giga Guru

"Look up records" are associated with "for each" , at 4 I could see for each but it is not associated with any look up records.

Can you add a screenshot of the execution with the errors or info messages.

 

@Anil Nemmikanti 
At step 1, I extract the issue key from the table and input it into an Action to obtain all associated comments (public and private). Subsequently, a second 'for each' iteration is performed to process the acquired comment dataset.


As per the executions I'm getting 5 comments data but in the field where I'm storing them , I'm getting only 1 comment data.

mdshahvez11_0-1749551823080.png

 



@mdshahvez11 

are you trying to update the same record with the comments again and again?

If yes then it's basically getting overridden and hence all comments are not coming.

I will suggest to use flow variable and append it using For Each with those 4-5 comments

Then use Update Record only once to update the record with the value from flow variable

check this how it's done and enhance

flow variable iterate and append for the for each.gif

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Anil Nemmikanti
Giga Guru

I believe you are getting the comments from Edge Jira comments?


Here after that add look up records and add EDGE jira comments action

and then add for each in