If you need to check out or use the Palo HTTP API and wish to do so in Excel/VBA, this may be of some use …
http://www2.gobansaor.com/PaloAPI/PaloAPI.zip
.. code is presented as is, treat as a proof of concept (i.e has not been hard tested).
See the code in demo.test for example of use. Also 3 of the functions can be called as UDFs.
Tested under Excel 2003, should work for any version from and including Excel 2000.
[...] The code may be found here. Enjoy! [...]