topic Re: File Type Output in QlikView

File Type Output

fcecconi — Wed, 25 Nov 2020 16:16:04 GMT

I am using Qlikview 12

I have a request to have Qlik produce JSON as an output. I was trying to look online at the API guide, but it hasn't been updated in a while. I don't need the actual way HOW to do it right now, but IS it possible to produce a JSON file with the API's?

thanks

Frank

Re: File Type Output

swuehl — Wed, 20 Apr 2016 14:29:27 GMT

I don't think that's supported by the API.

You might consider exporting your data to csv and then converting to JSON.

Re: File Type Output

markodonovan — Thu, 21 Apr 2016 07:34:02 GMT

Hi Frank,

What are you doing with the JSON file ?

If you are using it to send the data to a webservice this can be done using an Extension with javascript.

This post might help:

https://community.qlikview.com/thread/50694

Let me know and see if I can find some examples.

Thanks

Mark

http://techstuffy.tv

Re: File Type Output

fcecconi — Thu, 21 Apr 2016 13:49:39 GMT

Mark

The client wants to use their own visualization. So all they really want to use is the Qlik engine.

Regards,

Frank

Re: File Type Output

markodonovan — Thu, 21 Apr 2016 14:07:36 GMT

Hi Frank,

Does your data model need to contain the JSON or do you need to export the JSON to a file ?

Mark

Re: File Type Output

fcecconi — Thu, 21 Apr 2016 14:10:55 GMT

Mark

I need to export.

Re: File Type Output

markodonovan — Thu, 21 Apr 2016 14:19:22 GMT

Hi Frank,

If you are using Ajax you could still create an extension send the data elsewhere and changing this to json is possible:

http://www.qlikblog.at/1798/posting-data-from-qlikview-to-other-systems-using-the-ajax-client-and-extensions/

OR you could look into macros and building the format manually:

Have you looked into trying the macro route to format the text file manually :

sub exportrequest

Set fso = CreateObject("Scripting.FileSystemObject" )

Set file = fso.CreateTextFile("C:\testjson.txt",True)

file.Write("testtext")

end sub

OR as Stefan suggested having a 2 step process to convert to json.

Hope this helps.

Thanks

Mark

http://techstuffy.tv

Re: File Type Output

fcecconi — Thu, 21 Apr 2016 14:23:10 GMT

Mark

Right now I am just inquiring if this is possible and from your posts (THANKS), It appears that it is possible,

Frank

Re: File Type Output

markodonovan — Thu, 21 Apr 2016 14:32:20 GMT

Good luck Frank,

Here is an example of the javascript I use in an extension to post json.

Mark

////////////////////////////////////////////////////////////////////////

function postData(webServiceUrl, obj,listoffiles) {

$.support.cors = true;

var Id=12;

$.ajax({

// crossDomain:"true",

type: "POST",

url: webServiceUrl,

data: '{"qvDataTable":' + JSON.stringify(obj) + '}',

contentType: "application/json; charset=utf-8",

timeout:"1728000",

dataType: "JSON",

ProcessData : "false",

xhrFields: { withCredentials: false},

success: function (msg) {

if(listoffiles.length==0)

{

$("#filelist").html("<B>No Files have been selected!</B>");

}

else

{

$("#filelist").html("<B>Changes have been saved.</B>");

doc.SetVariable("images_selected","updated");

}

$("#dialog-message" ).dialog({ hide: { effect: "explode", duration: 1000 } });

//selectedlist

//Update variable so know images have been updated

error: function (xhr, ajaxOptions, thrownError) {

switch (xhr.status.toString()) {

case "404":

alert('Error 404 posting the data to the webservice!\n\nCould not find webservice at Url ' + _this.WebserviceUrl);

break;

default:

alert('Error posting the data to the webservice:\n\n' + 'Error Status: ' + xhr.status + '\nError Status: ' + xhr.statusText);

break;

}

});

}

}, false);

}