NetSuite

Connect fyrn to Oracle NetSuite to automate ERP workflows — manage customers, create sales orders, generate invoices, and run SuiteQL queries through the SuiteTalk REST API.

Overview

Property	Value
Type	http
Authentication	oauth2
Category	Finance & Accounting

Configuration

Field	Type	Required	Description
account_id	string	Yes	NetSuite account ID (e.g. 1234567 or 1234567_SB1 for sandbox)
consumer_key	string	Yes	OAuth 1.0a consumer key (integration record)
consumer_secret	string	Yes	OAuth 1.0a consumer secret
token_id	string	Yes	Token-based auth token ID
token_secret	string	Yes	Token-based auth token secret

Available actions

Get Record

Retrieve a single NetSuite record by type and internal ID.

Endpoint	GET /{recordType}/{recordId}
Method	GET

Create Record

Create a new NetSuite record of the specified type.

Endpoint	POST /{recordType}
Method	POST

Update Record

Update an existing NetSuite record (partial update via PATCH).

Endpoint	PATCH /{recordType}/{recordId}
Method	PATCH

Delete Record

Delete a NetSuite record by type and internal ID.

Endpoint	DELETE /{recordType}/{recordId}
Method	DELETE

List Records

List NetSuite records of a given type with optional filtering.

Endpoint	GET /{recordType}
Method	GET

Create Sales Order

Create a new sales order in NetSuite with line items.

Endpoint	POST /salesOrder
Method	POST

Create Customer

Create a new customer record in NetSuite.

Endpoint	POST /customer
Method	POST

Create Invoice

Create a new invoice in NetSuite with line items.

Endpoint	POST /invoice
Method	POST

Run SuiteQL Query

Execute a SuiteQL query against NetSuite.

Endpoint	POST /services/rest/query/v1/suiteql
Method	POST

Example flow

name: shopify-to-netsuite
description: Sync new Shopify orders into NetSuite as customers and sales orders
trigger:
  type: webhook
  event: shopify.order.created

steps:
  - id: create-customer
    connector: netsuite
    action: create-customer
    params:
      companyName: "{{ trigger.body.customer.first_name }} {{ trigger.body.customer.last_name }}"
      email: "{{ trigger.body.customer.email }}"
      phone: "{{ trigger.body.customer.phone }}"
      addressBook:
        - addr1: "{{ trigger.body.shipping_address.address1 }}"
          city: "{{ trigger.body.shipping_address.city }}"
          state: "{{ trigger.body.shipping_address.province_code }}"
          zip: "{{ trigger.body.shipping_address.zip }}"
          country: "{{ trigger.body.shipping_address.country_code }}"

  - id: create-sales-order
    connector: netsuite
    action: create-sales-order
    params:
      entity: "{{ steps.create-customer.result.id }}"
      tranDate: "{{ trigger.body.created_at | date: '%Y-%m-%d' }}"
      item:
        items: "{{ trigger.body.line_items | map: 'sku', 'quantity', 'price' }}"

  - id: log-order
    connector: netsuite
    action: run-suiteql
    params:
      q: "SELECT tranId, total FROM transaction WHERE id = {{ steps.create-sales-order.result.id }}"