NetSuite REST icon

NetSuite REST

Call NetSuite SuiteTalk REST operations.

Actions979

Expense Report → Get list of records

AI-generated

Summary

Retrieve a paginated list of NetSuite Expense Report records, optionally filtered by a search query, limited or offset, with support for async execution and debug info.

Inputs

  • isDebugMode — Whether to include full request and response info in the output
  • additionalFields.limit — The limit used to specify the number of results on a single page.
  • additionalFields.offset — The offset used for selecting a specific page of results.
  • additionalFields.Prefer — The server behavior requested by the client. Set to "respond-async" to execute the request asynchronously.
  • additionalFields.q — The search query that is used to filter results.
  • additionalFields.X-NetSuite-Idempotency-Key — A user-defined unique idempotency key for asynchronous requests; ignored when executed synchronously.

Output shape

a list of expense report records returned as an array of JSON objects (each object representing a record). If debug mode is enabled, each processed input item will also contain the raw request and response data.

Results are subject to NetSuite pagination: use "limit" to cap per-page count and "offset" to jump to a specific page. When the preference "respond-async" is chosen, the API responds with a status indicating async processing; the node will emit that response chain.

Examples

Example 1: Retrieve first 10 expense reports

Set limit to 10; leave other fields empty.

Example 2: Get expense reports starting from offset 20

Set offset to 20; optionally set limit and/or q.

Example 3: Debug a query for expense reports

Enable isDebugMode and set q to "status:open" to see request/response details.

Discussion