The following is a sample of a bulk delete operation.
<?xml version="1.0" encoding="UTF-8"?> <is:globaloperations.BulkDelete xmlns:is="http://com.ibi.crm/inputSchema/globaloperations/BulkDelete" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <EntityList> <Entity> <QuerySet> <QueryBase xsi:type="is:QueryExpression"> <EntityName>account</EntityName> <ColumnSet xsi:type="is:AllColumns"/> <Distinct>true</Distinct> <is:NoLock>true</is:NoLock> <Criteria> <FilterOperator>And</FilterOperator> <Conditions> <Condition> <AttributeName>name</AttributeName> <Operator>Equal</Operator> <Values> <Value xsi:type="xs:string">account_name</Value> <!-- xsi:type is required element! --> </Values> </Condition> </Conditions> <Filters/> </Criteria> </QueryBase> </QuerySet> <JobName>New Delete Job</JobName> <SendEmailNotification>false</SendEmailNotification> <ToRecipients /> <CCRecipients/> <RecurrencePattern/> <StartDateTime>2012/04/09T02:30:00-07:00</StartDateTime> <!--Format with timezone (e.g. 02:00:00 = 12:00:00, 07:30:00 = 17:30:00) --> </Entity> </EntityList> </is:globaloperations.BulkDelete>
The following table describes the date and time specification from MSDN.
Parameter | Specification |
---|---|
User time only | yyyy-MM-ddTHH:mm:ss |
UTC only | yyyy-MM-ddTHH:mm:ss Z |
Both | yyyy-MM-ddTHH:mm:ss OffsetWhere Offset is one of the following: +##:## -##:## |
where:
Is the month (01 - 12)
Is the day of the month (01 - 31)
Is the century (00 - 99)
Is the year (00 - 99)
Is the hour (0 - 23)
Is the minutes (0 - 59)
Is the seconds (1 - 59)
Is a digit between 0 and 9
Valid Values
Minimum value: 1900/1/1 00:00:00
Maximum value: 9999/12/30 23:59:59
Example
The following example shows how to set a date/time attribute value.
CrmDateTime dateTime = new CrmDateTime();
dateTime.Value = "2006/5/27T17:00:00";
iWay Software |