{"uid":"cap_dqx12MfdE6BiW_v1TIye5","slug":"delx-commerce-csv-join-by-key-88e711bc","name":"Delx Commerce — CSV 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-join-by-key?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"key":{"type":"string","maxLength":8192,"description":"Key supplied to CSV 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 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 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","row_count":1},"schema":"delx/util-csv-join-by-key/v1","status":"pass","evidence":{"retained":false,"input_sha256":"57022525cee3a1a6a7c28356dba473bc310bef220434f10ff449553cbb91cf73","external_calls":0},"operation":"data_batch:csv_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_ZtjqxD12xoWJugmBAU00c","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":"Joins two CSV datasets on a shared key column and returns the merged CSV result with row count.","exampleAgentPrompt":"I have two CSV tables I need joined on the 'id' column — the left table has id,name and the right has id,score — can you merge them together and give me the combined CSV?","exampleUseCases":[{"title":"Merge product catalog with pricing data","prompt":"I have a product catalog CSV with columns id,name and a separate pricing CSV with id,price — join them on 'id' so I get a single CSV with all three columns."},{"title":"Enrich customer list with order history","prompt":"Take my customer CSV (customer_id,email) and my orders CSV (customer_id,total_spent) and merge them on 'customer_id' so I can see each customer's email alongside their spend."},{"title":"Combine survey responses with user profiles","prompt":"I've got two CSVs — one with user_id,username and another with user_id,survey_score — join them on 'user_id' and give me the full merged table."}],"resultDescription":"Returns a JSON object containing the merged CSV string, the row count of the result, the operation name, a status field ('pass'), and an evidence block confirming no data was retained and providing a SHA-256 hash of the input for verifiability.","failureModes":["Missing or mismatched key column across left and right CSVs results in zero-row output","Input exceeding 8192 character limit per field is rejected","Malformed CSV (unbalanced quotes, inconsistent columns) may produce unexpected join results","Payment failure (insufficient USDC) results in 402 response before processing","Key field name not present in one or both CSVs produces empty or partial output"],"whenToPreferThis":"Use this endpoint when you need a lightweight, pay-per-call CSV join operation without setting up a database or data pipeline. It is ideal for agents that need to merge two small-to-medium CSV datasets on a shared key in real time, with cryptographic proof of processing and no data retention. Prefer it over general-purpose data tools when you need verifiable, privacy-respecting tabular merges billed in USDC micro-payments.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-01T00:47:39.793Z","isFirstParty":false,"canonicalSlug":"delx-commerce-csv-join-by-key-88e711bc"}