Integrating Tableau and MuleSoft

				
					        "use strict";
    
    var worksheetData = {}; // Will hold the average of each column in each worksheet
    var worksheetPromises = []; // Will hold the promises returned by fetch() when we call our MuleSoft API
    
    /**
    * Converts an object containing information about a particular cell in a worksheet to just the cell's numeric value.
    **/
    function getValue(obj)
    {
    		return obj._value;
    }
    
    function calcAvg(worksheetName, arr)
    {
    	let name = arr[0]._value; // This array's name
    	let nums = arr.slice(1).map(getValue); // Cut off the first object, because it only contains the column's name without any data. Then we fetch just the numeric value of each cell object.
    	let encodedURI = "https://{YOUR_EXTENSION'S_HTTPS_URI}/?nums=" + encodeURIComponent(JSON.stringify(nums)); // Create URI with array as param
    	return fetch(encodedURI, {method: "GET", mode: "cors", credentials: "omit"})
    	.then(resp => resp.json())
    	.then(obj => {
    		worksheetData[worksheetName][name] = Number(obj.average); // Save this column's average
    	})
    	.catch(e => appendToLog("Error while sending array to MuleSoft: " + JSON.stringify(e)));
    }
    
    /**
    * Adds a row for the average value of a column in a worksheet.
    **/
    function addAverageRow(data, tableId, columnName)
    {
    	$("table#" + tableId).append("<tr><td>" + columnName + "</td><td>" + data[columnName] + "</td></tr>");
    }
    
    /**
    * Creates a table to display the average values of each column in a given worksheet.
    **/
    function createWorksheetTable(tableName)
    {
    	let tableData = worksheetData[tableName];
    	let tableId = tableName.replace(/\s+/g, '-').replace("'", "").toLowerCase(); // ID to use for the table that will display our worksheet's average data
    	$("#dataTables").append("<div id=""><h2>" + tableName + "</h2><hr /><table class="table" id=""><tr><th>Column</th><th>Average</th></tr></table><div>"); // Create a table to display this worksheet's average data
    	Object.keys(tableData).forEach(addAverageRow.bind(window, tableData, tableId)); // Add a row for the average of each column in the worksheet
    }
    
    /**
    * Displays the average values of each column in all worksheets using the values that our API calculated.
    **/
    function createTables(avgData)
    {
    	$("#dataTables").html(""); // Clear the old display tables
    	Object.keys(worksheetData).forEach(createWorksheetTable); // Loop through each worksheet's average data and display it as a table.
    }
    
    /**
    * Calculates the average of each column in a worksheet.
    **/
    function handleSumData(worksheetName, data)
    {
    	let avgs = data._data.map(calcAvg.bind(window, worksheetName)); // Calculate the average of each column in this worksheet
    	Promise.all(avgs).then(ignored =&gt; createTables(avgs)); // Wait for all of our calls to MuleSoft to finish, then display the results
    }
    
    /**
    * Calls our MuleSoft API with the values of each row in each worksheet.
    **/
    function pingAPI(worksheet)
    {
    	worksheetData[worksheet.name] = {}; // Create an object to hold the average of each column in this worksheet
    	worksheetPromises.push(worksheet.getSummaryDataAsync().then(handleSumData.bind(window, worksheet.name))); // Fetch this worksheet's data, then process it
    }
    
    /*
    * Handles successful initialization of the Tableau library.
    */
    function tabSucc()
    {
    	const worksheets = tableau.extensions.dashboardContent.dashboard.worksheets;
    	worksheets.forEach(pingAPI); // Calculate average value of each column in each worksheet
    }
    
    /**
    * Handles the case where the Tableau library fails to initialize.
    **/
    function tabFail(e)
    {
    	alert("Error while initializing Tableau: " + e.toString());
    }
    
    /*
    * Initializes Tableau.
    */
    function initialize(e)
    {
    	tableau.extensions.initializeAsync().then(tabSucc, tabFail);
    }
    
    $(document).ready(initialize);