You can translate the question and the replies:

Not able to escape special character in post body

Hello, I am trying to pass this expression: \{ ^ExecuteIfIsNotNull("\"'"customerId\"'" : "\"", @CID, "\", " ,"\"'"customerId\"'" :null, "), ^ExecuteIfIsNotNull("\"'"employeeId\"'" : "\"", @EID, "\", " ,"\"'"employeeId\"'" :null, "), ^ExecuteIfIsNotNull("\"'"productId\"'" : "\"", @PID, "\", " ,"\"'"productId\"'" :null, ") \} To a Post body of a JSON data source, but I keeping getting this error. Unable to establish connection: Error obtaining interpolation variables from the Post Body. Note that you have to escape the characters '@', '{' and '}' with the character '\' and the character '\' with itself (e.g. '\\'). If the body of the request is loaded with Load file, the Tool escapes these characters automatically. I can't seem to escape the special characters. Can anyone help? Thank you
user
25-06-2021 06:34:50 -0400

1 Answer

Hi, I would suggest verifying if you have completed the steps here: [Error creating JSON data source with "POST Body" parameters](https://community.denodo.com/kb/en/view/document/Error%20creating%20JSON%20data%20source%20with%20%22Post%20Body%22%20parameters) Additionally, the thread below may be useful to grasp the idea for what you want to do: [Execution Context of a Query and Interpolation Strings](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/advanced_characteristics/execution_context_of_a_query_and_interpolation_strings/execution_context_of_a_query_and_interpolation_strings) [IGNORE NULLS](https://community.denodo.com/answers/question/details?questionId=90670000000XdBnAAK&title=IGNORE+NULLS) Hope this helps!
Denodo Team
28-06-2021 22:52:32 -0400
You must sign in to add an answer. If you do not have an account, you can register here