Re: Help with SYSTOOLS.HTTPPOSTCLOB

[Don Brown <DBrown@xxxxxxxxxx>]

+1

Don






From:   "Jon Paris" <jon.paris@xxxxxxxxxxxxxx>
To:     "RPG programming on IBM i" <rpg400-l@xxxxxxxxxxxxxxxxxx>
Date:   15/09/2021 07:48 AM
Subject:        Re: Help with SYSTOOLS.HTTPPOSTCLOB
Sent by:        "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>



"Personally, I'd use the HTTPAPI and just send the file that way. Not 
everything needs to be done with SQL."

Glad to see you say that Chris - there are days when I feel like I'm the 
only one who feels that way.


Jon Paris 


> On Sep 14, 2021, at 4:57 PM, Hiebert, Chris 
<chris.hiebert@xxxxxxxxxxxxxx> wrote:
> VALUES SYSTOOLS.HTTPPOSTBLOB( 
>  URL=>'https://www.google.com/' 
> , HTTPHEADER=>'' 
> , REQUESTMSG=> GET_BLOB_FROM_FILE( '/tmp/filename.zip')
> ) ;
>
> CLOB is a bad idea for zip files.
> BLOB is better.
>
> Also, you will want to look at what postman is doing for the http 
header.
> You probably need to include some sort of authentication.
>
> Personally, I'd use the HTTPAPI and just send the file that way. Not 
everything needs to be done with SQL. 
> Chris Hiebert
> Senior Programmer/Analyst
> Disclaimer: Any views or opinions presented are solely those of the 
author and do not necessarily represent those of the company.
> > -----Original Message-----
> > From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> > gio.cot via RPG400-L
> > Sent: Tuesday, September 14, 2021 8:43 AM
> > To: rpg400-l@xxxxxxxxxxxxxxxxxx
> > Cc: gio.cot <gio.cot@xxxxxxxxxxx>
> > Subject: Help with SYSTOOLS.HTTPPOSTCLOB
> >
> > Hi all
> >
> > I would need to invoke a webservice to post a zip file in azure; i 
would use
> > SYSTOOLS.HTTPPOSTCLOB , but i can't figure how can i fill the 
parameters
> > Thanks in advance
> >
> > Gio
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-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