Attach File to Transaction

4min
NetSuite API does not support attaching a file directly to the transaction, so we need minor customizations in NetSuite and Salesforce to attach the file to a transaction.
In NetSuite:
Create a custom field of type document on the transaction to which you want to attach the file.
﻿
In Salesforce:
Once you create the custom field in NetSuite, visit the Breadwinner tab, go to the custom fields section, and click "Fetch custom fields." You can see the created custom field here with the checkbox disabled.
Do the following steps:
Create the field of type text manually in Salesforce with the API name shown in the custom fields section, i.e., for example. If your NetSuite API name is custbody44, you must give the salesforce API name as ncf_body44__c. Refer to the sample screenshot attached below.
﻿
After creating the field in Salesforce, give the required permissions at the profile level.
To cross-check whether the field is created correctly, visit the custom fields section. The disabled checkbox should be checked.
To link the document to this field, pass the internal id of the file to that custom field using the update action in Global API.
The following is an example of updating the Sales Order by passing the file's internal id to the custom field.
Apex
//  Create a Map to store all the data of a Sales Order
Map<String, Object> nsSalesOrder = new Map<String, Object>();
nsSalesOrder.put('internalId', '122466'); // pass the internalid of the sales order.

// Initialize the Sales Order Custom Fields
List<Object> soCustomFieldList = new List<Object>();
Map<String,Object> soCustomField = new Map<String,Object>();
soCustomField.put('fieldType', 'string');
soCustomField.put('scriptId', 'custbody44');
soCustomField.put('value', '2178'); // pass the internalid of the file.
soCustomFieldList.add(soCustomField);

// Add the Sales Order Custom Fields
nsSalesOrder.put('customFieldList', new Map<String,Object>{'customField'=>soCustomFieldList});

// Initialize the RequestJSON Data to be passed.
Map<String, Object> requestJSONMap = new Map<String, Object>();
requestJSONMap.put('salesOrders', new List<Object>{nsSalesOrder});
String reqJSON = JSON.serialize(requestJSONMap);

Map<String, Object> reqObj = new Map<String, Object>();
reqObj.put('version', '1.0');
reqObj.put('action', 'updateSalesOrder');
reqObj.put('requestJSON', reqJSON);

// Place a request to Breadwinner Global API
Map<String, Object> resp = breadwinner_ns.BreadwinnerNetSuiteAPI.call(reqObj);
System.debug(resp);
//  Create a Map to store all the data of a Sales Order
Map<String, Object> nsSalesOrder = new Map<String, Object>();
nsSalesOrder.put('internalId', '122466'); // pass the internalid of the sales order.

// Initialize the Sales Order Custom Fields
List<Object> soCustomFieldList = new List<Object>();
Map<String,Object> soCustomField = new Map<String,Object>();
soCustomField.put('fieldType', 'string');
soCustomField.put('scriptId', 'custbody44');
soCustomField.put('value', '2178'); // pass the internalid of the file.
soCustomFieldList.add(soCustomField);

// Add the Sales Order Custom Fields
nsSalesOrder.put('customFieldList', new Map<String,Object>{'customField'=>soCustomFieldList});

// Initialize the RequestJSON Data to be passed.
Map<String, Object> requestJSONMap = new Map<String, Object>();
requestJSONMap.put('salesOrders', new List<Object>{nsSalesOrder});
String reqJSON = JSON.serialize(requestJSONMap);

Map<String, Object> reqObj = new Map<String, Object>();
reqObj.put('version', '1.0');
reqObj.put('action', 'updateSalesOrder');
reqObj.put('requestJSON', reqJSON);

// Place a request to Breadwinner Global API
Map<String, Object> resp = breadwinner_ns.BreadwinnerNetSuiteAPI.call(reqObj);
System.debug(resp);
﻿
﻿
Updated 05 May 2023
Did this page help you?
Upload File
Initiate Regular Sync