Skip to main content

Retrieve Data: Saved Search vs Data Filter vs Internal ID

ExtendInsights Data Management | Choosing the right way to retrieve NetSuite records

ExtendInsights offers three ways to retrieve existing NetSuite records into Excel. Use a Saved Search for established search criteria, a Data Filter for flexible rules, or Internal IDs to retrieve a known set of records.


Choose a retrieval method

Method

Best for

Where you define criteria

What you need

Saved Search

Complex filters, formulas, summary results, or an existing NetSuite search

NetSuite

Access to the Saved Search and the records

Data Filter (Rules)

Flexible, ad hoc filtering without a Saved Search

ExtendInsights

Access to the records and fields

Internal ID

Retrieving a known set of exact records

Column B in a loaded template

A template for the record type, valid IDs, and access to the records


Retrieve records with a Saved Search

Use a Saved Search when you want to apply criteria managed in NetSuite, use an existing search, or retrieve results that use complex filters or summaries. Your NetSuite role must have permission to access the Saved Search.

  1. Start Search and Download or Search and Download with Template.

  2. Select the NetSuite record type and fields.

  3. Turn on Apply Filters and select Using Saved Search.

  4. Choose the Saved Search and filter you want to apply.

  5. Download the results into Excel.


Retrieve records with a Data Filter

Use a Data Filter when you want to define rules directly in ExtendInsights without using a NetSuite Saved Search.

  1. Start Search and Download or Search and Download with Template.

  2. Select the record type and fields, or choose an existing template.

  3. Turn on Apply Filters and select Using Rules.

  4. Create or select a filter, then download the matching records.

Data Filters are saved by NetSuite account and record type. You can reuse them across workbooks, browsers, and devices when connected to the same NetSuite account. Your NetSuite role must still have access to the records and fields.


Retrieve records by Internal ID

Use Internal ID retrieval when you already know exactly which records you need—for example, for a targeted update, validation, or quick lookup.

  1. Load a template for the record type.

  2. Enter one valid NetSuite Internal ID per row in Column B – Internal ID.

  3. Click Reload Records.

ExtendInsights retrieves only the listed records that your NetSuite role can access. Keep Column B in place.


💡 Tips

  • For scheduled refreshes or repeat reporting, consider ExtendInsights Analytics.

  • If an Internal ID record doesn’t load, confirm that the ID is valid and your NetSuite role has access.

  • Before downloading, confirm that the selected record type, search or filter, and fields match what you need.


Need Help?

If you need help deciding between Internal IDs, Data Filters, and Saved Searches:

📎 Include the record type and filter criteria you’re trying to use.

Did this answer your question?