Get the Fields Available for Retrieval with “Describe”

<table border="1" cellspacing="0" cellpadding="1" bordercolor="#000000" style="color:#000000;font-family:Arial;">
<tr>
<th>Name</th>
<th>isRetrievable</th>
</tr>
<script runat="server">
Platform.Load("Core","1.1.1");
try{
var prox = new Script.Util.WSProxy();
var data = prox.describe("DataExtension")
var resultProperties = data.Results[0].Properties;

for ( i in resultProperties ) {
var colName = resultProperties[i].Name;
var Retrievable = resultProperties[i].IsRetrievable;

var color = (Retrievable == true) ? "#228C22" : "#8B0000";
Write("<tr>");
Write("<td>" + resultProperties[i].Name + "</td>");
Write('<td style="color:' + color + '">' + resultProperties[i].IsRetrievable + '</td>');
Write("</tr>");
}
}catch(err){
Write(Stringify(err));
}
</script>
</table>

--

--

--

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Strategising your testing efforts.

Hakluke’s Guide to Amass — How to Use Amass More Effectively for Bug Bounties

Generating Optimal Keyboard Layouts (with Code)

Google Colab Free GPU Tutorial

How to Maintain UPM Package Part 4: Managing Package Release with CLI

!$PDF ~*EPub Linux Command Line and Shell Scripting Bible Full Pages

Audio: Things Everyone Should Know

Publish and share your website code with GitHub

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Charlie Fay

Charlie Fay

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

More from Medium

CS373 Spring 2022: William Johnston

Send email with an attachment and HTML body in WSO2 MI

Task It! A task tracking app for your daily routine

VMware vSAN File Services Experience