REVOKEACCESSJSON issue in DB connection

[gaurav_wagh]

Hi Team,

We have a case where we have to insert new entry in DB while revoking the access. We have prepared the below query and trying to save the connection but we are getting below error.

We don't have any where clause as its new entry.

Query :

{
"Roles" : ["insert into ABC (id,first_name,last_name,email,emp_active,company_code,role_type,type_of_request,employee_flag,status,created_by,created_at,updated_by,updated_at,batch_id,source) values (${user.username},'${user.firstname}','${user.lastname}','${user.email}',true,'${task.entitlement_valueKey.entitlement_value}','${task.entitlement_valueKey.entitlement_value}','DELETE',true,'NEW','Saviynt',current_timestamp,'Saviynt',current_timestamp,1,'My Access')" ]
}

Thanks,

Gaurav

[NM]

@gaurav_wagh add a select statement with where clause as in 2 actions you are performing see what it shows.

[gaurav_wagh]

Can you please share the sample query ?

Regards,

Gaurav

[NM]

@gaurav_wagh never encountered the same use case so don't have one .. but with the insert query

Add a second statement which would be select .. they way we know normally add multiple statement to execute 

[Raghu]

@gaurav_wagh  try below

{
"Roles" : ["insert into ABC (id,first_name,last_name,email,emp_active,company_code,role_type,type_of_request,employee_flag,status,created_by,created_at,updated_by,updated_at,batch_id,source) values (${user.id},'${user.firstname}','${user.lastname}','${user.email}',true,${task.entitlement_valueKey.id},${task.entitlement_valueKey.id},'DELETE',true,'NEW','Saviynt',current_timestamp,'Saviynt',current_timestamp,1,'My Access')" ]
}

https://docs.saviyntcloud.com/bundle/Database-v24x/page/Content/Configuring-the-Integration-for-Prov...