Query
Tag19 integrations tagged with "query"
Get Transaction Details
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.
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.
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.
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.
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.
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.
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.
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.
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 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.