NetSuite component

Deprecated NetSuite functions

Information on deprecated NetSuite functions

Deprecated Triggers

Search Entity(deprecated)

Deprecated. Use Get New and Updated Objects Polling trigger instead.

Find an object or a set of objects using filter criteria (field, operator, value).

How to use Search Entity Trigger

Step 1

Find and select NetSuite component in the component repository

Step 1

Step 2

Create new or select existing credentials

Step 2

Step 3

Specify parameters for searching entity The component supports next entity types for now:

  • Customer payments
  • Vendor payments

Supported entity list can be extended in future.

Step 3

Step 3.1

Select “Entity type” from drop-down list, you can choose “Vendor payment” or “Customer payment”

Step 3.1

Step 3.2

Select options “Filter by field” from drop-down list, you can choose “dateCreated” or “lastModifiedDate”

Step 3.2

Step 3.3

Select options “Filter operator” from drop-down list, you can choose next one:

  • after
  • before
  • notAfter
  • notBefore
  • notEmpty
  • on
  • notOn
  • notOnOrBefore
  • notOnOrAfter
  • onOrAfter
  • onOrBefore

Step 3.3

Step 3.4

Input “Filter value” - date and time in format “2018-01-01T00:00:00.000 -07:00” At the end of trigger execution “Filter value” field change value to “Last trigger execution date” value. It is opportunity to load only new updated/created records from the NetSuite.

Step 3.4

Step 4

Retrieve sample or add sample manually

Step 4: Retrieve sample

Step 5

Retrieve sample result

Step 5: Retrieve sample result

Deprecated Action

Lookup Customer(deprecated)

Deprecated. Use Lookup Object By Id action instead.

This action enables to find the customer by provided ID. It is possible to provide internal, external id or all of them in input message.

If entity doesn’t have externalId You must specify only internalId in input message. If You specify incorrect internal or external id, You will get error That record does not exist.

For example when the externalId exists the answer would be:

{
  "internalId":"1234",
  "externalId":"4567"
}

When the externalId does not exist:

{
  "internalId":"1234"
}

Lookup Invoice(deprecated)

Deprecated. Use Lookup Object By Id action instead.

This action can be used to find invoices by provided ID.

You can provide internal, external id or all of them in input message. If entity doesn’t have externalId You must specify only internalId in input message.

If You specify incorrect internal or external id, You will get error “That record does not exist.

For example if the externalId exists:

{
  "internalId":"1234",
  "externalId":"4567"
}

If the externalId does not exist:

{
  "internalId":"1234"
}

Upsert Customer(deprecated)

Deprecated. Use Lookup Object By Id action instead

Create new or update existing customer by provided external ID. The request sample could look like:

{
  "externalId": "external order ID",
  "customerId": "internal customer ID",
  "currency": "USA",
  "exchangeRate": 1.0,
  "orderItems": [
		{
			"itemInternalId": "387",
			"quantity": 10![Step 1](https://some-url-address)

		}
	]
}

Upsert Contact(deprecated)

Deprecated. Use Upsert Object By Id action instead.

Create new or update existing contact by provided external ID.

Request sample:

{
  "externalId": "entity164",
  "customForm": {
    "internalId": "-40",
    "name": "Standard Contact Form"
  },
  "entityId": "Olha Grogan",
  "salutation": "Mrs.",
  "firstName": "Olha",
  "lastName": "Grogan",
  "subsidiary": {
    "internalId": "1",
    "name": "Honeycomb Mfg."
  }
}

Upsert Invoice(deprecated)

Deprecated. Use Upsert Object By Id action instead.

Create new or update existing invoice by provided external ID.

Request sample:

{
  "externalId": "23213000001",
  "customForm": {
    "name": "HM Product Invoice",
    "internalId": "102"
  },
  "entity": {
    "name": "Jennings Financial",
    "internalId": "81"
  },
  "terms": {
    "name": "Net 30",
    "internalId": "2"
  },
  "subsidiary": {
    "name": "Honeycomb Mfg.",
    "internalId": "1"
  },
  "currency": {
    "name": "USA",
    "internalId": "1"
  },
  "location": {
    "name": "02: Boston",
    "internalId": "1"
  },
  "isTaxable": true,
  "taxItem": {
    "name": "CA-SAN MATEO",
    "internalId": "-112"
  },
  "taxRate": 8.25,
  "fax": "916-555-0806",
  "message": "We appreciate your prompt payment",
  "shipMethod": {
    "name": "Truck",
    "internalId": "3"
  },
  "itemList": {
    "item": [
      {
        "job": null,
        "item": {
          "name": "CHA00002®",
          "internalId": "707",
          "externalId": null,
          "type": null
        },
        "line": 1,
        "description": "Assembly Item - Historical",
        "amount": 7020,
        "isTaxable": null,
        "quantity": 36,
        "price": {
          "name": "List Price",
          "internalId": "1"
        },
        "rate": "195.00",
        "taxCode": {
          "name": "-Not Taxable-",
          "internalId": "-7"
        }
      }
    ],
    "replaceAll": false
  },
  "shippingCost": 704.25,
  "customFieldList": {
    "customField": [
      {
        "type": "BooleanCustomFieldRef",
        "internalId": "167",
        "scriptId": "custbody_fmt_senior_exec_declined",
        "value": false
      }
    ]
  }
}

Upsert Sales Order(deprecated)

Deprecated. Use Upsert Object By Id action instead.

Create new or update existing sales order by provided external ID.

Request sample:

{
  "externalId": "80144000000B5wqAAC",
  "orderStatus": "_pendingFulfillment",
  "currency": {
    "name": "USA",
    "internalId": "1"
  },
  "customForm": {
    "internalId": "174",
    "name": "Z - HM Sales Order Form"
  },
  "entity": {
    "internalId": "2053"
  },
  "exchangeRate": "1.0",
  "toBePrinted":"false"
}

Upsert Vendor(deprecated)

Deprecated. Use Upsert Object By Id action instead.

Create new or update existing vendor by provided external ID.

Request sample:

{
  "externalId": "9999",
  "entityId": "Nick",
  "isPerson": "false",
  "companyName": "Nick2",
  "phone": "937 99 92",
  "fax": "937 99 92",
  "email": "nick2@nickthebest.com",
  "url": "http://www.nickthebest2.com",
  "customFieldList": {
    "customField": [
      {
        "internalId": "3992",
        "scriptId": "custentity_2663_payment_method",
        "type": "BooleanCustomFieldRef",
        "value": "false"
      },
      {
        "internalId": "3993",
        "scriptId": "custentity_2663_payment_method",
        "type": "BooleanCustomFieldRef",
        "value": "false"
      }
    ]
  }
}

Click here to learn more about the elastic.io iPaaS