Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, i've got a strange problem using a rest connection to get some json data.
the json table is very simple:
RestConnectorMasterTable:
SQL SELECT
"id",
"project_id",
"work_unit_type_id",
"time_from",
"duration_minutes",
"location_type",
"person_id",
"notes",
"planned_flag",
"excluded_from_billing"
FROM JSON (wrap on) "root"
When I load it with qlikview or in qliksense preview everything goes fine. The problem is that in qliksense, when I load data I get this error:
Si è verificato il seguente errore:
Unexpected token: '.', expected one of: 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', 'and', ...
L'errore si è verificato qui:
if [{"id":"b63d6c49-bdbd-4b2c-beac-6f7928d56111","project_id":"da7d3bb3-ac34-4a8e-be90-78dbefe0edbf","work_unit_type_id":"724263df-7846-46be-879c-4e9480ce6feb","time_from":"2019-01-07T00:00:00.000+01:00","duration_minutes":480,"location_type":"workplace","person_id":"244ba955-df86-407c-9292-8001f4f22d2f","notes":"Check disposizione materiale e carrelli in linea [4h]>>>>>>.<<<<<<\n
It seems that it doesn't like the dot character. Does anyone know what the problem is and if i can use a workaround?
p.s. I tried it on qlikview personal edition but i cannot use it to develop this app
The problem seems on "notes" field...
Can you check your source string into your source database? Maybe therse is a character not supported by QlikSense Rest connector which graphically seems a dot but it's not... Could be a similar character but with different ascii code.
The data preview works because it loads only a subset of records... this is the reason why i think is a problem linked to a specific record.
Can you share your rest connection parameters?