{"uid":"cap_vrrEZmH5v8V_AsilA3Ehs","slug":"json-to-csv-converter-b7f3025d","name":"JSON to CSV Converter","description":"JSON to CSV: converts an array of objects (nested keys flattened with dots, arrays joined) into RFC-4180 CSV with a header row, returning the CSV text, row and column counts and the columns detected. $0.01 per call.","url":"https://intel.rallylive.ca/data/json-to-csv","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET"],"type":"string"},"queryParams":{"type":"object","properties":{}}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":null,"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_I2h8jaCE4clr1Pg4hyqEs","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 a JSON array of objects into RFC-4180 compliant CSV, flattening nested keys with dots and joining arrays, and returns the CSV text plus row/column statistics.","exampleAgentPrompt":"I have a JSON array of user records with nested fields like address.city and tags as arrays — can you convert it to a proper RFC-4180 CSV with a header row and tell me how many rows and columns came out?","exampleUseCases":[{"title":"Export API data to spreadsheet","prompt":"I've got a JSON array from our orders API — each order has nested fields like customer.name and customer.email. Can you convert it to CSV so I can open it in Excel, and tell me what columns were detected?"},{"title":"Flatten nested analytics JSON","prompt":"We have analytics events in JSON where properties are deeply nested. Convert this JSON array to a flat CSV using dot notation for keys so I can import it into our BI tool."},{"title":"Prepare JSON for database import","prompt":"I need to turn this JSON array of product records into a CSV file for a bulk database import — make sure nested fields are flattened with dots and any array values are joined, and give me the row and column counts."}],"resultDescription":"Returns the full RFC-4180 CSV text with a header row derived from all detected keys (nested keys flattened with dot notation, array values joined), plus the total row count, total column count, and the list of column names detected.","failureModes":["Input is not a valid JSON array — returns an error indicating malformed input","Input JSON contains no objects or is empty — may return a CSV with only headers or an empty result","Extremely large JSON payloads may time out or hit size limits","Non-serializable values (e.g. functions, undefined) in JSON may be dropped or cause errors"],"whenToPreferThis":"Choose this endpoint when you need a quick, single-call conversion of a JSON array of objects to RFC-4180 CSV with automatic nested key flattening and array joining, especially when you also need metadata about the resulting table (row count, column count, column names). Ideal for lightweight ETL steps, spreadsheet exports, and BI tool ingestion prep without setting up a local library.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T12:45:12.211Z","isFirstParty":false}