List Accounts is a powerful feature that simplifies your financial management by retrieving a comprehensive list of accounts directly from the NetSuite API. This action enables you to access vital account information quickly, enhancing your ability to analyze financial data and make informed decisions. By integrating seamlessly with your existing workflows, List Accounts supports organizations of all sizes in optimizing their accounting processes and improving overall operational efficiency. Whether you need to track expenses, manage budgets, or generate reports, this action provides the essential data you need to drive your business forward.
Configuration
NetSuite - Connection (ver. 1.0.0)
URL
URL of your NetSuite instance.
Account ID
Account ID for NetSuite API.
Consumer Key
Consumer key for NetSuite API.
Consumer Secret
Consumer secret for NetSuite API.
Token ID
Token ID for NetSuite API.
Token Secret
Token secret for NetSuite API.
NetSuite - List Resources (ver. 1.0.0)
Error behavior
The available values are:
-
Fail and return response: The connector fails at the specified line but generates output with error details.
-
Fail without response: The connector fails - the error will be displayed only in the log.
-
Do not fail and return response: The connector does not fail but generates output records that may be marked with an error and detailed information.
Limit
Specifies the maximum number of records to retrieve in a single query. This setting helps manage data load and ensures efficient processing.
Query
Allows for the input of a specific search query or filter to refine which records are retrieved.
Load All Records
When checked, this option overrides the limit and attempts to load all available records that meet the query criteria.
Input & Output Schema
Input
This connector does not require a schema.
Output
NetSuite - Account Response (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | Indicates the status of the operation |
| IsError | Bool | No | Specifies whether an error occurred during the operation |
| Message | String | Yes | Provides additional information about the operation result |
| Account | NetSuite - Account v1.6.0 |
Yes | Contains details about the NetSuite account being accessed or modified |
NetSuite - Account (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| IsInactive | Bool | Yes | Indicates if the account is inactive |
| IsSummary | Bool | Yes | Specifies if the account is a summary account |
| OpeningBalance | Double | Yes | Represents the initial balance of the account |
| TranDate | DateTime | Yes | The date of the transaction associated with the account |
| ExternalID | String | Yes | Unique identifier for the account in external systems |
| Description | String | Yes | Provides a brief description of the account |
| Eliminate | Bool | Yes | Indicates if the account should be eliminated in reports |
| Inventory | Bool | Yes | Specifies if the account is used for inventory purposes |
| Revalue | Bool | Yes | Indicates if the account is subject to revaluation |
| AcctNumber | String | Yes | The account number assigned to the account |
| CurDocNum | Integer | Yes | Current document number for the account |
| SSpecAcct | NetSuite - S Spec Acct v1.4.0 |
Yes | Represents a specific account type in NetSuite |
| ID | String | Yes | Unique identifier for the account in NetSuite |
| AccountSearchDisplayNameCopy | String | Yes | Copy of the display name used in account searches |
| LastModifiedDate | DateTime | Yes | The date and time when the account was last modified |
| AcctType | NetSuite - Acct Type v1.4.0 |
Yes | Specifies the type of account in NetSuite |
| IncludeChildren | Bool | Yes | Indicates if child accounts should be included |
| AccountSearchDisplayName | String | Yes | The display name used for account searches |
| DisplayNameWithHierarchy | String | Yes | The display name of the account including its hierarchy |
| ReconcileWithMatching | Bool | Yes | Indicates if the account can be reconciled with matching transactions |
| FullName | String | Yes | The full name of the account as displayed in NetSuite |
| AcctName | String | Yes | The name of the account |
| RefName | String | Yes | Reference name for the account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links associated with the account |
| Subsidiary | NetSuite - Subsidiary Collection v1.2.0 |
Yes | The subsidiary to which the account belongs |
| DeferralAcct | NetSuite - ID v1.2.0 |
Yes | Account used for deferrals |
| Location | NetSuite - ID v1.2.0 |
Yes | Location associated with the account |
| AccountContextSearch | NetSuite - Account Account Context Search Collection v1.2.0 |
Yes | Contextual search information for the account |
| Localizations | NetSuite - Account Localizations Collection v1.2.0 |
Yes | Localizations related to the account |
| Parent | NetSuite - ID v1.2.0 |
Yes | Parent account in the hierarchy |
| BillableExpensesAcct | NetSuite - ID v1.2.0 |
Yes | Account used for billable expenses |
| Department | NetSuite - ID v1.2.0 |
Yes | Department associated with the account |
| Currency | NetSuite - ID v1.2.0 |
Yes | Currency used for the account |
| Class | NetSuite - ID v1.2.0 |
Yes | Class associated with the account |
| Category1099Misc | NetSuite - Ns Resource v1.6.0 |
Yes | Category for 1099 miscellaneous income |
| CustomFields | JSON | Yes | Custom fields associated with the account |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - S Spec Acct (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | Reference name for the Netsuite account |
| CustomFields | JSON | Yes | Additional custom fields related to the account |
NetSuite - Acct Type (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | User-friendly name for the Netsuite account |
| CustomFields | JSON | Yes | Additional custom attributes for the account |
NetSuite - Ns Link (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Rel | String | Yes | Represents the relationship identifier for the Netsuite account |
| Href | String | Yes | Contains the URL link to access the Netsuite account |
| CustomFields | JSON | Yes | Holds additional custom field data specific to the Netsuite account |
NetSuite - Subsidiary Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| TotalResults | Integer | Yes | Indicates the total number of results returned by the query |
| Items | NetSuite - ID v1.2.0 |
Yes | Contains the list of items retrieved from the NetSuite account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides links to related resources in the NetSuite account |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates whether there are more items available beyond the current response |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| CustomFields | JSON | Yes | Holds additional custom field data associated with the items |
NetSuite - Account Account Context Search Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Count | Integer | Yes | Represents the total number of accounts retrieved |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides links to related resources in NetSuite |
| TotalResults | Integer | Yes | Indicates the total number of results available |
| HasMore | Bool | Yes | Indicates if there are more results to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Account Account Context Search Element v1.2.0 |
Yes | Contains the list of account details retrieved |
| CustomFields | JSON | Yes | Holds any additional custom field data associated with accounts |
NetSuite - Account Localizations Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides the link to the NetSuite API endpoint |
| TotalResults | Integer | Yes | Indicates the total number of results returned |
| Count | Integer | Yes | Represents the number of items in the current response |
| HasMore | Bool | Yes | Indicates if there are more results available |
| Offset | Integer | Yes | Specifies the starting point for the next set of results |
| Items | NetSuite - Account Localizations Element v1.2.0 |
Yes | Contains the list of account localization details |
| CustomFields | JSON | Yes | Holds any additional custom field data related to the account |
NetSuite - Ns Resource (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | User-friendly name for the Netsuite account |
| ExternalID | String | Yes | Identifier used for external references to the account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links to related resources or entities in Netsuite |
| CustomFields | JSON | Yes | Additional custom attributes specific to the Netsuite account |
NetSuite - Account Account Context Search Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection to the NetSuite account |
| Acctnumber | String | Yes | Contains the unique account number for identification |
| Locale | NetSuite - Locale v1.4.0 |
Yes | Specifies the locale settings for the account |
| Acctname | String | Yes | Holds the name of the NetSuite account |
| RefName | String | Yes | Provides a reference name for the account |
| Accountingcontext | NetSuite - Ns Resource v1.6.0 |
Yes | Defines the accounting context for transactions |
| CustomFields | JSON | Yes | Stores additional custom fields related to the account |
NetSuite - Account Localizations Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection link to the NetSuite account |
| LegalName | String | Yes | Holds the legal name of the account for identification |
| Acctnumber | String | Yes | Contains the unique account number assigned by NetSuite |
| Locale | NetSuite - Locale v1.4.0 |
Yes | Specifies the locale settings for the account |
| Acctname | String | Yes | Represents the display name of the NetSuite account |
| RefName | String | Yes | Provides a reference name for easier account management |
| Accountingcontext | NetSuite - Ns Resource v1.6.0 |
Yes | Defines the accounting context for transactions in the account |
| CustomFields | JSON | Yes | Stores additional custom fields related to the account |
NetSuite - Locale (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | Reference name for the Netsuite account |
| CustomFields | JSON | Yes | Additional custom fields related to the account |