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

Noob question... API for polling values in the Mango database


  • I want to periodically retrieve certain values from the Mango database (via AJAX scripts from a PHP page).

    Can this be done?
    (No, obviously I've not RTFM... if it is there point me in the right direction)

    TIA

    Al


  • Hi Al,

    If your instance uses a MySQL database this is possible by having PHP access the database directly. You'll just need to know a bit about the database structure to correctly form your query.

    With derby - because it is a single-user database - you can't go direct. There is the HTTP data publisher, which sends data somewhere else, but you already know about that. There are also remote views, but they display values by manipulating the DOM with Javascript, so that likely won't work for you either.

    I'm assuming that you want to get these values into another system for some reason, rather than just having them display on a web page somewhere. Is that the case?