REST Web Services is a standard API that is provided by NetSuite. In REST Web services we can use the Query to list and filter the supported records. The query operation is used to execute a query on a specific record type based on a set of criteria. Record query only returns record IDs and HATEOAS links. That is, query results have a form of non-expanded references. Additionally, you can only use body fields in query conditions. Saved queries, multilevel joins, and sublist and sub-record queries are not supported. REST web services only support limited record queries. Joins are not supported.
Following are how to fetch all the transaction details using the Query.
The ids that are needed to use for the Query can be referenced from Analytics Browser.
The REST Web services with Query are very fast since the data are directly fetched from the RDMS table.