{"content":[{"text":"/sandbox/repo\ntotal 16\ndrwxr-xr-x 3 root root 4096 Sep 18 08:00 .\ndrwxr-xr-x 7 root root 4096 Sep 29 08:19 ..\ndrwxr-xr-x 8 root root 4096 Sep 24 20:05 .git\n-rw-r--r-- 1 root root  408 Sep 18 08:00 .gitignore\n","type":"text"}]}

{"content":[{"text":"Package                                      Version\n-------------------------------------------- -----------\naiofile                                      3.12.3\naiofiles                                     25.1.0\naiohappyeyeballs                             2.7.1\naiohttp                                      3.14.3\naiohttp-retry                                2.9.1\naiosignal                                    1.4.0\naiosqlite                                    0.22.1\nannotated-doc                                0.0.5\nannotated-types                              0.8.0\nanthropic                                    0.122.0\nanyio                                        4.14.2\nargcomplete                                  3.7.2\nasgiref                                      3.12.1\nattrs                                        26.1.0\nAuthlib                                      1.8.0\nbanks                                        2.5.0\nbeartype                                     0.22.9\nbeautifulsoup4                               4.15.0\nbidict                                       0.24.1\nblack                                        26.5.1\nblinker                                      1.9.0\ncachetools                                   7.1.7\ncaio                                         0.12.2\ncertifi                                      2026.7.22\ncffi                                         2.1.1\ncharset-normalizer                           3.5.1\nclaude-agent-sdk                             0.2.139\nclick                                        8.5.0\n---\n/usr/local/lib\n├── @anthropic-ai/claude-code@2.1.280\n├── @earendil-works/pi-coding-agent@0.84.2\n├── @openai/codex@0.142.5\n├── corepack@0.34.6\n└── npm@10.9.8\n\n---\n/usr/local/bin/python3\n/usr/local/bin/node\n/usr/local/go/bin/go\n---\n404\n","type":"text"}]}

{"content":[{"text":"column (0.4.3)\nAvailable versions: 0.4.3, 0.3.4, 0.3.0, 0.2.0\n---\nERROR: Could not find a version that satisfies the requirement column-python (from versions: none)\nERROR: No matching distribution found for column-python\n","type":"text"}]}

{"content":[{"text":"{\n  \"code\": \"resource_not_found\",\n  \"details\": {},\n  \"documentation_url\": \"https://docs.column.com/working-with-the-api/errors\",\n  \"message\": \"This API endpoint does not exist.\",\n  \"type\": \"server_error\"\n}\n---\nHTTP/2 200 \r\ncontent-type: text/html\r\ncontent-length: 881428\r\ndate: Tue, 29 Sep 2026 08:19:55 GMT\r\nlast-modified: Mon, 28 Sep 2026 22:21:10 GMT\r\n","type":"text"}]}

timeout 20 pip download column==0.4.3 --no-deps --no-binary :all: -d /tmp/col 2>&1 | tail -2; ls /tmp/col 2>/dev/null; timeout 20 python3 -c "
import json,urllib.request
d=json.load(urllib.request.urlopen('https://pypi.org/pypi/column/json'))
i=d['info']
print(i['name'],i['version']);print(i['summary']);print(i['home_page'],i.get('project_urls'));print((i['description'] or '')[:800])"

{"content":[{"text":"Saved /tmp/col/column-0.4.3.tar.gz\nSuccessfully downloaded column\ncolumn-0.4.3.tar.gz\ncolumn 0.5.1\nA thin wrapper on top of ansible with a stable API.\nhttps://github.com/vmware/column {'Homepage': 'https://github.com/vmware/column'}\ncolumn is a thin wrapper on top of ansible API, to serve\nas an entry point for other code when ansible is needed. As ansible\ninternal API is not officially exposed and thus changes are very likely,\nthis wrapper should be used instead of touching ansible directly,\nso that any further ansible API change will only incur change in this module.\n\nIt exposes two classes:\ncolumn.APIRunner and column.SubprocessRunner\n\nBoth of them implement API described in column.Runner.\nEach runner expose two public methods:\nrun_playbook() and run_module().\n\n\n\n","type":"text"}]}

timeout 15 curl -sS https://docs.column.com/ 2>&1 | head -c 300; echo; echo ===; timeout 15 curl -sSL https://column.com/pricing 2>&1 | python3 -c "import sys,re,html;t=sys.stdin.read();t=re.sub(r'<script.*?</script>','',t,flags=re.S);t=re.sub(r'<style.*?</style>','',t,flags=re.S);t=re.sub(r'<[^>]+>',' ',t);t=html.unescape(t);print(re.sub(r'\s+',' ',t)[:3000])"

{"content":[{"text":"<!DOCTYPE html><!--4Sv7UzNlm79OTQTjhqCZo--><html lang=\"en\"><head><meta charSet=\"utf-8\"/><meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"/><link rel=\"preload\" as=\"image\" href=\"/images/guide-getting-started.svg\"/><link rel=\"preload\" as=\"image\" href=\"/images/guide-getting-started-dar\n===\n \n","type":"text"}]}

for u in https://column.com/pricing https://docs.column.com/quickstart https://docs.column.com/api; do echo "== $u"; timeout 15 curl -sSL -o /tmp/p.html -w '%{http_code} %{size_download}\n' $u; python3 - <<'EOF'
import re,html
t=open('/tmp/p.html',encoding='utf8',errors='replace').read()
t=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
t=re.sub(r'<[^>]+>',' ',t); t=html.unescape(t)
print(re.sub(r'\s+',' ',t)[:1500])
EOF
done

{"content":[{"text":"== https://column.com/pricing\n200 50\n \n== https://docs.column.com/quickstart\n404 407689\n Column Documentation Docs Documentation ⌘ K Suggested Guides Getting Started Build a basic payment workflow consisting of a wire, a book transfer, and an ACH credit with Column's APIs. Guides Payment Origination Originate wires, ACH and book transfers, and store money in an FBO account for your customers. Guides Bank Accounts Programmatically open and manage FDIC insured bank accounts at Column on behalf of your customers. We support FBO, sweep, clearing and custom account types. Guides Search ⌘ K Sign in Get started Home Guides Overview Common workflows Book Transfers and Holds Overdrafts Two Legged Transactions Going live Technical guides Getting Started Sandbox and Testing Reporting KYC/KYB Verifications Use cases Payment Origination Bank Accounts Card Programs Loan Origination Informational guides Intro to Card Issuing Roles & Permissions API Key Security Bank Statements Working with the API Authentication Pagination Idempotency Errors Events and Webhooks Data Models Platform Entity Bank Account Account Number Counterparty Transfer Events and Webhooks Entities Overview Managing Entities Documentary Evidence ACH Overview Types Timing Notifications and States Returns Reversals International ACH Transfers Domestic Wire Overview Notifications and States Reversals Return Requests Wire Drawdown Requests International Wires Overview Outgoing Transfers Incoming Transfers Notifications and States Transfer Fees Returns Cancellations Tracking Supported Currencies Country-Specific D\n== https://docs.column.com/api\n200 474631\n API Reference | Column Docs Docs Documentation ⌘ K Suggested Guides Getting Started Build a basic payment workflow consisting of a wire, a book transfer, and an ACH credit with Column's APIs. Guides Payment Origination Originate wires, ACH and book transfers, and store money in an FBO account for your customers. Guides Bank Accounts Programmatically open and manage FDIC insured bank accounts at Column on behalf of your customers. We support FBO, sweep, clearing and custom account types. Guides Search ⌘ K Sign in Get started Home Guides Overview Common workflows Book Transfers and Holds Overdrafts Two Legged Transactions Going live Technical guides Getting Started Sandbox and Testing Reporting KYC/KYB Verifications Use cases Payment Origination Bank Accounts Card Programs Loan Origination Informational guides Intro to Card Issuing Roles & Permissions API Key Security Bank Statements Working with the API Authentication Pagination Idempotency Errors Events and Webhooks Data Models Platform Entity Bank Account Account Number Counterparty Transfer Events and Webhooks Entities Overview Managing Entities Documentary Evidence ACH Overview Types Timing Notifications and States Returns Reversals International ACH Transfers Domestic Wire Overview Notifications and States Reversals Return Requests Wire Drawdown Requests International Wires Overview Outgoing Transfers Incoming Transfers Notifications and States Transfer Fees Returns Cancellations Tracking Supported Currencies Country-Spe\n","type":"text"}]}

for u in https://docs.column.com/openapi.json https://api.column.com/openapi.json https://docs.column.com/api/openapi.json; do echo "== $u"; timeout 12 curl -sSL -o /tmp/o -w '%{http_code} %{size_download} %{content_type}\n' $u; head -c 200 /tmp/o; echo; done

{"content":[{"text":"== https://docs.column.com/openapi.json\n200 1127971 application/json\n{\n  \"openapi\": \"3.0.3\",\n  \"info\": {\n    \"title\": \"Column API\",\n    \"version\": \"1.4\",\n    \"contact\": {\n      \"name\": \"Column\",\n      \"url\": \"https://column.com\",\n      \"email\": \"support@column.com\"\n   \n== https://api.column.com/openapi.json\n404 205 application/json; charset=utf-8\n{\n  \"code\": \"resource_not_found\",\n  \"details\": {},\n  \"documentation_url\": \"https://docs.column.com/working-with-the-api/errors\",\n  \"message\": \"This API endpoint does not exist.\",\n  \"type\": \"server_err\n== https://docs.column.com/api/openapi.json\n404 407689 text/html\n<!DOCTYPE html><!--4Sv7UzNlm79OTQTjhqCZo--><html lang=\"en\"><head><meta charSet=\"utf-8\"/><meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"/><link rel=\"stylesheet\" href=\"/_next/static/\n","type":"text"}]}

timeout 15 curl -sSL 'https://column.com/pricing' -o /tmp/pr.html -w '%{http_code} %{size_download} %{url_effective}\n'; cat /tmp/pr.html | head -c 200; echo; timeout 15 curl -sSL 'https://column.com' -o /tmp/home.html -w '%{http_code} %{size_download}\n'; python3 - <<'EOF'
import re,html,json
t=open('/tmp/home.html',encoding='utf8',errors='replace').read()
# look for pricing keywords
for m in re.finditer(r'.{200}(?:pricing|Pricing|per wire|per transfer|\$\d).{300}', t):
    pass
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
i=tt.lower().find('pricing')
print(tt[max(0,i-200):i+2500] if i>=0 else 'no pricing word; len='+str(len(tt)))
EOF

{"content":[{"text":"200 50 https://column.com/pricing\n<meta http-equiv=\"refresh\" content=\"0; URL='/'\" />\n200 881428\nno pricing word; len=13567\n","type":"text"}]}

timeout 15 curl -sSL 'https://docs.column.com/getting-started' -o /tmp/gs.html -w '%{http_code}\n'; python3 - <<'EOF'
import re,html
t=open('/tmp/gs.html',encoding='utf8',errors='replace').read()
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
i=tt.find('Getting Started')
print(tt[i:i+3000])
EOF

{"content":[{"text":"404\nGetting Started Build a basic payment workflow consisting of a wire, a book transfer, and an ACH credit with Column's APIs. Guides Payment Origination Originate wires, ACH and book transfers, and store money in an FBO account for your customers. Guides Bank Accounts Programmatically open and manage FDIC insured bank accounts at Column on behalf of your customers. We support FBO, sweep, clearing and custom account types. Guides Search ⌘ K Sign in Get started Home Guides Overview Common workflows Book Transfers and Holds Overdrafts Two Legged Transactions Going live Technical guides Getting Started Sandbox and Testing Reporting KYC/KYB Verifications Use cases Payment Origination Bank Accounts Card Programs Loan Origination Informational guides Intro to Card Issuing Roles & Permissions API Key Security Bank Statements Working with the API Authentication Pagination Idempotency Errors Events and Webhooks Data Models Platform Entity Bank Account Account Number Counterparty Transfer Events and Webhooks Entities Overview Managing Entities Documentary Evidence ACH Overview Types Timing Notifications and States Returns Reversals International ACH Transfers Domestic Wire Overview Notifications and States Reversals Return Requests Wire Drawdown Requests International Wires Overview Outgoing Transfers Incoming Transfers Notifications and States Transfer Fees Returns Cancellations Tracking Supported Currencies Country-Specific Details Sandbox Simulations Realtime Payments Overview Outgoing Transfers Incoming Transfers Returns Notifications and States Request For Payment (RFP) Checks Overview Issuing, Printing, and Mailing Deposits Lockboxes Notifications and States Returns Loans Overview Disbursements Payments Sales and Reports Card Issuing Overview Card Programs Card Accounts Cards Card Authorization Policies Card Transactions Real-time Decisioning Card Tokens Card Sandbox Simulation API Reference Entity Overview Person Person entity object Create a person entity Update a person entity Business Business entity object Create a business entity Update a business entity General List all entities Get an entity by ID Delete an entity Get entity compliance Get entity evidence Create entity evidence Get additional requirements Submit additional requirements List associated persons Link an associated person Update associated persons Create evidence with file upload Narratives Create an entity narrative List entity narratives Delete an entity narrative Bank Account Overview Bank account object Create a new bank account List all bank accounts Get a bank account by ID Update a bank account Add a bank account owner Delete a bank account Bank account overdraft alert object Summary Bank account summary object Get bank account summary history Account Number Overview Account number object Create a new account number List all account numbers from a bank account Get an account number Update an account number Loans Overview Loan object Create a new loan List all loans Get a loan\n","type":"text"}]}

python3 - <<'EOF'
import re,html
t=open('/tmp/home.html',encoding='utf8',errors='replace').read()
# strip tags but keep scripts separately
body=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
body=re.sub(r'<[^>]+>',' ',body); body=html.unescape(body); body=re.sub(r'\s+',' ',body)
print("BODY:", body[:2000])
scripts=re.findall(r'<script.*?</script>',t,flags=re.S)
hits=[]
for s in scripts:
    for m in re.finditer(r'[^\"]{0,120}(?:per wire|ACH|price|Price|\$\d+)[^\"]{0,160}', s):
        hits.append(m.group(0))
print(len(hits))
for h in hits[:40]: print('-',h[:250])
EOF

{"content":[{"text":"BODY:  Column | The platform bank built for scale Announcing four new products. Four new products. Watch the keynote. Products Developers Blog Company Sign in Get started Contact sales Come and say hello. Create an account Start building in sandbox. Column NA Member FDIC Move, hold, and lend the dollar at scale The only nationally chartered bank designed to help you build and fund new financial products Sign up Documentation Operating Account New York, NY $10,293.29 USD John Doe London, UK £9,102.07 GBP Completed International Wire Outgoing { \"account_number_id\" : \"acno_2F37RhDUnWtB4GD9JXQEDYu7YAY\" , \"allow_overdraft\" : false , \"amount\" : 1029329 , \"bank_account_id\" : \"bacc_2F37RbG3NZAr7Yn2d1i5hITz9O4\" , \"beneficiary_account_number\" : \"10293297890\" , \"beneficiary_address\" : { \"city\" : \"London\" , \"country_code\" : \"GB\" , \"line_1\" : \"123 Threadneedle Street\" , \"line_2\" : \"\" , \"postal_code\" : \"EC2R 8AH\" , \"state\" : \"\" } , \"beneficiary_fi\" : \"HBUKGB4B\" , \"beneficiary_name\" : \"John Doe\" , \"charge_bearer\" : \"SHAR\" , \"charges\" : null , \"completed_at\" : null , \"counterparty_id\" : \"cpty_2ESSJPnpof38GraQR5C6EnfFGKw\" , \"created_at\" : \"2025-10-26T21:55:31Z\" , \"currency_code\" : \"USD\" , \"description\" : \"Swift transfer with GBP\" , \"end_to_end_id\" : \"\" , \"fx_quote_id\" : \"fxqt_2F3BY6XCpKQUy5cGCqPgLf3Kit7\" , \"fx_rate\" : \"6.872100000\" , \"id\" : \"swft_2F3BYA9aMdHag8iUtsDE8ji0KOK\" , \"idempotency_key\" : null , \"initiated_at\" : \"2025-10-26T21:55:31Z\" , \"instructed_amount\" : 1029329 , \"instructed_currency_code\" : \"GBP\" , \"instruction_id\" : \"XF7MBKI09TUNZXIL\" , \"instruction_to_beneficiary_fi\" : \"please contact with the beneficiary before releasing the funds\" , \"is_incoming\" : false , \"manual_review_at\" : null , \"originator_account_number\" : \"366763686659680\" , \"originator_address\" : { \"city\" : \"San Francisco\" , \"country_code\" : \"US\" , \"line_1\" : \"12345 Mission St.\" , \"line_2\" : \"\" , \"postal_code\" : \"94016\" , \"state\" : \"CA\" } , \"originator_fi\" : \"CLNOUS66\" , \"originator_name\" : \"Alice Grant\" , \"pend\n0\n","type":"text"}]}

{"content":[{"text":"href=\"/api/card-authorization-policy/\"\nhref=\"/api/card-authorization-policy/card-authorization-policy-config-sub-object/\"\nhref=\"/api/card-authorization-policy/card-authorization-policy-version-object/\"\nhref=\"/api/card-authorization-policy/card-spend-policy-sub-object/\"\nhref=\"/api/card-authorization-policy/create-card-authorization-policy-version/\"\nhref=\"/api/card-authorization-policy/create-card-authorization-policy/\"\nhref=\"/api/card-authorization-policy/delete-card-authorization-policy-version/\"\nhref=\"/api/card-authorization-policy/get-card-authorization-policy-version/\"\nhref=\"/api/card-authorization-policy/list-card-authorization-policy-versions/\"\nhref=\"/api/card-authorization-policy/update-card-authorization-policy-version/\"\nhref=\"/api/card-real-time-decisioning/3ds-authentication-decision-request-object/\"\nhref=\"/api/card-real-time-decisioning/3ds-authentication-decision-response-object/\"\nhref=\"/api/card-real-time-decisioning/3ds-data-only-authentication-object/\"\nhref=\"/api/simulation/close-sandbox-card-program/\"\nhref=\"/api/simulation/create-sandbox-card-program/\"\nhref=\"/api/simulation/simulate-3ds-authentication/\"\nhref=\"/api/simulation/simulate-card-authorization/\"\nhref=\"/api/simulation/simulate-incremental-authorization/\"\nhref=\"/card-issuing/card-authorization-policies/\"\nhref=\"/card-issuing/card-sandbox-simulation/\"\n","type":"text"}]}

grep -oE 'href="/[^"]*"' /tmp/gs.html | sort -u | grep -iE 'getting|technical|sandbox-and|going-live' | head; echo ===; grep -c 'pricing' /tmp/home.html; grep -oE '.{100}pricing.{200}' /tmp/home.html | head -5

timeout 15 curl -sSL 'https://column.com/developers' -o /tmp/dev.html -w '%{http_code} %{size_download}\n'; python3 - <<'EOF'
import re,html
t=open('/tmp/dev.html',encoding='utf8',errors='replace').read()
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
print(tt[:2500])
EOF

{"content":[{"text":"404 219049\n Page not found | Column Announcing four new products. Four new products. Watch the keynote. Products Developers Blog Company Sign in Get started Contact sales Come and say hello. Create an account Start building in sandbox. Page not found We weren't able to find what you are looking for. Go home. Products ACH Wire Realtime Book Transfers Checks Bank Accounts Loan Origination Loan Purchase Debt Financing Card Programs Card Issuing Stablecoins Global Banking Multicurrency Developers Documentation Changelog Company About Blog Careers Press Security Privacy Notice Column N.A. Member FDIC Privacy Notice Privacy Policy \n","type":"text"}]}

timeout 15 curl -sSL 'https://docs.column.com/guides/getting-started/' -o /tmp/gs2.html -w '%{http_code}\n'; python3 - <<'EOF'
import re,html
t=open('/tmp/gs2.html',encoding='utf8',errors='replace').read()
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
i=tt.find('Create an account')
if i<0: i=tt.find('Getting Started', 3000)
print(tt[i:i+3500])
EOF

{"content":[{"text":"200\nGetting Started Sandbox and Testing Reporting KYC/KYB Verifications Use cases Payment Origination Bank Accounts Card Programs Loan Origination Informational guides Intro to Card Issuing Roles & Permissions API Key Security Bank Statements Working with the API Authentication Pagination Idempotency Errors Events and Webhooks Data Models Platform Entity Bank Account Account Number Counterparty Transfer Events and Webhooks Entities Overview Managing Entities Documentary Evidence ACH Overview Types Timing Notifications and States Returns Reversals International ACH Transfers Domestic Wire Overview Notifications and States Reversals Return Requests Wire Drawdown Requests International Wires Overview Outgoing Transfers Incoming Transfers Notifications and States Transfer Fees Returns Cancellations Tracking Supported Currencies Country-Specific Details Sandbox Simulations Realtime Payments Overview Outgoing Transfers Incoming Transfers Returns Notifications and States Request For Payment (RFP) Checks Overview Issuing, Printing, and Mailing Deposits Lockboxes Notifications and States Returns Loans Overview Disbursements Payments Sales and Reports Card Issuing Overview Card Programs Card Accounts Cards Card Authorization Policies Card Transactions Real-time Decisioning Card Tokens Card Sandbox Simulation API Reference Entity Overview Person Person entity object Create a person entity Update a person entity Business Business entity object Create a business entity Update a business entity General List all entities Get an entity by ID Delete an entity Get entity compliance Get entity evidence Create entity evidence Get additional requirements Submit additional requirements List associated persons Link an associated person Update associated persons Create evidence with file upload Narratives Create an entity narrative List entity narratives Delete an entity narrative Bank Account Overview Bank account object Create a new bank account List all bank accounts Get a bank account by ID Update a bank account Add a bank account owner Delete a bank account Bank account overdraft alert object Summary Bank account summary object Get bank account summary history Account Number Overview Account number object Create a new account number List all account numbers from a bank account Get an account number Update an account number Loans Overview Loan object Create a new loan List all loans Get a loan by ID Update a loan Loan Programs Loan program object List loan programs Get a loan program Update loan program Loan Summary Loan summary object Get loan summary history Disbursements Loan disbursement object Create a disbursement List all disbursements Get a disbursement Update a disbursement hold Cancel a disbursement hold Clear a disbursement hold Payments Loan payment object Create a payment List all payments Get a payment Return a payment Loan Sales Loan sale object Create a loan sale List all loan sales Get a loan sale Loan sale summary object Get loan sale summaries for loans available for sale Get loan sale summaries for loans already sold Counterparty Overview Counterparty object Create a counterparty List all counterparties Get a counterparty by ID Delete a counterparty IBAN validation object Validate an IBAN Financial Institutions Financial institution object List financial institutions Get a financial institution ACH Transfer Overview ACH transfer object IAT transfer sub-object Create an ACH transfer List all ACH transfers Get an ACH transfer Cancel an ACH tr\n","type":"text"}]}

python3 - <<'EOF'
import re,html
t=open('/tmp/gs2.html',encoding='utf8',errors='replace').read()
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
i=tt.find('Build a basic payment workflow', 3000)
print(tt[i:i+4000] if i>=0 else tt[-4000:])
EOF

{"content":[{"text":"o \" \\ -d \" address[state] \" = \" CA \" \\ -d \" address[postal_code] \" = \" 94123 \" \\ -d \" address[country_code] \" = \" USA \" Create account Next, you are going to create an account that will be attached to the entity . You'll receive an entity_id from the create entity response that will be used to create accounts. curl https://api.column.com/bank-accounts \\ -XPOST \\ -u : < YOUR API KE Y > \\ -d entity_id= < entity_i d > \\ -d description= \" Andrew road-trip account \" Now, you have a bank account that you can move (well fake, since you're using your test api key) money in and out of! In the response to create account you'll receive a default_account_number and routing_number . These will be used to externally identify your account for transfers. Every account is created with a default_account_number , however you can create multiple account numbers that are associated with this account. You can view them as pointers to that bank account - however, they are all valid account numbers that you can send ACH and Wires from. You can create and remove them without interfering with the underlying bank account. Simulate an incoming wire transfer Now that we have a bank account, let's send some money to it! Our sandbox environment has several endpoints you can use to simulate an incoming ACH or Wire transfer. For now, let's receive an incoming wire of $1,000 (or 100,000 cents). The behavior is identical to what would happen if an account at another bank sent a wire to your account and routing number. curl https://api.column.com/simulate/receive-wire \\ -u : < YOUR API KE Y > \\ -d destination_account_number_id= < acno_i d > \\ -d amount= 100000 \\ -d currency_code=USD Any endpoint in the /simulate/* routes are used for simulating production behaviors and will NOT be available in production. You should now have a balance on your account. To confirm the balance on your account, feel free to send a GET request using your bank_account_id as shown below. curl https://api.column.com/bank-accounts/ < bank_account_i d > \\ -u : < YOUR API KE Y > Create counterparty A counterparty is an external account that you can transfer money to and from. All ACH and Wire transfers originated by Column take in a counterparty_id to identify the destination. Let's create a counterparty we can transfer to. curl https://api.column.com/counterparties \\ -u : < YOUR API KE Y > \\ -d account_number= 87654321 \\ -d routing_number= 121044055 Now that you created a counterparty - you can send money to it (or pull from it)! A counterparty stores an external bank account and can also store additional transaction detail, as desired or required. For example, an IAT (International ACH Transfer) and a wire transfer legally require information about the receiving party. You'll add this to the counterparty request. Note: for a domestic ACH transaction you only need to put in a valid account and routing number. Create ACH credit transfer Let's send $400 to our counterparty through an ACH Credit request. An ACH credit is when you push money from your account to an external account. Insert the counterparty_id from the last request and the bank_account_id of your account. Money will move from your account to the counterparty account. curl https://api.column.com/transfers/ach \\ -XPOST \\ -u : < YOUR API KE Y > \\ -d counterparty_id= < cpty_i d > \\ -d bank_account_id= < bacc_i d > \\ -d type=CREDIT \\ -d amount= 40000 \\ -d currency_code=USD \\ -d description= \" payment \" Congrats on your first outgoing transfer! You'll receive a webhook to remain updated as the ACH transfer goes through every step of the process and finally settles in the destination account. Note that ACHs usually take two business days to settle. If you want to speed up the settlement process for your own testing, take a look at our Settle ACH Transfer endpoint in our sandbox. If you want to start originating payments in production right away, check out our Payment Origination use case. Previous Going live Next Sandbox and Testing \n","type":"text"}]}

for p in ach wire book-transfers bank-accounts; do echo "== $p"; timeout 12 curl -sSL "https://column.com/$p" -o /tmp/pp.html -w '%{http_code}\n'; python3 - <<EOF
import re,html
t=open('/tmp/pp.html',encoding='utf8',errors='replace').read()
tt=re.sub(r'<(script|style).*?</\1>','',t,flags=re.S)
tt=re.sub(r'<[^>]+>',' ',tt); tt=html.unescape(tt); tt=re.sub(r'\s+',' ',tt)
for kw in ['pricing','per ','fee','\$']:
    i=tt.lower().find(kw.lower())
    if i>=0: print(kw,'->',tt[max(0,i-80):i+200]); break
else: print('no pricing keywords')
EOF
done

{"content":[{"text":"== ach\n200\nper  -> unts for your customers in one API call. All from our robust, easy to use developer platform. Learn more Card Programs Build a customized card program that fits your stage. With a dedicated BIN and the choice of issuing processors, you maintain control. Learn more Checks Take ful\n== wire\n200\nper  -> rocess every second the Federal Reserve is open , unlike legacy banks. 22 Hours Per day 5 Days Per week Initiate the wire transfer curl 'https://api.column.com/transfers/wire' \\ -XPOST \\ -u : < YOUR API KEY > \\ -d description = \"Example wire transfer\" \\ -d amount = 10000 \\ -d cur\n== book-transfers\n200\nper  -> unts for your customers in one API call. All from our robust, easy to use developer platform. Learn more Card Programs Build a customized card program that fits your stage. With a dedicated BIN and the choice of issuing processors, you maintain control. Learn more Checks Take ful\n== bank-accounts\n200\nper  -> unts for your customers in one API call. All from our robust, easy to use developer platform. Start building Documentation Bank Account House fund Savings - 2919 $62,703.32 Available balance Available $62,703.32 Pending $2,958.92 Locked $0 Created January, 23 2022 { \"id\" : \"strin\n","type":"text"}]}

cd /sandbox/repo && python3 column_example.py; echo "exit=$?"; echo ---; COLUMN_API_KEY=test_fake_key timeout 20 python3 -c "
from column_example import ColumnClient, ColumnError
c = ColumnClient('test_fake_key')
try:
    c.get('bank-accounts')
except ColumnError as e:
    print('got expected error:', e)
"

{"content":[{"text":"COLUMN_API_KEY is not set.\nCreate a (free) sandbox account at https://dashboard.column.com, grab your test API key, then:\n  export COLUMN_API_KEY=<key> && python3 column_example.py\nexit=1\n---\ngot expected error: Column API error 401: {'raw': ''}\n","type":"text"}]}