• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1448
  • Last Modified:

Use WEB Services API in MS Access / VBA

Hello,
I have a MS Access 2003 application in which I am trying to see about implementing a web API call. I have attached the actual PHP code of the API, so I am hoping to be able to create a VBA function in which I pass a text string, the API goes out to the provider, the text get altered , API passes back to windows/ VBA for reading.

I beleive Microsoft has a web services object addon that Access can reference. Any guidiance is appreciated. api.txt
0
Louis Capece
Asked:
Louis Capece
  • 2
1 Solution
 
woolmilkporcCommented:
I think STM (xstm, mstm, csmt) is the tool of choice here.

You'll need to have the Support Tools Manager installed.

Example:

echo 'selclass qualifier memory;wait;info;Infolog' | cstm

Here is a thread on that topic:
http://forums11.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0xfc619c196a4bd71190080090279cd0f9%2C00.html&admit=109447626+1305125481227+28353475

wmp
 
 
0
 
farzanjCommented:
Well, I have been doing something very similar to what you are describing except that I was using Excel.  Here is how it worked.

First, I had to make CGI calls. Lets me try to explain what am I talking about.

Suppose I opened internet explorer and pasted by CGI call in the address bar like

http://mycgi.website/cgi_function?var1=value1&var2=val2

So I passed these values to the CGI program.  In return I received some XML or text values in the body of IE.

This is exactly what I did in Excel. I created a form and put a web browser object.  My calls sent values to IE and read values from the body of IE.  I hid IE in the body of form.

Making sense?
0
 
woolmilkporcCommented:
Sorry for my comment above - wrong thread!

Sorry again!

wmp
0
 
Louis CapeceAuthor Commented:
Not really an applicable solution
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now