Now we have a problem with a JSON that adds new rows in a table
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.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |