Method ExtractOrigination
ExtractOrigination retrieves a loan application in any currently-supported “SBA_ETran” XML version. The loan application may be any you’re allowed to view. And, except for extra-important elements extracted first (“prime keys”, LoanApplication element, etc), elements are generally extracted alphabetically for easy lookup.
What you do with the XML is up to you: Save it as an archive. Learn how to construct various versions of SBA XML. Determine the exact “canonical” spelling of XML elements. Modify it to create a new application. You could even use it to copy production loan applications (caweb.sba.gov) to the test environment (catweb2.sba.gov) for in-house training with realistic data.
SOAP Component: | https://catweb.sba.gov/elend/ws/elend.wsdl |
SOAP Method: | SharedEntryPoint, only input is structure Inputs |
Or: | SharedEntryString, only input is JSON string InputString that decodes to a structure |
REST Component: | /rest/elend/flexible |
REST Method: | /rest/elend/flexible/SharedEntryPoint, only input is structure Inputs |
Or: | /rest/elend/flexible/SharedEntryString, only input is JSON string InputString |
Keys of the Input Structure: | |
Mandatory. Must be “ExtractOrigination”. | |
Mandatory. CLS login’s username with at least read permission in Origination. | |
Mandatory. CLS login’s password with at least read permission in Origination. | |
Mandatory. PIN generated by Generate_PIN using the same login. | |
Mandatory. SBA Application Number of app to be extracted. | |
Mandatory. A private code that authorizes use of SoftwareVendorName. | |
Mandatory. Value from Code Tables, Vendor Table. | |
Optional. Email address of person making the call. | |
Optional. Allows extracting multiple apps in one XML file. (See below.) | |
Optional. Comma-delimited list of option codes. (See below.) | |
Optional. Add a reason attribute to the root tag with this information. Convenience note. | |
Optional. SBA_ETran version number. If absent, the current default version will be used. | |
Optional. Format of ResponseData. XML or JSON | |
Keys of the Output Structure: | |
Should be nullstring. If not, a generally-worded error message. | |
Should be nullstring. If not, a more helpful error message, but scarier to some users. | |
“Yes”, “No”, number of days till expiration or “TBD” (prior to validating login). | |
The extracted XML in SBA_ETran.orig.xsd format (for the version requested). |
For examples of calling flexible, structured methods, see Flexible Structure of Inputs For an explanation of REST calls, see Calling Rest Methods
If ApplicationNumber is given, it overrides ExtractAppList. If ApplicationNumber is not given, ExtractAppList becomes mandatory and must contain a comma-delimited list of SBA application numbers. In either case, the CLS login account must have read access to the requested application(s). When a list is specified, all extracted applications will be contained in a single file, as allowed by the SBA_ETran format.
Currently available ExtractOptions are:- “cmp” – compresses out whitespace between tags. The default is indented, which is more human-readable.
- "env” – adds an attribute to the root tag to indicate environment. Example: <SBA_ETran environment="test">
- “lqd” – extracts LiquidCredit information in LoanApplication, Borrower and Principal elements.
- “oda” – extracts SBA Office of Disaster Assistance information. Only useful with disaster loans.