UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Getting Started With Web Services, Access 2010    
 
   
haresfur
post Mar 12 2018, 07:32 PM
Post#1



Posts: 277
Joined: 4-April 12
From: Bendigo, Australia


Is this the proper place to ask about accessing an external database through a web service? I'm not sure about the correct terminology much less how to get started.

--------------------
-- Evan
Go to the top of the page
 
GroverParkGeorge
post Mar 12 2018, 09:04 PM
Post#2


UA Admin
Posts: 33,013
Joined: 20-June 02
From: Newcastle, WA


Probably not.
Access Web Services for Office 365 come to an end this month.

WHat do you have it mind? There is probably an alternative, but we need more information to offer thoughts.

--------------------
Go to the top of the page
 
theDBguy
post Mar 12 2018, 09:33 PM
Post#3


Access Wiki and Forums Moderator
Posts: 72,709
Joined: 19-June 07
From: SunnySandyEggo


Hi Evan,

If you're referring to other web services like Google or PayPal and such, I usually use this method: HTTPRequest Class

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
haresfur
post Mar 12 2018, 10:24 PM
Post#4



Posts: 277
Joined: 4-April 12
From: Bendigo, Australia


I want to be able to query data from another government agency where, if I understand correctly they have set up a service to return data in JSON format. So I guess like Google or PayPal. My initial goal is to keep from re-importing snapshots of their data. I found this page on working with JSON data in SqlServer, which looks promising. But I'm on the very steep part of the learning curve where I don't even really know what I need to know. The data definitions pages provided are xml, but I still need to figure out how to 'attach' to the service, request data, and deal with what it returns.

I'm hoping someone can point me in the right direction to make this a bit less painful or at least so I can bug them with the right questions.

--------------------
-- Evan
Go to the top of the page
 
theDBguy
post Mar 12 2018, 10:59 PM
Post#5


Access Wiki and Forums Moderator
Posts: 72,709
Joined: 19-June 07
From: SunnySandyEggo


Hi Evan,

I use the HTTPRequest Class to request JSON data from a financial company. I wrote a JSON primer on my blog where there's a link at the end to the JSON-VBA Class I use to parse the return data from the web server.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
haresfur
post Mar 13 2018, 05:46 PM
Post#6



Posts: 277
Joined: 4-April 12
From: Bendigo, Australia


Thanks DBGuy,

I put your code for the post example behind a button on a form. Set a reference to Microsoft XML V 6.0 in VBA. The result was Status = 200 but the xhr.responseText was:

Attached File  Capture.JPG ( 32.75K )Number of downloads: 1


Not what I was expecting, so I'm not sure what I'm doing wrong.

Nevermind, I forgot to look at the debug window. Ooops.
This post has been edited by haresfur: Mar 13 2018, 06:04 PM

--------------------
-- Evan
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th July 2018 - 10:32 AM