Is there a solution for passing the single quote within the HTTP request body? I am trying to achieve the below but am getting %27 instead of the single quotes
What I am trying to send:
- select FIELD from TABLE where FIELD like 'ABC%'
What is being passed to my endpoint:
- select FIELD from TABLE where FIELD like %27ABC%%27
Strange, this is not happening for me (see pic below). Can you share more details how the SQL string is being configured in your flow? If the SQL originates from a handlebars expression, then be sure to use {{{ }}} vs {{ }} to instruct the handlebars engine not to escape any chars.
Very strange. I attempted the same SQL as below on a different endpoint and the single quotes were correct. I will review the settings for this endpoint and see if I can identify where the issue is.
