19 integrations tagged with "query"
Get transaction details including ETH value and USD conversion via Chainlink oracle. Returns sender, recipient, value in wei/ETH/USD, and the ETH price used. Ideal for: liquidity checks, transaction analysis, threshold filters, token launch sniping.
Retrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.
Check how many tokens a contract is approved to spend on behalf of a wallet. Useful for verifying approval status before swaps or DeFi interactions.
Fetch recent event logs emitted by an EVM contract without any gas cost. Returns up to 25 most-recent matching events decoded against the supplied event ABI, searching back up to ~3.5 days on L2s. Ideal for: populating test-workflow event pickers, inspecting recent on-chain activity, replaying an event for dry runs.
Search and list purchases in QuickBooks Sandbox (testing). Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
Search and list purchases in QuickBooks Online. Supports SQL-like queries for filtering (WHERE), sorting (ORDER BY), and pagination. Returns an array of purchase transactions matching your criteria. Ideal for: expense reports, transaction lookups, audit trails, data exports.
Search accounts in QuickBooks Online by name, type, or other criteria. Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
Search accounts in QuickBooks Sandbox by name, type, or other criteria (testing). Returns account IDs, names, types, and balances. Use this to look up account IDs needed for creating purchases or other transactions. Ideal for: account lookup, finding account IDs, listing expense categories.
Retrieve records from an Airtable base table with filtering and sorting. Use filterByFormula for conditional queries. Supports pagination up to 100 records. Ideal for: data lookups, report generation, fetching CRM data, inventory queries.
Check a wallet's native SOL balance on Solana. Returns both the raw lamport amount and a human-readable SOL value. Supports mainnet and devnet.
