Passing single quotes as an actual value in rest jsom

[NM]

Hi Team, has anyone passed single quotes as an actual value in rest json?

I tried using backslash but didn't work.

Thanks

[rushikeshvartak]

Share json

[NM]

@rushikeshvartak we need to pass a script in http param

Param looks like.

Script:select username, ID from user wher username ='name' and we need to add name in single quotes

[rushikeshvartak]

Add blackslash

[NM]

@rushikeshvartak tried that .. couldn't save the connection.

[rushikeshvartak]

Share error logs / json

[NM]

@rushikeshvartak here is the json not working with backslash

{
"name": "call1",
"connection": "acctAuth",
"url": "",
"httpMethod": "POST",
"httpContentType": "application/json",
"httpParams": "${\"Script\":\"Select Username, ID, status, email, displayname, sourceds from User where upper(username) = upper('+'\''+abc+'\''+') ORDER BY Username\"'}",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"successResponses": {
"statusCode": [
200
]
},
"unsuccessResponses": {
"statusCode": [
404,
401,
400
]
}
}

[rushikeshvartak]

"httpParams": "${\"Script\":\"Select Username, ID, status, email, displayname, sourceds from User where upper(username) = upper('\\\\'abc\\\\') ORDER BY Username\"}",

[NM]

@rushikeshvartak need to add single quotes in json

[rushikeshvartak]

Its added in above logic

[NM]

@rushikeshvartak it is adding backslash instead of single quote

\"Script\":\"Select Username, ID, status from user where upper(username) = upper(\\abc\\)

abc is dynamic value which we are picking from task account name

[rushikeshvartak]

"httpParams": "{\"Script\":\"Select Username, ID, status, email, displayname, sourceds from User where upper(username) = upper('\" + abc + \"') ORDER BY Username\"}"

[NM]

@rushikeshvartak , i have already tried above...

i was able to make it work. will share the working one just testing few scenarios.

Thank you!!

[NM · Accepted solution]

working Json

"httpParams": "{\"Script\":\"Select Username, ID, status, email, displayname, sourceds from User where upper(username) = upper('\\\" + abc + '\\\''+') ORDER BY Username\"}

Thank you so much @rushikeshvartak for always helping out.