21 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.
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.
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.
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.
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.
Resolve an ENS name (e.g. vitalik.eth) to its Ethereum address. Use this to turn a human-readable name into the 0x address other actions need. Ideal for: accepting names instead of addresses, identity lookups, address book resolution.
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.
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.
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.
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.
