Re: IWS, REST and retrieving variables from QUERY_STRING

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