Salesforce to Netsuite Integration Customer Payment Pipeline
Hi Guys, I’m trying to create a pipeline for Salesforce to Netsuite under Customer Payment object but I’m receiving this error: NetSuite Upsert[6229cd6941e91eb70ab295de_f05dc31f-cf24-44a8-bbd5-edce8bb8bae2 – 17235f10-139d-4e11-854c-0a96387c9b98] `com.snaplogic.snap.api.SnapDataException: Invalid JSON path: platformCore:status.platformCore:statusDetail.platformCore:message at com.snaplogic.snaps.netsuite.NetsuiteUtil.getValueAtJsonPath(NetsuiteUtil.java:577) at com.snaplogic.snaps.netsuite.NetSuiteCommon.parseResponseJson(NetSuiteCommon.java:933) at com.snaplogic.snaps.netsuite.NetSuiteCommon$3.call(NetSuiteCommon.java:430) at com.snaplogic.snaps.netsuite.NetSuiteCommon$3.call(NetSuiteCommon.java:423) at com.snaplogic.snaps.netsuite.NetSuiteCommon.doWithRetry(NetSuiteCommon.java:578) at com.snaplogic.snaps.netsuite.NetSuiteCommon.postRequest(NetSuiteCommon.java:423) at com.snaplogic.snaps.netsuite.NetSuiteCommon.makeRequestWithDocument(NetSuiteCommon.java:403) at com.snaplogic.snaps.netsuite.ListCommon.sendBatch(ListCommon.java:135) at com.snaplogic.snaps.netsuite.ListCommon.handle(ListCommon.java:122) at com.snaplogic.cc.snap.common.SnapRunnableImpl.callback(SnapRunnableImpl.java:849) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeForSuggest(SnapRunnableImpl.java:657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:865) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:436) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:120) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Reason: Expecting object for JSON-Path field reference ‘platformCore:message’, found: List Resolution: Please address reported issue. Error Fingerprint[0] = efp:com.snaplogic.snaps.netsuite.-52e7b00` I’m not quite sure where to fix the error. If ever there is an available example pipeline for Netsuite Customer Payments that would be very helpful, I’m not seeing much resource for it. Attached here is the exported pipeline. Any help would be appreciated. Thanks! SF to Netsuite Payment to Customer Payment.slp (28.8 KB)
Creating File in NetSuite File Cabinet using NetSuite Create Snap
I have various types of binary files such as word document, Excel, PDF, images etc. stored in MySQL DB as blob storage. I am transferring this files to NetSuite File Cabinet using NetSuite Create snap and selecting File as record type. The problem is that when I run the snap, it is only creating partial files on NetSuite. For e.g. I have one PDF file of 21KB but on NetSuite it is only creating PDF file with size of 6Bytes hence it is a corrupted file. How do I make sure the file is getting transferred correctly from MySQL blob to NetSuite File cabinet?NetSuite Attach Operation
We are building a pipeline where we create a vendor record in NetSuite using NetSuite Create Snap. We also have some attachments related to vendor that we would like to attach to the vendor when it is created in NetSuite using NetSuite Snaps. Based on NetSuite Doucment, we have attach method that we can use to attach file to vendor record. We can upload a file in NetSuite File Cabinet using NetSuite Create Snap and selecting File record. But I do not see this attach option in NetSuite Snap anywhere. How do I send the attachment details in NetSuite while creating a record? Or how do I link the attachment to record once it is uploaded in File Cabinet using available NetSuite Snaps?Using NetSuite Snap to fetch all the records from NetSuite
I am trying to get all the records for given object for e.g. vendors from NetSuite and store that information in MySQL DB. I tried to use NetSuite Get Snap but it requires use to pass the internal id and type of the object which we are trying to get and store in the MySQL DB in the first place. How can get all the records of different objects from NetSuite? in NetSuite update, we have dropdown for Object from where we can select different type of objects. Why don’t we have same dropdown in NetSuite Get Snap to get all the records for that objects?
Does NS Search Snap takes the date paramter as the criteria along with the saved search id?
Hello, We have a requirement for which we need to get the data using the NS Saved search. We have the savedSearchScriptId with us and we are passing this id to the NS Search Snap. We have enabled body fields, advanced fields and etc. The NS Search Snap is working as expected and producing the output as expected. Say for example, we have got 348 records when we run the NS Search pipeline. But out of there 348 reocrds we need only the records that are modified recently. So is there any way that I can pass the date parameter along with the search id to the NS Search snap so that the Snap takes the date and search id as the input parameters and produces the output that is matching the date parameter? This is kind of having a WHERE condition on the saved search. Help is appreciated. Thanks in advanceDoes NS Search Snap call getList action internally?
Hello, Hope you are doing good. We are using NS Search, NS Update, NS Get, and NS Upsert Snaps in most of our integrations. We would like to know if any one of the above snaps uses getList action? When we verify the logs we are always seeing an extra connection or connections were made to NS with the action as “getList” even though we are not explicitly using the NS GetList Snap. Can someone help me here on why there are extra connections are being made to NS? Below is the screenshot for reference We are mostly seeing this extra connectivity along with the Search action. Let me know if you need more information. Thanks in advanceMissing NetSuite Object: Customer-Subsidiary Relationship
Hi Team, I am using token-based authentication and trying to use ‘NetSuite Upsert’ snap to Upsert an object called ‘Customer-Subsidiary Relationship’. As per the NetSuite Upsert documentation(https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438202/NetSuite+Upsert), the object in question is available in the supported list of objects (version 2019.2) This NetSuite object is missing from the dropdown list Kindly look into this or advise next course of action.
