Execute SuiteQL Query

Description

Execute a suiteQL query on NetSuite databases. Only SELECT queries are supported.

For details, see Using the Execute Suite QL Query activity.

Project compatibility

Windows | Cross-platform

Configuration

• Connection ID - The connection established in Integration Service. Access the dropdown menu to choose, add, or manage connections.

• Select query - Input a valid SELECT query, then click the Generate output schema button. Query example: SELECT TOP 1 * FROM [TABLE_NAME].
  Note: Add a valid query (without variables) to generate the schema. You can add or update variables in the query after the schema is successfully generated.

Manage Properties

Use the Manage Properties wizard to configure or use any of the object's standard or custom fields. You can select fields to add them to the activity canvas. The added standard or custom fields are available in the Properties panel (in Studio Desktop) or under Show additional properties (in Studio Web).

Additional properties

• Limit - The number of records to return. This field supports Int32 type input.
• Offset - The number of records to skip. This field supports Int32 type input.