Re: Consuming a web service using SQL

I tried to run Birgitta example, but it crashes because it does not like
the* Http_get(* part.
Darryl

On Wed, Aug 31, 2022 at 2:28 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

---------- Forwarded message ---------
From: Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
Date: Sat, Aug 27, 2022 at 4:26 AM
Subject: RE: Consuming a web service using SQL
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>


Accessing a Web-Service might not be the problem.
With the HttpGetCLOB (or other http functions) in the SYSTOOLS schema or
better with the newer HTTP_GET (or other functions) a Web-Service can be
accessed.
The result can than be decoposed In composition with the XML_TABLE
function
(and this will be the hardest part).

Here again the example for accessing the Exchange Rate Web-service of the
European Central Bank

Select *
From XMLTable(
XMLNamespaces(DEFAULT
'http://www.ecb.int/vocabulary/2002-08-01/eurofxref',
'http://www.gesmes.org/xml/2002-08-01' AS
"gesmes"),
'gesmes:Envelope/Cube/Cube/Cube'
Passing XMLParse(DOCUMENT
-- SYSTOOLS.HTTPGetBLOB(
Http_Get(

'https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml',
''))
Columns Subject VarChar(30) Path '../../../gesmes:subject',
Sender VarChar(30) Path
'../../../gesmes:Sender/gesmes:name',
ExchgDate Date Path '../@time',
Currency Char(3) Path '@currency',
ExchgRate Dec(10, 4) Path '@rate' ) a;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i


"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
„Train people well enough so they can leave, treat them well enough so
they
don't want to.“ (Richard Branson)


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
Sent: Freitag, 26. August 2022 20:42
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Consuming a web service using SQL

I am trying to find my notes from Birgitta's presentation at Common this
year. I'll also look at Scott HTTPAPI. Thanks

On Thu, Aug 25, 2022 at 8:46 PM Don Brown via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

For initial testing I would recommend you download SoapUI

I have found this tool invaluable for testing SOAP services before
trying to code in RPG or SQL

Cheers

Don





From: "a4g atl" <a4ginatl2@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 26/08/2022 06:34 AM
Subject: Re: Consuming a web service using SQL
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



I need to consume a service to get inventory balances. The service is
SOAP based. I was hoping for JSON/REST but they do not support REST.
So I have to use SOAP for now.

Darryl.


On Thu, Aug 25, 2022 at 3:22 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

P.S. I should point out that the article I referenced is using the
old version of the SQL HTTP services. For more up-to-date versions
see IBM's web pages as well as many examples from Simon on
https://www.rpgpgm.com/p/about-this-blog_9.html <
https://www.rpgpgm.com/p/about-this-blog_9.html>

Jon P.

On Aug 25, 2022, at 1:49 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

This is a first for me and I need some help on where to start.
I have the details on the web service but I have not found a
document explaining what must be done to make SQL consume the

service.

I have an example of the web service.
Do I need to predefine the fields in the web service or can I
simply

use

the * to return all values?

TIA, Darryl Freinkel.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate

link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com




--
This email has been scanned for computer viruses. Although MSD has
taken reasonable precautions to ensure no viruses are present in this
email, MSD cannot accept responsibility for any loss or damage arising
from the use of this email or attachments..
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com