Illegal Character in Query error: REST Connector

[LoneWolf2020]

I am receiving the following error for one of the REST based applications:

"2024-10-08T16:15:52.700+00:00","ecm-worker","rest.RestUtilService","quartzScheduler_Worker-6-ddflz","DEBUG","Got null response statusCode with erroMsg - [error:Error Illegal character in query at index 79: https://XXX.XXX.com:8888/api/v2/database/XXX/SysUserList?query={%22active%22%3A%22Y%22}&resultcolumn...]}]"
"2024-10-08T16:15:52.700+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-ddflz","ERROR","Exception in getting response in pullObjectsByRest :"
"2024-10-08T16:15:52.876+00:00","ecm-worker","","null-ddflz","","java.lang.Exception: NullResponseFromTarget at com.saviynt.provisoning.rest.RestUtilService.checkForErrorMsg(RestUtilService.groovy:1463) at

Please find the importaccountjson attached to this message for your reference. Please suggest a fix for this issue!

Thanks!

[LoneWolf2020]

Exact characters in the URL for reference: 

"url": "https://xxxxxxxxxxxx.xxx.com:8888/api/v2/database/XXXXX_TEST/SysUserList?query={%22active%22%3A%22Y%...]}"

[rushikeshvartak]

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.‼️‼️⚠️

[LoneWolf2020]

Hi @rushikeshvartak !!
Please find the curl command from postman below:

curl --location --globoff 'https://xxxxxxxxxxxx.xxx.com:8888/api/v2/database/XXXXX_TEST/SysUserList?query={%22active%22%3A%22Y%...]}' \
--header 'Authorization: ••••••'

[LoneWolf2020]

Postman Screenshot:

[LoneWolf2020 · Accepted solution]

I was able to fix the URL syntax issue. I am not facing this issue any more. Thank you!

Working URL:

https://xxxxxxxxxxxx.xxx.com:8888/api/v2/database/XXXXX_TEST/SysUserList?query=%7B%22active%22%3A%22...