Exporting list of URLs

Question

In SDL Web 8.5 is it possible to export a list of all URLs in a specific tree?

We're hoping to use this to cross-check an XML sitemap to ensure nothing that's live isn't missed out (as crawlers won't index anything with a direct link to it).

Thank you,

Answer 1

There is no 'out of the box' way via the GUI, but you can do this using the Core Service.

Something like the following code (which outputs a CSV) should give you a good start:

void Main()
{
    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    
    foreach (PageData page in allPages)
    {
        OutputPageDetails(page.Id);
    }
}

void OutputPageDetails(string pageId)
{
    PageData page = (PageData)Client.Read(pageId, null);
    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");
    Console.WriteLine($"{pageId}, \"{page.Title}\", \"{livePagePublishUrl}\"");
}

(P.S. You'll probably want to consider using Client.GetListXML(), rather than Cleint.GetList() for efficiency)

Answer 2

Actually Jonathan's answer is just part of the solution. You should create 2 lists:

1. first list is the list created using Core Service API and this list is the list of URLs for pages that CM side thinks that are published.
2. Second list is list of page URLs created using Content Delivery API, and this list is the list of actually published pages.

In ideal world, these 2 lists should be identical, but in most cases they are not. Second list is the list of actually published pages on CD Environment, so you should in any case do the following:

• Create both lists
• compare them and make sure that they are in sync (if there are some URLs in first but not in second list, republish the page so that it indeed comes to CD side. If there is URL in second, but not in first list, it means that item is orphan, so you should create undeploy package and remove it from CD environment).