{"uid":"cap_6f3drOYyp8TWpYX96LhM4","slug":"pennyrail-json-path-query-ab00710a","name":"PennyRail JSON Path Query","description":"Extract a value from JSON by dot/bracket path such as items[2].name. Deterministic, no network, returns found/value and normalized path. Exact-match PennyRail gap-arbitrage route.","url":"https://pennyrail.vercel.app/api/bazaar/json-query","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":{"type":"object","description":"Input for JSON query.","additionalProperties":true},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"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.001","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.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_DKEwPowN_0D48gPGiAxKe","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Extracts a value from a JSON object using dot/bracket path notation (e.g. items[2].name), returning the found status, value, and normalized path deterministically.","exampleAgentPrompt":"From this JSON blob, extract the value at path items[2].name and tell me what it is and whether it was found: {\"items\":[{\"name\":\"alpha\"},{\"name\":\"beta\"},{\"name\":\"gamma\"}]}.","exampleUseCases":[{"title":"Extract nested API response field","prompt":"I got this JSON back from an API: {\"order\":{\"shipping\":{\"address\":{\"city\":\"Austin\",\"zip\":\"78701\"}}}} — can you pull out the value at order.shipping.address.city for me?"},{"title":"Read specific array element by index","prompt":"Here's a JSON payload with a products array: {\"products\":[{\"id\":1,\"sku\":\"A1\"},{\"id\":2,\"sku\":\"B2\"},{\"id\":3,\"sku\":\"C3\"}]} — grab the value at products[2].sku."},{"title":"Validate JSON path exists before processing","prompt":"Before I process this config file, check if the path server.database.port exists in this JSON: {\"server\":{\"host\":\"localhost\",\"database\":{\"port\":5432,\"name\":\"prod\"}}} and tell me the found status and value."}],"resultDescription":"Returns a JSON object indicating whether the path was found (boolean), the extracted value at that path (any JSON type: string, number, object, array, null), and the normalized canonical form of the provided path expression.","failureModes":["Path not found in the JSON object — returns found: false with no value","Malformed path syntax (e.g. mismatched brackets) — returns an error or found: false","Input body is not valid JSON — request may fail with a parse error","Missing required 'input' field in request body — returns a validation error","Array index out of bounds — returns found: false"],"whenToPreferThis":"Choose this endpoint when you need deterministic, side-effect-free extraction of a single value from a JSON structure using dot or bracket path notation without writing custom code. Ideal for agent pipelines that receive JSON payloads and need to pluck specific fields reliably. Prefer over general-purpose code execution when you want a simple, auditable, no-network lookup that costs only $0.001 per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T06:32:33.910Z","isFirstParty":false}