How to create new trigger in SN for change tasks and change approvals?

 
1
0
-1

Hello community,


I would like to synchronize from SN to Jira change tasks (table change_task)

and change approvals (table sysapproval_approver),

but these entities doesn't appear on drop-down list (see picture).


Also here (https://docs.idalko.com/exalate/display/ED/Start+sync+in+Exalate+for+ServiceNow),

change tasks and change approvals are not mentioned as supported by Exalate for ServiceNow.


My exalate proxy user has admin rights in SN, so it has access to all tables.


My aim is to synchronize change tasks and change approvals independently from overriding change.


If I start typing in below window table name "sys", it gives me nothing.


  1. Serhiy Onyshchenko

    Hello, Andrew
    Is your Exalate for SNOW on-prem or in Exalate Cloud?
    Regards, Serhiy.

  2. Andrew

    Hello Serhiy Onyshchenko 

    Exalate for SNOW is in Exalate Cloud.

    Regards,

    Andrew

  3. Serhiy Onyshchenko

    Hello, Andrew 
    A couple of follow-up questions:

    1. What happens if you type in "change"
    2. What happens if you type in "approver"

    3. What does opening the following URLs in browser (while being logged in as proxy user) show:


      • /api/now/v2/table/sys_db_object?sysparm_fields=name&sysparm_query=nameLIKEchange^ORDERBYname
      • /api/now/v2/table/sys_db_object?sysparm_fields=name&sysparm_query=nameLIKEapprover^ORDERBYname

    Regards, Serhiy.

  4. Andrew

    Hello Serhiy Onyshchenko 

    Strange, but after upgrading SN node to latest Exalate release it is what I see in trigger configuration window:



    So I see change_task and sysapproval_approver tables.

    Good results I also have when opening two your URLs (of course as proxy user):



    So I configured simple trigger for change_task



    and wrote simple SN outgoing script:



    but sync produces error as below:



    What's wrong with line 188 ?


    Regards,

    Andrew

CommentAdd your comment...