topic Re: Web connector JsonToTable incomplete data in Connectivity & Data Prep

Web connector JsonToTable incomplete data

Anonymous — Fri, 02 Apr 2021 08:01:15 GMT

Hello,

I'm trying a web connector call to an API,

if I choose the jsonToTable option a column comes out empty ( 0 ) while the same column is fully populated with a json array for each row if I choose jsonToXml or rawResponse.

Is there a way I can get the jsonToTable to show the full data content or some way to load the full data into qlikSense from the json response?

Thanks

Re: Web connector JsonToTable incomplete data

Anonymous — Wed, 26 Jul 2017 09:36:09 GMT

Is the question badly formulated?

Re: Web connector JsonToTable incomplete data

Anonymous — Mon, 23 Oct 2017 11:19:52 GMT

Can you give some more input?. What root fields are you getting? .I will try to fix..

Re: Web connector JsonToTable incomplete data

Darren_Ball — Mon, 23 Oct 2017 20:16:19 GMT

Hi,

What kind of data is being returned in that column when you use the jsonToXml or rawResponse tables?

Can you give an example of the response they give compared to jsonToTable?

Thanks,

Darren

Product Manager for Qlik Web Connectors