Method Loan List

Loan List Web Service attempts to input one or more report(s) in a structured format.

API Documentation
REST Method: https://catweb.sba.gov/rest/fta/LoanList/
SOAP Method: https://catweb.sba.gov/ftadistapps/1502gateway/ws/LoanListWS.wsdl
Keys of the Input Structure:
  • CLSUsername
  • Mandatory. CLS login’s username with update permissions in FTA Portal.
  • CLSPassword
  • Mandatory. CLS login’s password with update permissions in FTA Portal.
  • CLSPIN
  • Mandatory. PIN generated by Generate_PIN using the same login.
  • SoftwareVendorCode
  • Mandatory. A private code that authorizes use of SoftwareVendorName.
  • SoftwareVendorName
  • Mandatory. Value from Code Tables, Vendor Table.
  • FormatIn
  • Optional. Format of RequestData, if any. XML or JSON. See Format IN/OUT Defaults
  • FormatOut
  • Optional.“xml” is for XML return format and “json” is for JSON return format.
  • ServiceNme
  • Mandatory. LoanHeader, LoanPayment, Balance (only one option allowed)
  • LoanList
  • Mandatory. See Below for requirements based on ServiceNme chosen
  • LoanHeader (single value). Accepted Type: integer
  • LoanPayment (single value). Accepted Type: integer
  • Balance (multiple values comma delimited). Accepted Type: integer
  • PasswordUpdateRequired
  • Accepted Type: “Yes”, “No”
    Keys of the Output Structure:
  • ResponseData
  • XML or JSON determined with data type submitted.
  • ErrorMessageEnglish
  • Should be nullstring. If not, a generally-worded error message.
  • ErrorMessageTechnical
  • Should be nullstring. If not, a more helpful error message, but scarier to some users.
  • PasswordUpdateRequired
  • “Yes”, “No”. Indicate if this user needs to update the password
  • ServiceNme: LoanHeader
  • GPNUMBER returned type: STRING
  • NOTEDATE returned type: DATE
  • MATURITYDATE returned type: DATE
  • FLOATDATE returned type: DATE
  • SETTLEDATE returned type: DATE
  • PAYMENTFREQ returned type: STRING
  • NETRATEPCT returned type: DECIMAL
  • ORIGINATORPCT returned type: DECIMAL
  • FTAFEEPCT returned type: DECIMAL
  • PREPAYNOTICE returned type: STRING
  • STATUS returned type: INTEGER
  • FLOORPCT returned type: DECIMAL
  • CAPPCT returned type: DECIMAL
  • SPREADPCT returned type: DECIMAL
  • BASIS returned type: DECIMAL
  • GROSSRATEPCT returned type: DECIMAL
  • LENDERFEEPCT returned type: DECIMAL
  • SBAFEEPCT returned type: DECIMAL
  • ORIGFACEAMTOFCERT returned type: DECIMAL
  • ADJUSTMENTFREQUENCY returned type: STRING
  • POSTEDASOF returned type: DATE
  • ERRORCODE returned type: INTEGER
  • COMMENTS returned type: STRING
  • ServiceNme: LoanPayment
  • GPNUMBER returned type: STRING
  • OUTSTANDINGBALANCE returned type: DECIMAL
  • INTFORMDATE returned type: STRING
  • INTTODATE returned type: STRING
  • NUMBEROFDAYS returned type: INTEGER
  • PRINCIPALPAYMENT returned type: DECIMAL
  • INTERESTPAYMENT returned type: DECIMAL
  • TOTALPAYMENT returned type: DECIMAL
  • ORIGINTFEE returned type: DECIMAL
  • ERRORCODE returned type: INTEGER
  • COMMENTS returned type: STRING
  • ServiceNme: Balance
  • SBALOANNO returned type: STRING
  • INTERESTPAIDTODATE returned type: STRING
  • CLOSINGBALANCEAMT returned type: DECIMAL
  • LENDERPCT returned type: DECIMAL
  • ERRORCODE returned type: INTEGER
  • ERRORMESSAGE returned type: STRING