{"uid":"cap_b6BgnFIsdTPguN3fw6IF8","slug":"delx-commerce-csv-left-join-by-key-41080422","name":"Delx Commerce CSV Left Join By Key","description":"Pay-per-result APIs for agents. No signup. Exact price. Verifiable delivery. USDC on Base + Solana via x402.","url":"https://commerce.delx.ai/api/v1/x402/csv-left-join-by-key?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"key":{"type":"string","maxLength":8192,"description":"Key supplied to CSV Left Join By Key; used only for this bounded calculation and processed in memory without retention."},"left":{"type":"string","maxLength":8192,"description":"Left supplied to CSV Left Join By Key; used only for this bounded calculation and processed in memory without retention."},"right":{"type":"string","maxLength":8192,"description":"Right supplied to CSV Left Join By Key; used only for this bounded calculation and processed in memory without retention."}}},"responseSchema":{"type":"json","example":{"result":{"csv":"id,name,score\n1,Ada,10\n2,Lin,","row_count":2},"schema":"delx/util-csv-left-join-by-key/v1","status":"pass","evidence":{"retained":false,"input_sha256":"fc7b0105dea0cd7ff481614e8ba999b4ca60e2975a5ef301fc7efdbece9ea9cc","external_calls":0},"operation":"data_batch:csv_left_join_by_key"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_M8LELyhveslqIge_xsspC","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Performs a left join on two CSV datasets using a specified key column, returning merged rows in-memory without data retention.","exampleAgentPrompt":"I have two CSV datasets — one with user IDs and names, and another with user IDs and scores — can you left-join them on the 'id' column so I get a single merged CSV with all columns?","exampleUseCases":[{"title":"Enrich orders with customer names","prompt":"I have a CSV of orders with a customer_id column, and a separate CSV of customers with id and name columns — can you left-join them on customer_id so each order row also has the customer name?"},{"title":"Merge test scores into student roster","prompt":"I've got a student roster CSV and a separate test-scores CSV, both sharing a student_id field. Can you left-join them on student_id so I get one combined CSV with roster info plus each student's score?"},{"title":"Combine product catalog with inventory data","prompt":"I have a product catalog CSV and an inventory CSV, both with a sku column. Left-join them on sku for me so I can see each product's inventory level alongside its catalog details."}],"resultDescription":"Returns a JSON object containing a merged CSV string (result.csv) with all left-hand rows and matching columns from the right CSV, the total row count, an operation status ('pass'), and a verifiable evidence block confirming no data was retained and no external calls were made (includes input SHA-256 hash).","failureModes":["Missing or mismatched key column name causes empty or null join results","Input CSV strings exceeding 8192 characters are rejected","Malformed CSV input (inconsistent columns, unescaped commas) may cause parse errors","Key column not present in one or both CSVs results in unjoined output","Payment failure via x402 prevents execution"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, pay-per-use, no-signup CSV left join that runs in memory with verifiable non-retention guarantees — ideal for agents handling sensitive tabular data that must not be stored, or when you want exact per-call USDC micropayment pricing without subscription overhead.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-01T00:54:01.490Z","isFirstParty":false,"canonicalSlug":"delx-commerce-csv-left-join-by-key-41080422"}