{"uid":"cap_6ax0KY2bNy83aXEwWsDq8","slug":"jsonpath-extract-e4cdfc11","name":"JSONPath Extract","description":"JSONPath extraction: evaluates a path like $.store.book[*].author, $..price, $.items[-1], $['key with spaces'] against a JSON document and returns all matching values with a count. Handles recursive descent, wildcards, negative indexes and bracket keys. $0.01 per query.","url":"https://intel.rallylive.ca/dev/json-path","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_TC9wo7QVgP4KF-FRzdkxK","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":"Evaluates a JSONPath expression against a JSON document and returns all matching values with a count","exampleAgentPrompt":"I have a JSON document with a nested store structure — can you run the JSONPath expression $.store.book[*].author against it and tell me all the matching values and how many there are?","exampleUseCases":[{"title":"Extract nested API response fields","prompt":"I got back a big JSON response from an API and I need to pull out all the price fields from every product using the path $..price — can you run that JSONPath and tell me what values match?"},{"title":"Get last item from JSON array","prompt":"I have a JSON array of orders and I want to grab just the most recent one using $.items[-1] — can you evaluate that JSONPath against my document and return the result?"},{"title":"Query keys with spaces in bracket notation","prompt":"My JSON document has keys with spaces in them and I need to extract a specific field using $['key with spaces'] — can you run that JSONPath expression for me and count how many matches come back?"}],"resultDescription":"Returns all values matched by the JSONPath expression within the provided JSON document, along with a count of how many matches were found. Supports recursive descent (..), wildcards (*), negative array indexes, and bracket-notation keys with spaces.","failureModes":["Invalid JSONPath expression syntax returns an error","Malformed or unparseable JSON document causes a parse failure","No matching nodes found returns an empty result set with count zero","Missing required input parameter returns a 400-level error","Payment not included or insufficient funds results in a 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need to query or extract data from a JSON document using standard JSONPath syntax, especially when the document has deeply nested structures, arrays requiring negative indexing, wildcard traversal, or keys containing spaces. Ideal for agents that receive raw JSON API responses and need to pull out specific fields without writing custom parsing code. At $0.01 per call it is cost-effective for one-off or low-frequency extraction tasks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T13:13:40.892Z","isFirstParty":false}