public void QueryDefinitionDelete()
{
var qDef = new ETQueryDefinition
{
AuthStub = client,
CustomerKey = queryDefKey,
ObjectID = queryDef.ObjectID
};
var qdefResponse = qDef.Delete();
Assert.AreEqual(qdefResponse.Code, 200);
Assert.AreEqual(qdefResponse.Status, true);
Assert.AreEqual(qdefResponse.Results[0].StatusMessage, "QueryDefinition deleted");
}
public void TearDown()
{
var qDef = new ETQueryDefinition
{
AuthStub = client,
CustomerKey = queryDefKey,
ObjectID = queryDef.ObjectID
};
var qdefResponse = qDef.Delete();
var deObj = new ETDataExtension
{
AuthStub = client,
CustomerKey = dataExtensionName,
};
var result = deObj.Delete();
}
public void QueryDefinitionGet()
{
var qDef = new ETQueryDefinition
{
AuthStub = client,
CustomerKey = queryDefKey,
ObjectID = queryDef.ObjectID,
Props = new[] { "Name", "ObjectID", "Description" },
SearchFilter = new SimpleFilterPart {
Property = "ObjectID", Value = new[] { queryDef.ObjectID.ToString() }, SimpleOperator = SimpleOperators.equals
}
};
var qdefResponse = qDef.Get();
Assert.AreEqual(qdefResponse.Code, 200);
Assert.AreEqual(qdefResponse.Status, true);
var def = (ETQueryDefinition)qdefResponse.Results[0];
Assert.AreEqual(def.Name, queryDefKey);
Assert.AreEqual(def.Description, desc);
}
public void QueryDefinitionUpdate()
{
var qDef = new ETQueryDefinition
{
AuthStub = client,
CustomerKey = queryDefKey,
ObjectID = queryDef.ObjectID,
Description = updatedDesc,
DataExtensionTarget = new InteractionBaseObject {
CustomerKey = targetDEKey, Name = "Store102DEx"
},
QueryText = string.Format("SELECT * FROM [{0}] WHERE STOREID=102", dataExtensionName),
TargetType = "DE",
TargetUpdateType = "Overwrite"
};
var qdefResponse = qDef.Patch();
Assert.AreEqual(qdefResponse.Code, 200);
Assert.AreEqual(qdefResponse.Status, true);
Assert.AreEqual(qdefResponse.Results[0].StatusMessage, "QueryDefinition updated");
qDef = new ETQueryDefinition
{
AuthStub = client,
CustomerKey = queryDefKey,
ObjectID = queryDef.ObjectID,
Props = new[] { "Name", "ObjectID", "Description" },
SearchFilter = new SimpleFilterPart {
Property = "ObjectID", Value = new[] { queryDef.ObjectID.ToString() }, SimpleOperator = SimpleOperators.equals
}
};
var getResponse = qDef.Get();
Assert.AreEqual(getResponse.Code, 200);
Assert.AreEqual(getResponse.Status, true);
var def = (ETQueryDefinition)getResponse.Results[0];
Assert.AreEqual(def.Name, queryDefKey);
Assert.AreEqual(def.Description, updatedDesc);
}
public void Setup()
{
dataExtensionName = Guid.NewGuid().ToString();
targetDEKey = Guid.NewGuid().ToString();
desc = "Query definition created by C# SDK";
updatedDesc = "Updated Query definition created by C# SDK";
var deObj = new ETDataExtension
{
AuthStub = client,
Name = dataExtensionName,
CustomerKey = dataExtensionName,
Columns = new[] {
new ETDataExtensionColumn {
Name = "CustomerNumber", FieldType = DataExtensionFieldType.Text, IsPrimaryKey = true, MaxLength = 100, IsRequired = true
},
new ETDataExtensionColumn {
Name = "StoreId", FieldType = DataExtensionFieldType.Number
},
new ETDataExtensionColumn {
Name = "FirstName", FieldType = DataExtensionFieldType.Text, MaxLength = 256
},
new ETDataExtensionColumn {
Name = "LastName", FieldType = DataExtensionFieldType.Text, MaxLength = 256
}
}
};
var result = deObj.Post();
dataExtension = (ETDataExtension)result.Results[0].Object;
for (int i = 0; i < 3; i++)
{
var deRow = new ETDataExtensionRow
{
AuthStub = client,
DataExtensionName = dataExtensionName,
};
deRow.ColumnValues.Add("CustomerNumber", i.ToString());
deRow.ColumnValues.Add("StoreId", i % 2 == 0 ? "101" : "102");
deRow.ColumnValues.Add("FirstName", "FirstName_" + i.ToString());
deRow.ColumnValues.Add("LastName", "LastName_" + i.ToString());
var derResponse = deRow.Post();
Assert.AreEqual(derResponse.Code, 200);
Assert.AreEqual(derResponse.Results[0].StatusMessage, "Created DataExtensionObject");
}
queryDefKey = Guid.NewGuid().ToString();
var qDef = new ETQueryDefinition
{
AuthStub = client,
Name = queryDefKey,
Description = desc,
CustomerKey = queryDefKey,
DataExtensionTarget = new InteractionBaseObject {
CustomerKey = targetDEKey, Name = "Store102DEx"
},
QueryText = string.Format("SELECT * FROM [{0}] WHERE STOREID=102", dataExtensionName),
TargetType = "DE",
TargetUpdateType = "Overwrite"
};
var qdefResponse = qDef.Post();
Assert.AreEqual(qdefResponse.Code, 200);
Assert.AreEqual(qdefResponse.Status, true);
Assert.AreEqual(qdefResponse.Results[0].StatusMessage, "QueryDefinition created");
queryDef = (ETQueryDefinition)qdefResponse.Results[0].Object;
}