• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

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

    Development general discussion
    4
    8
    2558
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      lawrence26gta last edited by

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

      1 Reply Last reply Reply Quote 0
      • phildunlap
        phildunlap last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • L
          lawrence26gta last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • phildunlap
            phildunlap last edited by

            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:
            0_1483547979582_point-value-endpoint.png

            N 1 Reply Last reply Reply Quote 0
            • L
              lawrence26gta last edited by

              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

              1 Reply Last reply Reply Quote 0
              • phildunlap
                phildunlap last edited by 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.

                1 Reply Last reply Reply Quote 0
                • N
                  NinoK @phildunlap last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • MattFox
                    MattFox last edited by

                    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

                    Do not follow where the path may lead; go instead where there is no path.
                    And leave a trail - Muriel Strode

                    1 Reply Last reply Reply Quote 0
                    • First post
                      Last post