Executing Orchestrator Runbook using PowerShell

jansi rani krishnan 601

Hi Team,

I am followed the below link to call an Orchestrator Runbook via a PowerShell code by invoking a web-service call.

It is working when i used the below POST body structure.

when i try to use the similar XML POST body structure, it is not working and throwing the error message "".. Am i missing anything in the second XML structure.

Please help me in figure out the error.

1 answer

Andreas Baumgarten 108K Reputation points MVP

2021-06-14T19:36:34.273+00:00

Hi @jansi rani krishnan ,

in the second screenshot the ´<d:Parameters> .... </d:Parameters>´ section is not in the right format. It should be in the same format like the first screenshot.

you have to use the < instead of < and > instead of >and so on. You have to use these HTML Special entities.
That's something "special" in Orchestrator ;-)

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten
Please sign in to rate this answer.

1 person found this answer helpful.
jansi rani krishnan 601 Reputation points

2021-06-15T08:19:26.163+00:00

Hi Andreas,

Okay Got it. Will the Orchestrator accept the JSON format? If so how should we convert this to the proper HTTP POST request in JSON format. Please share any working JSON request format.

In my case, ServiceNow would be sending me the HTTP POST request to SCSM for any Incident updates happen at their end. I have the "Initialize Data" activity to accept the request and "Run .Net Script" to update the inputs in the incident form.

It would be great if I am able to share the HTTP POST request format in easy and readable form to the ServiceNow team.

Regards,
Jansi

Andreas Baumgarten 108K Reputation points MVP

2021-06-15T08:33:49.5+00:00

Hi @jansi rani krishnan ,

the "working format" you can see in your first screenshot. At least you said it's working.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

jansi rani krishnan 601 Reputation points

2021-06-15T09:05:36.42+00:00

Andreas,

As you mentioned in your earlier post (https://learn.microsoft.com/en-us/answers/questions/431056/executing-an-orchestrator-runbook-via-powershell.html), I checked the Orchestrator services and one of the service was not working, So After i ran the service, The XML body structure as in the first screenshot is working..

I feel it is not readable format or i think it is very difficult for ServiceNow team to understand and frame the request if there are more number of input fields.

Is there a chance that can we send the POSTbody in JSON format? If yes, please share any JSON POSTBody format.

Regards,
Jansi

Andreas Baumgarten 108K Reputation points MVP

2021-06-15T15:52:16.237+00:00

Hi @jansi rani krishnan ,

Orchestrator expects the input like in your first screenshot. As far as I know that's the only way.
You gave it a try with the JSON code in your second screenshot and it didn't work.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

jansi rani krishnan 601 Reputation points

2021-06-15T19:29:55.907+00:00

Hi Andreas,

I would like to create a variable with value as below.

Is it possible to create a variable which holds the value as below in PowerShell? Please suggests. If yes, Please show the syntax.

Regards,
Jansi

Andreas Baumgarten 108K Reputation points MVP

2021-06-15T19:44:54.137+00:00

Hi @jansi rani krishnan ,

could you please post the code as code and not as a screenshot.
It's really time consuming to write all the stuff from the screenshot. Copy&Paste is much easier.
Please try this:

$a = '"RunbookId":"11212313", "Parameters":"<Data><Parameter><Name>Urgency</Name><ID>{121242342342}</ID><Value>High</Value></Parameter></Data>"'

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Executing Orchestrator Runbook using PowerShell

1 answer

Your answer