# WebapiActivequerybuilder.ActiveQueryBuilderApi

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

Method | HTTP request | Description
------------- | ------------- | -------------
[**getQueryColumnsPost**](ActiveQueryBuilderApi.md#getQueryColumnsPost) | **POST** /getQueryColumns | 
[**transformSQLPost**](ActiveQueryBuilderApi.md#transformSQLPost) | **POST** /transformSQL | 


<a name="getQueryColumnsPost"></a>
# **getQueryColumnsPost**
> [QueryColumn] getQueryColumnsPost(query)



Returns list of columns for the given SQL query executed in particular context provided through the registered account at https://webapi.activequerybuilder.com/ identified by the given unique identifier.

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

var apiInstance = new WebapiActivequerybuilder.ActiveQueryBuilderApi();

var query = new WebapiActivequerybuilder.SqlQuery(); // SqlQuery | Information about SQL query and it's context.

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

```

### Parameters

Name | Type | Description  | Notes
------------- | ------------- | ------------- | -------------
 **query** | [**SqlQuery**](SqlQuery.md)| Information about SQL query and it&#39;s context. | 

### Return type

[**[QueryColumn]**](QueryColumn.md)

### Authorization

No authorization required

### HTTP request headers

 - **Content-Type**: application/json, text/xml
 - **Accept**: application/json, text/html

<a name="transformSQLPost"></a>
# **transformSQLPost**
> TransformResult transformSQLPost(transform)



Transforms the given SQL query according to the commands provided in this request. You can add constraints, hide some of the resultset columns, change 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&#39;s impossible to get transformed SQL that reveals any other data than the data retutned by original query.

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

var apiInstance = new WebapiActivequerybuilder.ActiveQueryBuilderApi();

var transform = new WebapiActivequerybuilder.Transform(); // Transform | SQL transformation parameters and commands.

apiInstance.transformSQLPost(transform).then(function(data) {
  console.log('API called successfully. Returned data: ' + data);
}, function(error) {
  console.error(error);
});

```

### Parameters

Name | Type | Description  | Notes
------------- | ------------- | ------------- | -------------
 **transform** | [**Transform**](Transform.md)| SQL transformation parameters and commands. | 

### Return type

[**TransformResult**](TransformResult.md)

### Authorization

No authorization required

### HTTP request headers

 - **Content-Type**: application/json, text/xml
 - **Accept**: application/json, text/html