Note
We've packed up and moved from Confluence to Discourse to bring you a better, more interactive space. Out of courtesy we didn't migrate your user account so - you will have to signup again
The Exalate team will be on holiday for the coming days - returning Jan 4
Enjoy & stay safe
I am integrating ServiceNow and ADO so the Project Owners/Managers and the developers can share some information back and forth in their chosen tools. In Service now there are Programs that have Demand records associated with them. We created a custom workitem type in ADO for Demands and we would like to link them to Epics such that an Epic could have a Demand as an associated workitem.
ServiceNow <=> ADO
Project == Epic
Project Task == Feature
and
in SNOW, Projects have related Project Tasks
In ADO Epics have related Features
Here's the question:
These records will originate in ServiceNow and be replicated to ADO. When we create a Project Task under a Project in ServiceNow, how can I then replicate that relationship status to ADO?
I have attempted the following and it fails regardless of what values I use as the identifier unless I hardcode the ADO workItem number in which case it does work.
outgoing sync for pm_project_task in SNow has the following:
which shows in the replica as:
"parent_Id": { "display_value": "PRJ0012345", "link": "https://Company.service-now.com/api/now/v2/table/task/37d73128db0c8154e12345d7f4961982", "scala$collection$convert$Wrappers$MapWrapper$$underlying": {} },I have tried putting the following in place of the <identifier> below but my value is always null. I know all records are in sync ahead of this too:
if(replica.parent_Id){ def localParent = syncHelper.getLocalIssueKeyFromRemoteId(<identifier>) workItem."Custom.TechnicalandArchitectureDetails" = localParent.toString() //just to echo the output so I can "see" it workItem.parentId = localParent.toString() }Could it be that this helper just doesn't work with the ServiceNow datatype?
Help?
Hi Jack,
Have you tried:
if(replica.parent_Id){ def localParent = syncHelper.getLocalIssueKeyFromRemoteId(replica.parent_Id.toLong()) workItem."Custom.TechnicalandArchitectureDetails" = localParent.toString() //just to echo the output so I can "see" it workItem.parentId = localParent.toString() }Kind regards,
Ariel
I tried this initially but it always failed for me. Here's what I entered:
if(replica.parent_Id){ def parent=syncHelper.getLocalIssueKeyFromRemoteId(replica.parent_Id.toLong()) workItem."Custom.TechnicalandArchitectureDetails" = parent workItem.parentId = parent }And this is what it returned for the "def parent=syncHelper.getLocalIssueKeyFromRemoteId..." line
Error Detail Message:
No signature of method: com.google.gson.internal.LinkedTreeMap.toLong() is applicable for argument types: () values: [] Possible solutions: toString(), toString(), toString(), toString(), count(groovy.lang.Closure), notify()
My suspicion is that toLong() is choking on the result because it's expecting a number and the result in either a URL or a value like "PRJ0012345"
Hi Jack
I think your suspicion is correct, can you try changing that line to:
Let us know the outcome.
Cheers,
Daniel
Throws the following: