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
Solved! Go to 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'.
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'.