Hi there, I'm looking to read Mango NoSQL database to get time series data in C# .net application. Appreciate help and guidelines. Thanks
-
How to read Mango NoSQL database in .net (c# windows app)?
-
Hi Lawrence,
It's not the most open source answer, but have you considered running Mango and querying the database through the API (i.e. your C# is a rest client)? If you require reading it directly you'll have to get an agreement with Joel before receiving any assistance.
-
Thanks Phildunlap, API would also work for me if Mango NoSQL database is not open source. Can you help to to get API queries? I'm not really friendly with this system. Appreciate your help. Thanks.
-
Hi Lawrence,
You can launch Mango with swagger.enabled=true set in your env.properties file (either in Mango/overrides/properties/ or Mango/classes) to have a helpful endpoint explorer page at localhost:port/swagger
You can find more details about how to authenticate and then make requests with the token you receive from authentication here: http://help.infiniteautomation.com/solution/articles/14000023292-mango-rest-api-authentication
I suspect this is the endpoint you would use:
-
Thanks Phildunlap, Is there any limitation on number of point values we can read from API? I would like to know the limitation of API. My requirement is to get all trend configured Points (PointName & Hierarchy) & trend data (like 15min interval samples). Appreciate your help. Thanks
-
There is not an artificial limit.
Rollups are possible through these API endpoints as well. I encourage you to explore swagger, and to check out the network tab of your browser's developer tools. You can see the HTTP traffic for sake of whatever C# client you're writing.
-
@phildunlap said in How to read Mango NoSQL database in .net (c# windows app)?:
http://help.infiniteautomation.com/solution/articles/14000023292-mango-rest-api-authentication
This link is not valid:
http://help.infiniteautomation.com/solution/articles/14000023292-mango-rest-api-authenticationCould you place add a working one, please.
