• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

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

    Development general discussion
    4
    8
    3.6k
    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
      • phildunlapP
        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
          • phildunlapP
            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
              • phildunlapP
                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
                  • MattFoxM
                    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