Bika
ReferenceAutomation action

Get Records

Retrieve several records from a specified database, based on a view or filtering criteria.

Retrieve several records from a specified database, based on a view or filtering criteria.

UI DEMO

This is a UI interaction demo and function parameter example of this feature. You can experience it. Please note that this interaction demo only shows the UI interface and some parameters, and does not have actual data operations. If you want to really use this function, please log in to the system and enter the resource editor, and the function will take effect at that time.→ Go to Space

Editor

Please provide a concise and clear note, which will be displayed on the automation main interface for better understanding.

Maximum records per search. Returns a single record when set to 1.
Run a test to verify the automation flow and ensure it works as expected.

Recommend Templates

These are the related templates that includes the feature. You can install it to get it started.
Automated Stock Data Retrieval (Python)
The Automated Stock Data Retrieval (Python) template automatically fetches US stock data every day and writes it into a structured table, giving you clean, consistent time series for analysis. Use it as part of your financial data automation stack to power stock trend analysis, dashboards, alerts, and quantitative analysis data for models and backtests. Designed for financial analysts, investment managers, data scientists, quants, and portfolio managers, it saves time on manual data collection so you can focus on research, strategy, and better investment decisions.
AI Sales Report
The AI Sales Report template turns raw sales data analysis into automated sales reporting and a clear weekly sales report for every store. Use AI sales analytics and AI retail analytics to run sales performance analysis, sales performance monitoring, and sales trend analysis across locations. It works like AI business intelligence for retail teams, supporting business analyst reporting, automated report delivery, and trend analysis for sales so managers and analysts can make faster, data‑driven decisions without manual reporting.
Send Emails in Bulk
Easily send multiple emails in bulk, manage your recipient list, and set up automated workflows for product updates or event notifications. Collect emails through forms, sync with your CRM, and track performance seamlessly. Simplify your email broadcast process with an intuitive workflow setup.
Automated Currency Data Retrieval (Python)
The Automated Currency Data Retrieval (Python) template runs a scheduled job to fetch specific currency rates every day and store them in a structured table, building clean historical exchange rate data over time. Use it for financial data automation that powers dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and risk managers always have up-to-date FX data at hand. By automating data collection, you save time, reduce manual errors, and make better investment and risk decisions based on reliable exchange rate history.
AI Project Issues and Tickets
Use the AI Project Issues and Tickets template as a complete issue tracking template and AI-powered project ticket system for product and project teams. Collect bug tickets, customer support tickets, and feature request form submissions in one place, and manage ticket prioritization and status updates with automated notifications. Every week, an AI summary report aggregates all requests and bugs, giving project managers, product owners, QA engineers, customer support, and business analysts clear insights into user feedback, development progress, and your overall AI project workflow.
Onboard & Engage: New User Welcome Automation
Streamline your new user onboarding with this automated welcome email sequence. Send personalized welcome emails, schedule follow-ups after 4 days, and ensure unsubscribed users are excluded. Perfect for SaaS businesses, marketing teams, and customer success teams looking to improve engagement, retention, and early product adoption through automated email sequence automation, follow-up email automation, and welcome email campaigns.
Contractor / Freelancer Management
Streamlined contractor and freelancer management template that centralizes resources, automates application reviews, approval workflows, task assignment, and tracks project expenses for full transparency and budget control.
Information Query (Student Grades)
Easily retrieve student grades and exam results with Bika.ai's Information Query template. Submit queries via the intuitive Query Form, track Query Records, and access Score Information or Academic Scores instantly. Receive real-time Query Results through automated email notifications and feedback automation. Perfect for students, parents, homeroom teachers, and teaching assistants, this system streamlines student feedback, ensures accurate result verification, and enhances academic information management.
Issue tracking
Streamline your team's workflow with our Issue Tracking template. Manage issues efficiently, assign tasks, track problem resolution, and monitor progress in real-time. Automated notifications and weekly summaries improve collaboration, enhance issue management, and ensure timely resolution, making it perfect for product managers, developers, QA engineers, and support teams focused on effective problem tracking and team coordination.
Fully Automated Twitter Scheduler
Automate your Twitter (X) account with Bika.ai's AI-powered template. Schedule tweets, post automatically, and save time while keeping your account active 24/7. Perfect for social media managers, businesses, and influencers.