[Openroad-users] OpenRoad - WebServices

[Paul White]

Hello Marcello,

Unfortunately my expert is away. Did you get my test example working?

I think X509Certificate2 is vb.net. You may have to write and install a .net
wrapper which can be called from OpenROAD.  A quick search on google will
find  you some examples. Try searching "xmlhttp30 certificate".

I have forwarded your question to the OpenROAD users list, hopefully you
should get a response very soon.

To join up to the OpenROAD Users list click on this link
  mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
and press send.
The list server will send you a message to confirm.
Click reply and send.


Regards

Paul White

-----Original Message-----
From: info-ingres-admin at cariboulake.com On Behalf Of Gattino Marcello
Sent: Wednesday, 8 November 2006 4:30 AM
To: paulwh at mpiece.com.au; info-ingres at cariboulake.com
Cc: Grieco, Donato
Subject: [Info-ingres] OpenRoad - WebServices


Hi Paul,

I must to interface my openroad 4.1 software to an web server.
I use a xml communication with the object xmlhttp30.
But my problem is this object don't support the certificate.
In fact I must to send my input-xml with an certificate object
(X509Certificate2).

So I have need to include the library .dll that contains the useful methods.
Which library .dll can help me for my goal?
And how I to do for including this .dll in my openroad for to see the
methods and attributes?

Any helps is appreciated

Thank you, Marcello


-----Original Message-----
From: 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 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
> 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 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
>