Hi
Does anyone know if it is possible to use Web APIs from within Access.
I have a search form where I search in different tables that I import into access prior to Searching. I would like to send my keyword to Chemspider.com using their Web API solution.
So if anyone could have a brief look at this info to tell me if it can be used somehow in access and then how I get started in access VBA.
Info from chemspider website:
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
Thanks
Rasmus T
Does anyone know if it is possible to use Web APIs from within Access.
I have a search form where I search in different tables that I import into access prior to Searching. I would like to send my keyword to Chemspider.com using their Web API solution.
So if anyone could have a brief look at this info to tell me if it can be used somehow in access and then how I get started in access VBA.
Info from chemspider website:
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
Code:
GET /Search.asmx/SimpleSearch?query=string&token=string HTTP/1.1
Host: LINK TO WEBSITE
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInt xmlns="LINK TO WEBSITE">
<int>int</int>
<int>int</int>
</ArrayOfInt>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
Code:
POST /Search.asmx/SimpleSearch HTTP/1.1
Host: LINK TO WEBSITE
Content-Type: application/x-www-form-urlencoded
Content-Length: length
query=string&token=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInt xmlns="LINK TO WEBSITE">
<int>int</int>
<int>int</int>
</ArrayOfInt>
Thanks
Rasmus T