I am trying to Exalate two fields from Service Now to Jira. These fields are held in the ‘sys_user’ table and have the following in the Outgoing sync script:
I am looking sync the ‘email’ and ‘department’ fields from the sys_user table, from the person who raised the call in Service Now to Jira. I have created two new custom fields in Jira called ‘Requestor Email’ and 'Department to sync the data to. So far I have had no issues syncing data from the incident table in Service Now to Jira, but I have been unable to get any data from the sys_user table.
Thank you for sharing the information.
Let me have it checked and will get back to you in case further information is needed or any update is available.
I believe you want to sync the reporter (caller) details from the ServiceNow incident ticket but you are trying to sync the sys_user table as these details are not directly available from the incident table.
What I’ll suggest here is can you please try the below code for fetching the email address of the user and let me know if this works or not.