[Openroad-users] FW: OpenRoad - Web service
Paul White
pwhite at peerlessit.com.au
Tue Oct 31 05:07:04 EST 2006
-----Original Message-----
From: info-ingres-admin at cariboulake.com
[mailto:info-ingres-admin at cariboulake.com] On Behalf Of Paul White
Sent: Saturday, 28 October 2006 2:46 PM
To: Sergio; OpenRoad user list; info-ingres
Subject: RE: [Info-ingres] OpenRoad - Web service
I don't think we have used https with SOAP. But we have successfully
connected using the IE browser control and xml controls.
You'll of course install the certificate on each OpenROAD client.
Here is an example using XML object
Strobj = stringobject;
Xml = ex_xmldom!xmlhttp30;
{
Xml.Open('GET','https://mysite.com.au',FALSE);
G_browser.navigate('https://mysite.com.au')
Xml.Send(null);
strobj = Xml.responsetext();
Return ifnull(strobj.value,'');
}
-----Original Message-----
From: info-ingres-admin at cariboulake.com
[mailto:info-ingres-admin at cariboulake.com] On Behalf Of Sergio
Sent: Friday, 27 October 2006 6:03 PM
To: OpenRoad user list; info-ingres
Subject: Re: [Info-ingres] OpenRoad - Web service
I have another problem. The WS that i have to interface needs SSL
certificate. What have I to do ?
Thanks, Sergio
----- Original Message -----
From: "Paul White" <paulwh at mpiece.com.au>
To: <sergio.sperandio66 at tin.it>
Cc: <info-ingres at cariboulake.com>
Sent: Friday, October 13, 2006 5:21 AM
Subject: RE: [Info-ingres] OpenRoad - Web service
> Below is an example which makes a call to a local web service.
>
>
> -----Original Message-----
> From: White, Doug
> Sent: Friday, 13 October 2006 12:56 PM
> To: 'paulwh at mpiece.com.au'
> Subject: RE: [Info-ingres] OpenRoad - Web service
>
>
> 1) This calls server 127.0.0.1/message.aspx
> 2) If you wanted the results as xml data instead of text, the xml data
will be stored in the xml object
> 3) ex_xmldom is the microsoft XML document dll
>
> PROCEDURE SOAP () =
> DECLARE
> req = ex_xmldom!xmlhttp30;
> lv_data = VARCHAR(2000) NOT NULL;
> strobj = req.responsetext();
> ENDDECLARE
> {
>
> Lv_Data = '<?xml version="1.0" encoding="utf-8"?>' + '<soap:Envelope
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
' +
> ' xmlns:xsd="http://www.w3.org/2001/XMLSchema" ' + '
> xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> ' + '
> <soap:Body>'+
> ' <Message>'+
> ' <Text>Hello There!</Text>' +
> ' <To>OpenROAD Users</To>' +
> ' </Message>' +
> ' </soap:Body>' +
> '</soap:Envelope>';
>
> req.Open('POST', 'http://127.0.0.1/message.asmx', FALSE);
> req.setRequestHeader ('SOAPAction',
'http://tempuri.org/MESSAGE/SendMessage');
> req.setRequestHeader ('Content-Type', 'text/xml');
>
> req.Send(:Lv_Data);
> strobj = req.responsetext();
>
> /* [ insert your processing here ] */
>
> RETURN C_RTNSUCCESS;
> }
>
>
> -----Original Message-----
> From: sergio.sperandio66 at tin.it [mailto:sergio.sperandio66 at tin.it]
> Sent: Friday, 13 October 2006 12:52 AM
> To: paulwh at mpiece.com.au
> Subject: R: RE: [Info-ingres] OpenRoad - Web service
>
>
> I want to send HTTP post, via SOAP then receive XML data, store in
> database.
> I attach a list of methods that i have to interface.
>
> Thanks
>
> ----Messaggio originale----
> Da: paulwh at mpiece.com.au
> Data: 12-ott-2006
> 3.24 PM
> A: "Sergio"<sergio.sperandio66 at tin.it>
> Cc: <info-
> ingres at cariboulake.com>
> Ogg: RE: [Info-ingres] OpenRoad - Web service
>
> Hello Sergio,
>
> Unfortunately the OpenROAD User list is off line at the moment
> undergoing repairs.
> I'll help if I can. Can you explain a bit more about your
> requirements?
>
> Our application is used for secure
> banking transactions, collecting data
> from web sites, etc.
> We have
> OpenROAD communicating with web services in various ways.
> For example:
>
> Browse to a web page and display to your user Connect to a web page,
> extract data and store in database Respond to prompts on a web page,
> complete entry fields and activate buttons to submit requests Send
> HTTP post, via SOAP then receive XML data, store in database Linked
> openroad to md5 and pgp encryption.
>
>
> Paul White
>
> -----Original Message-----
> From: info-ingres-admin at cariboulake.com
> [mailto:info-ingres-
> admin at cariboulake.com]On Behalf Of Sergio
> Sent: Thursday, 12 October
> 2006 5:23 PM
> To: info-ingres; OpenRoad user list
> Subject: [Info-ingres]
> OpenRoad - Web service
>
>
> I have to interface my openroad 4.1 software to an web service.
>
> Any help is apreciated
>
> Thanks, Sergio
>
>
>
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at cariboulake.com
> http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
More information about the Openroad-users
mailing list