1

Is there any chance i can retrive the names of all fields with created date in a data extension via Query/API

0
4

As provide in the example on this question 'Retrieve the Data Extension Fields using Soap Api'

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Header>
      <fueloauth>XXXXXXXXXXXX</fueloauth>
   </soapenv:Header>
   <soapenv:Body>
      <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <RetrieveRequest>
            <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>XXXXXXXX</Value>
        </Filter>
         </RetrieveRequest>
      </RetrieveRequestMsg>
   </soapenv:Body>
</soapenv:Envelope>

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