Escaping single quotes in Dataflow Expression Builder does not work as documented

[gbraven-dev]

I am trying to set the body of a REST source Dataset with a POST operation. The body includes single quotes (it is actually an OData based protocol using single quotes to enclose entity set ID's). However the dataflow expression builder will not let me escape these single quotes by using two single quotes as described in the documentation. In fact if I just copy the example of single quote escaping from the documentation into the expression builder it interactively says it cannot be parsed.

Example: concat('Baba', '''s ', 'book store')

From the image you can see it is underlined as an error.

Is there a way to escape single quotes in the REST dataset body for a POST request? and/or is there possibly a way to get it to not treat the body as an expression and just let me paste in the actual body vs having to create a string using the expressions builder?

my current work around is to use the char() function to insert the single quotes into the string.

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: 76e31411-f1a2-710b-94c0-39acf9e7314b
• Version Independent ID: d5cefffe-dee0-2d2e-f3cb-8eefd5d40d17
• Content: Expression and functions - Azure Data Factory & Azure Synapse
• Content Source: articles/data-factory/control-flow-expression-language-functions.md
• Service: data-factory
• Sub-service: orchestration
• GitHub Login: @kromerm
• Microsoft Alias: makromer

[PesalaPavan]

@gbraven-dev Thanks for your feedback! We will investigate and update as appropriate.

[Naveenommi-MSFT]

@gbraven-dev Thank you for bringing this to our attention. I've delegated this to content author @kromerm, who will review it and offer their insightful opinions.

[Naveenommi-MSFT]

@kromerm Could you please review add comments on this, update as appropriate.