Deprecated NetSuite functions
Related pages:
NetSuite
NetSuite Technical Notes
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 2
Create new or select existing credentials
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.1
Select “Entity type” from drop-down list, you can choose “Vendor payment” or “Customer payment”
Step 3.2
Select options “Filter by field” from drop-down list, you can choose “dateCreated” or “lastModifiedDate”
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.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 4
Retrieve sample or add sample manually
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
}
]
}
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"
}
]
}
}