This task changes the priority field of the Zendesk ticket with the
ID of
46
from low to
high.Procedure
-
Double-click the tFixedFlowInput component to open the Basic settings view.
-
Click the […] button next to Edit
schema, remove all the existing columns, and add the following
columns in the schema editor: id (type
Int) and priority (type
String).
Note: Column names are case-sensitive.
-
Click Yes when prompted.
This propagates the schema to the tZendeskOutput component.
- Select the Use Single Table option.
-
Enter the following in the Values field for the
columns.
- id: 46
- priority: "high"
- Leave the other options as they are.
-
Click the […] button next to Edit
schema, remove all the existing columns, and add the following
columns in the schema editor: id (type
Int) and priority (type
String).
-
In the Basic settings view of the
tZendeskOutput component:
- Select Tickets from the Selection type drop-down list.
- Select Update from the Data action drop-down list.
- Leave the other options as they are.
-
In the Basic settings view of the
tZendeskInput component:
- Click the […] button next to Edit schema and add this column in addition to the existing columns in the schema editor: id, type Int.
-
Click Yes when prompted.
This propagates the schema to the tLogRow component.
- Leave the Query string field empty.
-
Save the Job and press F6 to execute the Job.
The priority of the ticket with the id of 46 changes to high.