2

I know that a Data extension could beb deployed using tool like Postman through API by SOAP request as described here But this request requires adding all the fields to the request manually. How can this be avoided? Is there a way to include all fields (like using * or something) so that this manual effort is removed? Or is there a way to get all fields of data extension in same format as required in the SOAP request?

We can retrieve Data extension using the API call which has all the fields, but again the fields needs to be copy pasted from this response to Deploy request.

2

In the June release, Deployment Manager can achieve this for you.

But this post shows you retrieve all the fields in the DE

<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">
  <!-- header removed -->
  <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
      <RetrieveRequest>
        <ClientIDs>
          <ID>999999999</ID>
        </ClientIDs>
        <ObjectType>DataExtensionField</ObjectType>
        <Properties>ObjectID</Properties>
        <Properties>PartnerKey</Properties>
        <Properties>CustomerKey</Properties>
        <Properties>Name</Properties>
        <Properties>DefaultValue</Properties>
        <Properties>MaxLength</Properties>
        <Properties>IsRequired</Properties>
        <Properties>Ordinal</Properties>
        <Properties>IsPrimaryKey</Properties>
        <Properties>FieldType</Properties>
        <Properties>CreatedDate</Properties>
        <Properties>ModifiedDate</Properties>
        <Properties>Scale</Properties>
        <Properties>Client.ID</Properties>
        <Properties>DataExtension.CustomerKey</Properties>
        <Properties>StorageType</Properties>
        <Filter xsi:type="SimpleFilterPart">
          <Property>DataExtension.CustomerKey</Property>
          <SimpleOperator>equals</SimpleOperator>
          <Value>DATAEXTENSIONCUSTOMERKEY</Value>
        </Filter>
      </RetrieveRequest>
    </RetrieveRequestMsg>
  </s:Body>
</s:Envelope>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.