File seperator '\' doubles in SP body

[SkiDK]

Hi all,

I have a flow that calls a stored procedure. One of the input parameters is the user like next "company\first.last"

When I run the stored procedure, it get result:

However when I call the stored procedure from Flow with the exact same parameter values, then I get nothing. I think the problem is with the '\' character, aka file separator. The inputted value in the connector is correct with one '\', but in the body suddenly is shown as a double '\\'. Thus the database will not find any records because it's a wrong value.

Is there a way to pass this clean, so that the '\' does not doubles?

Many thanks,

Ski

[SkiDK · Accepted solution]

Found the answer: https://www.freeformatter.com/json-escape.html#ad-output

'\' is one of the characters that are reserved in JSON, thus meaning if it's for a string they will be changed (or escaped) so to not disrupt the JSON structure. To use a single '\' in a string then, you need to reverse (or unescape) by writing '\\'.

Thus in my flow I need to add as input paramater 'company\\first.last' and the stored procedure will receive as 'company\first.last'.