We would like to pull data from our KBOX 1000 appliance without having to resort to the MySQL ODBC client. We'd also like to set up notifications (such as when new tickets are created) to use in gadgets on the desktop. Is there a KBOX API that would allow us to do some of these things through standard HTTP calls like when using REST or OData? Perhaps a web service or something to get call backs when an event occurs? The only thing I can see at the moment is setting up a web service through like ASP.Net that acts as a middleman and talks to KBOX using ODBC. Or, for push events, writing triggers or commands in MySQL that get ran during a custom trigger in KBOX. However MySQL doesn't really support running external commands in a SQL statement unless you use UDFs, which I'm not sure I can even load on KBOX.
Both of these seem really a hack when simpler methods may already be built into KBoX itself. I'd appreciate any suggestions or solutions that you might be willing to share. Thanks,Matt Penner
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Nope. The only external access to the database is read-only via ODBC. If you only need reporting capability, why do you want to avoid "resorting to ODBC"? That's a lot easier than custom .NET development with an API would be.
Answered 07/21/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment