Comments are not updating through integration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2019 05:43 AM
Hi All,
I am doing an integration between two snow instances. All the data is moving fine from one instance to another.
Even the data are also updating without any issue.
But when I try to updating the additional comments and worknotes in source instance, the same data is not updating in target.
I used an import set table for the integration. The comments and the work notes are updating in the import set table but its is not updating in the target fields.
I tried to map the comments and worknotes with other custom fields. The data is getting updated without any issue. But when I mapped them with comments and work notes. The worknotes or comments is not getting add in target instance.
Let me know if I am missing something.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2019 07:29 AM
Hi Jaya,
I don't think it should be an issue while updating it via field map? Can you share how you are mapping it?
Any data policy etc for that field or ACL on that field which is blocking that field update
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2019 10:20 PM
Hi Ankur,
Thanks for the suggestion.
I check the ACL. only one ACL on task table for write and roles associated is itil role. My integration user is admin.
Script I am using is :
var r = new sn_ws.RESTMessageV2('Datavail Integration', 'POST');
r.setStringParameter('Caller',current.caller_id.name);
r.setStringParameter('Catagory', current.catagory);
r.setStringParameter('Number', current.number);
r.setStringParameter('Impact', current.impact);
r.setStringParameter('Urgency', current.urgency);
r.setStringParameter('ShortDescription', current.short_description);
r.setStringParameter('Comments', current.comments);
r.setStringParameter('WorkNotes', current.work_notes);
My parameters
{'u_number':'${Number}','u_impact':'${Impact}','u_state':'${State}','u_short_description':'${ShortDescription}','u_description':'${Description}','u_urgency':'${Urgency}','u_caller_id':'${Caller}','u_practice':'ServiceNow','u_company':'a94b5d16dbbf2b8098e8f3551d961904','u_work_notes':'${WorkNotes}',u_comments:'${Comments}'}
Let me know your thoughts on the same.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2019 10:59 PM
Hi,
In the example you have shown you are sending the work notes and comments to 3rd party using REST Message.
Is that rest endpoint configured to that REST Message a scripted rest api or table api?
Can you check in other instance what is being performed i.e. how these values are being used and mapped to the target fields.
I believe you are sending it properly. at the receiving end something in code which is not proper.
can you check that?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2019 11:59 PM
End Point
https://xxxxxx.service-now.com/api/now/table/u_vvv_one_way
Initially I mapped the field with target field, How I mapped for comments and other fields. Then to go for a try I have used script to return the value.