Escaping characters in T-SQL OPENJSON queries Escaping characters in T-SQL OPENJSON queries json json

Escaping characters in T-SQL OPENJSON queries


Adding double quotes around the field name seems to work

SELECT    *FROM    OPENJSON(JSON_QUERY(@jsonData,'$.insertions'))WITH    (uuid UNIQUEIDENTIFIER '$.id',    modified DATETIME '$."last-modified"',    Label NVARCHAR(128) '$.label'    )