Hi Nick Fernley, I've provided a complete example to achieve what you are looking to do. The code includes comments to describe what's going on, if not for you then for other users reading this post in the future looking to achieve something similar:

<div id="CommunityExamples">
    <table class="table table-condensed export-data">
        <thead>
            <tr>
                <th>Site Url</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Loading...</td>
            </tr>
        </tbody>
    </table>
</div>
<script>

    // When the HTML page is ready for us JQuery will call our function
    $j(function() {

        CommunityExamples.getISheetExportXML({
            siteID: 1111,
            sheetID: 2222,
            sheetViewID: 3333
        }).then(function($data) {

            // our link column ID
            var linkColumnID = CommunityExamples.getColumnIdByName($data, "Site");

            // iterate through the iSheet records returned and translate each item
            // to an equivalent HTML table row with the required columns, and data from the iSheet Item
            var $rows = $data.find("view > data > item").map(function(idx, el) {
                // find the link column in this iSheet Item data
                var $linkColumn = $j(el).find("> column[columnid=" + linkColumnID + "

); // and construct the HTML table row using the data from this iSheet item var $link = $j("") .attr("href", $linkColumn.find("linkDisplayURL").text()) .attr("target", "_blank") .html($linkColumn.find("linkDisplayName").text()); return "

"

+ $link.get(0).outerHTML + ""; }); // convert the JQuery Array to a standard Javascript Array, and join each element // in the array to create one (concatenated) string, which we then set as the // HTML table's body - replacing any previous table body contents $j("#CommunityExamples table.export-data tbody").html($rows.toArray().join("")); }) }); var CommunityExamples = { // function to retrieve the ExportXML data for our iSheet View getISheetExportXML: function(params) { return $j.ajax({ "dataType": "xml", "url": "./sheetViewExportXML.action?" + $j.param({ "metaData.siteID": params.siteID, "metaData.sheetId": params.sheetID, "metaData.sheetViewID": params.sheetViewID, "metaData.isheetExportType": "xml" }) }).then(function(data) { // return the XML data as a JQuery fragment return $j(data); }); }, getColumnIdByName: function($data, columnName) { return +$data // get all the column headers .find("view > head > headColumn > columnValue") // and find the required column (by name) .filter(function(idx, el) { return $j(el).text() === columnName; }) // then extract the column ID from the parent of the element found .parent() .attr("columnid"); } }; </script>

The code above is provided as only an example and doesn't include best practices, which would be advisable when writing Production code.

Any questions, just post them. Hope this helps,

Andrew

]]>