NetSuite Integration document

[sksuresh2k20]

Hi Team,

We are working on NetSuite integration with SOD workflows. We need to onboard the NetSuite application with Saviynt. Please let me know if there is any documentation for Account and Access import in NetSuite with SOAP connector.

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/saviynt-knowledge-base/netsuite-integration-soap-connector-with-sample...

[sksuresh2k20]

Hi Rushi,

I appreciate your support. I have a few questions below. Please assist me in answering them.

1) Can we import the NetSuite account and Security Role using the account import JSON mentioned below?

2) Do we have any additional information on record access? Specifically, which tables need to be accessed to set up the connection?

AccountImport JSON

-------------------

{

    "CONNECTION1":"netsuite",

    "REQUESTXML1":"${String timestamp=new Date().getTime().toLong().toString().substring(0, 10); String nonce=java.util.UUID.randomUUID().toString().replace('-', '').substring(0, 20); String signature=org.apache.commons.codec.digest.HmacUtils.hmacSha1( (CONSUMER_SECRET+'&'+TOKEN_SECRET).getBytes() , (ACCOUNT+'&'+CONSUMER_KEY+'&'+TOKEN_ID+'&'+nonce+'&'+timestamp).getBytes() ).encodeAsBase64(); return '<soapenv:Envelope xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"> <soapenv:Header> <tokenPassport> <account>'+ACCOUNT+'</account> <consumerKey>'+CONSUMER_KEY+'</consumerKey> <token>'+TOKEN_ID+'</token> <nonce>'+nonce+'</nonce> <timestamp>'+timestamp+'</timestamp> <signature algorithm=\"HMAC-SHA1\">'+signature+'</signature> </tokenPassport> </soapenv:Header> <soapenv:Body>' + (nsId != null && nsId != '' ? '<ns3:searchMoreWithId xmlns=\"urn:customization_2020_1.setup.webservices.netsuite.com\" xmlns:ns2=\"urn:core_2020_1.platform.webservices.netsuite.com\" xmlns:ns3=\"urn:messages_2020_1.platform.webservices.netsuite.com\"> <ns3:searchId>'+nsId+'</ns3:searchId> <ns3:pageIndex>'+PAGE_NUMBER+'</ns3:pageIndex> </ns3:searchMoreWithId>' : '<platformMsg:search xmlns:platformMsg=\"urn:messages_2020_1.platform.webservices.netsuite.com\"> <platformMsg:searchRecord xsi:type=\"ns2:EmployeeSearchAdvanced\" savedSearchId=\"18732\" xmlns:ns2=\"urn:employees_2020_1.lists.webservices.netsuite.com\"> </platformMsg:searchRecord> </platformMsg:search>' ) + '</soapenv:Body> </soapenv:Envelope>';}",

    "REQUESTPARAMS1":{

        "Content-Type":"text/xml",

        "SOAPAction":"${nsId != null && nsId != '' ? 'searchMoreWithId' : 'search'}"

    },

    "RESPONSEDATAPATH1":"${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.searchRowList.searchRow' : 'Body.searchResponse.searchResult.searchRowList.searchRow'}",

    "RESPONSETOTALRESULTS1":"${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.totalRecords' : 'Body.searchResponse.searchResult.totalRecords'}",

    "RESPONSEPAGERESULTS1":"${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.pageSize' : 'Body.searchResponse.searchResult.pageSize'}",

    "ACCOUNTMAPPING1":"name:basic.entityId.searchValue,customproperty1:basic.email.searchValue,accountid:basic.externalId.searchValue.@externalId,customproperty2:basic.giveAccess.searchValue",

    "ENTITLEMENTMAPPING1":{

        "Role":"basic.role.searchValue.@internalId"

    },

    "RESPONSEMAPPING1":{

        "nsId":"Body.searchResponse.searchResult.searchId"

    }

}

[rushikeshvartak]

1) Can we import the NetSuite account and Security Role using the account import JSON mentioned below? Yes from ENTITLEMENTMAPPING1

2) Do we have any additional information on record access? Specifically, which tables need to be accessed to set up the connection? This are SOAP API calls.

[sksuresh2k20]

Need more clarification about this question. We are planning to work on SOD and need data for SOD analysis. Please clarify if this sample JSON works for this requirement.

2) Do we have any additional information on record access? Specifically, which tables need to be accessed to set up the connection? This are SOAP API calls.

[rushikeshvartak]

Once connector is setup all account / entitlement / account to entitlement mapping will be pulled and then you can configure sod

[sksuresh2k20]

Got it. Can I use the same JSON for account import, or do we need any changes on the JSON?

[rushikeshvartak]

You can use same

[sksuresh2k20]

Thank you