Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is right way to load data from MongoDB?
Currently mi Stack is:
MongoDB - QVSource (MongoDB Connector V2) - Qlik Sense Desktop
What im doing right now,
In Qlik Sense,
Sometimes it doesn't load thought it loads by url in browser.
Thanks in Advance.
Hi Petter,
Thanks for the reply.
Yes you are right. I am able to connect to the XML file. But it's gave the error. I have attached that xml file.
Appreciate your help.
Regards
Sagar
This isn't an XML file it is a JSON file. So trying to use it as an XML file will give an error.message naturally.
Hi Petter,
Can you please tell me how to pull this data in correct format. It's showing values as below :
[{ "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" }]
I have only REST connector installed.
Thanks
The screenshot you showed much earlier in this thread is not from the Qlik REST Connector. That is from a file connector... I am a little bit confused - have you switched over from trying to read from file to reading directly from a http based source with the REST Connector?
Which version of the REST Connector are you using? And which version of Qlik Sense are you using the screenshot is not Qlik Sense it is QlikView....
Anyway the content you show above can in some contexts be interpreted as valid JSON - for instance if you have a Python reading the three lines as individual lines and trying to deserialize them into a Python object...
However reading this from for instance Apache Drill or many other tools they wouldn't accept this form of mixing of records... could you share the entire file?