Create and Update Change Request (ServiceNow) - Transformation

Before we begin building our Transformation, we first need to collect some data.

Transformation Video

Step 1

Continuing with the JSON Form we created, Lab – Create and Update Change Request – ServiceNow – XX, click the eye icon in the upper right, and populate the fields in the Preview Form with the following:

• Title  is Title. 
• Summary is Summary.
• Description is Description.
• for Configuration item, we click the dropdown and select IOS.

Step 2

Click Show Form Data at the bottom of the form.

Step 3

Hover your cursor next to the “4 items” text, click on the clipboard icon to copy the data to Clipboard/Text Editor. Then click Close to close the preview.

This is the format in which the data will be submitted when executing our automation from Operations Manager. You will now build a Transformation that takes the data in this format and breaks it out into the individual variables that the Child Job needs in the workflow.

Step 4

Click the + at the top of the left navigation panel. The Create window opens.  We click the dropdown and select Transformation.

Step 5

We enter ServiceNow Change Request JST – XX  in the name field and click Create.

Step 6

The canvas loads with a lot of empty space in the center. To remove some of the white space, place your cursor near the top of the canvas, and click the delete (trash can) icon that displays.

Step 7

We are ready to create our Incoming Schema.  Click the Add+ button under Incoming Schema and select Incoming Schema.

Step 8

Paste the example data from your JSON Form into the field on the right. Next,  click the Infer Schema From Example JSON button on the left.

Step 9

The Incoming Schema is created, you just need to give it a name. In line 2 in the “$id” field, enter formData between the double quotes and click Save at the bottom.

Step 10 

Now that we have created an Incoming Schema, we will need to take the data and break it out into the individual variables that the Child Job needs in the workflow. To do that, click the half-circle for the title value in the Incoming Schema and drag the cursor to the Add + under Outgoing Schemas. A dropdown menu will appear, and we select the first option, Outgoing Schema.

Step 11

The first Outgoing Schema is created. Perform the same steps for the remaining variables. 

Step 12
We've now transformed our Incoming Schema into the structure that the automation requires. 

Verify your Transformation looks like this image. Click the Save button.