webapi-active-query-builder

webapi-active-query-builder

Active Query Builder Web API lets create, analyze and modify SQL queries for different database servers using RESTful HTTP requests to a cloud-based service. It requires SQL execution context (information about database schema and used database server) to be stored under the registered account at https://webapi.activequerybuilder.com/.

Installation

For Node.js

npm

npm install webapi-active-query-builder --save

For browser

The library also works in the browser environment via npm and browserify. After following the above steps with Node.js and installing browserify with npm install -g browserify, perform the following (assuming main.js is your entry file):

browserify main.js > bundle.js

Then include bundle.js in the HTML pages.

Getting Started

Please follow the installation instruction and execute the following JS code:

var WebapiActiveQueryBuilder = require('webapi-active-query-builder');

var api = new WebapiActiveQueryBuilder.ActiveQueryBuilderApi()

var query = new WebapiActiveQueryBuilder.SqlQuery(); // {SqlQuery} Information about SQL query and it's context.

api.getQueryColumnsPost(query).then(function(data) {
  console.log('API called successfully. Returned data: ' + data);
}, function(error) {
  console.error(error);
});

Documentation for API Endpoints

All URIs are relative to https://webapi.activequerybuilder.com

Class	Method	HTTP request	Description
WebapiActiveQueryBuilder.ActiveQueryBuilderApi	[getQueryColumnsPost]	POST /getQueryColumns
WebapiActiveQueryBuilder.ActiveQueryBuilderApi	[transformSQLPost]	POST /transformSQL

Documentation for Models

• WebapiActiveQueryBuilder.Condition
• WebapiActiveQueryBuilder.ConditionGroup
• WebapiActiveQueryBuilder.HiddenColumn
• WebapiActiveQueryBuilder.Pagination
• WebapiActiveQueryBuilder.QueryColumn
• WebapiActiveQueryBuilder.Sorting
• WebapiActiveQueryBuilder.SqlQuery
• WebapiActiveQueryBuilder.Totals
• WebapiActiveQueryBuilder.Transform
• WebapiActiveQueryBuilder.TransformResult

Documentation for Authorization

All endpoints do not require authorization.

Source code

Full source code of all clients for Active Query Builder Web API is available on GitHub. Get the source code of javascript here: https://github.com/ActiveDbSoft/webapi-active-query-builder-javascript