Reference: CCDS Sample Script Template

Prerequisites

Required Permissions:
Integration Developer
within
Administration > Permission Set
See Concept: CCDS, Create Scripts for CCDS
Understand the various Adaptive Planning Functions
CCDS Developers must be experienced JavaScript programmers

Example

var sampleData = {
    validConnection: true,//Change this for an invalid connection
    headings: ['Heading A', 'Heading B', 'Heading C'],
    data: [
        ['A1','B1','C1'], 
        ['A2','B2','C2'], 
        ['A3','B3','C3']
    ],
    tableName: 'Example'
};


function testConnection(context) 
{       
    return sampleData.validConnection;
}    
    
function importStructure(context) 
{
    var builder = context.getStructureBuilder();
    var table = createTable(builder, sampleData.tableName);
    for(var i = 0; i < sampleData.headings.length; i++) {
        var heading = sampleData.headings[i];
        createColumn(table, heading);
    }
}

function importData(context)
{
    
    //Use the passed-in contextual information to create a rowset object.
    var rowset = context.getRowset();   
    //Process each row to extract cell values for each column.
    for(var i = 0; i < sampleData.data.length; i++) {
        var data = sampleData.data[i];
        //Add each row array to the rowset.
        rowset.addRow(data);
    }
}

function createColumn(table, heading) {
    var columnId = escape(heading);
    var column = table.addColumn(columnId);
    column.setDisplayName(heading);
    column.setTextColumnType(1000);
}

function createTable(builder, name) {
    var tableId = escape(name);
    var table = builder.addTable(tableId);
    table.setDisplayName(name);
    return table;
}