# webapi-activequerybuilder

> Active_Query_Builder_Web_API_lets_create_analyze_and_modify_SQL_queries_for_different_database_servers_using_RESTful_HTTP_requests__Transforms_the_given_SQL_query_according_to_the_commands_provided_in_this_request__You_can_add_constraints_hide_some_of_the

Latest version **1.1.2** (published 2016-08-05) · Apache-2.0 license · 0 weekly downloads

## Install

```sh
npm install webapi-activequerybuilder
pnpm add webapi-activequerybuilder
yarn add webapi-activequerybuilder
bun add webapi-activequerybuilder
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.1.2 |
| Published | 2016-08-05 |
| First published | 2016-05-12 |
| Weekly downloads | 0 |
| License | Apache-2.0 |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 1 |
| Known vulnerabilities | 0 (+1 in 1 direct dependencies) |
| Install scripts | no |
| Maintainers | activedbsoft |

## Links

- npm: https://www.npmjs.com/package/webapi-activequerybuilder
- npm.io page: https://npm.io/package/webapi-activequerybuilder

## Dependencies (1)

- [superagent](https://npm.io/package/superagent.md) 1.7.1

## Recent versions

- 1.1.2 (latest) — 2016-08-05
- 1.1.1 — 2016-08-03
- 1.0.2 — 2016-07-07
- 1.0.1 — 2016-05-14
- 1.0.0 — 2016-05-12

## README

# webapi-activequerybuilder

WebapiActivequerybuilder - JavaScript client for webapi-activequerybuilder
Active Query Builder Web API lets create, analyze and modify SQL queries for different database servers using RESTful HTTP requests. Transforms the given SQL query according to the commands provided in this request. You can add constraints, hide some of the resultset columns, chang sorting or limit rows of resultset. All transformations are performed according to the SQL syntax and database schema provided through the registered account at https://webapi.activequerybuilder.com/ identified by the given unique identifier. All transformations can only lead to reorganization or limitation of the resultset data. This means that it's impossible to get transformed SQL that reveals any other data than the data retutned by original query.

## Installation

### For [Node.js](https://nodejs.org/)

#### npm

```shell
npm install webapi-activequerybuilder --save
```

### For browser

The library also works in the browser environment via npm and [browserify](http://browserify.org/). 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):

```shell
browserify main.js > bundle.js
```

Then include *bundle.js* in the HTML pages.

## Getting Started

Please follow the [installation](#installation) instruction and execute the following JS code:

```javascript
var WebapiActivequerybuilder = require('webapi-activequerybuilder');

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**](docs/ActiveQueryBuilderApi.md#getQueryColumnsPost) | **POST** /getQueryColumns | 
*WebapiActivequerybuilder.ActiveQueryBuilderApi* | [**transformSQLPost**](docs/ActiveQueryBuilderApi.md#transformSQLPost) | **POST** /transformSQL | 


## Documentation for Models

 - [WebapiActivequerybuilder.Condition](docs/Condition.md)
 - [WebapiActivequerybuilder.ConditionGroup](docs/ConditionGroup.md)
 - [WebapiActivequerybuilder.HiddenColumn](docs/HiddenColumn.md)
 - [WebapiActivequerybuilder.Pagination](docs/Pagination.md)
 - [WebapiActivequerybuilder.QueryColumn](docs/QueryColumn.md)
 - [WebapiActivequerybuilder.Sorting](docs/Sorting.md)
 - [WebapiActivequerybuilder.SqlQuery](docs/SqlQuery.md)
 - [WebapiActivequerybuilder.Totals](docs/Totals.md)
 - [WebapiActivequerybuilder.Transform](docs/Transform.md)
 - [WebapiActivequerybuilder.TransformResult](docs/TransformResult.md)


## Documentation for Authorization

 All endpoints do not require authorization.

---
_Source: https://npm.io/package/webapi-activequerybuilder · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._