You can download the ready-to-use client for Java using the "Download now" link below or install the package from the public repository. Using the package will let you keep the client up-to-date. Full source code is available at GitHub.
Download and review source code of Active Query Builder Web API Client for Java on GitHub
Source on GithubActiveQueryBuilderApi api = new ActiveQueryBuilderApi();
Transform transform = new Transform(); transform.setGuid("9dbd355e-360e-430e-9cca-df6dd8b6d8d1"); //Metadata Guid from dashboard transform.setSql("select id, name from Person"); //Initial sql query
Totals max = new Totals(); max.setField("id"); max.setAggregate(Totals.AggregateEnum.MAX); Totals min = new Totals(); min.setField("id"); min.setAggregate(Totals.AggregateEnum.MIN); transform.setTotals(Arrays.asList(max, min));
Pagination page = new Pagination(); page.setSkip(2); page.setTake(3); transform.setPagination(page);
Sorting asc = new Sorting(); asc.setField("id"); asc.setOrder(Sorting.OrderEnum.ASC); Sorting desc = new Sorting(); desc.setField("name"); desc.setOrder(Sorting.OrderEnum.DESC); transform.setSortings(Arrays.asList(asc, desc));
ConditionGroup filter = new ConditionGroup(); Condition condition = new Condition(); condition.setField("id"); condition.setConditionOperator(Condition.ConditionOperatorEnum.BETWEEN); condition.setValues(Arrays.asList("1", "5")); filter.setConditions(Arrays.asList(condition)); transform.setFilter(filter);
HiddenColumn column = new HiddenColumn(); column.setField("name"); transform.setHiddenColumns(Arrays.asList(column));
TransformResult result = api.transformSQLPost(transform); String transformedSql = result.getSql();
SqlQuery query = new SqlQuery(); query.setGuid("9dbd355e-360e-430e-9cca-df6dd8b6d8d1"); //Metadata Guid from dashboard query.setText("select id, name from Person"); //Initial sql query List<QueryColumn> columns = api.getQueryColumnsPost(query);