{"uid":"cap_GRdWFOWzZI-7A-NjDnykE","slug":"g-forge-filter-json-records-53e401f9","name":"G-Forge Filter JSON Records","description":"Keep the JSON records that match your next workflow step. Filter by exact equality on a named top-level field, including objects, arrays or null. Missing fields do not match; booleans and numbers stay distinct. Original row order is preserved. Up to 5,000 rows.","url":"https://api.getretold.com/services/agent-auto-launch-filter/invoke?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"value":{"type":"object","required":["rows","field","equals"],"properties":{"rows":{"type":"array","items":{"type":"object"},"maxItems":5000},"field":{"type":"string"},"equals":{}},"additionalProperties":false}}},"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_jA1KA5dXJ8iotWNITGJBu","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":"Filter an array of JSON records, keeping only rows where a named top-level field exactly equals a specified value (including objects, arrays, or null).","exampleAgentPrompt":"From these API records, keep only the rows where the 'status' field equals 'active' — here's the JSON array of up to 5,000 objects.","exampleUseCases":[{"title":"Filter orders by fulfillment status","prompt":"I have a JSON array of order records from our e-commerce API — can you filter it down to only the rows where the 'fulfillmentStatus' field equals 'shipped'?"},{"title":"Isolate null-category products","prompt":"Here's a list of product records as JSON. Keep only the ones where the 'category' field is null so I can find the uncategorized items."},{"title":"Segment users by subscription tier","prompt":"I've got a JSON export of user accounts — filter it to only the records where the 'plan' field equals 'enterprise' so I can send them a targeted message."}],"resultDescription":"A JSON array containing only the subset of input rows where the specified top-level field exactly equals the given value. Row order is preserved. Rows where the field is missing do not appear in the output. Booleans and numbers remain type-distinct (e.g., true !== 1).","failureModes":["Field name not found in any rows — returns empty array (not an error)","Input array exceeds 5,000 rows — request rejected","Malformed JSON in the rows array — parsing error returned","Incorrect type coercion expectations (e.g., treating 1 as true) — caller must supply exact typed value"],"whenToPreferThis":"Use this endpoint when you need to subset a JSON record array by exact equality on a single top-level field, especially within an automated data pipeline. It handles all JSON value types (strings, numbers, booleans, objects, arrays, null) correctly without type coercion, preserves row order, and is priced per-call making it cost-effective for frequent lightweight filtering. Prefer it over general-purpose scripting when you want a stateless, auditable filter step in an agent workflow without spinning up compute.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:32:19.649Z","isFirstParty":false,"canonicalSlug":"g-forge-filter-json-records-53e401f9"}