Parameters

1. mode - Config name

2. id - Record Id

Example Usages

loads a record and stores it in a variable

   let record = await brixxServerApi.loadConfigRecordById("address", req.body.parameters.addressId);

See also client side api loadConfigRecordById

Parameters

1. statementName - The name of the statement

2. additionalParameters - all controls in the current config are set as paramters automatically. If you need to add additional parameters, you can use this json object to set them

3. queryOptions - (optional) a json object with options for the request

   • timeout - (optional) timeout for the SQL Request. Default is 30 seconds

   • connectionKey - (optional) a key to a custom settings entry with the connection string to an external MSSQL database

Example Usages

Update a record with parameters

   let rowsChanged = await brixxServerApi.sqlWrite("updateAddres", {
       newName: "John",
       addressId: 45,
   });

See also client side api sqlWrite

Parameters

1. statementName - The name of the statement

2. additionalParameters - all controls in the current config are set as paramters automatically. If you need to add additional parameters, you can use this json object to set them

3. queryOptions - (optional) a json object with options for the request

   • timeout - (optional) timeout for the SQL request. Default is 30 seconds

   • connectionKey - (optional) a key to a custom settings entry with the connection string to an external MSSQL database

Example Usages

Read all data without parameters

   let rowsChanged = await brixxServerApi.sqlRead("getAddresses", {}, {timeout: 90});

Read all data with parameters

   let rowsChanged = await brixxServerApi.sqlRead("getAddresses", { adrType: 1});

See also client side api sqlRead

Api Version > 0.1.30

Example 1

Send a blob object to the cloud print api

Example 2

We create a blob with create report and send it to the cloudPrint api

Example 3

Send a base64 file content to the cloudPrint api.

Parameters

1. mode - Config name

2. id - Record Id

Example Usages

Create a new Record with 2 fields

See also client side api

How to Use Server Side Functions

Preparing to use BrixxServerApi

Install from npm. This will give your project access to the BrixxServerApi.

Reference the Class BrixxServerApi from your function source.

Create an instance from BrixxServerApi to access the avialable methods.

Now the different methods from brixxServerApi can be called.

Example

Server Side Api Function List

Example 1

See also client side api

let result = await brixxApi.businessBrixx({
            functionName:"CurrencyConverter",
            methodName: "Convert",
            fromCurrencySymbol: "EUR",
            toCurrencySymbol: "USD"
        });
console.log(result);

See also client side api businessBrixx

Example 1

    await brixxServerApi.createReportPdfBlob({
            reportName: "myDemoReport",
            configName: "address",
            archive: true,
            parameters:{
                id: 45
            },
        });

See also client side api createReport