Pull data from MongoDB

sagarkharpude — Fri, 02 Apr 2021 07:50:55 GMT

Hi All,

What is right way to load data from MongoDB?

Currently I have Added a Web File with URL from QVSource 'mongo'.

Written Load script in Qlik Sense from above created web file as this

LOAD
1. linking_id as Name,
2. "timestamp" as "Time",
3. value as Value
FROM [lib://mongo]
(qvx);

But I am getting the data in below format

[{ "Address" : "00:0A:F7:2D:2C:D1", "IpAddresses" : [{ "Address" : "10.180.74.14", "IPSubnet" : "255.255.252.0" }, { "Address" : "fe80::b57d:f0e7:3891:bd21", "IPSubnet" : "64" }] }]

{ "InventorySiteId" : "0c396f1f-2139-4590-8c75-4a47ae8bb407", "SiteComputerId" : "0a604b58-1994-4958-b40f-adc8232b74a5" }

[{ "_t" : "DirectX", "Version" : "4.9.0.904" }, { "_t" : "Antivirus", "Name" : "AVG CloudCare AntiVirus", "State" : "262160" }]

Thanks in Advance.

Re: Pull data from MongoDB

Darren_Ball — Mon, 20 Feb 2017 08:50:24 GMT

Hi,

The returned format is JSON, so one method is as described in your other post:

MongoDB data extraction

topic Pull data from MongoDB in Connectivity & Data Prep

Pull data from MongoDB

Re: Pull data from MongoDB