Skip to content

Instantly share code, notes, and snippets.

@wvpv
Last active February 19, 2023 12:24
Show Gist options
  • Save wvpv/9001b002ebf7552f64db to your computer and use it in GitHub Desktop.
Save wvpv/9001b002ebf7552f64db to your computer and use it in GitHub Desktop.
SFMC DataExtensionField Retrieve SOAP Envelope
<?xml version="1.0" encoding="UTF-8"?>
<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<s:Header>
<a:Action s:mustUnderstand="1">Retrieve</a:Action>
<a:MessageID>urn:uuid:e3f7fdfe-d225-47fb-a764-ad4f465fb724</a:MessageID>
<a:ReplyTo>
<a:Address>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</a:Address>
</a:ReplyTo>
<a:To s:mustUnderstand="1">https://webservice.exacttarget.com/Service.asmx</a:To>
<o:Security xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" s:mustUnderstand="1">
<u:Timestamp u:Id="_0">
<u:Created>2014-11-18T14:44:10.936Z</u:Created>
<u:Expires>2014-11-18T14:49:10.936Z</u:Expires>
</u:Timestamp>
<o:UsernameToken u:Id="uuid-642de236-bbe2-41d9-b965-d107063c913c-3">
<o:Username>
<!-- Removed-->
</o:Username>
<o:Password>
<!-- Removed-->
</o:Password>
</o:UsernameToken>
</o:Security>
</s:Header>
<s:Body xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
<RetrieveRequest>
<ObjectType>DataExtensionField</ObjectType>
<Properties>Client.ID</Properties>
<Properties>CreatedDate</Properties>
<Properties>CustomerKey</Properties>
<Properties>DataExtension.CustomerKey</Properties>
<Properties>DefaultValue</Properties>
<Properties>FieldType</Properties>
<Properties>IsPrimaryKey</Properties>
<Properties>IsRequired</Properties>
<Properties>MaxLength</Properties>
<Properties>ModifiedDate</Properties>
<Properties>Name</Properties>
<Properties>ObjectID</Properties>
<Properties>Ordinal</Properties>
<Properties>Scale</Properties>
<Filter xsi:type="SimpleFilterPart">
<Property>DataExtension.CustomerKey</Property>
<SimpleOperator>equals</SimpleOperator>
<Value>YOURDATAEXTENSIONCUSTOMERKEYHERE</Value>
</Filter>
<QueryAllAccounts>true</QueryAllAccounts>
<Retrieves />
<Options>
<SaveOptions />
<IncludeObjects>true</IncludeObjects>
</Options>
</RetrieveRequest>
</RetrieveRequestMsg>
</s:Body>
</s:Envelope>
@wvpv
Copy link
Author

wvpv commented Feb 19, 2023

You're right. Updated. Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment