Cherwell

Cherwell



Cherwell

Cherwell plugin has several steps for operations on Cherwell.

Compatibilitry: Cherwell plugin steps have been tested on Cherwell Version 9.4


Prerequisites:

  1. Services of the Cherwell Server must be up and running.
  2. Access Cherwell instance using REST APIs from Process Studio/AE agent machine.
Cherwell Server settings:

When Cherwell REST APIs are called simultaneously, due to multiple requests with the same username, password and api key, the API starts giving  ‘invalid_grant: badrequest’ error. 

To handle this error, add highlighted line in the web.conig file of CherwellAPI.

<appSettings>

<add key="DisableMessageThrottling" value="true" />

<add key="TrebuchetDataSource" value="[Common]Cherwell Browser" />

<add key="SamlBaseUri" value="your web api base uri(https://domain/CherwellApi" />

</appSettings>




Error Message Display Properties when run with Process Studio:

  1. All the validation messages are displayed as pop up and runtime error messages are recorded in the logging tab.
  2. The pop up box is configured to be displayed as Message Box not as Error Dialog box.
  3. The error messages at runtime are displayed in the logging tab of Process Studio in red color.
  4. For Successful validation the Message Box title is “Success” and the result message in the body.
  5. For Failed validation message the Message Box title is “Failure” and the failed message is in the body.
  6. The plugin throws error at run time if invalid query is provided.

   


Cherwell: Delete Record

Description

Cherwell Delete Record step is used to delete records in Cherwell Business Objects (Forms) (For example close an incident if it is resolved or to keep a ticket open if not resolved yet).

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL  

Base URL of Cherwell. This field is mandatory.

3

User Name 

Cherwell username. This field is mandatory.


Password:


4

Accept Value as variable/static

Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. 

Else enable checkbox for Password field to appear as Text box.

5

Password

Provide the Cherwell Password for the user.  Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory.


If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps.

6

Client ID  

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.


Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

7

Button: Test Connection

Verifies whether the connection is available or not. 

Base URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.


Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 


Input Fields:

No.

Field Name

Description

1

Form Name  

Specify the Cherwell form name/Business Object from which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of the connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing then it will display validation error message.    

Select a form to populate it into the Form Name field.

3

Business Object

Public ID/RecID  

Cherwell Business Object PublicID/RecID. This field is mandatory.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values


Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.



Cherwell: Download Attachment

Description

Cherwell Download Attachment step is used to download attachments from Cherwell Business Objects (Forms) on a provided Business Object Rec ID or Public ID. (For example close an incident if it is resolved or to keep a ticket open if not resolved yet).

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL  

Specify URL to access Cherwell. This field is mandatory.

3

User Name 

Cherwell username. This field is mandatory.


Password:


4

Accept Value as variable/static

Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. 

Else enable checkbox for Password field to appear as Text box.

5

Password

Provide the Cherwell Password for the user.  Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory.


If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps.

6

Client ID  

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.


Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

7

Button: Test Connection

Verifies whether the connection is available or not. 

Base URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.


Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 


Input Fields:

No.

Field Name

Description

1

Form Name  

This holds the Cherwell form name from which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing then it will display validation error message.    

Select a form to populate it into the Form Name field.

3

Business Object 

Public ID/RecID  

Cherwell Business Object PublicID/RecID. This field is mandatory.

4

Output Folder Path

Specify a folder path where files are to be downloaded or browse for a folder using the Browse File… button. Alternatively, when the folder path is coming from an input stream, you may select the field containing the folder path from the drop down list

5

Button: Browse Folder

This is the button to browse for a folder to download to a Cherwell Business Object file.

6

Delete Output Folder Contents before downloading

Allowed values:  ‘Yes’, ‘No’. Specify Yes to delete output folder contents before downloading else Specify No.

7

Add Date TimeStamp for Duplicate Files

Allowed values:  ‘Yes’, ‘No’.  Specify Yes to add 

Date TimeStamp for Duplicate Files.

8

Add File To Result

Allowed values:  ‘Yes’, ‘No’.  Specify Yes to add 

file to result set and display download link on AE otherwise else select No.

Output Tab:


No.

Field Name

Description

1

Total Files 

Specify a field name to store the total number of files in the Cherwell Business Object. This field is mandatory.

2

Downloaded Files

Specify a field name to store the number of Downloaded Files. 

This field is mandatory.

3

Overwritten Files

Specify a field name to store the number of Overwritten Files in the output folder. This field is mandatory. 


Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values


Cherwell: Input

Description

Cherwell input step gets Cherwell records based on the form name and query criteria provided. It returns the form field values for fields specified in the output Field Name.

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL 

Specify URL to access Cherwell. This field is mandatory.

3

Username 

Cherwell username. This field is mandatory.

4

Password

Provide the Cherwell Password for the user. Password field value is encrypted (*****) and also stored in encrypted format in the psw file. This field is mandatory.

5

Client ID

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.


Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

6

Button: Test Connection

Verifies whether the connection is available or not. 

URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.


Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 



Input Fields:

No.

Field Name

Description

1

Form Name  

This holds the Cherwell Form/Business Object/ for which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing then it will display validation error message.    

Select a form to populate it into the Form Name field.

3

Criteria Query

Specify the criteria query in json format.

Following, is a sample json with two conditions. The first condition is ‘Status’ equals (eq) ‘Assigned’ and the second statement is ‘Created Date Time’ later than(lt) ‘6/20/2016 8:59:17 PM’.

[

{

"displayName": "Status","operator": "eq","value": "Assigned"

},

{

"displayName": "Created Date Time","operator": "lt","value": "6/20/2016 8:59:17 PM"

}

]

This criteria query will filter rows fulfilling the two conditions below.  

4

Fetch Records Batch Size

Default Records Batch Size is 10. Specify the batch size to fetch records. These fetched records in the batch are then available to the next step in workflow while the next batch is being fetched in this step.  Thus, parallel execution of records is achieved. This should be a positive number. 



Output  Fields:

No.

Field Name

Description


Output Fields:


1

Field Name

The name of the fields fetched from the business object as per Criteria Query. 

On click of this column field, it will open a dialog with the list of available form fields of the provided Business Object Name.  

2

Output Field

Specify an output field name for containing Cherwell field values.

3

Get HTML

Select Yes/No from the Drop down list. 

If a field in a Business object accepts Rich Text Format (RTF) input (Text and images) then such input is stored in HTML format internally. To fetch the stored content in RTF (in html format) you may select Yes. If Yes is selected for fields that do not have RTF input it returns null.


Some examples of business object fields accepting RTF input are, Incident: Description, Change: Description, Problem: Description, Knowledge Article: Body Text.

Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values



Cherwell: Insert Record

Description

Cherwell Insert record step is used to create a record in a particular Cherwell Business Object (Form). It creates a new record with for the provided form name and field values on specified Cherwell Server. It returns the Public ID/RecID and Result as output.

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL  

Specify URL to access Cherwell. This field is mandatory.

3

User Name 

Cherwell username. This field is mandatory.


Password:


4

Accept Value as variable/static

Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. 

Else enable checkbox for Password field to appear as Text box.

5

Password

Provide the Cherwell Password for the user.  Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory.


If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps.

6

Client ID  

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.

Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

7

Button: Test Connection

Verifies whether the connection is available or not. 

Base URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.

Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 


Input Fields:

No.

Field Name

Description

1

Form Name  

This holds the Cherwell form name from which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing then it will display validation error message.    

Select a form to populate it into the Form Name field.                  

3

Accept Fields as JSON

Enable checkbox to accept field names as JSON input.

4

JSON

If ‘Accept Fields as JSON’ checkbox is enabled this field is activated. Choose a field containing the JSON text. JSON text should contain key-value pairs enclosed by double quotes (“) enclosure. Provide all the required or mandatory fields as well as other fields to be inserted as as keys in the JSON. 

Note: The JSON could be from any input step such as Generate rows, Text File input, Excel Input Et al. In Cherwell steps JSON text can only be accepted from input fields from previous steps and not as files directly.


Sample JSON text for inserting a single Knowledge Article record:

Following is a sample JSON for inserting a record in Knowledge Article form. This JSON text has five key-value pairs denoting fields and their values to populate five fields. In this Cherwell instance Service and Title are mandatory for Knowledge Article Business Object.

Note: Lookup field values must exactly match existing values in the Cherwell instance.


JSON text: 

[

 {

   "displayName": "Service",

   "value": "IT Service Desk"

 },

 {

   "displayName": "Title",

   "value": "Test_KA5"

 },

 {

   "displayName": "Category",

   "value": "Request Help"

 },

 {

   "displayName": "SubCategory",

   "value": "Submit Service Request"

 },

 {

   "displayName": "Keywords",

   "value": "Test for KA"

 },

 {

   "displayName": "Visible to Customer Portal",

   "value": "False"

 },

 {

   "displayName": "Article Type",

   "value": "How To"

 }

]


Sample JSON text for inserting an Incident record:

Following is a sample JSON for inserting a record in Incident form. This JSON text has five key-value pairs denoting fields and their values to populate three fields. In this Cherwell instance Description, Short Description, Priority, Owned By and Customer ID are mandatory for Incident Business Object.


Note: Lookup field values must exactly match existing values in the Cherwell instance.


[

 {

   "displayName": "Description",

   "value": " Computer is Slow "

 },

 {

   "displayName": "Short Description",

   "value": " Cannot open office applications "

 },

 {

   "displayName": "Priority",

   "value": "1"

 },

 {

   "displayName": "Owned By",

   "value": "Andrew"

 },

 {

   "displayName": "Customer ID",

   "value": "123"

 }

]

]


Table Fields:


5

Variable Field Name

This is an optional field. Choose a field in input stream from drop down list or provide a user or system defined variable.

6

Static Field Name

On click of this column field, it opens a dialog with the list of available form fields of the provided Form Name.  

The name of the fields to be inserted should be selected. Multiple fields can be selected from the list displayed on click. The selected field’s values below will be inserted in the Business object form. 

7

Field Value

Provide field values to be inserted in the corresponding chosen fields.


Output Tab:

No.

Field Name

Description

1

RecID

Specify a field name to return the RecID created with the input fields and field values provided. This field is mandatory.

2

Public ID

Specify a field name to return the Business Object Public ID created with the input fields and field values provided. This field is mandatory.


Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values



Cherwell: Update Record

Description

Cherwell Update Record is used to update Cherwell Business Objects (Forms). For example Cherwell Update record may be used to update an incident (i.e. to close an incident if resolved or to keep an incident open if not resolved yet).

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL  

Specify URL to access Cherwell. This field is mandatory.

3

User Name 

Cherwell username. This field is mandatory.


Password:


4

Accept Value as variable/static

Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. 

Else enable checkbox for Password field to appear as Text box.

5

Password

Provide the Cherwell Password for the user.  Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory.


If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps.

6

Client ID  

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.


Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

7

Button: Test Connection

Verifies whether the connection is available or not. 

Base URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.


Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 



Input Fields:

No.

Field Name

Description

1

Form Name  

This holds the Cherwell form name from which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing then it will display validation error message.    

Select a form to populate it into the Form Name field.

3

Business Object Public ID/RecID  

Cherwell Business Object PublicID/RecID. This field is mandatory.

4

Accept Fields as JSON

Enable checkbox to accept field names as JSON input.

5

JSON

About JSON text:

If ‘Accept Fields as JSON’ checkbox is enabled this field is activated. Choose a field containing the JSON text. JSON text should contain key-value pairs enclosed by double quotes (“) enclosure. Provide all the required or mandatory fields as well as other fields to be inserted as as keys in the JSON. 

Note: The JSON could be from any input step such as Generate rows, Text File input, Excel Input Et al. In Cherwell steps JSON text can only be accepted from input fields from previous steps and not as files directly.


Sample JSON text for inserting a single Knowledge Article record:

Following is a sample JSON for inserting a record in Knowledge Article form. This JSON text has five key-value pairs denoting fields and their values to populate five fields. In this Cherwell instance Service and Title are mandatory for Knowledge Article Business Object.

Note: Lookup field values must exactly match existing values in the Cherwell instance.


JSON text: 

[

 {

   "displayName": "Service",

   "value": "HR Service Desk"

 },

 {

   "displayName": "Title",

   "value": "Test_KA10"

 },

 {

   "displayName": "Category",

   "value": "Request leave Rules"

 },

 {

   "displayName": "SubCategory",

   "value": "Submit Service Request"

 },

 {

   "displayName": "Keywords",

   "value": "Test for KA"

 },

 {

   "displayName": "Visible to Customer Portal",

   "value": "False"

 },

 {

   "displayName": "Article Type",

   "value": "How To"

 }

]


Sample JSON text for updating an Incident record:

Following is a sample JSON for updating two records in Incident form. This JSON text has three key-value pairs denoting three fields and their values to update three fields. In this Cherwell instance Description, Short Description, Priority, Owned By and Customer ID are mandatory for Incident Business object.


Note: Lookup field values must exactly match existing values in the Cherwell instance.

[

[

 {

   "displayName": "Description",

   "value": "Computer is Slow_updated"

 },

 {

   "displayName": "Short Description",

   "value": "Cannot open office applications_updated"

 },

 {

   "displayName": "Priority",

   "value": "1"

 },

 {

   "displayName": "Owned By",

   "value": "Andrew"

 },

 {

   "displayName": "Customer ID",

   "value": "123"

 }

]

]


Table Fields:


1

Variable Field Name

This is an optional field. Choose a field in input stream from drop down list or provide a user or system defined variable.

2

Select Field Name

On click of this column field, it opens a dialog with the list of available form fields of the provided Form Name.  

The name of the fields to be updated should be selected. Multiple fields can be selected from the list displayed on click. The selected field’s values below will be updated in the Business object form. 

3

Field Value

Provide field values to be inserted in the corresponding chosen fields.



Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values.


Cherwell: Upload Attachment

Description

Cherwell Upload Attachment step is used to upload a file to a Cherwell Business Object using the Public ID/RecID.

Configurations 

Connection:

No.

Field Name

Description

1

Step Name

Name of the step.  This name has to be unique in a single workflow.

2

URL  

Specify URL to access Cherwell. This field is mandatory.

3

User Name 

Cherwell username. This field is mandatory.


Password:


4

Accept Value as variable/static

Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. 

Else enable checkbox for Password field to appear as Text box.

5

Password

Provide the Cherwell Password for the user.  Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory.


If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps.

6

Client ID  

Provide a Cherwell Client ID. Client ID is used to communicate to Cherwell instance. This field is mandatory.


Note:

CSM Administrator (Orange client) and CSM client (Blue client) tools can be installed for administration and development purposes. Generate a Cherwell client ID from Orange Client using the navigation, 

CSM Administrator toolSecurity  REST API clients.

7

Button: Test Connection

Verifies whether the connection is available or not. 

Base URL, Username, Password, Client ID fields are mandatory. If no values are provided or some values are missing then it will display the validation error message.


Note: For the purpose of verification fields coming from previous steps are not allowed. Static values and environment variables are allowed. 


Input Fields:

No.

Field Name

Description

1

Form Name  

This holds the Cherwell form name from which the record details will be fetched. This field is mandatory.

2

Button: Get Forms

On click of this button, it populates the forms of connected Cherwell Server depending on Access/Permissions of the user.  If any required field values are missing, then it will display validation error message.    

Select a form to populate it into the Form Name field.

3

Business Object Public ID/RecID  

Cherwell Business Object PublicID/RecID. This field is mandatory.

4

File

Specify a file path to be uploaded may browse for a file using the Browse File… button.  Alternatively, when the filename is coming from an input stream, you may select the field containing the filename from the drop down list. 

5

Button: Browse File…

This is the button to browse a file to be uploaded to a Cherwell Business Object. 


Result:

There is no explicit output Result field in this plugin. Plugin results weather success or error can be captured using Set Workflow Result. Errors can be captured in error handling as discussed in Appendix 1: Error Handling in IT Plugins to make the error message visible on AutomationEdge Requests.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values





      Links to better reach 

            Bot Store

             EPD