Rest API Import User JSON URL issue

[Smitakkhi]

I am trying to import user by configuring the below import user json-

{
"connection": "userAuth",
"showResponse": true,
"successResponses": {
"statusCode": [
200,
201,
202,
203,
204,
205
]
},
"url": "https://....../person?lastname=${user.lastname}&firstname=${users.firstname}&birthdate=1999-10-20&email=${users.email}",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Content-Type": "application/json",
"Authorization": "${refresh_token}"
},
"userResponsePath": "Persons",
"colsToPropsMap": {
"customproperty2": "id~#~char",
"firstname": "firstname~#~char",
"lastname": "lastname~#~char",
"email": "email~#~char",
"customproperty21": "birthdate~#~date"
}
}

But I am getting below error

Got Webservice API Response: [error:Error Illegal character in query at index 70: https:// .../person?lastname=${user.lastname}&firstname=${user.firstname}&birthdate=1999-10-20&email=${user.email}]

[This message has been edited by moderator to disable url hyperlink]

[Raghu]

@Smitakkhi  can you modify the url please and change below

user.firstname and user.email instead of users. and try

"url": "https://....../person?lastname=${user.lastname}&firstname=${users.firstname}&birthdate=1999-10-20&email=${users.email}",

[Smitakkhi]

I have tried with user and users both . It is not working .

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/multiple-calls-illegal-character-when-using-respon...

[Smitakkhi]

I have tried using url as "url": "https://....../person?lastname=${user.lastname}&firstname=\\${users.firstname}&birthdate=1999-10-20&email=\\${users.email}", but still it is not accepting.

[rushikeshvartak]

Please share logs in txt file

[Smitakkhi]

Hi,

I have pasted some part of the logs -

Error while getting User Import response for url- https://...person?lastname=${user.lastname}&firstname=${user.firstname}&email=${user.email}&birthdat... is: null

2024-05-08T14:09:12+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-4-DEBUG-Getting response statusCode null, so failing User Import Job

As you can see it still is not dynamically picking up user information . Its not able to identify the $ which is used to fetch the user information from Saviynt.

[This message has been edited by moderator to edit URL]