Re: [IBMiOSS] Scripting cURL to execute in CL Programs -- OPENSOURCE

Install QSHONI and make calling shell stuff so much easier. It handles all the little details for you.

You can call your curl command listed below and consume the results as an OUTFILE, Spool File or in the joglog (Not recommended for large results).

QSHONI/QSHEXEC CMDLINE('/QOpenSys/usr/bin/sh -c "/QOpenSys/bin/script.sh"')

QShell on i Commands
http://www.github.com/richardschoen/qshoni

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx

----------------------------------------------------------------------

message: 1
date: Sat, 27 Feb 2021 12:06:44 -0600
from: "Jacob Banda" <jnbanda@xxxxxxxxxx>
subject: Re: [IBMiOSS] Scripting cURL to execute in CL Programs

I agree with Bryan's suggestion. At least it's easier for me that way.

QSH CMD('/QOpenSys/usr/bin/sh -c "/QOpenSys/bin/script.sh"') where /QOpenSys/bin/script.sh is any PASE shell command or script.

See IBM's article on calling shell scripts from CL.
https://www.ibm.com/support/pages/node/684869

-----------------------------------------
Jacob Banda
-----------------------------------------

-----Original Message-----
date: Fri, 26 Feb 2021 15:02:27 -0600
from: Bdietz400 <bdietz400@xxxxxxxxx>
subject: Re: [IBMiOSS] Scripting cURL to execute in CL Programs

It might help to put the curl steps in a shell script file and run that from the command line program

--
Bryan Dietz

On Feb 26, 2021, at 9:01 AM, Michael Fulmer <mfulmer@xxxxxxx> wrote:

? Has anyone had success scripting cURL to execute in an IBM i CL

Program?

I have a project to access a Vendor Web Site using cURL to upload a

file,

wait till the file is processed and download a resulting file.

I have been provided the cURL Commands for the process.

I've enetered cURL command through a QP2TERM Terminal Session and had
success uploading the data file.

Now I need to script the cURL Command to run from an IBM i CL Program.

The upload command is as follows:

curl -v https://vendorurl.net/import -u'Noreply@xxxxxxxxxxx:Password' -F
data=@/temp/uploaddata_20210226.csv >
/response/response_20210226.json

I believe the problem is caused by the User Id & Password being enclosed
in single quotes.
I've written many dynamic SQL Statements in RPGLE and substituted
parameters in CL Program,
but none of my methods for quoting a string have worked.

Any advice would be appreciated.

Thanks,

Michael Fulmer

------------------------------

Subject: Digest Footer

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/opensource.

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

------------------------------

End of OpenSource Digest, Vol 6, Issue 12
*****************************************