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.
AI Batch Image Recognition(OpenAI gpt-4o)
Extract text from multiple images at once with Bika.ai's AI Batch Image Recognition. Supports OpenAI gpt-4o, batch processing, and automated image recognition for fast, accurate results.
Automated Stock Data Retrieval (JavaScript)
The Automated Stock Data Retrieval (JavaScript) 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.
Agile Workflow
Use the Agile Workflow template as a centralized project management workspace for your Agile team. Streamline sprint tracking and backlog management, handle backlog prioritization with clear views, and improve project visibility across tasks, stories, and sprints. Built‑in agile automation and automated reminders power daily scrum standups, sprint start and end notifications, and overdue task alerts, helping teams stay aligned, reduce manual follow‑up, and keep every sprint on track.
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.
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.
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.
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.
AI Automated Task Management
Helps teams efficiently manage weekly tasks. Through a series of automation tools, including task summaries, progress reminders, and personal summary reports, team members can promptly obtain task information and progress, thereby improving collaboration efficiency and work transparency. By using these automation features, teams can maintain efficient operations and ensure that each member has a clear understanding and sense of responsibility for their tasks.
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.
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.