This task removes the ticket with the ID of
45
.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 this column in
the schema editor: id (type
Int).
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 45 in the Values field of the id column.
- Leave the other options as they are.
-
Click the […] button next to Edit
schema, remove all the existing columns, and add this column in
the schema editor: id (type
Int).
-
In the Basic settings view of the
tZendeskOutput component:
- Select Tickets from the Selection type drop-down list.
- Select Delete 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 ticket with the id of 45 is not displayed, indicating that it has been removed.