I'm trying to obtain the publishedUrl of every CloudPage published.
With this script:
<script runat="server">
// Load the Core Library
Platform.Load("core", "1.1");
// Create a WSProxy Object
var prox = new Script.Util.WSProxy();
var cols = [
"ID",
"CustomerKey",
"Name",
"fileProperties.publishedURL"
];
var filter = {
Property: "assetType.id",
SimpleOperator: "in",
Value: [205, 206]
}
var results = prox.retrieve("Asset", cols, filter);
Write(Stringify(results.Results));
</script>
I am reciving a json (converted in text) where all the fields that are objects appear as null. I can filter with the fields contained in that objects but I can't extract them.
Here is an example of the results:
[{"ContentType":"text/html","Version":1,"Locked":null,"Name":"testes","Description":null,"ActiveDate":null,"ExpirationDate":null,"MemberId":......,"EnterpriseId":....,"CreatedBy":null,"ModifiedBy":null,"Content":null,"Design":null,"SuperContent":null,"MinBlocks":null,"MaxBlocks":null,"File":null,"AssetType":null,"Status":null,"Thumbnail":null,"GenerateFrom":null,"Template":null,"Category":null,"Data":null,"FileProperties":null,"Meta":null,"CustomFields":null,"SharingProperties":null,"Views":null,"Blocks":null,"Slots":null,"Channels":null,"AllowedBlocks":null,"Tags":null,"Attributes":null,"Client":null,"PartnerKey":null,"PartnerProperties":null,"CreatedDate":"2020-09-24T05:12:21.557","ModifiedDate":"2020-09-28T03:23:40.280","ID":....,"ObjectID":".....","CustomerKey":".....","Owner":null,"CorrelationID":null,"ObjectState":null,"IsPlatformObject":false}]
Is there anything I can do to obtain a field inside one of those fields that are resulting like null? fileProperties is the objective, but once get one I will have full access to the info
Thank you