About Clearing Transactions from Integration Event Queues
You can use the Upsert
command to clear transactions
from an integration event queue. You can clear all transactions from
the queue by including the <ClearAllTransactions> element in the
XML file for the upsert operation, with the value set to true, as
follows:
<data:ClearAllTransactions>true</data:ClearAllTransactions>
Alternatively, you can clear older transactions from the queue by including the <ClearFromDate> element in the XML file for the upsert operation, with the value set to a date and time. The upsert operation clears all of the transactions that occurred before that date and time from the queue.
In the <ClearFromDate> element, you must use the date and time format specified by the W3C standard. The format is:
YYYY-MM-DDTHH:MM:SS
In the string:
YYYY specifies the year
MM specifies the month
DD specifies the day
T indicates the start of the required time section
HH specifies the hour
MM specifies the minute
SS specifies the second
If you express the time in UTC (Coordinated Universal Time), then append the letter Z to the string, as shown in the following example:
2002-05-30T09:30:10Z
If you express the time in a time zone other than UTC, then you must specify the positive or negative offset from UTC in hours and minutes, as shown in the following examples.
This example shows a time expressed in UTC:
2002-05-30T09:30:10Z
The following example shows the same moment expressed in a time zone that is six hours behind UTC:
2002-05-30T03:30:10-06:00
The following example shows the same moment expressed in a time zone that is six hours ahead of UTC:
2002-05-30T15:30:10+06:00