Thanks, I've seen that article. It doesn't address my certificate issue though.
Reason... Just a mental stretch. Having another tool in the toolbox is always good! Gotta keep learning!
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
Sent: Thursday, March 28, 2019 5:50 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL HTTP Function to get a text file from web service
I'm sure something like HTTPGETCLOB would do it (
https://www.itjungle.com/2017/09/18/guru-consuming-rest-web-service-using-sql-get/).
As a side note, if you have it working in Python why do you need to change?
-----Original Message-----
From: Roger Harman [mailto:roger.harman@xxxxxxxxxxx]
Sent: Wednesday, March 27, 2019 4:47 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
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
