Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

sagarkharpude
Not applicable

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:2CSmiley Very Happy1", "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.

Tags (1)
1 Solution

Accepted Solutions
Darren_Ball
Not applicable

Re: Pull data from MongoDB

Hi,

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

MongoDB data extraction

1 Reply
Darren_Ball
Not applicable

Re: Pull data from MongoDB

Hi,

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

MongoDB data extraction