Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/22/2024 06:25 AM - last edited on 07/23/2024 02:35 AM by Sunil
Hi,
We are trying to configure importaccountentJSON for REST connector. However, we get stopped by this kind of error constantly. We are not able to import any account information. What could cause these? Error message
2024-07-22T15:41:07+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-8-q462w-DEBUG-Got null response statusCode with erroMsg - [error:Error Illegal character in query at index 96: https://test-it-ops-abc.cdf.abc.net/services/search/jobs/export?search=| inputlookup azure_ad_signin_logs.csv&output_mode=json&preview=false
Tried %7C in place of pipe(|) but getting the same error.
{
"accountParams":{},
"entitlementParams":{
"processingType":"SequentialAndIterative",
"entTypes":{
"Account Logs":{
"entTypeOrder":0,
"call":{
"call1":{
"connection":"acctAuth",
"callOrder":0,
"stageNumber":0,
"http":{
"httpHeaders":{
"Authorization":"${access_token}",
"Accept":"application/json"
},
"url":"https://test-it-ops-abc.cdf.abc.net/services/search/jobs/export?search=| inputlookup azure_ad_signin_logs.csv&output_mode=json&preview=false",
"httpContentType":"application/json",
"httpMethod":"GET"
},
"statusConfig":{
"active":"A",
"inactive":"I"
},
"listField":"result",
"keyField":"entitlementID",
"colsToPropsMap":{
"entitlementID":"mail~#~char",
"entitlement_value":"mail~#~char",
},
"disableDeletedEntitlements":false
}
}
}
}
},
"acctEntParams":{
"processingType":"acctToEntMapping"
}
}
Thanks in Advance
[This message has been edited by moderator to disable URL hyperlink]
07/22/2024 06:28 AM
Hi @sk , try backslash
07/22/2024 06:30 AM
Hi @NM , thanks for the response. I have tried by adding backslash front of pipe symbol but didn't work
07/22/2024 09:09 AM
07/23/2024 12:28 AM
Hi @rushikeshvartak , tried but still getting the null response from target
07/23/2024 12:30 AM
@sk , share error logs
07/23/2024 12:50 AM
@NM / @rushikeshvartak please find the logs
07/23/2024 12:58 AM - edited 07/23/2024 12:58 AM
Hi @sk , it seems issue related to SSL certificate.
Did application team provide you with an certificate?
07/23/2024 01:20 AM
No, we have checked with application team and they don't have any certificate
07/23/2024 03:50 AM
Does provisioning / test connection is working ?
07/23/2024 04:58 AM
Hi @rushikeshvartak / @NM , the certificate is resolved and job is also getting success, but entitlements are not imported to saviynt.
below json {
"accountParams":{},
"entitlementParams":{
"processingType":"SequentialAndIterative",
"entTypes":{
"Account Logs":{
"entTypeOrder":0,
"call":{
"call1":{
"connection":"acctAuth",
"callOrder":0,
"stageNumber":0,
"http":{
"httpHeaders":{
"Authorization":"${access_token}",
"Accept":"application/json"
},
"url":"https://test-it-ops-abc.cdf.abc.net/services/search/jobs/export?search=| inputlookup azure_ad_signin_logs.csv&output_mode=json&preview=false",
"httpContentType":"application/json",
"httpMethod":"GET"
},
"statusConfig":{
"active":"A",
"inactive":"I"
},
"listField":"result",
"keyField":"entitlementID",
"colsToPropsMap":{
"entitlementID":"mail~#~char",
"entitlement_value":"mail~#~char",
},
"disableDeletedEntitlements":false
}
}
}
}
},
"acctEntParams":{
"processingType":"acctToEntMapping"
}
}
Let me know If I am missing anything
Below are logs
07/23/2024 04:59 AM
Hi @sk , did you upload the certificate? How did it get resolved?
07/23/2024 05:12 AM
@NM , Yes uploaded the certificate
07/23/2024 05:17 AM
@sk above logs doesn't have all the details ..share again after running access import
07/23/2024 05:20 AM
Please share postman screenshot and curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]
⚠️‼️‼️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.‼️‼️⚠️
07/23/2024 05:28 AM
@rushikeshvartak , Please find below
the curl --location 'https://test-it-ops-abc.cdf.abc.net/services/search/jobs/export?search=| inputlookup azure_ad_signin_logs.csv&output_mode=json&preview=false' \
--header 'Authorization: Basic axaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'