Skip to main content
Documentation
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Netsuite2 - supportcase table needs to sync dailu

Mike Hastings User

Currently with the Netsuite2 connector the supportcase table is considered non-incremental. This causes it to be replicated weekly on the weekend. This table does have a primary key called 'id' and we request that this table be changed to incremental status so it can be replicated it on every sync? This is a key table in Netsuite and includes all the technical support cases. It is a key reason we use the Netsuite2 connector and we need the data updated daily.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Erin Fivetranner

    Hi Mike - 

    Thanks for submitting this request. Our connector looks for not only a PK field(s) but also a field that tells us when it was last modified (date_last_modified for example). If we don't have that field, while we could incrementally insert new records, we would miss updates to existing records. 

    We have learned of specific NetSuite tables (for example SystemNotes) that are "additive" i.e. updates don't occur to them, are insert only. From my understanding, the supportCase table is not one of those. A support case record could be modified after it is created, as such we would miss records if we didn't re-sync the table. If this is not the right understanding of how this table specifically operates I would be interested to learn more in that area. 

    Thanks,
    Erin 

  • Mike Hastings User

    Erin,

    We can add a custom field to the supportcase table called custevent_lastmodifieddate with a timestamp that is updated anytime the row changes. Would it be possible to look for this field and use it in the replication sync ? Netsuite uses standard fieldname pre words such as custevent_ custentity_ and custbody_ for Customer custom fields so this enhancement could be done in a standard way for Netsuite2. Again our goal is to migrate from the Netsuite connector to Netsuite2 connector and this weekly replication issue is blocking us?

    This is the query I see in your sync script to identify tables that can be replicated incrementally =>

    {
  "event" : "sql_query",
  "data" : {
    "query" : "SELECT TABLE_NAME FROM oa_columns WHERE COLUMN_NAME IN ('lastmodifieddate', 'lastmodified', 'linelastmodifieddate')",
    "number" : 2,
    "executionTime" : 64335
  },
  "created" : "2023-06-25T17:45:32.505Z",
  "connector_type" : "netsuite_suiteanalytics",
  "connector_id" : "revealing_herring",
  "connector_name" : "netsuite2prod",
  "sync_id" : "1897619d-bb4b-40cc-af23-1cd46d13762e"
}

    Would just need to add custevent_lastmodifieddate in the ... WHERE COLUMN IN() list. Let us know if you can add this capability to Netsuite2 connector?