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 access Rest API Login Endpoint using VBA


  • Hi,

    How can access the Rest API Login endpoint using VBA code? Do you have a simple sample codes for this kind of access?
    Thank you very much.

    Regards,
    Mok Kiew


  • Hi Mok Kiew,

    I've never written any VBA and very little VB personally, but I think this stackoverflow thread does some general API type stuff, and it does contain some information about setting headers: http://stackoverflow.com/questions/19553476/how-to-make-rest-call-with-vba-in-excel

    You'll want to do a GET to /rest/v1/login/admin or another user with the password in a header named "password" which will get you a response with a Set-Cookie header if successful. You'll have to pass that header's value as the "Cookie" header in subsequent requests.

    You may need to include the XSRF-TOKEN portion of the Cookie under the X-Xsrf-Token header, as well. If this is required you'll have a 403 Forbidden response when using just the Cookie header.

    Someone else may chime in with an example script. Good luck!


  • Hi,

    To add to what phildunlap said, you must include 'application/json' in the accepts header.

    If basing your code on the question and answers on that stackoverflow page, you would need to add the following line before invoking the send method:

    objHTTP.setRequestHeader "accept", "application/json"

    Regards,

    Gary