{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["API Overview","Transfer Endpoints","Account Endpoints","Error Codes","Integration Points"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"API Overview","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1]]}
["Banking Transfer API Specification v4.1"]
["Last Updated: 2023-12-01"]
[]
["Property","Value"]
["Base URL","https://api.bankingsystem.internal/v1"]
["Auth Method","Bearer Token (JWT)"]
["Token Expiry","3600 seconds"]
["Rate Limit","200 req/min per client"]
["Content-Type","application/json"]
["Encoding","UTF-8"]

{"sheet":"Transfer Endpoints","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Endpoint Overview"]
["#","Method","Path","Description","Auth"]
["T-01","POST","/api/transfers","Execute new transfer","Yes"]
["T-02","POST","/api/transfers/{id}/cancel","Cancel transfer","Yes"]
["T-03","GET","/api/transfers/{id}","Get transfer details","Yes"]
[]
["Request Schema — POST /api/transfers"]
["Field","Type","Required","Description"]
["senderAccountNumber","String","Yes","Source account number"]
["receiverAccountNumber","String","Yes","Destination account number"]
["amount","BigDecimal","Yes","Transfer amount > 0"]
["type","String","Yes","DOMESTIC_TRANSFER or INTERNATIONAL_TRANSFER"]
["description","String","No","Transfer memo, max 255 chars"]
[]
["Response Schema — POST /api/transfers"]
["Field","Type","Description"]
["transactionId","Long","Unique transaction ID"]
["status","String","PENDING/COMPLETED/FAILED/CANCELLED"]
["amount","BigDecimal","Transfer amount"]
["fee","BigDecimal","Calculated fee"]
["totalDebited","BigDecimal","Amount + fee"]
["senderBalance","BigDecimal","Remaining balance"]
["timestamp","DateTime","Transaction time"]

{"sheet":"Account Endpoints","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Account Endpoints"]
["#","Method","Path","Description","Auth"]
["A-01","GET","/api/accounts/{num}/balance","Get balance","Yes"]
["A-02","GET","/api/accounts/{num}","Get account details","Yes"]
["A-03","GET","/api/accounts","List all accounts","Yes (Admin)"]
["A-04","POST","/api/accounts","Create account","Yes (Admin)"]
["A-05","POST","/api/accounts/{num}/freeze","Freeze account","Yes (Admin)"]

{"sheet":"Error Codes","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Error Codes"]
["HTTP","Error Code","Message","Notes"]
["400","INVALID_REQUEST","Missing required fields","Validation failure"]
["401","UNAUTHORIZED","Invalid token","Token expired"]
["403","FORBIDDEN","No permission","Role mismatch"]
["404","RESOURCE_NOT_FOUND","Transfer/account not found","ID not found"]
["409","DUPLICATE_TRANSFER","Duplicate reference","Idempotency conflict"]
["422","INSUFFICIENT_BALANCE","Not enough balance","Business rule"]
["422","DAILY_LIMIT_EXCEEDED","Exceeds daily limit","Business rule"]
["422","ACCOUNT_FROZEN","Account frozen","Business rule"]
["500","INTERNAL_ERROR","Unexpected error","Contact support"]

{"sheet":"Integration Points","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Integration Points"]
["System","Type","Direction","Purpose","Status"]
["Core Banking","Internal","Bidirectional","Account/balance ops","Implemented"]
["Fraud Detection","Internal","Outbound","Fraud rule validation","Implemented"]
["Notification Svc","Internal","Outbound","SMS/email alerts","Implemented"]
["Audit Log Svc","Internal","Outbound","Centralized audit","Implemented"]
["Reporting API","Internal","Outbound","Regulatory reporting","Phase 2 (Planned)"]
["SWIFT Gateway","External","Bidirectional","International wires","Phase 2 (Planned)"]
["BI/Analytics","Internal","Outbound","Business intelligence","Phase 2 (Planned)"]