{"uid":"cap_6asNAxkpunmpfD33_rWF7","slug":"relaystation-data-union-84c9b20b","name":"Relaystation Data Union","description":"$0.0002/MB. Concatenate tables with an ordered key-union schema — stack datasets safely. 1¢ x402 min; remainder auto-credits — relaystation.ai/penny","url":"https://api.relaystation.ai/v1/data/union","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_Odc9vN2LDPfocYknIMk4L","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":"Concatenates multiple tables into a single dataset using an ordered key-union schema, safely stacking rows from heterogeneous sources.","exampleAgentPrompt":"Stack my two sales datasets into one unified table — the Q1 results and Q2 results have slightly different columns, so use a key-union schema to safely merge them without losing any fields.","exampleUseCases":[{"title":"Merging monthly report exports","prompt":"I have January and February sales tables exported separately and they have slightly different columns — can you union them into one table using a key-union schema so no columns are dropped?"},{"title":"Combining ETL pipeline outputs","prompt":"My pipeline produces three separate output tables from different data sources with overlapping but not identical schemas — stack them all into one unified dataset using ordered key-union."},{"title":"Stacking A/B test result tables","prompt":"I ran an A/B test and the control and variant result tables have a few different columns — combine them into one table with all columns present, filling nulls where a column didn't exist in one group."}],"resultDescription":"Returns a single unified table whose schema is the ordered key-union of all input tables' columns, with rows from all inputs stacked in order and missing column values filled with nulls where a source table lacked that column. Billed at $0.0002/MB with a 1¢ minimum; any remainder is auto-credited.","failureModes":["Mismatched key types across tables causing schema resolution failure","Input tables too large for per-call MB budget, requiring chunking","Malformed input table format (unsupported serialization format)","Empty or null table inputs returning an empty result or error","Column name collisions with conflicting data types across sources"],"whenToPreferThis":"Choose this endpoint when you need to vertically stack or union multiple tabular datasets that may have different but overlapping column schemas, and you want the result to safely include all columns from all sources without data loss. It is particularly well-suited for ETL pipelines, report consolidation, and merging exports from heterogeneous systems where schema normalization is needed automatically.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T06:45:01.828Z","isFirstParty":false}