Actions981
- Account Actions
- Accounting Period Actions
- Adv Intercompany Journal Entry Actions
- Assembly Build Actions
- Assembly Item Actions
- Assembly Unbuild Actions
- Billing Account Actions
- Billing Revenue Event Actions
- Billing Schedule Actions
- Bin Actions
- Bin Transfer Actions
- Blanket Purchase Order Actions
- Bom Actions
- Bom Revision Actions
- Calendar Event Actions
- Campaign Actions
- Campaign Response Actions
- Cash Refund Actions
- Cash Sale Actions
- Charge Actions
- Check Actions
- Classification Actions
- Commerce Category Actions
- Competitor Actions
- Consolidated Exchange Rate Actions
- Contact Actions
- Contact Category Actions
- Contact Role Actions
- Cost Category Actions
- Coupon Code Actions
- Credit Card Charge Actions
- Credit Card Refund Actions
- Credit Memo Actions
- Currency Actions
- Currency Rate Actions
- Customer Actions
- Customer Category Actions
- Customer Deposit Actions
- Customer Message Actions
- Customer Payment Actions
- Customer Refund Actions
- Customer Status Actions
- Customer Subsidiary Relationship Actions
- [Custom Record] Actions
- Department Actions
- Deposit Actions
- Deposit Application Actions
- Description Item Actions
- Discount Item Actions
- Download Item Actions
- Email Template Actions
- Employee Actions
- Estimate Actions
- Expense Category Actions
- Expense Report Actions
- Fair Value Price Actions
- Fulfillment Request Actions
- Gift Certificate Item Actions
- Inbound Shipment Actions
- Intercompany Journal Entry Actions
- Intercompany Transfer Order Actions
- Inventory Adjustment Actions
- Inventory Cost Revaluation Actions
- Inventory Count Actions
- Inventory Item Actions
- Inventory Number Actions
- Inventory Transfer Actions
- Invoice Actions
- Issue Actions
- Item Fulfillment Actions
- Item Group Actions
- Item Receipt Actions
- Item Revision Actions
- Job Actions
- Job Status Actions
- Job Type Actions
- Journal Entry Actions
- Kit Item Actions
- Location Actions
- Manufacturing Cost Template Actions
- Manufacturing Operation Task Actions
- Manufacturing Routing Actions
- Markup Item Actions
- Merchandise Hierarchy Level Actions
- Merchandise Hierarchy Node Actions
- Merchandise Hierarchy Version Actions
- Message Actions
- Nexus Actions
- Non Inventory Purchase Item Actions
- Non Inventory Resale Item Actions
- Non Inventory Sale Item Actions
- Note Type Actions
- Opportunity Actions
- Other Charge Purchase Item Actions
- Other Charge Resale Item Actions
- Other Charge Sale Item Actions
- Other Name Actions
- Other Name Category Actions
- Partner Actions
- Paycheck Actions
- Payment Item Actions
- Payment Method Actions
- Phone Call Actions
- Price Book Actions
- Price Level Actions
- Price Plan Actions
- Pricing Group Actions
- Project Task Actions
- Promotion Code Actions
- Purchase Contract Actions
- Purchase Order Actions
- Purchase Requisition Actions
- Resource Group Actions
- Return Authorization Actions
- Rev Rec Schedule Actions
- Rev Rec Template Actions
- Sales Order Actions
- Sales Role Actions
- Sales Tax Item Actions
- Service Purchase Item Actions
- Service Resale Item Actions
- Service Sale Item Actions
- Ship Item Actions
- Statistical Journal Entry Actions
- Subscription Actions
- Subscription Change Order Actions
- Subscription Line Actions
- Subscription Plan Actions
- Subscription Term Actions
- Subsidiary Actions
- Subtotal Item Actions
- [SuiteQL] Actions
- Support Case Actions
- Task Actions
- Tax Type Actions
- Term Actions
- Time Bill Actions
- Time Sheet Actions
- Topic Actions
- Transfer Order Actions
- Units Type Actions
- Usage Actions
- Vendor Actions
- Vendor Bill Actions
- Vendor Category Actions
- Vendor Credit Actions
- Vendor Payment Actions
- Vendor Prepayment Actions
- Vendor Prepayment Application Actions
- Vendor Return Authorization Actions
- Vendor Subsidiary Relationship Actions
- Web Site Actions
- Work Order Actions
- Work Order Close Actions
- Work Order Completion Actions
- Work Order Issue Actions
[SuiteQL] → Get list of records using advanced query
AI-generatedSummary
Execute an advanced SuiteQL query to retrieve a list of records from NetSuite via a POST request to the /suiteql endpoint.
Inputs
- Query (required) — The SuiteQL query string to execute.
- Limit — Optional limit for the number of results to return in a single page.
- Offset — Optional offset to select a specific page of results starting point.
- Debug Mode — Flag to include full request and response details in the output for debugging purposes.
- Authentication Method — Method used to authenticate with NetSuite API, either OAuth1 or OAuth2.
Output shape
a list of records matching the SuiteQL query
The output includes the query results; if Debug Mode is enabled, it also includes detailed request and response information. Limit and Offset parameters control pagination. Errors or invalid queries will result in failure.
Examples
Example 1: Retrieve customers with a limit of 10
Set the Query to select desired fields from customer records, Limit to 10, and choose the appropriate Authentication Method. Optionally enable Debug Mode for detailed info.