Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

headmaster92
New Contributor

"Cannot parse data in selected response type"

Hello there,

I have a problem with loading data to Qlik Sense with REST driver.

I have tried to load JSON, XML and CSV data (same data but in different formats). I can display them in add data form (see attachment load_form.png) but when I am trying to load selected data in then i throws me multiple times error (see attachment error.png). I have tried to load this data with Web File Driver but it is throwing same error.

I thought that this might be a problem with encoding but I have tried encoding UTF-8 and still nothing (UTF-8 xml files from e.g. SOLR are working correctly). I couldn't find other requirements for load data.

Do you have any idea whats wrong? What else should I add to the file to get it working?

Any help is really appreciated.

Data is in file (1).csv

6 Replies
headmaster92
New Contributor

Re: "Cannot parse data in selected response type"

up

Partner
Partner

Re: "Cannot parse data in selected response type"

Did you resolve this issue?

Highlighted
Partner
Partner

Re: "Cannot parse data in selected response type"

Hi

Not sure if this might help, but it looks to me that Qlik Sense still tries to parse it as XML.

Would adding the following response headers help?

Content-Type: "text/csv"

Content-Disposition: "attachment;filename=myfilename.csv"

Partner
Partner

Re: "Cannot parse data in selected response type"

Hi,

Thanks for writing back. I m trying to hit a https url to retrieve JSON format and it works like a charm in September 2017 release but when trying the same in February 2018 release, I m getting below error.

Tried Content-Type -> application/json, but it throw error saying content-type is not supported using GET method.

Appreciate your help as I m stuck and still trying to get a fix.

cannot parse the data in the selected response type. check response type parameter value


Thanks,

Rakul.

kuczynska
Contributor III

Re: "Cannot parse data in selected response type"

Hi there!

Did you manage to resolve this issue? We are currently trying to pull JSON format too from a URL and we are on Sep 2018 version. Any advice will be highly appreciated.

Thanks in advance,

Michalina

Partner
Partner

Re: "Cannot parse data in selected response type"

Yes we resolved it by adding the url to trusted website in Qlik Sense server and everything worked as expected.