http xml messaging

[darren via AccessMonster.com]

Hi

I've been given a heads up on a task that might coming my way. I don't have
full details yet but understand that it involves getting the access
application to connect to a web application to get quotes. All I have so far
is that it may involve http POST requests and XML messaging. We will be
provided a user name, password and digital certificate.

Whilst I await further information I am simply trying to get an idea of what
this might entail. Looking through the forum I have found some information
regarding http posts and from what I can gather I may be sending an XML
document, presumably first created by the access app, with the data necessary
for the quote and will receive an XML response.

Obviously the response will contain the quote data but not exactly sure as to
the XML 'object' that I will receive and how I pull this into the database.
It may be as simple as receiving an XML doc that immediately gets imported or
gets saved first and then imported.

Just wondering whether anyone else has experience in this type of area, what
may be involved and its complexity as I do not want to promise what I can't
deliver.

Thanks again

--
Darren

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[darrensawyer via AccessMonster.com]

Re: http xml messaging

Update: Ok, for what it's worth to those who may be interested...

The web service requires xml to a standard that it specifies. I have to spit
the data out of acc2003 in to XML run a transform using XSLT then http post
this transformed XML. Likewise reverse the process for the response.

Simple in theory. Just need to learn XSLT and ake my data fit. So why do I
find a long weekend of studying/research coming on ...........

--
Darren

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[rkc]

Re: http xml messaging

darrensawyer via AccessMonster.c om wrote:

Update: Ok, for what it's worth to those who may be interested...
>
The web service requires xml to a standard that it specifies. I have to spit
the data out of acc2003 in to XML run a transform using XSLT then http post
this transformed XML. Likewise reverse the process for the response.
>
Simple in theory. Just need to learn XSLT and ake my data fit. So why do I
find a long weekend of studying/research coming on ...........

There is a Soap toolkit available for use with Office\VBA. It
would seem to me anyone using XML to transport data would likely
conform to that standard instead of making up their own.

http://msdn.microsoft.com/msdnmag/issues/02/12/OfficeXPToolkit/