Bulk Delete Sample

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:

MM

Is the month (01 - 12)

dd

Is the day of the month (01 - 31)

cc

Is the century (00 - 99)

yy

Is the year (00 - 99)

hh

Is the hour (0 - 23)

mm

Is the minutes (0 - 59)

ss

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