Toolkit API

The functions toolkit API is comprised of the miscellaneous utility functions. The list is flexible and can further be expanded. Currently available methods are listed below.

generate a random uuid number

  • Returns: number

As json pretty string string.

  • Parameters: obj — the obj
  • Returns: the string

As json string.

  • Parameters: obj — the obj
  • Returns: the string

Audit log object.

  • Parameters: logObject — the log object
  • Returns: the object

Audit log object.

  • Parameters:
    • parentUid
    • action — the action
    • summary — the summary
  • Returns: the object

Audit log object.

  • Parameters:
    • sourceClass — the source class
    • sourceId — the source id
    • action — the action
    • summary — the summary
  • Returns: the object

Audit log object.

  • Parameters:
    • parentUid
    • action — the action
    • summary — the summary
    • oldObject — the old object
    • newObject — the new object
  • Returns: the object

Audit log object.

  • Parameters:
    • sourceClass — the source class
    • sourceId — the source id
    • action — the action
    • summary — the summary
    • oldObject — the old object
    • newObject — the new object
  • Returns: the object

get an object from attributes

  • Parameters:
    • v
    • attrMap

  • Returns: object

Delete object.

  • Parameters:
    • className — the class name
    • id — the id
    • permanent — the permanent
  • Returns: the object

delete an object

  • Parameters:
    • className
    • id
    • permanent
    • audit

  • Returns: result

delete an object

  • Parameters:
    • className
    • id
    • permanent
    • auditMsg

  • Returns: result

Delete object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • id — the id
    • permanent — the permanent
  • Returns: the object

delete an object

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • permanent
    • audit

  • Returns: result

delete an object

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • permanent
    • auditMsg

  • Returns: result

Delete all object .

  • Parameters:
    • className — the class name
    • ids — the ids
    • permanent — the permanent
  • Returns: the object

delete all objects

  • Parameters:
    • className
    • ids
    • permanent
    • audit

  • Returns: result

delete all objects

  • Parameters:
    • className
    • ids
    • permanent
    • auditMsg

  • Returns: result

Delete all object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • ids — the ids
    • permanent — the permanent
  • Returns: the object

delete all objects

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • permanent
    • audit

  • Returns: result

delete all objects

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • permanent
    • auditMsg

  • Returns: result

Delete by query object.

  • Parameters:
    • className — the class name
    • query — the query
    • permanent — the permanent
  • Returns: the object

delete specific to a query

  • Parameters:
    • className
    • query
    • permanent
    • audit

  • Returns: result

delete by query

  • Parameters:
    • className
    • query
    • permanent
    • auditMsg

  • Returns: result

Delete by query object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — the query
    • permanent — the permanent
  • Returns: the object

delete by query

  • Parameters:
    • appName
    • dsName
    • className
    • query
    • permanent
    • audit

  • Returns: result

delete by query

  • Parameters:
    • appName
    • dsName
    • className
    • query
    • permanent
    • auditMsg

  • Returns: result

empty table

  • Parameters: className

  • Returns: result

empty table

  • Parameters:
    • className
    • auditMsg

  • Returns: result

empty table

  • Parameters:
    • appName
    • dsName
    • className

  • Returns: result

empty table

  • Parameters:
    • appName
    • dsName
    • className
    • auditMsg

  • Returns: result

generate an error result

  • Parameters: msg

  • Returns: result

generate error result

  • Parameters:
    • msg
    • code

  • Returns: results

execute function

  • Parameters:
    • functionName
    • params

  • Returns: result

execute function

  • Parameters:
    • appName
    • functionName
    • params

  • Returns: result

execute rule

  • Parameters:
    • functionName
    • params

  • Returns: result

execute rule

  • Parameters:
    • appName
    • functionName
    • params

  • Returns: result

execute remote call

  • Parameters:
    • hostName
    • command

  • Returns: result

execute remote call

  • Parameters:
    • hostName
    • command
    • async

  • Returns: result

fhir resource mapping

  • Parameters:
    • stateMap
    • mapping
    • d

  • Returns: map

finalize transaction

  • Parameters: forceCommit

From json string t.

  • Parameters:
    • <T> — the type parameter
    • json — the json
  • Returns: the string converted to a HashMap

From json string t.

  • Parameters:
    • <T> — the type parameter
    • json — the json
  • Returns: the string converted a ArrayList of HashMaps

Http get result.

  • Parameters: requestUrl — the request url
  • Returns: the result

HTTP post

  • Parameters:
    • requestUrl
    • body

  • Returns: result

HTTP post

  • Parameters:
    • requestUrl
    • body
    • headers

  • Returns: result

Invoke service result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • method — the method
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Invoke service result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • method — the method
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Invoke service result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • method — the method
    • mediaType — the media type
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
    • objectOrMediaType — the object or media type
  • Returns: the result

Invoke service result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • method — the method
    • mediaType — the media type
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
    • objectOrMediaType — the object or media type
  • Returns: the result

logging

  • Parameters: msg

logging

  • Parameters: msg

login info

  • Parameters: msg

logging warnings

  • Parameters: msg

Make audit log object object.

  • Parameters:
    • sourceClass — the source class
    • sourceId — the source id
    • action — the action
    • summary — the summary
  • Returns: the object

create audit records

  • Parameters:
    • type
    • sourceClass
    • sourceId
    • action
    • summary

  • Returns: result

Make audit log object object.

  • Parameters:
    • parentUid
    • action — the action
    • summary — the summary
  • Returns: the object

create audit records

  • Parameters:
    • type
    • parentUid
    • action
    • summary

  • Returns: result

map attributes

  • Parameters:
    • stateMap
    • attrs
    • m
    • d

map one attribute

  • Parameters:
    • stateMap
    • attrMap
    • m
    • d

Mvel logger mvel logger.

  • Returns: the mvel logger

check an ongoing task

  • Parameters: id

  • Returns: result

  • Parameters:
    • dir
    • fileName

  • Returns:

Replace path variables string.

  • Parameters:
    • url — the url
    • m — the m
  • Returns: the string

reset Auto increment

  • Parameters:
    • appName
    • dsName
    • className

  • Returns: result

run local commands

  • Parameters: argList

  • Returns: result

Save object.

  • Parameters:
    • className — the class name
    • entity — the entity
  • Returns: the object

save an object

  • Parameters:
    • className
    • entity
    • audit

  • Returns: result

save an object

  • Parameters:
    • className
    • entity
    • auditMsg

  • Returns: result

Save object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • entity — the entity
  • Returns: the object

save an object

  • Parameters:
    • appName
    • dsName
    • className
    • entity
    • audit

  • Returns: result

save an object

  • Parameters:
    • appName
    • dsName
    • className
    • entity
    • auditMsg

  • Returns: result

Save all object.

  • Parameters:
    • className — the class name
    • entities — the entities
  • Returns: the object

save all objects

  • Parameters:
    • className
    • entities
    • audit

  • Returns: result

save all objects

  • Parameters:
    • className
    • entities
    • auditMsg

  • Returns: result

Save all object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • entities — the entities
  • Returns: the object

save all objects

  • Parameters:
    • appName
    • dsName
    • className
    • entities
    • audit

  • Returns: result

save all objects

  • Parameters:
    • appName
    • dsName
    • className
    • entities
    • auditMsg

  • Returns: results

Send email object.

  • Parameters:
    • appName — the app name
    • email — the email
    • subject — the subject
    • content — the content
    • template — the template
    • fromAlias — the from alias
    • templateParams — the template params
  • Returns: the object

Service delete result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service delete result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Service delete result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service delete result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Service file get result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • pathVariables — the path variables
  • Returns: the result

Service file get result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • pathVariables — the path variables
  • Returns: the result

Service get result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
  • Returns: the result

Service get result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • pathVariables — the path variables
  • Returns: the result

Service get result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
  • Returns: the result

Service get result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • pathVariables — the path variables
  • Returns: the result

Service post result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service post result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Service post result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service post result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Service put result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service put result.

  • Parameters:
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Service put result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
  • Returns: the result

Service put result.

  • Parameters:
    • appName
    • serviceName — the service name
    • partialPath — the partial path
    • queryStr — the query str
    • body — the body
    • pathVariables — the path variables
  • Returns: the result

Signup object.

  • Parameters:
    • entity — the entity
    • authChoice — the auth choice
  • Returns: the object

success result

  • Returns: result

success result

  • Parameters: msg

  • Returns: result

success result

  • Parameters:
    • msg
    • data

  • Returns: result

time zone adjustment

  • Parameters:
    • value
    • tzStr
    • dir

  • Returns: result

Uid to class name string.

  • Parameters: uid — the uid
  • Returns: the string

Uid to id long.

  • Parameters: uid — the uid
  • Returns: the long

Uid to id str string.

  • Parameters: uid — the uid
  • Returns: the string

Update attr object.

  • Parameters:
    • className — the class name
    • ids — the ids
    • attrName — the attr name
    • value — the value
  • Returns: the object

Update attr object.

  • Parameters:
    • className — the class name
    • id — the id
    • attrName — the attr name
    • value — the value
  • Returns: the object

update attribute object

  • Parameters:
    • className
    • ids
    • attrName
    • value
    • audit

  • Returns: result

update attribute object

  • Parameters:
    • className
    • ids
    • attrName
    • value
    • auditMsg

  • Returns: result

update attribute object

  • Parameters:
    • className
    • id
    • attrName
    • value
    • audit

  • Returns: result

update attribute object

  • Parameters:
    • className
    • id
    • attrName
    • value
    • auditMsg

  • Returns: result

Update attr object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • ids — the ids
    • attrName — the attr name
    • value — the value
  • Returns: the object

Update attr object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • id — the id
    • attrName — the attr name
    • value — the value
  • Returns: the object

update attribute object

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • attrName
    • value
    • audit

  • Returns: result

update attribute object

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • attrName
    • value
    • auditMsg

  • Returns: result

update attribute object

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • attrName
    • value
    • audit

  • Returns: result

update attribute object

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • attrName
    • value
    • auditMsg

  • Returns: result

Update attr object.

  • Parameters:
    • className — the class name
    • ids — the ids
    • updateAttrs — - map of attribute names and values
  • Returns: the object

Update attr object.

  • Parameters:
    • className — the class name
    • id — the id
    • updateAttrs — - map of attribute names and values
  • Returns: the object

update attribute objects

  • Parameters:
    • className
    • ids
    • updateAttrs
    • audit

  • Returns: result

update attribute objects

  • Parameters:
    • className
    • ids
    • updateAttrs
    • auditMsg

  • Returns: result

update attribute objects

  • Parameters:
    • className
    • id
    • updateAttrs
    • audit

  • Returns: result

update attribute objects

  • Parameters:
    • className
    • id
    • updateAttrs
    • auditMsg

  • Returns: result

Update attr object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • ids — the ids
    • updateAttrs — - map of attribute names and values
  • Returns: the object

Update attr object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • id — the id
    • updateAttrs — - map of attribute names and values
  • Returns: the object

update attribute objects

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • updateAttrs
    • audit

  • Returns: result

update attribute objects

  • Parameters:
    • appName
    • dsName
    • className
    • ids
    • updateAttrs
    • auditMsg

  • Returns: result

update attribute objects

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • updateAttrs
    • audit

  • Returns: result

update attribute objects

  • Parameters:
    • appName
    • dsName
    • className
    • id
    • updateAttrs
    • auditMsg

  • Returns: result

Update attr object.

  • Parameters:
    • className — the class name
    • query — - query
    • updateAttrs — - map of attribute names and values
  • Returns: the object

update by query

  • Parameters:
    • className
    • query
    • updateAttrs
    • audit

  • Returns: result

update by query

  • Parameters:
    • className
    • query
    • updateAttrs
    • auditMsg

  • Returns: result

Update attr object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — - query
    • updateAttrs — - map of attribute names and values
  • Returns: the object

update by query

  • Parameters:
    • appName
    • dsName
    • className
    • query
    • updateAttrs
    • audit

  • Returns: result

update by query

  • Parameters:
    • appName
    • dsName
    • className
    • query
    • updateAttrs
    • auditMsg

  • Returns: result

wait in milliseconds

  • Parameters: tm

  • Returns: result

fhir resources to file

  • Parameters:
    • fileName
    • resourceType
    • className
    • where
    • orderBy
    • start
    • size

  • Returns: result

create json object

  • Parameters:
    • dir
    • fileName
    • obj

write pretty Json

  • Parameters:
    • dir
    • fileName
    • obj

get this class

  • Returns:

set the class

  • Parameters: cls

application data directory

  • Returns: directory

Gets base repo.

  • Returns: the base repo

Gets data model class.

  • Parameters: className
  • Returns: the data model class

Gets data model class.

  • Parameters:
    • appName
    • dsName
    • className
  • Returns: the data model class

Gets value of a cloud resource.

  • Parameters: resourceName
  • Returns: the resource value given its name

code values

  • Parameters:
    • stateMap
    • codeMapping
    • v

  • Returns: result

Get or create user.

  • Parameters: map — the map
  • Returns: the create user

Gets create user app object.

  • Parameters:
    • idOfUser — the id of user
    • appName — the app name
    • role — the role
  • Returns: the create user app object

current user details

  • Returns: map

current user ID

  • Returns: user ID

data iterator

  • Parameters: className

  • Returns: object

data iterator

  • Parameters:
    • className
    • sqlTemplate

  • Returns: object

data iterator for application and data source

  • Parameters:
    • sqlQuery
    • start
    • size

  • Returns: object

    Example:

    Object di = func.getDataIterator(0, 1000, "select * from gex_tbl');

    Object page

    while (di.hasPage()) {

    page = di.getPage();

    }

data iterator

  • Parameters:
    • className
    • start
    • size

  • Returns: object

data iterator

  • Parameters:
    • className
    • sqlTemplate
    • start
    • size

  • Returns: object

data iterator

  • Parameters:
    • className
    • where
    • orderBy
    • start
    • size

  • Returns: object

data iterator for application and data source

  • Parameters:

    • appName
    • dsName
    • sqlQuery
    • start
    • size — Example:

      Object di = func.getDataIterator("analytics", "applications", 0, 1000, "select * from app_tbl');

      Object page

      while (di.hasPage()) {

      page = di.getPage();

      }

  • Returns: object

data iterator for application and data source

  • Parameters:
    • appName
    • dsName
    • className
    • sqlTemplate
    • start
    • size

  • Returns: object

data iterator for application and data source

  • Parameters:
    • appName
    • dsName
    • className
    • where
    • orderBy
    • start
    • size

  • Returns: object

Gets data model repo.

  • Returns: the data model repo

returns the default folders used (dev, prd, int, stg).

  • Returns: the current runtime environment

domain files

  • Parameters: fileName

  • Returns: object

retrieve domain files

  • Parameters:
    • fileName
    • type
    • <T>

  • Returns: type object

Gets domain meta repo.

  • Returns: the domain meta repo

Gets current runtime environment (dev, prd, int, stg).

  • Returns: the current runtime environment

Gets faas repo.

  • Returns: the faas repo

Is failed result boolean.

  • Parameters: obj — the obj
  • Returns: the boolean

Gets flow repo.

  • Returns: the flow repo

Gets function repo.

  • Returns: the function repo

get ID of current user

  • Returns: ID

get ID of current user as long

  • Returns: Id

memory cache

  • Returns: object

message

  • Parameters: obj

  • Returns: object

numeric

  • Parameters: strNum

  • Returns: flag

Gets object.

  • Parameters:
    • className — the class name
    • id — the id
  • Returns: the object

Gets object.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • id — the id
  • Returns: the object

Gets object graph.

  • Parameters: ogr — the object graph request
  • Returns: the object graph

Gets object graph.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • ogr — the object graph request
  • Returns: the object graph

Gets objects by query.

  • Parameters:
    • className — the class name
    • query — the query
  • Returns: the objects by query

Gets objects by query.

  • Parameters:
    • className — the class name
    • query — the query
    • includeDeleted
  • Returns: the objects by query

Gets objects by query.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — the query
  • Returns: the objects by query

Gets objects by query.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — the query
    • includeDeleted
  • Returns: the objects by query

Gets one by query.

  • Parameters:
    • className — the class name
    • query — the query
  • Returns: the one by query

Gets one by query.

  • Parameters:
    • className — the class name
    • query — the query
    • includeDeleted
  • Returns: the one by query

Gets one by query.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — the query
  • Returns: the one by query

Gets one by query.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • query — the query
    • includeDeleted
  • Returns: the one by query

Gets org by org name.

  • Parameters: orgName — the org name
  • Returns: the org by org name

Gets org by query.

  • Parameters: orgName — the org name
  • Returns: the org by query

Gets page.

  • Parameters: dsr — the dsr
  • Returns: the page

Gets page.

  • Parameters:
    • className — the class name
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • dsr — the dsr
  • Returns: the page

Gets page.

  • Parameters:
    • className — the class name
    • whereClause — the where clause
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • className — the class name
    • sqlTemplate — the sql template
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • whereClause — the where clause
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • sqlTemplate — the sql template
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • whereClause — the where clause
    • orderBy — the order by
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • whereClause — the where clause
    • having — the having
    • groupBy — the group by
    • orderBy — the order by
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • sql — the actual sql statement
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • className — the class name
    • sql — the actual sql statement
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • sql — the actual sql statement
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page.

  • Parameters:
    • appName — the app name
    • dsName — the ds name
    • className — the class name
    • sql — the actual sql statement
    • params — the params
    • start — the start
    • size — the size
  • Returns: the page

Gets page where having group by order by.

  • Parameters:
    • className — the class name
    • whereClause — the where clause
    • having — the having
    • groupBy — the group by
    • orderBy — the order by
    • start — the start
    • size — the size
  • Returns: the page where having group by order by

Gets page where order by.

  • Parameters:
    • className — the class name
    • whereClause — the where clause
    • orderBy — the order by
    • start — the start
    • size — the size
  • Returns: the page where order by

Is result boolean.

  • Parameters: obj — the obj
  • Returns: the boolean

Is result boolean.

  • Parameters: obj — the obj
  • Returns: the boolean

Gets route repo.

  • Returns: the route repo

Gets rt url.

  • Parameters: orgName — the org name
  • Returns: the rt url

Gets function repo.

  • Returns: the rule repo

Gets security repo.

  • Returns: the security repo

Gets service repo.

  • Returns: the service repo

Is success result boolean.

  • Parameters: obj — the obj
  • Returns: the boolean

Gets user.

  • Parameters: id — the id
  • Returns: the user

Gets user by email.

  • Parameters: email — the email
  • Returns: the user by email

Gets user by query.

  • Parameters: query — the query
  • Returns: the user by query

Gets user by user id.

  • Parameters: userId — the user id
  • Returns: the user by user id

Gets view repo.

  • Returns: the view repo

export bq table data to CSV

  • Parameters:
    • filePath
    • columnNames
    • dataSetName
    • bqTableName
    • query

  • Returns: result

export bq table data to CSV

  • Parameters:
    • filePath
    • columnNames
    • dataSetName
    • bqTableName
    • query
    • functionName

  • Returns: result

export bq table data to CSV

  • Parameters:
    • filePath
    • columnNames
    • dataSetName
    • bqTableName
    • query
    • script

  • Returns: result

get all rows of CSV data file

  • Parameters: filePath

  • Returns: list of data

get all rows of CSV data file

  • Parameters:
    • filePath
    • separator

  • Returns: list of rows

transform CSV to SQL

  • Parameters:
    • filePath
    • className
    • query
    • commonAttrs

  • Returns: result

transfer CSV to SQL Server

  • Parameters:
    • filePath
    • className
    • query
    • parentId

  • Returns: result

transfer CSV to SQL Server

  • Parameters:
    • filePath
    • className
    • query
    • commonAttrs
    • functionName

  • Returns: result

transfer CSV to SQL

  • Parameters:
    • filePath
    • className
    • query
    • parentId
    • functionName

  • Returns: result

transfer CSV to SQL

  • Parameters:
    • filePath
    • className
    • query
    • commonAttrs
    • functionName
    • pageSize

  • Returns: result

transfer CSV to SQL using script

  • Parameters:
    • filePath
    • className
    • query
    • parentId
    • script

  • Returns: result

transfer CSV to SQL using script

  • Parameters:
    • filePath
    • className
    • query
    • commonAttrs
    • script
    • pageSize

  • Returns: result

transform CSV to SQL with script

  • Parameters:
    • filePath
    • className
    • query
    • parentId
    • script
    • pageSize

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • useClassSchema

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • functionName

  • Returns: result

transfer CSV with separator do SQL

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • useClassSchema

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • functionName

  • Returns: result

transfer CSV to SQL with specific separator using specific class schema

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • functionName
    • useClassSchema

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • functionName
    • pageSize

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • functionName
    • useClassSchema

  • Returns: result

transfer CSV to SQL with specific separator

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • functionName
    • pageSize
    • useClassSchema

  • Returns: result

transfer CSV to SQL with script

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • script

  • Returns: result

transfer CSV with specific separator to SQL with script

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • script
    • pageSize

  • Returns: result

transfer CSV with specific separator to SQL

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • script
    • useClassSchema

  • Returns: result

transfer CSV with separate data to SQL with specific script

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • script
    • pageSize

  • Returns: result

transfer CSV with separator to SQL script with variation

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • commonAttrs
    • script
    • pageSize
    • useClassSchema

  • Returns: result

transfer CSV to SQL with specific separator with script

  • Parameters:
    • filePath
    • separator
    • className
    • query
    • parentId
    • script
    • pageSize
    • useClassSchema

  • Returns: result

migrate from one schema to another

  • Parameters:
    • appName1
    • dsName1
    • className1
    • className2

  • Returns: result

migrate from one class to another

  • Parameters:
    • appName1
    • dsName1
    • className1
    • className2
    • mapperFunction

  • Returns: result

migrate from one data source to another data source

  • Parameters:
    • appName1
    • dsName1
    • className1
    • appName2
    • dsName2
    • className2

  • Returns:

migrate from one data source to another data source with mapper function

  • Parameters:
    • appName1
    • dsName1
    • className1
    • appName2
    • dsName2
    • className2
    • mapperFunction

  • Returns: result

migrate from one data source to another data source

  • Parameters:
    • appName1
    • dsName1
    • className1
    • appName2
    • dsName2
    • className2
    • mapperFunction
    • sql

  • Returns: result

migrate from one data source to another

  • Parameters:
    • appName1
    • dsName1
    • className1
    • appName2
    • dsName2
    • className2
    • mapperFunction
    • query
    • orderBy

  • Returns: result

export data from SQL to CSV

  • Parameters:
    • filePath
    • columnNames
    • className
    • query

  • Returns: result

export data from SQL to CSV

  • Parameters:
    • filePath
    • columnNames
    • className
    • query
    • functionName

  • Returns: the result

export data from SQL to CSV with script

  • Parameters:
    • filePath
    • columnNames
    • className
    • query
    • script

  • Returns: result

transfer text file to SQL Server

  • Parameters:
    • filePath
    • className
    • parentId

  • Returns: result

transfer text file to SQL Server

  • Parameters:
    • filePath
    • className
    • commonAttrs
    • functionName

  • Returns: result

transfer text file to SQL

  • Parameters:
    • filePath
    • className
    • parentId
    • functionName

  • Returns: result

transfer text file to SQL

  • Parameters:
    • filePath
    • className
    • commonAttrs
    • functionName
    • pageSize

  • Returns: result

transfer text file to SQL using script

  • Parameters:
    • filePath
    • className
    • parentId
    • script

  • Returns: result

transfer text file to SQL using script

  • Parameters:
    • filePath
    • className
    • commonAttrs
    • script
    • pageSize

  • Returns: result

transform text file to SQL with script

  • Parameters:
    • filePath
    • className
    • parentId
    • script
    • pageSize

  • Returns: result

get the list of BG datasets

  • Returns:

get all tables in a BQ dataset

  • Parameters: datasetName

  • Returns:

data iterator for application and data source

  • Parameters:

    • query
    • startIndex
    • pageSize — Example in Trillo Function:

      Object iter = getBigQueryIterator(query, 0, 100);

      Object page;

      while (iter.hasNext()) {

      page = iter.getPage();

      }

  • Returns: object

BQ: data iterator for application and data source

  • Parameters:
    • serviceName
    • query
    • startIndex
    • pageSize

  • Returns: object

CSV: data interator

  • Parameters:
    • fileName
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data interator

  • Parameters:
    • fileName
    • separatorChar
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data interator

  • Parameters:
    • fileName
    • columnNames
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data interator

  • Parameters:
    • fileName
    • separatorChar
    • columnNames
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data interator

  • Parameters:
    • fileName
    • columnNames
    • columnNameLine
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data interator

  • Parameters:
    • fileName
    • separatorChar
    • columnNames
    • columnNameLine
    • query
    • startIndex
    • pageSize

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • fl

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • columnNames

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • separatorChar
    • fl

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • separatorChar
    • columnNames

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • separatorChar
    • fl
    • columnNameLine

  • Returns:

CSV: data writer

  • Parameters:
    • fileName
    • separatorChar
    • columnNames
    • columnNameLine

  • Returns:

get the file path

  • Parameters: fileId

  • Returns: path

get the folder path

  • Parameters: folderId

  • Returns: result

get the script

  • Parameters: functionName

  • Returns: result

BQ: data get table handle

  • Parameters:
    • datasetName
    • tableName

  • Returns: