How to set the endpoint url in soapui

Integrity Lifecycle Manager

The Integrity Lifecycle Manager (ILM) connector enables ThingWorx flow workflows to access and execute actions in Integrity Lifecycle Manager.

requirements

Depending on which version of Integrity Lifecycle Manager you are using, make sure that you meet the correct requirements:

If you are using Integrity Lifecycle Manager 12.1

1. Set up and configure the following:

▪ Integrity Lifecycle Manager 12.1 Server

▪ Integrity Lifecycle Manager REST Services 12.1

▪ Integrity Lifecycle Manager solution for requirements and validation

2. Run the following Bootstrap API endpoint:

https: // : / rws / odata / ptc / ilm / resources / jsongenerators

You must run this endpoint every time the REST service or Integrity Lifecycle Manager server restarts.

If you are using Integrity Lifecycle Manager 12.2

1. Set up and configure the following:

▪ Integrity Lifecycle Manager 12.2 Server

▪ Integrity Lifecycle Manager solution for requirements and validation

2. In the ResourcesNameMapping.xml file under / data / rws, change the values ​​of the Source type for the following fields of the Destination type, as shown below.

aim

source

Live Item ID

LiveItemID

Major version ID

MajorVersionID

Minor version ID

MinorVersionID

Type

Type

The field names of the various Integrity Lifecycle Manager connector actions correspond to the Source type values ​​in the ResourcesNameMapping.xml file. To see the corresponding field names for the actions, you can change the Source type values ​​for the other Target type fields. However, make sure that the Source type values ​​do not contain spaces.

3. Run the following endpoint:

https: // : / rws / odata / ptc / ilm / resources / jsongenerators? updateformapping = true

 

Consider the following points:

• Make sure that you are running this endpoint every time you update the ResourcesNameMapping.xml file.

• When the server restarts, the ResourcesNameMapping.xml file is reset to the original and the changed file is saved as a backup as ResourcesNameMapping.xml.bak.

Delete the ResourcesNameMapping.xml file, rename ResourcesNameMapping.xml.bak to ResourcesNameMapping.xmlum, and run the endpoint again.

In ThingWorx Flow, you can use the HTTP request action of the HTTP utility to run the endpoint. To use the HTTP Request action, set the URL value to the URL of the Bootstrap API endpoint and provide an administrator username and password in additional basic authentication fields. If Integrity Lifecycle Manager is not configured to use SSL / TLS, set SSL Certificate Verification to false, otherwise to true. For more information, see HTTP request.

Version of the connector publication

The Integrity Lifecycle Manager connector was provided in version 8.4.1.

Supported Actions

• Create element

• Edit element

• Execute query

• Text search

Supported triggers

None

Supported Authorizations

The Integrity Lifecycle Manager connector requires the following authorization:

• Easy

• OAuth

Authorize Integrity Lifecycle Manager

You must authorize Integrity Lifecycle Manager for every action of the Integrity Lifecycle Manager connector. To authorize the Integrity Lifecycle Manager connector, select one of the following authentication schemes:

• Simple - In the Select an authentication scheme list, select Simple and do the following:

1. Click Add New, then enter the following details:

▪ Connection labeling - automatically filled. You can enter a connection label of your choice.

▪ Integrity Lifecycle Manager - REST URL - Enter the REST URL in the format https: // : .

▪ Enter the username and password.

2. Click on ADD.

 

Click TEST to validate the connection.

• OAuth - In the Select Authentication Scheme list, select OAuth and do the following:

1. Click Add New, then enter the following details:

▪ Username: Enter the username.

▪ Password: Enter the password.

▪ Click ALLOW, then complete the authorization process.

▪ In the "Add Authorization" window, rename the authorization label if necessary, then add the resource URL such as https: // : .

2. Click on ADD.

 

Click TEST to validate the connection.

Use OData connector action

You can use the Get Properties action on the OData connector to get the content or properties of one or more Integrity Lifecycle Manager items. To use the Get Properties action in a flow, specify the base URL in the following format: https: // : / rws / odata / ptc / ilm / items / $ metadata

For more information, see OData Connector.

Examples

Now let's see how you can integrate the actions of Excel Online and Integrity Lifecycle Manager with ThingWorx Flow.

Drag Integrity Lifecycle Manager query results into an Excel spreadsheet

Requirement:

1. You must be able to access Excel Online and Integrity Lifecycle Manager with the same company account.

2. Some queries have already been created in Integrity Lifecycle Manager. For example the query "Problems", which returns all problems. For information on creating custom queries, see the Integrity Lifecycle Manager documentation on the PTC Support website.

Steps:

Configure the Integrity Lifecycle Manager Run Query action

1. Drag the Execute Query action under the Integrity Lifecycle Manager connector into the drawing area, hover over the action, and then click . Or: Double-click on the action. The window for the "Execute query" action opens.

2. Create a connection in the Execute Query action. For information on creating a connection, see the Integrity Lifecycle Manager connector topic.

3. Enter the following information:

a. In the Queries box, select Problems.

b. In the Sort By section, select Attribute to sort the result.

c. Select the order of the result: ascending or descending.

d. Select attributes to display in the output of the query. In this example, seven attributes are added - ID, Summary, Project, Priority, Severity, State, and Description - by clicking Add in the "Select Attributes" section.

4. Connect the Execute query action to the start symbol in the drawing area.

Configure loops to process query output

In this example, "loop" is used to write one row of data at a time to an Excel spreadsheet. For more information about the Loop utility, see the topic on the Loop Action.

The "Loop" action can be found under the "Utility" tab or by simply searching for "Loop" in the search box. You need to drag the actions into the "Loop" action.

1. Click on and drag the Loop action under the Loop utility into the drawing area.

2. Connect the Execute Query action to the loop tool.

3. Connect "Loop" to the stop symbol in the drawing area.

4. In the Select Loop Type list, select Any Element. The loop action is executed as many times as there are items in the result of the Execute query action.

5. In the Source array or object field, select the result element from the trigger data for the Execute query action by clicking next to "Result element" click.

We will now create a table in the Excel online connector.

1. Go to the Microsoft Excel Online website and sign in with your company account credentials. Create a workbook. In this example we will create a workbook called DemoTask.

The workbook contains a standard spreadsheet - Sheet 1.

2. Add more worksheets by clicking the plus sign (+) next to the Table tab in the lower left corner.

3. Create a table with a name of your choice. Let's say you create Table 1. The table should contain a similar number of columns as fields returned by the Integrity Lifecycle Manager query. In this example seven columns are created: ID, Summary, Project, Priority, Severity, State and Description.

4. Connect the action Add rows to table on the left and right with the loop.

Configure the "Add Rows to Table" action of the ThingWorx Flow Excel Online Connector

1. Drag the Add rows to table action under the Excel Online connector into the drawing area, hover over the action, and then click . Or: Double-click on the action. The window for the "Add rows to table" action opens.

2. If necessary, edit the name of the label. By default, the label name is the same as the action name.

3. For information on how to add an authorization, see the Authorize Excel Online section of the "Excel Online Connector" topic.

 

If you have previously added an authorization for Excel Online, you can select an authorization from the list.

4. Enter the following details:

a. Folder Name - Select "Documents" from the list.

b. Workbook ID - Select the name of the workbook you created. In this case it is "DemoTask".

c. Sheet ID - Select the name of the sheet containing the table. In this case the table is contained in "Sheet 1".

d. ID / Name of the table - name of the table in which the result of the query is to be written. Select the table name from the list.

e. Select Entry Type - Select a single line entry or multiple line entries. In this tutorial we will use a single line entry with the loop tool; the number of loop executions thus corresponds to the number of elements returned by the Integrity Lifecycle Manager query and written to the table one after the other.

Row Values ​​- Map the row values ​​with which the table will be populated. Seven columns are added to the "Row Values" field because seven fields must be filled. ID, Summary, Project, Priority, Severity, State and Description are added in columns 1, 2, 3, 4, 5, 6 and 7, respectively, as shown in the following figure. The order of the columns is the same as in the table we created in the Excel sheet in step 1.

These result elements are in an array, and each time the loop is executed, the current value of the loop index must be inserted. In the index, therefore, the current index is added to the loop, as shown in the following figure:

Start the flow by clicking the Run button in the top right corner.

Result

When the flow is complete, the Excel spreadsheet will be filled with the query results. The illustration shows that two issues with all seven fields have been added to the table.

Edit Integrity Lifecycle Manager item with Excel data

requirements

1. You must be able to access Excel Online and Integrity Lifecycle Manager with the same company account.

2. Integrity Lifecycle Manager 12.1 Server

a. REST web services

b. Integrity Lifecycle Manager solution for requirements and validation

3. ThingWorx Flow

Steps:

Edit the field values ​​in the Excel worksheet.

"Priority" and "Severity" are changed to "Low" and "Minor", respectively, for both elements.

Configure the "Retrieve table rows" action of the Excel online connector:

1. Drag the Add rows to table action under the Excel Online connector into the drawing area, hover over the action, and then click . Or: Double-click on the action. The window for the "Add rows to table" action opens.

2. Enter the information in the following fields:

a. Folder Name - Select "Documents" from the list.

b. Workbook ID - Select the name of the workbook you created from the list. In this case it is "DemoTask".

c. Sheet ID - Select the name of the sheet with your table from the list. Our table is in "Sheet 2".

d. Table ID - Name of the table you created and to which the result of the query should be written. Select a table name from the list.

e. Rows to Retrieve - Enter the number of rows the user wants to read from the table and edit in Integrity Lifecycle Manager.

f. Rows to Skip - You can skip some rows from the top of the table. Enter the value for the lines to be skipped.

3. Connect the action Retrieve table rows with the start symbol in the drawing area.

The configuration is complete.

Configure the loop action to process the query output

The "Loop" action can be found under the Utility tab or by simply searching for "Loop" in the search box. A connector needs to be pulled into the loop to use it with the tool. This tutorial shows you how to edit elements one at a time in Integrity Lifecycle Manager. "Result Element" is selected in the Source Array or Object action, the output of the Get Table Rows action.

1. Click on and drag the Loop action under the Loop utility into the drawing area.

2. In the Select a loop type box, select Any item in the list. Execute the loop as often as there are elements in the result of the action Get Table Rows.

3. In the Source array or object field, assign the table value from the section with trigger data by clicking click.

4. Connect the Get Table Rows action to the Loop action.

5. Connect the "Loop" action to the symbol in the drawing area.

The "Loop" action is configured.

Configure the Integrity Lifecycle Manager Edit Item action

1. Drag the Edit Item action under the Integrity Lifecycle Manager connector into the drawing area, hover over the action, and then click . Or: Double-click on the action. The window for the "Edit element" action opens.

2. In the Entity type field, enter the type of elements to be edited. In our case "problems". The fields belonging to the selected element type are displayed after selection.

3. Map the values ​​from table values ​​and change the index to match the current index.

4. All other fields are mapped from the table values ​​under the Get Table Rows action.

5. Connect the Edit Element action to the right-hand side of the Loop action.

6. Run the flow by clicking the Run button in the upper right corner. After the flow is complete, the user can see the edited fields in Integrity Lifecycle Manager. The finished flow is shown in the following figure: