Pull data from MongoDB

[sagarkharpude]

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

1. LOAD
   1. linking_id as Name,
   2. "timestamp" as "Time",
   3. value as Value
2. FROM [lib://mongo]
3. (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.

[Darren_Ball · Accepted solution]

Hi,

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

MongoDB data extraction