Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator III

Pull data from MongoDB

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.

1 Solution

Accepted Solutions
Darren_Ball
Employee
Employee

Hi,

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

MongoDB data extraction

View solution in original post

1 Reply
Darren_Ball
Employee
Employee

Hi,

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

MongoDB data extraction