Query
Tag22 integrations tagged with "query"
Google Sheets: Get Values
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.
Get Token Allowance
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.
Airtable: List Records
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.
QuickBooks Sandbox: Search Accounts
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.
Resolve ENS Name
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.
QuickBooks Sandbox: Search Purchases
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.
QuickBooks: Search Accounts
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.
Get SOL Balance
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.
Get Contract Event Logs
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.
QuickBooks: Search Purchases
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.