How to read Mango NoSQL database in .net (c# windows app)?

lawrence26gta

Hi there, I'm looking to read Mango NoSQL database to get time series data in C# .net application. Appreciate help and guidelines. Thanks

phildunlap

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.

lawrence26gta

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.

phildunlap

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:

lawrence26gta

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

phildunlap

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.

NinoK

@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-authentication

Could you place add a working one, please.

MattFox

Version 3:
https://docs-v3.mango-os.com/mango-rest-api-authentication

Version 4:
https://docs-v4.mango-os.com/mango-rest-api-authentication

Fox