Common Script Examples

import groovy.sql.Sql;
def query = 'SELECT "Description" FROM "SCHEMA"."TABLE_1"'
Sql sql = new Sql(taskStageHook.connection.jdbcConnection)
sql.eachRow(query, {
    println("Output option 1: ${it.getString(1)}")
    println("Output option 2: ${it[0]}")
    println("Output option 3: ${it.Description}")
})

importPackage(java.sql);
var query = 'SELECT "Description" FROM "SCHEMA"."TABLE_1"';
var prepareStatement = taskStageHook.myConnection.jdbcConnection.prepareStatement(query);
var resultSet = prepareStatement.executeQuery();
while(resultSet.next()) {
    print("Output option 1: " + resultSet.getString(1));
    print("Output option 2: " + resultSet.getString("Description"));
}

resultSet.close();
prepareStatement.close();

import groovy.json.JsonSlurper
import org.springframework.http.HttpHeaders
import org.springframework.http.HttpEntity
import org.springframework.http.HttpMethod
import org.springframework.web.client.RestTemplate

def body = restCall("https://api.genderize.io/?name=john", "GET", null,
       [
           "Content-Type": "application/json",
           "Accept": "application/json",
       ]
    )
 print(body)
 var result = new JsonSlurper().parseText(body)
 print("The name  ${result.name} is with a probability of ${result.probability} of gender ${result.gender}")


def restCall(url, method, payload, headersMap) {

    def headers = new HttpHeaders()
    headersMap.each { entry ->
        headers.set(entry.key, entry.value)
    }

    def entity = new HttpEntity(payload, headers)
    println("Call REST Endpoint $url method: $method")

    def restTemplate = buildRestTemplate()
    def response = restTemplate.exchange(url, HttpMethod.valueOf(method), entity, String.class)

    return response.getBody()
}

def buildRestTemplate() {
    return new RestTemplate()
}

importClass(org.springframework.http.HttpHeaders)
importClass(org.springframework.http.HttpEntity)
importClass(org.springframework.http.HttpMethod)
importClass(org.springframework.web.client.RestTemplate)

var body = restCall("https://api.genderize.io/?name=john", "GET", null,
            {
                "Content-Type": "application/json",
                "Accept": "application/json",
            }
        );
print("Raw REST result:" + body);
var result = JSON.parse(body);
print("The name " + result.name + " is with a probability of " + result.probability + " of gender " + result.gender);

function restCall(url, method, payload, headersMap) {
    var headers = new HttpHeaders()

    for(var key in headersMap) {
        headers.set(key, headersMap[key]);
    }
    var entity = new HttpEntity(payload, headers)
    print("Call REST Endpoint " + url + " with method: " + method)

    var restTemplate = buildRestTemplate();
    var response = restTemplate.exchange(url, HttpMethod.valueOf(method), entity, Packages.java.lang.String.class)

    return response.getBody()
}

function buildRestTemplate() {
    return new RestTemplate();
}