Hello,
We are onboarding the NetSuite application via the SOAP connector and the connection has been successful using the below connection JSON. however, while running the jobs, the jobs are getting failed and error mentioned below. Kindly guide on how to run a successful job for accounts and entitlement imports.
Connection JSON:
{
"authentications":{
"netsuite":{
"properties":{
"SOAP_ENDPOINT":" https://baseurl/services/NetSuitePort_2020_1",
"ACCOUNT":"clientAccount",
"CONSUMER_KEY":"clientConsumerKey",
"CONSUMER_SECRET":"clientConsuemerSecret",
"TOKEN_ID":"clientsTokenID",
"TOKEN_SECRET":"clientsTokenSecret"
}
}
}
}
Job error log:
Regards,
Vidhi
Hello Sahil,
the below errors for 2 different instance connections, the same job running for different SS:
Hello Team,
After updating the GrantAccess JSON and AccountImport JSON, facing the below error. (JSON from the forums - https://forums.saviynt.com/t5/saviynt-knowledge-base/netsuite-integration-soap-connector-with-sample...)
Question - the connection is establishing but jobs are errored.
Kindly let me know if any additional details are needed.
Regards,
Vidhi.
- last edited on by
Sunil
Hello @SB,
Still facing the same error.
Error:
Connection JSON:
{
"authentications": {
"netsuite": {
"properties": {
"SOAP_ENDPOINT": "https://***/services/NetSuitePort_2017_2 ",
"ACCOUNT": "***",
"CONSUMER_KEY": "***",
"CONSUMER_SECRET": "***",
"TOKEN_ID": "***"
"TOKEN_SECRET": "***"
}
}
}
}
Account Import 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.hmacSha256( (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-SHA256\">'+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"
}
}
Log:
2023-11-14T00:14:27+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-116-ffbnn-DEBUG-qry = SELECT il.IMPORTLOGID as IMPORTLOGID,il.logDataAsXML as logDataAsXML,ecmimp.jobid as jobID,ecmimp.jobname as JOBNAME,ecmimp.jobStartDate as JOBSTARTDATE,ecmimp.coments as COMMENTS,ecmimp.jobEndDate as JOBENDDATE,il.filename as FILENAME,ecmimp.SAVRESPONSE as SAVRESPONSE,ecmimp.systemName as SYSTEMNAME,ecmimp.externalconnection as EXTERNALCONNECTION,ecmimp.updateUser as UPDATEUSER,ecmimp.triggername as TRIGGERNAME,ecmimp.jobgroup as JOBGROUP,ecmimp.triggerType as TRIGGERTYPE FROM EcmImportJob ecmimp left join ImportLog il on(ecmimp.jobid=il.jobid) where 1=1 AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_NetSuite_SVC_Accounts' AND ecmimp.jobgroup = 'DATA' ORDER BY ecmimp.jobid DESC limit 0,15
2023-11-14T00:14:27+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-116-ffbnn-DEBUG-extraQry = AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_NetSuite_SVC_Accounts' AND ecmimp.jobgroup = 'DATA'
2023-11-14T00:14:04+05:30-ecm-worker-integration.ExternalConnectionCallService-quartzScheduler_Worker-8-w5l99-DEBUG-Key=jobtriggername Value=I_NetSuite_SVC_Accounts
2023-11-14T00:14:04+05:30-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-8-w5l99-DEBUG-Only one instance is running.. Trigger Name : I_NetSuite_SVC_Accounts
2023-11-14T00:13:59+05:30-ecm-domain.FlatViewJobcontrolController-http-nio-8080-exec-113-ffbnn-DEBUG-Inside fireJobAction params = [triggername:I_NetSuite_SVC_Accounts, triggergroup:GRAILS_JOBS, jobname:SapImportJob, jobgroup:DATA, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]
SOAP Response:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.</faultstring>
<detail>
<ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">partners230.prod-phx-na5.core.ns.internal</ns1:hostname>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
I had changed the port to 2017_2 & signature method to SHA256, but it was still throwing an error.
Kindly let me know if any additional information is needed.
Regards,
Vidhi.
[This message has been edited by moderator to disable URL link]
Hello @SB,
The signature would not affect the output, however, i have still changed the same and it is still failing.
Below Import 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.hmacSha256( (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_SHA256\">'+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"
}
Error:
Regards,
Vidhi.
