sample-dataextension.php

<?php
include_once('tests/UnitBootstrap.php');
use FuelSdk\ET_Client;
use FuelSdk\ET_DataExtension;
use FuelSdk\ET_DataExtension_Column;
use FuelSdk\ET_DataExtension_Row;

try {	
	$myclient = new ET_Client();
		
	//DataExtension Testing
	//Get all Data Extensions
	print_r("Get all Data Extensions \n");
	$getDE = new ET_DataExtension();
	$getDE->authStub = $myclient;
	$getDE->props = array("CustomerKey", "Name");	
	$getResult = $getDE->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	//print 'Results: '."\n";
	//print_r($getResult->results);
	print "\n---------------\n";

	// Specify a name for the data extension that will be used for testing 
	// Note: Name and CustomerKey will be the same value
	// WARNING: Data Extension will be deleted so don't use the name of a
	// production data extension 
	
	$DataExtensionNameForTesting = "PHPSDKTestDE_".uniqid();

	// Create a Data Extension
	print_r("Create a Data Extension  \n");
	$postDE = new ET_DataExtension();
	$postDE->authStub = $myclient;
	$postDE->props = array("Name" => $DataExtensionNameForTesting, "CustomerKey" => $DataExtensionNameForTesting);
	$postDE->columns = array();
	$postDE->columns[] = array("Name" => "Key", "FieldType" => "Text", "IsPrimaryKey" => "true","MaxLength" => "100", "IsRequired" => "true");
	$postDE->columns[] = array("Name" => "Value", "FieldType" => "Text");
	$postResult = $postDE->post();
	print_r('Post Status: '.($postResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$postResult->code."\n";
	print 'Message: '.$postResult->message."\n";	
	print 'Result Count: '.count($postResult->results)."\n";
	print 'Results: '."\n";
	print_r($postResult->results);
	print "\n---------------\n";

	// Update a Data Extension (Add New Column)
	print_r("Update a Data Extension (Add New Column)  \n");
	$patchDE = new ET_DataExtension();
	$patchDE->authStub = $myclient;
	$patchDE->props = array("Name" => $DataExtensionNameForTesting, "CustomerKey" => $DataExtensionNameForTesting);
	$patchDE->columns = array();
	$patchDE->columns[] = array("Name" => "AnExtraField", "FieldType" => "Text");
	$patchResult = $patchDE->patch();
	print_r('Patch Status: '.($patchResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$patchResult->code."\n";
	print 'Message: '.$patchResult->message."\n";	
	print 'Result Count: '.count($patchResult->results)."\n";
	print 'Results: '."\n";
	print_r($patchResult->results);
	print "\n---------------\n";

	//Get single Data Extension
	print_r("Get single Data Extension \n");
	$getDE = new ET_DataExtension();
	$getDE->authStub = $myclient;
	$getDE->props = array("CustomerKey", "Name");	
	$getDE->filter = array('Property' => 'CustomerKey','SimpleOperator' => 'equals','Value' => $DataExtensionNameForTesting);
	$getResult = $getDE->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	print 'Results: '."\n";
	print_r($getResult->results);
	print "\n---------------\n";

	//Get all Data Extensions Columns filter by specific DE
	print_r("Get all Data Extensions Columns filter by specific DE \n");
	$getDEColumns = new ET_DataExtension_Column();
	$getDEColumns->authStub = $myclient;
	$getDEColumns->props = array("CustomerKey", "Name");	
	$getDEColumns->filter = array('Property' => 'CustomerKey','SimpleOperator' => 'equals','Value' => $DataExtensionNameForTesting);
	$getResult = $getDEColumns->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	print 'Results: '."\n";
	print_r($getResult->results);
	print "\n---------------\n";

	// Add a row to a DataExtension 
	print_r("Add a row to a DataExtension  \n");
	$postDRRow = new ET_DataExtension_Row();
	$postDRRow->authStub = $myclient;
	$postDRRow->props = array("Key" => "PHPSDKTEST", "Value" => "ItWorks");
	$postDRRow->Name = $DataExtensionNameForTesting;	
	$postResult = $postDRRow->post();
	print_r('Post Status: '.($postResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$postResult->code."\n";
	print 'Message: '.$postResult->message."\n";	
	print 'Result Count: '.count($postResult->results)."\n";
	print 'Results: '."\n";
	print_r($postResult->results);
	print "\n---------------\n";

	// Add a row to a DataExtension (Specify CustomerKey instead of Name)
	print_r("Add a row to a DataExtension (Specify CustomerKey instead of Name)  \n");
	$postDRRow = new ET_DataExtension_Row();
	$postDRRow->authStub = $myclient;
	$postDRRow->props = array("Key" => "PHPSDKTEST2", "Value" => "ItWorks");
	$postDRRow->CustomerKey = $DataExtensionNameForTesting;	
	$postResult = $postDRRow->post();
	print_r('Post Status: '.($postResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$postResult->code."\n";
	print 'Message: '.$postResult->message."\n";	
	print 'Result Count: '.count($postResult->results)."\n";
	print 'Results: '."\n";
	print_r($postResult->results);
	print "\n---------------\n";

	//Get all Data Extensions Rows (By CustomerKey)
	print_r("Get all Data Extensions Rows (By CustomerKey) \n");
	$getDERows = new ET_DataExtension_Row();
	$getDERows->authStub = $myclient;
	$getDERows->props = array("Key", "Value");
	$getDERows->CustomerKey = $DataExtensionNameForTesting;
	$getResult = $getDERows->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	//print 'Results: '."\n";
	//print_r($getResult->results);
	print "\n---------------\n";
	
	// Update a row in a DataExtension 
	print_r("Update a row in a DataExtension   \n");
	$patchDRRow = new ET_DataExtension_Row();
	$patchDRRow->authStub = $myclient;
	$patchDRRow->props = array("Key" => "PHPSDKTEST2", "Value" => "ItWorksUPDATED!");
	$patchDRRow->CustomerKey = $DataExtensionNameForTesting;	
	$patchResult = $patchDRRow->patch();
	print_r('Patch Status: '.($patchResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$patchResult->code."\n";
	print 'Message: '.$patchResult->message."\n";	
	print 'Result Count: '.count($patchResult->results)."\n";
	print 'Results: '."\n";
	print_r($patchResult->results);
	print "\n---------------\n";
	
	//Get rows from Data Extension using filter (By Name)
	print_r("Get rows from Data Extension using filter (By Name) \n");
	$getDERows = new ET_DataExtension_Row();
	$getDERows->authStub = $myclient;
	$getDERows->props = array("Key", "Value");
	$getDERows->Name = $DataExtensionNameForTesting;
	$getDERows->filter = array('Property' => 'Key','SimpleOperator' => 'equals','Value' => 'PHPSDKTEST2');
	$getResult = $getDERows->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	print 'Results: '."\n";
	print_r($getResult->results);
	print "\n---------------\n";
	
	// Delete a row from a DataExtension 
	print_r("Delete a row from a DataExtension   \n");
	$deleteDRRow = new ET_DataExtension_Row();
	$deleteDRRow->authStub = $myclient;
	$deleteDRRow->props = array("Key" => "PHPSDKTEST2", "Value" => "ItWorksUPDATED!");
	$deleteDRRow->CustomerKey = $DataExtensionNameForTesting;	
	$deleteResult = $deleteDRRow->delete();
	print_r('Delete Status: '.($deleteResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$deleteResult->code."\n";
	print 'Message: '.$deleteResult->message."\n";	
	print 'Result Count: '.count($deleteResult->results)."\n";
	print 'Results: '."\n";
	print_r($deleteResult->results);
	print "\n---------------\n";
	
	
	//Get all Data Extensions Rows (By CustomerKey) Again
	print_r("Get all Data Extensions Rows (By CustomerKey) Again \n");
	$getDERows = new ET_DataExtension_Row();
	$getDERows->authStub = $myclient;
	$getDERows->props = array("Key", "Value");
	$getDERows->CustomerKey = $DataExtensionNameForTesting;
	$getResult = $getDERows->get();
	print_r('Get Status: '.($getResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$getResult->code."\n";
	print 'Message: '.$getResult->message."\n";
	print_r('More Results: '.($getResult->moreResults ? 'true' : 'false')."\n");
	print 'Result Count: '.count($getResult->results)."\n";
	//print 'Results: '."\n";
	//print_r($getResult->results);
	print "\n---------------\n";
	
	
	// Delete a Data Extension
	print_r("Delete a Data Extension  \n");
	$deleteDE = new ET_DataExtension();
	$deleteDE->authStub = $myclient;
	$deleteDE->props = array("Name" => $DataExtensionNameForTesting, "CustomerKey" => $DataExtensionNameForTesting);
	$deleteResult = $deleteDE->delete();
	print_r('Delete Status: '.($deleteResult->status ? 'true' : 'false')."\n");
	print 'Code: '.$deleteResult->code."\n";
	print 'Message: '.$deleteResult->message."\n";	
	print 'Result Count: '.count($deleteResult->results)."\n";
	print 'Results: '."\n";
	print_r($deleteResult->results);
	print "\n---------------\n";
	
	}
	catch (Exception $e) {
    echo 'Caught exception: ',  $e->getMessage(), "\n";
}

?>