{"uid":"cap_g3th_NrHoUb2uIr34uW45","slug":"tradepilotusa-csv-table-converter-adf1cc74","name":"TradepilotUSA CSV Table Converter","description":"Convert comma/tab-delimited quoted CSV to JSON string rows or JSON string rows to CSV. Preserves string values, duplicate headers and ragged rows; no type inference. CSV output escapes spreadsheet formula starters by default and reports alterations. Maximum 500 rows and 50 columns.","url":"https://www.tradepilotusa.com/api/agent-commerce/v1/services/csv_table_convert/execute?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"source":{"type":"string","maxLength":48000},"delimiter":{"enum":[",","\t"]},"direction":{"enum":["csv_to_json","json_to_csv"]},"spreadsheet_safe":{"type":"boolean"}}},"responseSchema":{"type":"json","example":{"result":{"json":"[[\"name\",\"note\"],[\"Ada\",\"Hello, world\"]]","rows":[["name","note"],["Ada","Hello, world"]],"row_count":2,"formula_cells_escaped":0},"utility":"csv_table_convert","provenance":{"execution":"deterministic_local","model_used":false,"network_request_performed":false},"request_id":"example_csv_table_convert"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_WLtTOdCtW_oVxRpJjd6pI","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Converts CSV text to structured JSON rows (or JSON back to CSV), with optional spreadsheet-safe formula escaping.","exampleAgentPrompt":"Convert this CSV text to JSON rows for me — it uses comma delimiters — and make sure any spreadsheet formula cells are safely escaped: 'name,score\nAda,100\nBob,200'.","exampleUseCases":[{"title":"Parse exported CRM report to JSON","prompt":"I just exported a CSV from my CRM with leads — can you convert it to JSON so my code can process it? It uses commas as delimiters: 'company,email,status\nAcme,acme@test.com,open\nGlobex,globex@test.com,closed'. Make it spreadsheet-safe too."},{"title":"Serialize API response data to CSV","prompt":"I have a JSON array of order rows — [[\"order_id\",\"amount\"],[\"1001\",\"250\"],[\"1002\",\"180\"]] — can you convert it to CSV format using commas so I can open it in Excel?"},{"title":"Parse tab-separated analytics export","prompt":"My analytics tool exported a TSV file with tab delimiters. Can you convert it to JSON? Here's the data: 'page\tviews\tclicks\nHome\t5000\t320\nBlog\t1200\t95'."}],"resultDescription":"Returns a JSON object containing: a JSON string representation of the table, a rows array (array of arrays), a row_count integer, and a formula_cells_escaped count. Also includes provenance metadata confirming deterministic local execution with no model or network calls used.","failureModes":["Malformed CSV with unmatched quotes returns a parse error","Source data exceeding 48,000 character limit is rejected","Invalid direction enum value (not csv_to_json or json_to_csv) causes validation error","Invalid delimiter (not comma or tab) causes a schema rejection","Empty source string may return empty rows array"],"whenToPreferThis":"Choose this endpoint when you need a deterministic, low-latency CSV↔JSON conversion without sending data to an LLM or external network service. Ideal for structured tabular data pipelines where reproducibility matters and spreadsheet formula injection safety is required. Prefer over LLM-based parsing when precision on row/column structure is critical.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-02T12:31:50.421Z","isFirstParty":false,"canonicalSlug":"tradepilotusa-csv-table-converter-adf1cc74"}