webapi.activequerybuilder

Maven users

Add this dependency to your project's POM:

<dependency>
<groupId>webapi.activequerybuilder</groupId>
<artifactId>webapi.activequerybuilder</artifactId>
<version>1.1.2</version>
<scope>compile</scope>
</dependency>

Gradle users

Add this dependency to your project's build file:

compile "webapi.activequerybuilder:webapi.activequerybuilder:1.1.2"

Others

Manually install the following JARs:

• webapi.activequerybuilder-1.1.2.jar
• lib/*.jar

Getting Started

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

importwebapi.activequerybuilder.*;
importwebapi.activequerybuilder.auth.*;
importwebapi.activequerybuilder.model.*;
importwebapi.activequerybuilder.api.ActiveQueryBuilderApi;
importjava.io.File;
importjava.util.*;
publicclassActiveQueryBuilderApiExample {
publicstaticvoidmain(String[] args) {
StringmetadataGuid = "b3207f4f-b1f4-4dc2-979b-7724ed2d0221";
Stringsql = "Select customer_id, first_name From customer";
ActiveQueryBuilderApiapiInstance = newActiveQueryBuilderApi();
SqlQueryquery = newSqlQuery(); // SqlQuery | Information about SQL query and it's context.query.setGuid(metadataGuid);
query.setText(sql);
List<QueryColumn> columns = apiInstance.getQueryColumnsPost(query);
System.out.println(columns);
Transformtransform = newTransform();
transform.setGuid(metadataGuid);
transform.setSql(sql);
ConditionGroupfilter = newConditionGroup();
Conditioncondition = newCondition();
condition.setField("customer_id");
condition.setConditionOperator(Condition.ConditionOperatorEnum.GREATER);
condition.setValues(Arrays.asList("10"));
filter.setConditions(Arrays.asList(condition));
Paginationpage = newPagination();
page.setSkip(2);
page.setTake(3);
Sortingorder = newSorting();
order.setField("customer_id");
order.setOrder(Sorting.OrderEnum.ASC);
transform.setFilter(filter);
transform.setPagination(page);
transform.setSortings(Arrays.asList(order));
TransformResultresult = api.transformSQLPost(transform);
System.out.println(result);
}
}

Documentation for API Endpoints

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

Class	Method	HTTP request	Description
ActiveQueryBuilderApi	getQueryColumnsPost	POST /getQueryColumns
ActiveQueryBuilderApi	transformSQLPost	POST /transformSQL

Documentation for Models

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

Documentation for Authorization

All endpoints do not require authorization. Authentication schemes defined for the API:

Recommendation

It's recommended to create an instance of ApiClient per thread in a multithreaded environment to avoid any potential issue.

Author

support@activedbsoft.com