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
midrange.com
