Executing a API curl command from UniBasic

Greg Livingston
Participating Frequently
12 replies
Forum|Forum|4 years ago
September 13, 2021

Hello group!

I should know this but it's not working for me. I'm trying to execute a API curl command from my Unidata Unibasic flavor running HP/UX system. The emulator is wIntegrate but I don't think that matters. What is the correct syntax to execute an API Curl command from my PC? Thanks!

*** This works from command prompt ***
C:\\Users\\gonzalp>curl -o out.json http://www.example.com/index.html
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 26723

*** This does not work from UniBasic ***
STMT = 'curl -o out.json http://www.example.com/index.html'
PCPERFORM STMT

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hi Peter,

The execute or perform statement will execute what is possible at the Unidata command line. In Universe pick i would need to execute the following

On Windows
STMT = "DOS -c 'curl -o out.json www.example.com/index.html'"
PCPERFORM STMT

and Linux

STMT = "SH -c 'curl -o out.json www.example.com/index.html'"
PCPERFORM STMT

------------------------------
greg Livingston
Universe Practice Lead
OUTsurance Insurance
Centurion GA South Africa
------------------------------

+1

Michael Belme
Inspiring
14 replies
Forum|Forum|4 years ago
September 13, 2021

Hello group!

I should know this but it's not working for me. I'm trying to execute a API curl command from my Unidata Unibasic flavor running HP/UX system. The emulator is wIntegrate but I don't think that matters. What is the correct syntax to execute an API Curl command from my PC? Thanks!

*** This works from command prompt ***
C:\\Users\\gonzalp>curl -o out.json http://www.example.com/index.html
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 26723

*** This does not work from UniBasic ***
STMT = 'curl -o out.json http://www.example.com/index.html'
PCPERFORM STMT

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hi Peter,

I gave your program a test on UniData 8.2.3 on Windows. It seems to work and the out.json file will be created at the OS level in the account you run the program from:

:CT BP CURLTEST
BP:

CURLTEST
STMT = "curl -o out.json http://www.example.com/index.html"
PCPERFORM STMT
END:
:RUN BP CURLTEST
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 39250
:

So this should work. My only programming difference is the final 'END' last line. Do you get an error message or just no response? I started with 'curl -V' as the command to make sure I was getting output back first via PCPERFORM before moving on to the request.

We also have the callHTTP extension within UniBASIC if you'd like to run the HTTP request directly in BASIC without the external curl call.

Feel free to open a support case with Rocket if you'd like to discuss further.

Thanks,
Michael Belme
Rocket U2 Support

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

+1

Nik Kesic001
Participating Frequently
29 replies
Forum|Forum|4 years ago
September 14, 2021

Hi Peter,

I gave your program a test on UniData 8.2.3 on Windows. It seems to work and the out.json file will be created at the OS level in the account you run the program from:

:CT BP CURLTEST
BP:

CURLTEST
STMT = "curl -o out.json http://www.example.com/index.html"
PCPERFORM STMT
END:
:RUN BP CURLTEST
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 39250
:

So this should work. My only programming difference is the final 'END' last line. Do you get an error message or just no response? I started with 'curl -V' as the command to make sure I was getting output back first via PCPERFORM before moving on to the request.

We also have the callHTTP extension within UniBASIC if you'd like to run the HTTP request directly in BASIC without the external curl call.

Feel free to open a support case with Rocket if you'd like to discuss further.

Thanks,
Michael Belme
Rocket U2 Support

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

Peter,

This sounds like to me you are having an issue at the HPUX platform.

Have you tried to run your curl command from the HP UNIX shell?

What you could do from your telnet session is:

At the ECL prompt(:) type:

!curl -o out.json Example Domainwww.example.com/index.html

The ! (exclamation) will send you to the UNIX shell and execute the command following the !

------------------------------
Nik Kesic
DevOps
LKQ
NASHVILLE TN United States
------------------------------

Peter Gonzalez001
Author
Participating Frequently
51 replies
Forum|Forum|4 years ago
September 15, 2021

Hi Peter,

The execute or perform statement will execute what is possible at the Unidata command line. In Universe pick i would need to execute the following

On Windows
STMT = "DOS -c 'curl -o out.json www.example.com/index.html'"
PCPERFORM STMT

and Linux

STMT = "SH -c 'curl -o out.json www.example.com/index.html'"
PCPERFORM STMT

------------------------------
greg Livingston
Universe Practice Lead
OUTsurance Insurance
Centurion GA South Africa
------------------------------

Thank you Greg. I was hoping to execute the curl command from the client (pc) not the server. Our HPUX doesn't have curl.

-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Peter Gonzalez001
Author
Participating Frequently
51 replies
Forum|Forum|4 years ago
September 15, 2021

Hi Peter,

I gave your program a test on UniData 8.2.3 on Windows. It seems to work and the out.json file will be created at the OS level in the account you run the program from:

:CT BP CURLTEST
BP:

CURLTEST
STMT = "curl -o out.json http://www.example.com/index.html"
PCPERFORM STMT
END:
:RUN BP CURLTEST
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 39250
:

So this should work. My only programming difference is the final 'END' last line. Do you get an error message or just no response? I started with 'curl -V' as the command to make sure I was getting output back first via PCPERFORM before moving on to the request.

We also have the callHTTP extension within UniBASIC if you'd like to run the HTTP request directly in BASIC without the external curl call.

Feel free to open a support case with Rocket if you'd like to discuss further.

Thanks,
Michael Belme
Rocket U2 Support

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

Michael,
Is you curl command being execute on the Unidata Windows server? I'm trying to execute the curl command on the client side and capture the data there. Would Integrate's WIN.EXPORT WIN.IMPORT do what I'm looking for?

Our version of Unidata HPUX is very old and it does not have the "call..." extensions.

Thanks,
-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Peter Gonzalez001
Author
Participating Frequently
51 replies
Forum|Forum|4 years ago
September 15, 2021

Peter,

This sounds like to me you are having an issue at the HPUX platform.

Have you tried to run your curl command from the HP UNIX shell?

What you could do from your telnet session is:

At the ECL prompt(:) type:

!curl -o out.json Example Domainwww.example.com/index.html

The ! (exclamation) will send you to the UNIX shell and execute the command following the !

------------------------------
Nik Kesic
DevOps
LKQ
NASHVILLE TN United States
------------------------------

Nik,
Our HPUX server does not have curl. maybe I should install curl in the HPUX. I want the curl command to execute at the client level not the server. Thanks.

-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

+1

Nik Kesic001
Participating Frequently
29 replies
Forum|Forum|4 years ago
September 15, 2021

Nik,
Our HPUX server does not have curl. maybe I should install curl in the HPUX. I want the curl command to execute at the client level not the server. Thanks.

-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hello Peter,

I dont have the wIntegrate manual, but I know it is a powerful product with a lot of functions. I am sure Michael Belme can help you figure out which win.prog would trigger a pc event from basic.

------------------------------
Nik Kesic
DevOps
LKQ
NASHVILLE TN United States
------------------------------

+1

Michael Belme
Inspiring
14 replies
Forum|Forum|4 years ago
September 15, 2021

Michael,
Is you curl command being execute on the Unidata Windows server? I'm trying to execute the curl command on the client side and capture the data there. Would Integrate's WIN.EXPORT WIN.IMPORT do what I'm looking for?

Our version of Unidata HPUX is very old and it does not have the "call..." extensions.

Thanks,
-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hi Peter,

Oh I see now... the way you were programming it would have been to run on the server side. In this case to run it on the client side and have it initiated by the host you will definitely have wIntegrate as part of the picture.

Let me spend some time looking into this today and see what I can come up with.

Regards,
Michael

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

+1

Michael Belme
Inspiring
14 replies
Forum|Forum|4 years ago
September 15, 2021

Michael,
Is you curl command being execute on the Unidata Windows server? I'm trying to execute the curl command on the client side and capture the data there. Would Integrate's WIN.EXPORT WIN.IMPORT do what I'm looking for?

Our version of Unidata HPUX is very old and it does not have the "call..." extensions.

Thanks,
-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hi Peter,

I spent some time working on this and came up with something that works. I'm not quite sure how you want this setup to run on the client PC, so just went with what works first.

The BASIC program using the wIntegrate host routines looks like this:

CALL WIN.PCRUN2("C:\\users\\mbelme\\desktop\\curlcommand.bat","",0, RESP)
IF RESP < 32 THEN
PRINT "Failed to run curl, error code: ":RESP
END ELSE PRINT "curl command started"

So when you run this it will launch a Windows batch script on the client PC located on my user's desktop called curlcommand.bat. That batch script is setup like this inside:

@ECHO OFF
echo Running curl command:
echo.
curl.exe -o c:\\users\\mbelme\\desktop\\out.json http://www.example.com/index.html
echo.
cmd.exe /k

It will open a Windows command prompt and run the command on the client moving focus to that window and off wIntegrate. Obviously you can modify that however you want it setup. The last line of 'cmd.exe /k' leaves the command prompt window open. Get rid of that line if you want it to just self-close once it runs. Refer to the wIntegrate Host Subroutines Reference for more info on WIN.PCRUN2.

I tried passing the curl.exe command direct into WIN.PCRUN2, but I couldn't find any combo to get it to run and successfully create that output file. So this was the combo I came up with to get it to run properly. Let me know if you have questions.

Thanks,
Michael

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

Peter Gonzalez001
Author
Participating Frequently
51 replies
Forum|Forum|4 years ago
September 15, 2021

Hi Peter,

I spent some time working on this and came up with something that works. I'm not quite sure how you want this setup to run on the client PC, so just went with what works first.

The BASIC program using the wIntegrate host routines looks like this:

CALL WIN.PCRUN2("C:\\users\\mbelme\\desktop\\curlcommand.bat","",0, RESP)
IF RESP < 32 THEN
PRINT "Failed to run curl, error code: ":RESP
END ELSE PRINT "curl command started"

So when you run this it will launch a Windows batch script on the client PC located on my user's desktop called curlcommand.bat. That batch script is setup like this inside:

@ECHO OFF
echo Running curl command:
echo.
curl.exe -o c:\\users\\mbelme\\desktop\\out.json http://www.example.com/index.html
echo.
cmd.exe /k

It will open a Windows command prompt and run the command on the client moving focus to that window and off wIntegrate. Obviously you can modify that however you want it setup. The last line of 'cmd.exe /k' leaves the command prompt window open. Get rid of that line if you want it to just self-close once it runs. Refer to the wIntegrate Host Subroutines Reference for more info on WIN.PCRUN2.

I tried passing the curl.exe command direct into WIN.PCRUN2, but I couldn't find any combo to get it to run and successfully create that output file. So this was the combo I came up with to get it to run properly. Let me know if you have questions.

Thanks,
Michael

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

Michael,
This is great! That is thinking outside the box. Thank you very much.

So,
1. Build the curlcommand.bat file with UniBasic.
2. Use WIN.PCWRITE curlcommand.bat file on the client's pc drive.
3. Use WIN.PCRUN2 to execute curlcommand.bat.
4. Use WIN.PCREAD to get the output back into Unidata.

I said WIN.PCWRITE and WIN.PCREAD just to simplify the logic, there will be more logic added. I'll post the program when done.

-Peter G

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

+2

Manu Fernandes
Inspiring
257 replies
Forum|Forum|4 years ago
September 16, 2021

Hello group!

I should know this but it's not working for me. I'm trying to execute a API curl command from my Unidata Unibasic flavor running HP/UX system. The emulator is wIntegrate but I don't think that matters. What is the correct syntax to execute an API Curl command from my PC? Thanks!

*** This works from command prompt ***
C:\\Users\\gonzalp>curl -o out.json http://www.example.com/index.html
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1256 100 1256 0 0 1256 0 0:00:01 --:--:-- 0:00:01 26723

*** This does not work from UniBasic ***
STMT = 'curl -o out.json http://www.example.com/index.html'
PCPERFORM STMT

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Hi Peter,

I know you have the solution with wintegrate.
One another option is using the 'CallHTTP' toolset from uniBASIC and then you do not need to deploy curl and you are not client dependant.
Have a look into the documentation UniData/UniBasicExtensionsRefGuide, chapter 2 - using call HTTP

I hope this help

------------------------------
Manu Fernandes
------------------------------

Peter Gonzalez001
Author
Participating Frequently
51 replies
Forum|Forum|4 years ago
September 27, 2021

Hi Peter,

I spent some time working on this and came up with something that works. I'm not quite sure how you want this setup to run on the client PC, so just went with what works first.

The BASIC program using the wIntegrate host routines looks like this:

CALL WIN.PCRUN2("C:\\users\\mbelme\\desktop\\curlcommand.bat","",0, RESP)
IF RESP < 32 THEN
PRINT "Failed to run curl, error code: ":RESP
END ELSE PRINT "curl command started"

So when you run this it will launch a Windows batch script on the client PC located on my user's desktop called curlcommand.bat. That batch script is setup like this inside:

@ECHO OFF
echo Running curl command:
echo.
curl.exe -o c:\\users\\mbelme\\desktop\\out.json http://www.example.com/index.html
echo.
cmd.exe /k

It will open a Windows command prompt and run the command on the client moving focus to that window and off wIntegrate. Obviously you can modify that however you want it setup. The last line of 'cmd.exe /k' leaves the command prompt window open. Get rid of that line if you want it to just self-close once it runs. Refer to the wIntegrate Host Subroutines Reference for more info on WIN.PCRUN2.

I tried passing the curl.exe command direct into WIN.PCRUN2, but I couldn't find any combo to get it to run and successfully create that output file. So this was the combo I came up with to get it to run properly. Let me know if you have questions.

Thanks,
Michael

------------------------------
Michael Belme
Technical Support
Rocket Internal - All Brands
DENVER CO United States
------------------------------

Michael and others,
Below is the UniBasic program using wIntegrate calls that will execute a Curl command and retrieve a json file from a website. The results.json is placed in a newly created Pie_Downloads directory. Note: directories can't have a blank space in the name. From this point on you can access the results.json file and do as you want locally on the client.

-Peter G

PATHNAME = "C:\\Pie_Downloads"
FILENAME = "CURLCOMMAND.BAT"

STMT = ""
STMT<-1> = "@ECHO OFF"
STMT<-1> = "echo Running curl command:"
STMT<-1> = "echo."
STMT<-1> = "curl.exe -o ":PATHNAME:"\\results.json http://www.example.com/index.html"
STMT<-1> = "echo."
STMT<-1> = "cmd.exe /k"
*
* Verify that the Download folder is there.
*
CALL WIN.PCDIR(PATHNAME, FOUND)
IF NOT(FOUND) THEN
*
* Create The "Download Folder" If Not Found.
*
CALL WIN.PCMKDIR(PATHNAME)
END
*
* Opens The File Or Creates The File.
*
CALL WIN.PCOPEN("CURL", PATHNAME:"\\":FILENAME, FOUND)
IF NOT(FOUND) THEN
*
* Create The "CURLCOMMAND.BAT" If Not Found.
*
CALL WIN.PCCREATE(PATHNAME:"\\":FILENAME)
*
* Opens The File Or Creates The File.
*
CALL WIN.PCOPEN("CURL", PATHNAME:"\\":FILENAME, FOUND)
END
*
* Writes The Contents To The File.
*
CALL WIN.PCWRITE("CURL", STMT, "TEXT") ;* "TEXT" Swaps a crlf
*
* Closes The File. - Very Important
*
CALL WIN.PCCLOSE("CURL")
*
* Execute The Bat Program.
*
CALL WIN.PCRUN2(PATHNAME:"\\":FILENAME, "", 0, RESP)

STOP

------------------------------
Peter Gonzalez
programmer
Self Registered
University City MO United States
------------------------------

Sign up

Please log in or register:

Welcome to the Rocket Forum!

Please log in or register:

Scanning file for viruses.

This file cannot be downloaded