Hey, I'm currently working on a copilot project. I'm using an FX formula to concatenate multiple strings and variables in order to generate the full payload that I need for a POST request in JSON format. The issue I'm encountering is that when two quotation marks are included, Copilot automatically changes them from regular quotes (") to smart quotes (“”), which is not valid in JSON. If I hardcode the entire payload, like using "123" instead of a variable, the response is correct, but that's not a viable solution since I need to use a dynamic value for the CustomerID.
I tried many work arounds like
- using Char(34) instead of "
- Using Replace or Concatenate Function
- Split up the strings and combine them later on
but as soon as there are two quotation marks, they get switched to “ .
If I just use one ", it works fine and don't get changed to “. Like Char(34) & Topic.CustomerID turns to "123
Example:
Lets say our variable is called CustomerID
The formula I'm using: Char(34) & Topic.CustomerID & Char(34)
The output I need: "123"
The Output I get: “asdfhsfd”
Is there any option to turn off these smart quotes in Copilot or do you know any other workaround which might work?
Looking forward to hear from you
Philip
2
Share
Report
All responses (
Answers (
