public void DataExtensionUpdate() { var deObj = new ETDataExtension { AuthStub = client, Name = updatedDataExtensionName, CustomerKey = dataExtensionName }; var response = deObj.Patch(); Assert.AreEqual(response.Code, 200); var degetObj = new ETDataExtension { AuthStub = client, Props = new[] { "Name" }, SearchFilter = new SimpleFilterPart { Property = "CustomerKey", SimpleOperator = SimpleOperators.equals, Value = new[] { dataExtension.CustomerKey } }, }; var getResponse = degetObj.Get(); Assert.AreEqual(getResponse.Code, 200); Assert.GreaterOrEqual(getResponse.Results.Length, 1); var getDE = (ETDataExtension)getResponse.Results[0]; Assert.AreEqual(getDE.Name, updatedDataExtensionName); }
public void DataExtensionSetup() { dataExtensionName = Guid.NewGuid().ToString(); updatedDataExtensionName = Guid.NewGuid().ToString(); var deObj = new ETDataExtension { AuthStub = client, Name = dataExtensionName, CustomerKey = dataExtensionName, Columns = new[] { new ETDataExtensionColumn { Name = "Field1", FieldType = DataExtensionFieldType.Text, IsPrimaryKey = true, MaxLength = 100, IsRequired = true }, new ETDataExtensionColumn { Name = "Field2", FieldType = DataExtensionFieldType.Text }, new ETDataExtensionColumn { Name = "NumericField", FieldType = DataExtensionFieldType.Number } } }; var result = deObj.Post(); dataExtension = (ETDataExtension)result.Results[0].Object; }
public void PublishItem(int changeId, string approvalStatus) { List <ItemChangeHistory> changeList = GetItemChangeHistory(changeId, approvalStatus); if (changeList.Count > 0) { ItemChangeHistory change = GetItemChangeHistory(changeId, approvalStatus)[0]; string itemId = change.ItemId; string changeType = change.ChangeType; ETDataExtension etd = new ETDataExtension(); etd.InsertIntoDataExtension(change.ItemHtml, change.ChangeType, change.ProductCategory); Sitecore.Data.Database master = Sitecore.Configuration.Factory.GetDatabase("master"); Sitecore.Data.Database web = Sitecore.Configuration.Factory.GetDatabase("web"); Sitecore.Data.Items.Item item = master.Items.GetItem(itemId); Sitecore.Publishing.PublishOptions publishOptions = new Sitecore.Publishing.PublishOptions(item.Database, web, Sitecore.Publishing.PublishMode.SingleItem, item.Language, System.DateTime.Now); Sitecore.Publishing.Publisher publisher = new Sitecore.Publishing.Publisher(publishOptions); publisher.Options.RootItem = item; publisher.Options.Deep = true; publisher.Publish(); } }
public void DataExtensionDelete() { var deObj = new ETDataExtension { AuthStub = client, CustomerKey = dataExtensionName }; var response = deObj.Delete(); Assert.AreEqual(response.Code, 200); Assert.AreEqual(response.Results[0].StatusMessage, "Data Extension deleted."); var degetObj = new ETDataExtension { AuthStub = client, Props = new[] { "Name" }, SearchFilter = new SimpleFilterPart { Property = "CustomerKey", SimpleOperator = SimpleOperators.equals, Value = new[] { dataExtension.CustomerKey } }, }; var getResponse = degetObj.Get(); Assert.AreEqual(getResponse.Code, 200); Assert.AreEqual(getResponse.Results.Length, 0); }
public void DataExtensionTearDown() { if (dataExtension != null) { var deObj = new ETDataExtension(); deObj.AuthStub = client; deObj.CustomerKey = dataExtensionName; deObj.Delete(); } }
protected void AddSubscriber() { string email = tbx_YourEmail.Value; string firstName = tbx_FirstName.Value; string lastName = tbx_LastName.Value; List <string> productCategories = categories.Value.Split(';').ToList(); ETDataExtension etd = new ETDataExtension(); etd.InsertSubscribers(productCategories, firstName, lastName, email); }
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 TearDown() { var deObj = new ETDataExtension { AuthStub = client, CustomerKey = dataExtensionName }; var response = deObj.Delete(); if (deleteDef) { var importObj = new ETImportDefinition { AuthStub = client, CustomerKey = importName }; importObj.Delete(); } }
public void TearDown() { var emailSendDef = new ETEmailSendDefinition { AuthStub = client, CustomerKey = this.emailSendDef.CustomerKey }; var response = emailSendDef.Delete(); var email = new ETEmail { AuthStub = client, CustomerKey = this.email.CustomerKey }; var emailResponse = email.Delete(); var de = new ETDataExtension { AuthStub = client, CustomerKey = this.dataExtension.CustomerKey }; var deResponse = de.Delete(); }
public void Setup() { dataExtensionName = Guid.NewGuid().ToString(); importName = Guid.NewGuid().ToString(); var deObj = new ETDataExtension { AuthStub = client, Name = dataExtensionName, CustomerKey = dataExtensionName, IsSendable = true, SendableDataExtensionField = new ETDataExtensionColumn { Name = "SubscriberID", FieldType = DataExtensionFieldType.Number }, SendableSubscriberField = new ETProfileAttribute { Name = "Subscriber ID", Value = "Subscriber ID" }, Columns = new[] { new ETDataExtensionColumn { Name = "SubscriberID", FieldType = DataExtensionFieldType.Number, IsPrimaryKey = true, IsRequired = true }, new ETDataExtensionColumn { Name = "FirstName", FieldType = DataExtensionFieldType.Text }, new ETDataExtensionColumn { Name = "LastName", FieldType = DataExtensionFieldType.Text } } }; var response = deObj.Post(); Assert.AreEqual(response.Code, 200); Assert.AreEqual(response.Status, true); dataExtensionId = response.Results[0].NewObjectID; var importDefObj = new ETImportDefinition { AuthStub = client, Name = importName, CustomerKey = importName, Description = "Created with FuelSDK", AllowErrors = true, DestinationObject = new ETDataExtension { ObjectID = dataExtensionId }, FieldMappingType = ImportDefinitionFieldMappingType.InferFromColumnHeadings, FileSpec = "FuelSDKExample.csv", FileType = FileType.CSV, Notification = new AsyncResponse { ResponseType = AsyncResponseType.email, ResponseAddress = "*****@*****.**" }, RetrieveFileTransferLocation = new FileTransferLocation { CustomerKey = "ExactTarget Enhanced FTP" }, UpdateType = ImportDefinitionUpdateType.Overwrite, }; var createresponse = importDefObj.Post(); Assert.AreEqual(createresponse.Code, 200); Assert.AreEqual(createresponse.Status, true); Assert.AreEqual(createresponse.Results[0].StatusMessage, "ImportDefinition created."); deleteDef = true; }
public void Setup() { //To create a email send definition we need: Email, SendableList, SendClassification //we will create email ,sendable data extension for SendableList var dataExtensionName = Guid.NewGuid().ToString(); var deObj = new ETDataExtension { AuthStub = client, Name = dataExtensionName, CustomerKey = dataExtensionName, IsSendable = true, SendableDataExtensionField = new ETDataExtensionColumn { Name = "SubscriberID", FieldType = DataExtensionFieldType.Number }, SendableSubscriberField = new ETProfileAttribute { Name = "Subscriber ID", Value = "Subscriber ID" }, Columns = new[] { new ETDataExtensionColumn { Name = "SubscriberID", FieldType = DataExtensionFieldType.Number, IsPrimaryKey = true, IsRequired = true }, new ETDataExtensionColumn { Name = "FirstName", FieldType = DataExtensionFieldType.Text }, new ETDataExtensionColumn { Name = "LastName", FieldType = DataExtensionFieldType.Text } } }; var result = deObj.Post(); dataExtension = (ETDataExtension)result.Results[0].Object; var dataExtensionId = result.Results[0].NewObjectID; //create Email var emailName = string.Empty; var emailCustKey = emailName = System.Guid.NewGuid().ToString(); var emailContent = "<b>This is a content generated by Fuel SDK C#"; var emailObj = new ETEmail { AuthStub = client, Name = emailName, CustomerKey = emailCustKey, Subject = "This email is created using C# SDK", HTMLBody = emailContent }; var emailResponse = emailObj.Post(); Assert.AreEqual(emailResponse.Code, 200); Assert.AreEqual(emailResponse.Status, true); email = (ETEmail)emailResponse.Results[0].Object; //create the send def var sendDefName = Guid.NewGuid().ToString(); var sendDefList = new ETSendDefinitionList { Name = "SendDefintion List CSharp", CustomerKey = dataExtension.CustomerKey, SendDefinitionListType = SendDefinitionListTypeEnum.SourceList, CustomObjectID = dataExtension.ObjectID, DataSourceTypeID = DataSourceTypeEnum.CustomObject }; var postESDDE = new ETEmailSendDefinition { AuthStub = client, Name = sendDefName, CustomerKey = sendDefName, Description = desc, SendClassification = new ETSendClassification { CustomerKey = "Default Commercial" }, SendDefinitionList = new[] { sendDefList }, Email = new ETEmail { ID = emailResponse.Results[0].NewID }, }; var postResponse = postESDDE.Post(); Assert.AreEqual(postResponse.Code, 200); Assert.AreEqual(postResponse.Status, true); emailSendDef = (ETEmailSendDefinition)postResponse.Results[0].Object; }
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; }