DeleteData

Description

Deletes data in the database according to the given TransferDef. The data will be deleted in reversed nesting level order. Rows appurtenant in underlying levels will also be deleted.

Signature
int DeleteData(string key, SurveyDataTransferDefBase dataTransferDef)

Parameters

Name Data Type Description

key

string required

The authentication key

dataTransferDef

The transfer definition object.

Response

Data Type Description

int

Number of affected rows.

Example

//***************************************************
//
// DeleteData
//
//***************************************************

// Initiate webservice
DataTransferSoapClient dataTransfer = new DataTransferSoapClient();

// Create a transfer definition
SurveyDataTransferDef transferDefinition = new SurveyDataTransferDef();

// Set the project id for the Confirmit project where data should be deleted
transferDefinition.ProjectId = projectId;

// Create a filter expression to only delete responses that were completed at or
// after 01-01-2013
transferDefinition.FilterExpression = "interview_end >= TODATE(\"2013-01-01\")";

// Delete the responses
int numberOfResponsesDeleted = dataTransfer.DeleteData(key, transferDefinition);