Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/26/2024 10:23 PM - edited 05/26/2024 10:27 PM
Hi Team -
I am using multiple calls in my service-now createticketjson and seeing an issue where the ticket gets created fine with all the requirement dynamic attributes that I am passing and also evaluating the conditions, but the task still stays in 'New' state instead of 'pending provision' with the error as below.
05/26/2024 11:23 PM
requestAccessAttributes?.get('typeofaccess'
05/27/2024 03:03 AM
Tried this @rushikeshvartak .even after removing typeofaccess from the json, I still get the json parse error
05/27/2024 09:31 AM
Share current json
05/27/2024 09:39 AM
Here it is:
{
"call": [{
"name": "call1",
"connection": "userAuth",
"url": "XXXXX",
"httpMethod": "POST",
"httpParams": "${(task.source == 'REQUEST' && (task.endpoint.endpointname.equals('CYT-Azure-Devops-Project-Access') || task.endpoint.endpointname.equals('CYT-Azure-Devops-Azure-Repos')))?'{\"sysparm_quantity\":\"1\", \"variables\": {\"u_request_for\":\"'+user.firstname+' '+user.lastname+'\", \"u_email\":\"'+user.email+'\", \"u_assign_grp\":\"'+task.endpoint.customproperty6+'\", \"u_short_desc\":\"Requested for : '+user.firstname+' '+user.lastname+' \\\\nRequested by : '+requestor.firstname+' '+requestor.lastname+' \\\\nOpened by Saviynt\", \"u_desc\":\"Please take action for '+user.firstname+' '+user.lastname+' \\\\nEmail: '+user.email+ '\\\\nUser Name: '+user.username + '\\\\nApplication: '+task.endpoint.displayName + '\\\\nOrganization: '+requestAccessAttributes?.get('Organization')+((task.endpoint.endpointname.equals('CYT-Azure-Devops-Project-Access'))? '\\\\nProject : '+requestAccessAttributes?.get('project'):'') +' \\\\nType of Action: '+requestAccessAttributes?.get('action') + '\\\\nRole: '+requestAccessAttributes?.get('accessrole') + ' \\\\ncomments: '+task.requestKey.comments.replace('<span class=\"busjustformat\">','').replace('</span>','').replace('<br/>','').replace('\"','').replace('\\r\\n',' ').replace('\\n',' ').decodeHTML()+' \\\\nSaviynt Task # '+task.id+'\"}}':'{\"sysparm_quantity\":\"1\", \"variables\": {\"u_request_for\":\"'+user.firstname+' '+user.lastname+'\", \"u_email\":\"'+user.email+'\", \"u_assign_grp\":\"'+task.endpoint.customproperty6+'\", \"u_short_desc\":\"Request for Entitlement : '+allEntitlementsValues+' \\\\nRequested for : '+user.firstname+' '+user.lastname+' \\\\nOpened by Saviynt\", \"u_desc\":\"Please Provision Access to '+user.firstname+' '+user.lastname+' \\\\nEmail: '+user.email+'\\\\nUser Name: '+user.username+((task.endpoint.endpointname.equals('CYT-Signals'))? '\\\\nCountry : '+user.country:'') +' \\\\nApplication Entitlement : '+allEntitlementsValues+((task.endpoint.endpointname.equals('CYT-Bank-Portals'))? '\\\\nBank Account\/TCODE : '+requestAccessAttributes?.get('bankaccount'):'') +((task.endpoint.endpointname.equals('CYT-China-wechat-based-SCRM-system'))? '\\\\nBusiness Justification : '+requestAccessAttributes?.get('Justification'):'') +' \\\\nApproved by : '+userManager.email+' '+usermanager+' \\\\ncomments: '+task.requestKey.comments.replace('<span class=\"busjustformat\">','').replace('</span>','').replace('<br/>','').replace('\"','').replace('\\r\\n',' ').replace('\\n',' ').decodeHTML()+' \\\\nSaviynt Task # '+task.id+'\"}}'}",
"httpHeaders": {
"Authorization": "${access_token}"
},
"ticketidPath": "result.number",
"ticketStatusPath": "result.state",
"ticketStatusValue": [
"Open", "OPEN", "open"
],
"httpContentType": "application/json",
"successResponses": {
"statusCode": [
200,
201
]
}
}]
}
05/27/2024 09:43 AM
{
"call": [
{
"name": "call1",
"connection": "userAuth",
"url": "XXXXX",
"httpMethod": "POST",
"httpParams": "${(task.source == 'REQUEST' && (task.endpoint.endpointname.equals('CYT-Azure-Devops-Project-Access') || task.endpoint.endpointname.equals('CYT-Azure-Devops-Azure-Repos'))) ? '{\"sysparm_quantity\":\"1\", \"variables\": {\"u_request_for\":\"${user.firstname} ${user.lastname}\", \"u_email\":\"${user.email}\", \"u_assign_grp\":\"${task.endpoint.customproperty6}\", \"u_short_desc\":\"Requested for : ${user.firstname} ${user.lastname} \\\\nRequested by : ${requestor.firstname} ${requestor.lastname} \\\\nOpened by Saviynt\", \"u_desc\":\"Please take action for ${user.firstname} ${user.lastname} \\\\nEmail: ${user.email}\\nUser Name: ${user.username} \\nApplication: ${task.endpoint.displayName} \\nOrganization: ${requestAccessAttributes?.get('Organization')}${(task.endpoint.endpointname.equals('CYT-Azure-Devops-Project-Access')) ? ' \\nProject : ${requestAccessAttributes?.get('project')}' : ''} \\nType of Action: ${requestAccessAttributes?.get('action')} \\nRole: ${requestAccessAttributes?.get('accessrole')} \\ncomments: ${task.requestKey.comments.replace('<span class=\"busjustformat\">','').replace('</span>','').replace('<br/>','').replace('\"','').replace('\\r\\n',' ').replace('\\n',' ').decodeHTML()} \\nSaviynt Task # ${task.id}\"}}' : '{\"sysparm_quantity\":\"1\", \"variables\": {\"u_request_for\":\"${user.firstname} ${user.lastname}\", \"u_email\":\"${user.email}\", \"u_assign_grp\":\"${task.endpoint.customproperty6}\", \"u_short_desc\":\"Request for Entitlement : ${allEntitlementsValues} \\\\nRequested for : ${user.firstname} ${user.lastname} \\\\nOpened by Saviynt\", \"u_desc\":\"Please Provision Access to ${user.firstname} ${user.lastname} \\nEmail: ${user.email}\\nUser Name: ${user.username}${(task.endpoint.endpointname.equals('CYT-Signals')) ? ' \\nCountry : ${user.country}' : ''} \\nApplication Entitlement : ${allEntitlementsValues}${(task.endpoint.endpointname.equals('CYT-Bank-Portals')) ? ' \\nBank Account\/TCODE : ${requestAccessAttributes?.get('bankaccount')}' : ''}${(task.endpoint.endpointname.equals('CYT-China-wechat-based-SCRM-system')) ? ' \\nBusiness Justification : ${requestAccessAttributes?.get('Justification')}' : ''} \\nApproved by : ${userManager.email} ${usermanager} \\ncomments: ${task.requestKey.comments.replace('<span class=\"busjustformat\">','').replace('</span>','').replace('<br/>','').replace('\"','').replace('\\r\\n',' ').replace('\\n',' ').decodeHTML()} \\nSaviynt Task # ${task.id}\"}}'}",
"httpHeaders": {
"Authorization": "${access_token}"
},
"ticketidPath": "result.number",
"ticketStatusPath": "result.state",
"ticketStatusValue": ["Open", "OPEN", "open"],
"httpContentType": "application/json",
"successResponses": {"statusCode": [200, 201]}
}
]
}
05/30/2024 02:30 AM
Looks like the issue was with storing the DAs in accounts column. when that was changed it worked
05/30/2024 06:23 AM
✅👍Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.