{"uid":"cap_LivWA0yIE1XlD0ga4IJ8r","slug":"relaystation-explode-json-array-unnest-4ce48d09","name":"Relaystation Explode — JSON Array Unnest","description":"$0.0002/MB. Unnest array cells into rows — flatten nested JSON for analysis. 1¢ x402 min; remainder auto-credits — relaystation.ai/penny","url":"https://api.relaystation.ai/v1/data/explode","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"properties":{}},"type":{"type":"string","const":"http"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"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":"registry","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_LcRyReVuoxfMA6N1S7jLm","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Unnests (explodes) array cells in nested JSON, flattening each array element into its own row for tabular analysis","exampleAgentPrompt":"Take this JSON dataset where the 'tags' and 'orders' fields are arrays — explode each array element into its own row so I can analyze it in a flat table format.","exampleUseCases":[{"title":"Flatten e-commerce order line items","prompt":"I have a JSON export from our store where each customer record has an array of order line items nested inside — can you explode those so each line item becomes its own row I can load into Postgres?"},{"title":"Unnest API response arrays for analytics","prompt":"Our analytics pipeline gets nested JSON from a third-party API where each event has an array of tags — I need each tag exploded into its own record before we run aggregations on it."},{"title":"Normalize survey response arrays for reporting","prompt":"I've got survey results as JSON where each respondent has an array of selected answers — please unnest those answer arrays so every answer is a separate row I can pivot in a spreadsheet."}],"resultDescription":"Returns a collection of flattened JSON records where each element of the specified array field has been expanded into its own row, with all sibling fields duplicated across the resulting rows — ready for tabular analysis, database ingestion, or CSV export. Billed at $0.0002/MB with a 1¢ minimum; any overage auto-credits to the account.","failureModes":["Malformed or invalid JSON input returns a parse error","Non-array target field returns an error or passes through unchanged","Empty arrays produce zero output rows","Very large payloads may exceed size limits or incur higher costs","Missing required field path parameter causes a 400-style error"],"whenToPreferThis":"Choose this endpoint when you have nested JSON with array-valued fields that need to be normalized into flat, row-per-element records — particularly useful in ETL pipelines, pre-analytics normalization, or before loading data into relational databases or spreadsheets. It is priced per MB so it is cost-effective for large batches. Prefer it over writing custom code when you need a quick, reliable, hosted transformation without managing infrastructure.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T06:41:56.806Z","isFirstParty":false}