Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Maximum Payload Size and limitations for Soap router

Aalokitoaami
Level 3
Level 3

We are using nl/jsp/soaprouter.jsp for creating new records in the database. We are planning to use the xtk:session WriteCollection method and create/update multiple records in one call.

What is the maximum size of request payload the endpoint accepts?

As per the contract, we cam make 50K engine calls per day. So if I merge multiple record insert/updates into one payload, that will be considered as one call. Please confirm.

The methods like write and others accepts the open XML as parameter and thus it is very difficult for the caller to know the actual structure of the payload. Is it possible to generate a wsdl which will expose the attributes of a schema as class properties and some method accepting the class or class collection as parameter to save the records.

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

API calls have no limit in size AFAIK, they're ordinary HTTP POST.

The Update data workflow activity defaults to transaction batches of 10k.

That said, if possible use files for ETL as they are strictly better:

  • Simple, don't need a message bus or specialized code
  • Reliable, doesn't require high availability, files can be checksummed
  • Performant, use bulk load feature of db
  • Auditable, can zip files to look backward in time
  • Free, don't need extra hardware and not subject to license limitation

Thanks,

-Jon

View solution in original post

1 Reply
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

API calls have no limit in size AFAIK, they're ordinary HTTP POST.

The Update data workflow activity defaults to transaction batches of 10k.

That said, if possible use files for ETL as they are strictly better:

  • Simple, don't need a message bus or specialized code
  • Reliable, doesn't require high availability, files can be checksummed
  • Performant, use bulk load feature of db
  • Auditable, can zip files to look backward in time
  • Free, don't need extra hardware and not subject to license limitation

Thanks,

-Jon

View solution in original post