we are using this request VTL code.
{
"version": "2018-05-29",
"statements": [
"INSERT INTO company1.companies(name) VALUES (:name)",
"SELECT LAST_INSERT_ID() AS id, name FROM company1.companies WHERE id = LAST_INSERT_ID()"
],
"variableMap": {
":name": $util.toJson($ctx.args.name)
}
}
and
{
"version": "2018-05-29",
"statements": [
"INSERT INTO company1.companies(name) VALUES (:name)",
"SELECT id, name FROM company1.companies WHERE name= :name"
],
"variableMap": {
":name": $util.toJson($ctx.args.name)
}
}
both but we don't get response.
and response VTL code.
$util.toJson($ctx.result)
please give me suggestion