× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.