Issue with Netsuite Get Snap
Hi,
I am trying to get customer Details from Netsuite using Netsuite Get snap, but the snap is routing documents to both Error and output views, is there any issue with the snap or Am I doing anyth...
Forum Discussion
What exactly do you mean by “it keeps on loading”? Does the snap appear to still be running?
The issue is that when the snap is writing the SOAP response as a document to the output view, it’s encountering an exception due to a null key somewhere in the document. To diagnose this issue further, we’re going to need to understand what the raw SOAP response looks like. The best way to do this is using the NetSuite UI via the “Setup | Integration | SOAP Web Services Usage Log” screen. You may need someone else with Administrator privilege to do this. Find the Get request that the snap is making, click on Response in the last column, and send us the results. I realize this may be sensitive data that shouldn’t be shared in this public forum. I would suggest opening a support ticket with SnapLogic support containing all the information and referencing this post. Or if you like, you can email the SOAP response to me at ptaylor@snaplogic.com. But I may still end up asking you to create a support ticket. It’s fine to replace sensitive data in the response with “…” or “xxx” or the like, but please try to keep most of it intact.
Hi Taylor,
I am having the same issue as abhinav.
After further analysis i figured out that it only works on Pipeline Execute mode(not validate) because one of the node in the NetSuite Reponse has some special character and SnapLogic might be trying to parse it.
I have reviewed the NetSuite Response Log and came to the conclusion.
Below is the node with special character:
<listRel:customFieldList xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
<platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="XX" internalId="XX">
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="XX" internalId="XX">
<platformCore:value>false</platformCore:value>
</platformCore:customField>
<platformCore:customField xsi:type="platformCore:StringCustomFieldRef">
<platformCore:value><a href='#' onclick='javascript:var regno = trim( nlapiGetFieldValue("vatregnumber"));if (regno != null && regno != ""){var countryCode = trim( regno.substr(0, 2) ); var vatno = trim( regno.substr(2) ); var url = ["http://ec.europa.eu/taxation_customs/vies/vatResponse.html?memberStateCode="];url.push(countryCode);url.push("&number=" + vatno);url.push("&traderName=&traderStreet=&traderPostalCode=&traderCity=&requesterMemberStateCode=&requesterNumber=&action=check&check=Verify");var taxsiteurl = url.join("");var respObject = nlapiRequestURL( taxsiteurl );var response = respObject.getBody();if ( response.indexOf("invalidStyle") > -1 ) { alert( "VAT Registration number "+ regno + " is NOT valid."); }else if (response.indexOf("validStyle") > -1) { alert( "VAT Registration number " + regno + " is valid."); }} else {alert("VAT Registration number is empty.");}'>Click this link to check VAT Reg No.</a></platformCore:value>
</platformCore:customField>
</listRel:customFieldList>
Hi Sharique,
Can you please clarify what your question is? In what sense does it not work during validation? Are you having trouble viewing the preview output?
Hi Taylor,
The issue is exactly the same as described by abhinav. When I do the pipeline validation it results in error (same error as abhinav’s). However, there is no error when I execute the pipeline. Based on my analysis, it is because Snaplogic is unable to read this response data from NetSuite and provide it in the output view(not even in raw) due to special character. Portion of XML response from NetSuite is supplied in my previous comment.
Can you please capture the full stack trace from the error view and paste it in a code block here?
