× 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.



We do not currently support executing multiple SQL statements on one
invocation of the API. However, a SQL statement that calls a stored
procedure may get what you want. The stored procedure can do anything it
wants.

"WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx> wrote on 07/28/2020 02:02:08
PM:

From: Carlos Irigoyen <carlosir@xxxxxxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxxxxxxxx>, Carlos Irigoyen <cirigoyen@xxxxxxxxxx>
Date: 07/28/2020 02:08 PM
Subject: [EXTERNAL] Re: [WEB400] IWS, REST and retrieving variables
from QUERY_STRING
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx>

Hi:
I have a similar situation, but it is in SQL.
I have three SQL statements (Delete,Insert,Load the JSON data Procedures
Name)
My URL is:
https://urldefense.proofpoint.com/v2/url?

u=http-3A__p9-2Ddr-3A10000_web_services_SQLTEST04-5FSecure&d=DwIGaQ&c=jf_iaSHvJObTbx-
siA1ZOg&r=1i-jGlz0-JTK1aLHcsU-

ew&m=ZuPHd0OAAAbZszZxSsWEvh7xRJQJW2S4ADgLlGqIc9Y&s=x4VJ3n1W2sPjZtnzjeepu3ibgRh_K35jkEjFCPJfMY0&e=

I need to run those statements in that sequence as Delete, Insert,
and Load) using the above URL.
How can I do it?
Thanks




On Tuesday, July 28, 2020, 12:51:53 PM CDT, Nadir Amra
<amra@xxxxxxxxxx> wrote:

Hi,

You have two options to getting access to query string variable. The
recommended way is to inject the query string parameter into a
parameter
automatically.

The alternative way is to pass the entire query string as an environment

variable and within your code you would need to issue a getenv() call
and
then parse the query string variable.

Obviously, injecting an input parameter with value of query string
variable is easiest. And this method allows you to specify a default
value as well if not specified.




"WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx> wrote on 07/28/2020
08:45:55
AM:

From: Robert Rogerson <rogersonra@xxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxxxxxxxx>
Date: 07/28/2020 08:46 AM
Subject: [EXTERNAL] [WEB400] IWS, REST and retrieving variables from
QUERY_STRING
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxxxxxxxx>

Hi All,

I'm creating a REST webservice/api and using IWS. I'm then using
Postman
to test the webservice. All the endpoints call procedures in a
service
program..

I have an endpoint /web/server/claims which will call the RPG
procedure
GetAllClaims which returns all claims. I have tested this with
Postman
and it works correctly.

My next step is to add a filter. So I call the same endpoint but this

time
I pass a parameter of whid. So the endpoint now becomes
/web/server/claims/?whid=93 which will call the RPG procedure
GetAllClaims
but this time I need to extract the parameter passed in the
QUERY_STRING
to
return only claims for warehouse 93.

Can someone point me to either documentation or an example of how to
specify and extract from the QUERY_STRING. I've done a lot of
searching
on
Google but I must not be searching on the correct terms because I
can't
find anything on QUERY_STRING other than that you may specify it..




--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?

u=https-3A__lists.midrange.com_mailman_listinfo_web400&d=DwIGaQ&c=jf_iaSHvJObTbx-
siA1ZOg&r=1i-jGlz0-JTK1aLHcsU-

ew&m=ZuPHd0OAAAbZszZxSsWEvh7xRJQJW2S4ADgLlGqIc9Y&s=ACyeOp7YJHOFR6lwCWCc4qiV81fOyOrYXhLEg3rTbp8&e=
or email: WEB400-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?
u=https-3A__archive.midrange.com_web400&d=DwIGaQ&c=jf_iaSHvJObTbx-
siA1ZOg&r=1i-jGlz0-JTK1aLHcsU-
ew&m=ZuPHd0OAAAbZszZxSsWEvh7xRJQJW2S4ADgLlGqIc9Y&s=cQyuEqOTapdAeOZM8Bz-
m2ZWQAJbPkRNRdPRSzTMJqI&e= .


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?

u=https-3A__lists.midrange.com_mailman_listinfo_web400&d=DwIGaQ&c=jf_iaSHvJObTbx-
siA1ZOg&r=1i-jGlz0-JTK1aLHcsU-

ew&m=ZuPHd0OAAAbZszZxSsWEvh7xRJQJW2S4ADgLlGqIc9Y&s=ACyeOp7YJHOFR6lwCWCc4qiV81fOyOrYXhLEg3rTbp8&e=
or email: WEB400-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?
u=https-3A__archive.midrange.com_web400&d=DwIGaQ&c=jf_iaSHvJObTbx-
siA1ZOg&r=1i-jGlz0-JTK1aLHcsU-
ew&m=ZuPHd0OAAAbZszZxSsWEvh7xRJQJW2S4ADgLlGqIc9Y&s=cQyuEqOTapdAeOZM8Bz-
m2ZWQAJbPkRNRdPRSzTMJqI&e= .




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.