QLik Sense LiveTable Editing Data

[nmathieu]

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