Comments are not updating through integration

Jaya4
Kilo Guru

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.

 

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

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

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

Jaya4
Kilo Guru

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}'}

 

find_real_file.png

 

Let me know your thoughts on the same.

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

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

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.