Please refer to the source code of this page for boilerplates (F12 for console).

Notes:
Completely standalone. No extra libraries required (jquery, underscore etc.).
It is recommended to add local fallback version of the library if you use it in production (click "download" on the right).
We bear no responsibility for possible reachability interruption of directly linked components, they are useful to cold start your project and set up testing.

For extended APIs concerning SharePoint and Persistence go to "theobald.ecs" (tEcs+)
Go to theobald.ecs

If you are experiencing problems with version 5 (removed jQuery prerequisite), please try version 4 (tEcs)
Go to tEcs 4

tEcs.executeXql()

Example:

{
    data: "SELECT TOP 10 MATNR, MAKTX FROM MAKT"
}

Execute XQL

tEcs.executeFunction()

Example:

{
    name: 'Z_ECS_GET_STOCK_INFO',
    data: {
        exports: {
            MATNR: '100-100'
        }
    }
}

Execute Function

tEcs.executeInScope()

Example (same for two functions):

{
    functions: [
        {
            name: "Z_PREPARE_REQ",
            data: {
                PARAMONE: "SOMEVALUE"
            }
        },
        {
            name: "Z_EXEC_REQ",
            data: function(){
                return parametersSapCheck;
            }
        }
    ]
}

Execute In Scope

Use ecs.micro, when it has been initialized:

theobald.ready(function(){
    alert(theobald.ecs.version);
});

"connection" parameter should be passed to each of the above functions!
For ECS on premise this parameter is optional and ecs.micro will be working with defaults out of the box.

var connection = {
    ecs: {
        // ECSCore model, must be "true" for ECSCore
        core: true,
        coreApiKey: "E370FB721AFA4EB2A86CC624E4B6890C",
        // serviceApplication (or "instance"). Context dependent (small/capital symbols)!
        //serviceApplication: "ec2",
        // url to ECSCore
        url: "https://yourecscore.com:8080/ecs",
        // NOTE: For the Azure Relay use postfix "WS"
        //url: "https://[namespace].servicebus.windows.net/ecs/ws"
        // NOTE: To call deployed webservices use postfix "CUSTOM"
        // url: "https://yourecscore.com:8080/ecs/custom/"
        // OR for Azure Relay:
        // url: "https://[SERVICEBUSNAME].servicebus.windows.net/ecs/ws/custom/"
        // OPTIONAL - "withMetadata" - delivers function result with SAP metadata, such as structure sizes, headers, columns.
        // withMetadata: true, // default false
    }
};

Optionally "done" and "fail" handlers could be passed to execute custom actions with result or error.

{
    connection: connection,
    done: function(data) {
        alert('Everything as planned!');
    },
    fail: function(data) {
        alert('Something broke :(');
    }
};

Full example of call executeFunction():

tEcs.executeFunction({
    connection: {
        ecs: {
            core: true,
            coreApiKey: "E370FB721AFA4EB2A86CC624E4B6890C",
            serviceApplication: "ec4",
            url: "https://ecscore.mydomain.com"
        }
    },
    data: {
        exports: {
            MATNR: '100-100'
        }
    },
    done: function(data) {
        alert('Everything as planned!');
    },
    fail: function(data) {
        alert('Something broke :(');
    },
    name: 'Z_ECS_GET_STOCKS'
});

Full example of call executeInScope():

var FUNCTION_TWO_PARAMETERS = {
    exports: {
        PARAMX: 'VALX'
    }
};

tEcs.executeInScope({
    // out of the box commit will be added after given functions
    // commit: true,
    connection: {
        ecs: {
            core: true,
            coreApiKey: "E370FB721AFA4EB2A86CC624E4B6890C",
            serviceApplication: "ec4",
            url: "https://ecscore.mydomain.com"
        }
    },
    // these "done" and "fail" will be executed when all functions are executed
    done: function(data) {
        alert('All funcitons executed!');
    },
    fail: function(data) {
        alert('Something broke :(');
    },
    functions: [
        {
            name: "FUNCTION_ONE",
            data: {
                PARAMONE: "SOMEVALUE"
            },
            // SET VALUES FOR THE NEXT FUNCTION
            done: function(data){
                // updating parameters of next function!
                FUNCTION_TWO_PARAMETERS.exports.PARAMTWO = data.imports.PARAMY;
            }
        },
        {
            name: "FUNCTION_TWO",
            // note, data is a function!
            data: function(){
                return FUNCTION_TWO_PARAMETERS;
            }
        }
    ],
});

Get SOAP XML, calling a WSD-Service from inside of SharePoint:

tEcs.callSoapService({
    //
    // REQUIRED: Name of deployed service
    serviceName: 'SAPCustomerWebService',
    //
    // OPTIONAL: can be put explicitly. If not, then '/_vti_bin/' + serviceName is used
    url: '/_vti_bin/SAPCustomerWebService.svc',
    //
    // Name of action. If not specified, tests the service connection
    actionName: 'GetCustomersByName',
    //
    // JSON of input paramters, OPTIONAL (if no input)
    data: { name: '%' },
    //
    // OPTIONAL: success handler
    done: function(data, status, xhr){ alert('COMPLETED!'); },
    //
    // OPTIONAL: error handler
    fail: function(xhr, status, thrownError){ alert('ERROR!'); },
    // OPTIONAL: will be always executed (on success AND error)
    always: function (data, statusText, errorThrown) { console.log('%o', data); },
    // OPTIONAL: direct overrides of jquery ajax
    ajax: { url: 'http://someserver.com/service.svc', contentType: 'text' //... }
});

Example:

tEcs.callSoapService({
    serviceName: 'GetPersonalDataWebService',
    actionName: 'GetPersonalData',
    data: {
        name: '%',
        surname: 'T*',
        date: '20141230'
    },
    always: function (data, statusText, errorThrown) {
        console.log('GetPersonalDataWebService/GetPersonalData: %o', data);
    }
});

tEcs.testSapConnection()

Example:

tEcs.testSapConnection({
    connection: {
        ecs: {
            core: true,
            coreApiKey: "E370FB721AFA4EB2A86CC624E4B6890C",
            serviceApplication: "ec4",
            url: "https://ecscore.mydomain.com"
        }
    }
});

tEcs.AddCredentialToSecureStore()

Example:

tEcs.AddCredentialToSecureStore({
    connection: {
        ecs: {
            coreApiKey: 'A1E2B883AC3141E29917F41CC92AE82B',
            url: 'https://myservicebus.servicebus.windows.net/ecs/ws'
        }
    },
    SecureStoreName: 'MySecureStore',
    UserOrGroup: 'MYDOMAIN\\MYUSER',
    // sap user
    Username: 'MYSAPUSER',
    // sap password
    Password: 'MYSAPPASSWORD'
});

tEcs.DeleteCredentialFromSecureStore()

Example:

tEcs.DeleteCredentialFromSecureStore({
    connection: {
        ecs: {
            coreApiKey: 'A1E2B883AC3141E29917F41CC92AE82B',
            url: 'https://myservicebus.servicebus.windows.net/ecs/ws'
        }
    },
    SecureStoreName: 'MySecureStore',
    // Secure Store user
    UserOrGroup: 'MYDOMAIN\\MYUSER'
});

tEcs.CheckCredentialInSecureStore()

Example:

tEcs.CheckCredentialInSecureStore({
    connection: {
        ecs: {
            coreApiKey: 'A1E2B883AC3141E29917F41CC92AE82B',
            url: 'https://myservicebus.servicebus.windows.net/ecs/ws'
        }
    },
    SecureStoreName: 'MySecureStore',
    // Secure Store user
    UserOrGroup: 'MYDOMAIN\\MYUSER',
    done: function(checkedOk){
        if(checkedOk){
            alert('Legit user!');
        }
    }
});

All functions return deferred. Done/Fail as parameters supported:

done: function(response){
    if (response === "OK") {
        alert('ALL GOOD!');
    }else{
        console.log(response);
    }
},
fail: function(response){
    console.log(response);
    alert(response.error.message);
}