¶ Netsuite - Query
This task executes specified QL query in Netsuite and gets the result in a local (csv) file.
¶ Prerequisites
Netsuite connection should be defined and active.
Netsuite has a limit of 1000 records for the query API. EAConnect uses paging to get multiple batches of 1000 records each if required. To ensure correct results, always add an ‘Order By’ clause in your query that identifies unique records. Netsuite also has hard limit of 100 such paging calls (max 100K records) and may have sizing limits. As such, split your query task into multiple tasks if the data returned is large (anything more than 30K records or so should be split).
¶ Configuration
¶ Configuration Details:
- SQL : Specify query. Please note Netsuite QL may not support all SQL commands and syntax.
- URL: Query API URL will be as shown above with the hidden part identifying your Netsuite account id.
- File: Local file where result from the query is to be saved.
- Field_Order and File_Header are optional fields, if not specified output of Saved Search will be saved as is in a csv format - in specified file.
Let us say, saved search returns results like below
| entity | subsidiarywithhierarchy | acctnumber | sum of amount |
| 100 | ABC | 1001 | 20500.00 |
Let us say, we want to exclude subsidiary column from this list, move acctnumber to left, and rename the column headers.
Field_Order = acctnumber,entity,sum of amount
File_Header = Account Number,Entity,Amount
This will produce the resulting csv file as
| Account Number | Entity | Amount |
| 1001 | 100 | 20500.00 |