If-else condition for createaccountjson

[Mortal]

Hi,

I am working on Service account for DB based application. For this, I am writing JSON where for login name user can provide any string value. So I created a dynamic attribute for service account form and created a condition for login_name where if accounttype (will read from the create service account page) equals service account then it whatever string user will provide it will update the at login_name (dynamic attribute) else it will update the account name. I am using the following query to achieve that:

{
"createaccountqry": [
"create user ${task.accountName} login_name = '${if(ACCOUNTTYPE == 'Service Account') ? requestAccessAttributes.get("login_name") : task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
]
}

There are no details in provisioning comments as well and in logs its showing format is incorrect

2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.443323743Z stdout F 2024-07-23 07:51:32,443 [quartzScheduler_Worker-8] INFO provisoning.DBProvisioningService - End getConnection
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.443326296Z stdout F 2024-07-23 07:51:32,443 [quartzScheduler_Worker-8] DEBUG provisoning.DBProvisioningService - got SQL Connection
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.44333437Z stdout F 2024-07-23 07:51:32,443 [quartzScheduler_Worker-8] DEBUG provisoning.DBProvisioningService - Create account JSON String is {
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.443336783Z stdout F "createaccountqry": [
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.443340278Z stdout F "create user ${task.accountName} login_name = '${if(ACCOUNTTYPE == 'Service Account') ? requestAccessAttributes.get("login_name") : task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.443342514Z stdout F ]
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.4433446Z stdout F }
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470488085Z stdout F 2024-07-23 07:51:32,470 [quartzScheduler_Worker-8] ERROR provisoning.DBProvisioningService - Error occured in creating account
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470517562Z stdout F groovy.lang.GroovyRuntimeException: Failed to parse template script (your template may contain an error or be trying to use expressions not currently supported): startup failed:
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470521338Z stdout F SimpleTemplateScript36.groovy: 3: unexpected token: ? @ line 3, column 96.
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470524552Z stdout F UNTTYPE == 'Service Account') ? requestA
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470529793Z stdout F ^
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470532627Z stdout F
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.47053551Z stdout F 1 error
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470538818Z stdout F
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470541585Z stdout F at com.saviynt.utility.TemplateUtilityService$_addTemplateCheck_closure2.doCall(TemplateUtilityService.groovy:259)
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470545118Z stdout F at com.saviynt.provisoning.DBProvisioningService.createAccount(DBProvisioningService.groovy:315)
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470549819Z stdout F at com.saviynt.ecm.services.ArsTaskService.createAccountTarget(ArsTaskService.groovy:11619)
2024-07-23T13:21:33+05:30-ecm-worker----2024-07-23T07:51:32.470553372Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_whenTaskTypeIsThreeNewAccountAccess_closure50.doCall(ArsTaskHelperService.groovy:3064)

 Need help on this, thanks.

[rushikeshvartak]

{
"createaccountqry": [
"create user ${task.accountName} login_name = '${if(ACCOUNTTYPE == 'Service Account') ? login_name}
:task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
]
}

[Mortal]

@rushikeshvartak Thank you for the reply.
I used the above query but it's also giving the same error at the '?' operator

2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648507173Z stdout F 2024-07-23 09:45:29,648 [quartzScheduler_Worker-3] INFO provisoning.DBProvisioningService - End getConnection
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648509476Z stdout F 2024-07-23 09:45:29,648 [quartzScheduler_Worker-3] DEBUG provisoning.DBProvisioningService - got SQL Connection
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648519355Z stdout F 2024-07-23 09:45:29,648 [quartzScheduler_Worker-3] DEBUG provisoning.DBProvisioningService - Create account JSON String is {
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648529226Z stdout F "createaccountqry": [
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648531657Z stdout F "create user ${task.accountName} login_name = '${if(ACCOUNTTYPE == 'Service Account') ? login_name}
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648536117Z stdout F :task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648538319Z stdout F ]
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.648540394Z stdout F }
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658150731Z stdout F 2024-07-23 09:45:29,657 [quartzScheduler_Worker-3] ERROR provisoning.DBProvisioningService - Error occured in creating account
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658173758Z stdout F groovy.lang.GroovyRuntimeException: Failed to parse template script (your template may contain an error or be trying to use expressions not currently supported): startup failed:
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658177828Z stdout F SimpleTemplateScript37.groovy: 3: unexpected token: ? @ line 3, column 88.
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658180923Z stdout F UNTTYPE == 'Service Account') ? login_na
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658183612Z stdout F ^
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658186064Z stdout F
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658188867Z stdout F 1 error
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658191333Z stdout F
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658194273Z stdout F at com.saviynt.utility.TemplateUtilityService$_addTemplateCheck_closure2.doCall(TemplateUtilityService.groovy:259)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.65819687Z stdout F at com.saviynt.provisoning.DBProvisioningService.createAccount(DBProvisioningService.groovy:315)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658199729Z stdout F at com.saviynt.ecm.services.ArsTaskService.createAccountTarget(ArsTaskService.groovy:11619)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.65820242Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_whenTaskTypeIsThreeNewAccountAccess_closure50.doCall(ArsTaskHelperService.groovy:3064)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658204897Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.whenTaskTypeIsThreeNewAccountAccess(ArsTaskHelperService.groovy:3055)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658212919Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_completeAutoProvTasksUpgraded_closure1.doCall(ArsTaskHelperService.groovy:175)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.65821541Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.completeAutoProvTasksUpgraded(ArsTaskHelperService.groovy:160)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.65821808Z stdout F at MultipleProvisioningJob.execute(MultipleProvisioningJob.groovy:222)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.65822062Z stdout F at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.658223086Z stdout F at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2024-07-23T15:15:30+05:30-ecm-worker----2024-07-23T09:45:29.866632291Z stdout F 2024-07-23 09:45:29,866 [quartzScheduler_Worker-3] INFO provisoning.DBProvisioningService - End createAccountDB

[rushikeshvartak]

{
  "createaccountqry": [
    "create user ${task.accountName} login_name = ${if(ACCOUNTTYPE == 'Service Account') ? login_name : task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
  ]
}

[NM]

Try this @Mortal 

"createaccountqry": [

"create user ${task.accountName} login_name = ${if(ACCOUNTTYPE == 'Service Account') ? login_name : task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"

]

}

[Mortal]

Hi @rushikeshvartak @NM 

still getting same error and no change or any query execution on target application (Snowflake) as well

2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983416885Z stdout F 2024-07-23 10:31:27,982 [quartzScheduler_Worker-9] DEBUG provisoning.DBProvisioningService - got SQL Connection
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983418893Z stdout F 2024-07-23 10:31:27,982 [quartzScheduler_Worker-9] DEBUG provisoning.DBProvisioningService - Create account JSON String is {
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983421198Z stdout F "createaccountqry": [
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983425409Z stdout F "create user ${task.accountName} login_name = ${if(ACCOUNTTYPE == 'Service Account') ? login_name : task.accountName} display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"ledger\":\"${user.customproperty13}\", \"activity center\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles= null;"
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983427496Z stdout F ]
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:27.983429665Z stdout F }
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012565762Z stdout F 2024-07-23 10:31:28,012 [quartzScheduler_Worker-9] ERROR provisoning.DBProvisioningService - Error occured in creating account
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012579575Z stdout F groovy.lang.GroovyRuntimeException: Failed to parse template script (your template may contain an error or be trying to use expressions not currently supported): startup failed:
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012582774Z stdout F SimpleTemplateScript43.groovy: 3: unexpected token: ? @ line 3, column 91.
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.01258552Z stdout F UNTTYPE == 'Service Account') ? login_na
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012587444Z stdout F ^
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012589171Z stdout F
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012591121Z stdout F 1 error
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012592822Z stdout F
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012594695Z stdout F at com.saviynt.utility.TemplateUtilityService$_addTemplateCheck_closure2.doCall(TemplateUtilityService.groovy:259)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.01259808Z stdout F at com.saviynt.provisoning.DBProvisioningService.createAccount(DBProvisioningService.groovy:315)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012600758Z stdout F at com.saviynt.ecm.services.ArsTaskService.createAccountTarget(ArsTaskService.groovy:11619)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012603375Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_whenTaskTypeIsThreeNewAccountAccess_closure50.doCall(ArsTaskHelperService.groovy:3064)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012605228Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.whenTaskTypeIsThreeNewAccountAccess(ArsTaskHelperService.groovy:3055)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.012607126Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_completeAutoProvTasksUpgraded_closure1.doCall(ArsTaskHelperService.groovy:175)
2024-07-23T16:01:28+05:30-ecm-worker----2024-07-23T10:31:28.01260892Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.completeAutoProvTasksUpgraded(ArsTaskHelperService.groovy:160)

[rushikeshvartak]

• Sample Syntax adjust as per your needs

{
	"CreateAccountQry": 
		[
			'${if((ACCOUNTTYPE.isEmpty()))
				{
					'CREATE USER '+accountName+' IDENTIFIED BY \"'+randomPassword+'\" DEFAULT TABLESPACE '+DEFAULTTABLESPACE+' TEMPORARY TABLESPACE '+TEMPORARYTABLESPACE+' PROFILE '+PROFILE+' PASSWORD EXPIRE'
				} 
				else {
					'CREATE USER '+accountName+' IDENTIFIED BY \"'+randomPassword+'\" DEFAULT TABLESPACE '+FA_RV_DEFAULTTABLESPACE+' TEMPORARY TABLESPACE '+FA_RV_TEMPORARYTABLESPACE+' PROFILE '+FA_RV_PROFILE+' PASSWORD EXPIRE'
				 }
				}'
		]
		
}

[Mortal]

Hi @rushikeshvartak @NM 

I tried the above query as well but it didn't work. So I created another dynamic attribute and I'm trying to read it but in provisioning comments, it mentions, 

"SAV - Error while creating an account - SVC_Snowflake_CN_ServAcc-No such property: Okta_Field for class: java.lang.String"
using the following query:

{
  "createaccountqry": [
    "create user ${task.accountName} login_name = '${requestaccessattributes.Okta_Field.equals('Yes') ? requestaccessattributes.get('login_name') : task.accountName}' display_name = '${user.displayname}' first_name = '${user.firstname}' last_name = '${user.lastname}' email = '${user.email}' comment = '{\"Department Name\":\"${user.departmentname}\", \"Manager Portal ID\":\"${user.customproperty11}\", \"Activity Center\":\"${user.customproperty13}\", \"Ledger\":\"${user.customproperty14}\"}' default_role = null default_secondary_roles = null;"
  ]
}

[rushikeshvartak]

Are you storing value in accounts column ?

[Mortal]

@rushikeshvartak 
No. Do I need to store it in the accounts column? And how should I call this attribute using the attribute name or accounts column?

[rushikeshvartak]

Yes. You need to store and use attribute name

Refer https://forums.saviynt.com/t5/identity-governance/rest-connector-create-account-json-if-else-using-d...

[Mortal]

@rushikeshvartak 

I mapped the attribute to accounts customproperty60 but still getting an error. Is DB-based application having bugs if we try to use conditions in create JSON?

Error in create account - groovy.lang.MissingPropertyException: No such property: Okta_Field for class: java.lang.String| at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:50)| at org.codehaus.groovy.runtime.callsite.PojoMetaClassGetPropertySite.callGetProperty(PojoMetaClassGetPropertySite.java:43)| at SimpleTemplateScript791.run(SimpleTemplateScript791.groovy:3)| at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:165)| at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:177)| at sun.reflect.GeneratedMethodAccessor1736.invoke(Unknown Source)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:230)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53)| at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:112)| at com.saviynt.provisoning.DBProvisioningService$_createAccount_closure2.doCall(DBProvisioningService.groovy:412)| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)| at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1086)| at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:910)| at groovy.lang.Closure.call(Closure.java:411)| at groovy.lang.Closure.call(Closure.java:427)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.callClosureForMapEntry(DefaultGroovyMethods.java:3875)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:1354)| at org.codehaus.groovy.runtime.dgm$149.invoke(Unknown Source)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:271)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53)| at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)| at com.saviynt.provisoning.DBProvisioningService.createAccount(DBProvisioningService.groovy:347)| at com.saviynt.provisoning.DBProvisioningService$createAccount$5.call(Unknown Source)| at com.saviynt.ecm.services.ArsTaskService.createAccountTarget(ArsTaskService.groovy:11819)| at com.saviynt.ecm.services.ArsTaskService$createAccountTarget$21.call(Unknown Source)| at com.saviynt.ecm.services.ArsTaskHelperService$_whenTaskTypeIsThreeNewAccountAccess_closure50.doCall(ArsTaskHelperService.groovy:3078)| at sun.reflect.GeneratedMethodAccessor3945.invoke(Unknown Source)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)| at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1086)| at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:910)| at groovy.lang.Closure.call(Closure.java:411)| at groovy.lang.Closure.call(Closure.java:427)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.callClosureForMapEntry(DefaultGroovyMethods.java:3875)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:1354)| at org.codehaus.groovy.runtime.dgm$149.invoke(Unknown Source)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:271)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53)| at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)| at com.saviynt.ecm.services.ArsTaskHelperService.whenTaskTypeIsThreeNewAccountAccess(ArsTaskHelperService.groovy:3069)| at sun.reflect.GeneratedMethodAccessor4055.invoke(Unknown Source)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)| at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1086)| at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:910)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1031)| at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:910)| at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)| at com.saviynt.ecm.services.ArsTaskHelperService$_completeAutoProvTasksUpgraded_closure1.doCall(ArsTaskHelperService.groovy:175)| at sun.reflect.GeneratedMethodAccessor2992.invoke(Unknown Source)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)| at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1086)| at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1110)| at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:910)| at groovy.lang.Closure.call(Closure.java:411)| at groovy.lang.Closure.call(Closure.java:427)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:1325)| at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:1297)| at org.codehaus.groovy.runtime.dgm$148.invoke(Unknown Source)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:271)| at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53)| at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)| at com.saviynt.ecm.services.ArsTaskHelperService.completeAutoProvTasksUpgraded(ArsTaskHelperService.groovy:160)| at com.saviynt.ecm.services.ArsTaskHelperService$completeAutoProvTasksUpgraded$7.call(Unknown Source)| at MultipleProvisioningJob.execute(MultipleProvisioningJob.groovy:222)| at sun.reflect.GeneratedMethodAccessor4076.invoke(Unknown Source)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)| at java.lang.reflect.Method.invoke(Method.java:498)| at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:196)| at org.codehaus.groovy.grails.plugins.quartz.GrailsJobFactory$GrailsTaskClassJob.execute(GrailsJobFactory.java:72)| at org.quartz.core.JobRunShell.run(JobRunShell.java:199)| at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)|

[rushikeshvartak]

Try new request

[Mortal]

Hey @rushikeshvartak, I also attempted to create new requests, but they don't seem to work. Do you have any other syntax that can help us accomplish this?

[rushikeshvartak]

Share you current json