Data from JSON data source is not extracted properly using 'Web Files' option.

Prabhu — Sat, 16 Nov 2024 21:18:47 GMT

Hi All,

I am trying to load data from JSON data source using 'Web Files' option. I get the following script with column name and column value. I want a tabular format with columns and rows. Please do the needful.

LOAD "[{""id"":1",
[DI_SID":"A000060],
["product_id":9],
[provisioned_date":"2018-12-04T00:00:00.000Z],
["last_scan_date":null],
["last_updated":null],
["build_type":null],
["build_version":null],
["serial_number":null],
["inventory_number":null],
[description":"T3],
["host_ip":null],
["manufacturer":null],
["model":null],
["os_name":null],
["os_version":null],
["purpose":null],
["eol_date":null],
[job_desc":"Assoc],
[location":"Avery Rd],
[country":"UNITED STATES],
[region":"AMER],
[city":"Dublin],
[job_type":"Non-Technical],
["createdDateTime":"2019-01-24T06:56:12.000Z"}],

[{"id":8],
[DI_SID":"A000062],
["product_id":1],
[provisioned_date":"2017-01-05T00:00:00.000Z],
["last_scan_date":null],
["last_updated":null],
["build_type":null],
["build_version":null],
["serial_number":null],
["inventory_number":null],
[description":"NULL],
["host_ip":null],
["manufacturer":null],
["model":null],
["os_name":null],
["os_version":null],
["purpose":null],
["eol_date":null],
[job_desc":"VP],
[location":"Tempe Bldg G],
[country":"UNITED STATES],
[region":"AMER],
[city":"Tempe],
[job_type":"Non-Technical],
["createdDateTime":"2019-01-24T06:56:12.000Z"}]

FROM
[https://mtm-api.apps.dev.4a.aia.jse.net/api/vdipaged/0/50]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

@Gysbert_Wassenaar @sunny_talwar @rwunderlich

Re: Data from JSON data source is not extracted properly using 'Web Files' option.

Gysbert_Wassenaar — Tue, 05 Mar 2019 09:58:22 GMT

Try using the REST connector instead of trying to load it as a web file.

topic Data from JSON data source is not extracted properly using 'Web Files' option. in QlikView

Data from JSON data source is not extracted properly using 'Web Files' option.

Re: Data from JSON data source is not extracted properly using 'Web Files' option.