Re: SQL HTTP Function to get a text file from web service

Well, I seem to have made a bit of progress.

SELECT SYSTOOLS.HTTPGETCLOB('<the url>',
cast('<httpHeader>
<header name="User-Agent" value="<the agent>" />
<ditto for the others>

But, the next hurdle is a certificate error. I didn't have any issues
with that using Python.
"The certificate issued by CN=DST Root CA X3, O=Digital Signature Trust
Co. is not trusted"

My knowledge of dealing with certs is pretty minimal.

Once I get past that, I feel like the dog chasing a car. What do I do
when I catch it?

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power










From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
Roger Harman <roger.harman@xxxxxxxxxxx>
Sent: Wednesday, March 27, 2019 2:46 PM
To: Midrange Systems Technical Discussion
Subject: SQL HTTP Function to get a text file from web service

I have a Python script that downloads a text file from a web service.
Looks like this:

response = requests.get(
url="https:<the url>",
headers={
"Accept": "text/tab",
"API-TOKEN": "<the token>",
"SITE-USER": "<the user>",
"user-agent": "<the agent>",
}
)

with open(TxtFileName, 'wb') as outputFile:
outputFile.write(response.content)
outputFile.close()

Is this easily replicated using one of the SQL HTTP functions? After
download we put in a PF and feed a downstream process.

I feel like I should be able to figure this out but I'm just... stumped.

Thanks!!

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power







--
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@xxxxxxxxxxxx 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@xxxxxxxxxxxx for any subscription related
questions.

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