QLik Sense LiveTable Editing Data

nmathieu — Mon, 27 Sep 2021 08:46:53 GMT

Hi ALl,

I am setting up the Qlik Live Table so as to be able to connect with SQL Database and edit directly the database on the dashboard

I have the Javascript code related to the save data here below

$(document).on("click", ".saveData", function(){

//get values from table

values = {};

$('.editable').each(function(index, item) {

if($(item).attr('id') != qKeyField){

values[$(item).attr('id')] = $(item).val();

}

});

if(qDebug){

console.log('JSON Sent: ' + JSON.stringify(myJSON))

}

//add new values to JSON (filters should still match single record)

myJSON["values"] = values;

//Send JSON to the REST API using fetch and get result

var fetchData = {

method: 'PUT',

body: JSON.stringify(myJSON),

headers: {

'Accept': 'application/json',

'Content-Type': 'application/json'

}

fetch(qRestAPI, fetchData)

.then((resp) => resp.json()) // Transform the data into json

.then(function(data) {

if(qDebug){

console.log('JSON Received: ' + JSON.stringify(data))

I am getting this error when clicking on Save data button:

There was an error fetching the data from LiveTable REST API : SyntaxError : Unexpected token < in JSON at position 0

I know the JSON might not be in a correct format but I don't know honestly how to troubleshoot it,

Could you please help ?

Thanks a lot in advance

topic QLik Sense LiveTable Editing Data in Management & Governance