Re: Blocking Excessive API Calls?

The question was raised if there was something on the iSeries that would block excessive calls to a API.

The web server, using ODBC and SQL Stored Procedures, is making these calls to retrieve SKU/ITEM information from the iSeries. From what they are telling me, they get about 20 updates and everything stops.

On 11/02/2021 4:59 PM Nathan Andelin <nandelin@xxxxxxxxx> wrote:


Jay,

The way you're asking your question, and the way you're describing your web
service seems confusing to me. "Blocking Excessive API Calls?"; although
ended with a question mark, that sounds more like a statement. What
software do you suspect might be "blocking" your API calls? Your external
HTTP server? Your PHP server? An external router? What server is doing the
logging that you're referring to?

If we assume that you're referring to your HTTP server and the logs
generated by it, then I would assume that the logs are showing HTTP
"requests"; Not "updates" to the database. Are you saying that only 20
requests appear in the log? That's such a small amount, that it begs the
question, what do you mean by "excessive". Some HTTP sites process
thousands of requests per second. Are you asking about an HTTP
configuration directive that restricts the number of requests?

Nathan.






On Tue, Nov 2, 2021 at 11:51 AM Jay <tegger@xxxxxxxxxxx> wrote:

How does one check to see if a system is blocking excessive API calls?

We have a PHP-based external WEB server that places calls to SQL stored
procedures via ODBC. One call runs several times during the night to update
the WEB version of the master item file. Several thousand records.

Right now, it appears the routine is running, but the web server only sees
about 20 actual updates.

I've gone through all of the logs and have not found anything about
blocking the calls.
--
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://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.

--
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://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.