<div>
<div class="content wysiwyg-content">
I'm using a service that provides an api to get data out of our online, hosted database. I've never called data this way from VBA and am wondering how to do it. <br />
I have an api key, username, password but am not sure how to put code together to make it work.<br />
Code I've put together is below:<br />
<br />
Dim httpreq As New MSXML2.XMLHTTP60, myurl As String<br />
myurl = &quot;<a href="https://cowtown.breezechms.com/api/people" rel="ugc">https://cowtown.breezechms.com/api/people</a>&quot;<br />
httpreq.Open &quot;GET&quot;, myurl, False<br />
httpreq.setRequestHeader &quot;Content-Type&quot;, &quot;application/json&quot;<br />
httpreq.setRequestHeader &quot;dduck&quot;, &quot;abc123&quot;<br />
httpreq.send<br />
MsgBox (httpreq.responseText)<br />
<br />
The MsgBox just kicks back the following response.<br />
<br />
&quot;Permission Denied - API key () does not match subdomain (cowtown)&quot;
</div>
</div>


I'm using a service that provides an api to get data out of our online, hosted database. I've never called data this way from VBA and am wondering how to do it. 
I have an api key, username, password but am not sure how to put code together to make it work.
Code I've put together is below:

Dim httpreq As New MSXML2.XMLHTTP60, myurl As String
myurl = "https://cowtown.breezechms.com/api/people"
httpreq.Open "GET", myurl, False
httpreq.setRequestHeader "Content-Type", "application/json"
httpreq.setRequestHeader "dduck", "abc123"
httpreq.send
MsgBox (httpreq.responseText)

The MsgBox just kicks back the following response.

"Permission Denied - API key () does not match subdomain (cowtown)"

How do i send an api key in a request header

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.