JSON Problem

Now we have a problem with a JSON that adds new rows in a table

image

The JSON is:

{
  "Action": "Add",
"Properties": {
      "Locale": "es-AR",
      "Location": "47.623098, -122.330184",
      "Timezone": "Pacific Standard Time",
      "RunAsUserEmail": "email@gmail.com"
   }
,
  "Rows": [
<<START:SELECT(dbo.Solicitud_Alta_CCO1[ID];[ID_Sol_Cli]=[_THISROW-1].[ID];TRUE)>>
    {
"Empresa": "<<[_THISROW-1].[Empresa]>>", 
"Cliente": "<<[_THISROW-1].[Cliente]>>",
"Nro_Cliente": "<<SUBSTITUTE([_THISROW-1].[Nro_Cliente];",";"")>>",
"Nro_CCO": "<<SUBSTITUTE([Nro_CCO];",";"")>>",
"CCO": "<<[Nombre_CCO]>>",
"Provincia": "<<[Provincia]>>",
"Municipio": "<<[Municipio]>>",
"Localidad": "<<[Localidad]>>",
"Direccion": "<<[Direccion]>>",
"Lat_Long": "<<Text([LatLong])>>",
"Tipo": "<<[Tipo]>>",
"Estado": "Activo",
"Codigo_CCO": "<<CONCATENATE(RIGHT([Nro_CCO],3);UNIQUEID())>>",
"Codigo_Cli": "<<CONCATENATE([Nro_Cliente];UNIQUEID())>>"
    }
<<END>>
  ]
} 

What’s happen?

I’m not very knowledgable about JSON issues but I just noticed this post by @Steve:

I wonder if ENCODEURL() might not help.

2 Likes