Dremio REST API response changes backslash into double backslash


#1

Having a ‘\’ in a field is changing to ‘\\’ in my response from SQL API.


#2

Hi @pmo3

I was able to reproduce this behavior, please stay tuned and will get back to you on the next steps.

Note: In the below result “45\\6” is actually “45\6”

{
“rowCount”: 6,
“schema”: [
{
“name”: “dummy”,
“type”: {
“name”: “VARCHAR”
}
}
],
“rows”: [
{
“dummy”: “def”
},
{
“dummy”: “uvw”
},
{
“dummy”: “45\6”
},
{
“dummy”: “abc”
},
{
“dummy”: “xyz”
},
{
“dummy”: “12/3”
}
]
}


#3

Sure. Waiting for your response.


#4

@pmo3

That is expected JSON behavior - the \ character (backslash) is a special character in JSON so it will be escaped if its a value.