Forgot password?
Welcome to the SSDT Question and Answer Site!
Or Join with FTT



Another USAS SOAP call question.  Is there some limitation on the number of Vendor records returned on a "queryVendors"?   There "seems" to be... and if there is... how could one go about getting them ALL returned (to say... populate another database)?

Jeff Culwell
asked June 20, 2016 09:36 AM


1 Answer

Best answer


SOAP API's are not intended for batch updates or synchronization.  That is, it's not a download protocol.  The API's are intended for use by applications which are integrating dynamically with USAS, where USAS is the source of the data.

The queryVendors() service defaults to only active vendors and a "maxreturn" value of 100.  You can adjust these parameters in the VendorQueryParams. See: 

However, because the SOAP response is a single message, the service or the VMS process may fail if the number of Vendor's is too large for the ITC's configuration.

Since you are downloading to store in an other database, you would be better off with a batch ETL process.   You could use UDMS or DTR (on OpenVMS), or Safari ODBC (from Windows) to extract the data you need and then transfer it and load it in a separate process.  If this is a regular synchronization process, then the extract and transfer can be automated on the OpenVMS server.

Let us know if you have more questions.


Jodi Becher

Edited Jun 23, 2016 02:00 PM
fix typo
answered June 20, 2016 03:52 PM
Jodi: First... thanks for a pretty good - consistent answer between you and Dave. Eric... our young programmer here... had went to the "contact us" page at your site... and I wasn't sure how well it was monitored... so I slid the same question he asked... in here. Understandable it was written that way... so no problem. We opted to just use the existing SSWAT extracts (for vendor only) to populate what we needed. Thanks again, Jeff Culwell.
Jun 21, 2016 05:33 PM

Your answer

Join with account you already have