AF
HomeTagSubmit NotesAsk AnythingLoginSubscribe Us
AF
1. Feel Free to ask and submit anything on Anyforum.in and get satisfactory answer
2. Registration is not compulsory, you can directly login via google or facebook
3. Our Experts are looking for yours ?.



web-service-netsuite: How to get single custom field value of netsuite using web services?

How get single custom field value of netsuite any record using web services through C#?

web-service x 19
netsuite x 18
Posted On : 2015-02-03 08:22:33.0
profile Amol Ghadage - anyforum.in Amol Ghadage
2900
up-rate
2
down-rate

Answers


You can use getCustomizationId method to return meta data for customizations by the specified customization type.

Within the array of customizations, you can find the particular customization you need, and all the meta data associated with it, including your custom list. You may find all the information you need. By doing get operation on the custom list, you can retrieve all values and IDs.


Following is the sample code to get a custom field value:
-------------------------------------------------------------------------------------------
The code focused on trying to make as few calls out to NetSuite as possible. This assumed that you would be re-using much of this data in multiple transactions.


// NetSuite Session
// _service is constructed elsewhere in code.

// Global Values
Dictionary<string, CustomizationRef> _Dictionary_CustomListRef = new Dictionary<string, CustomizationRef>();
Dictionary<string, CustomList> _Dictionary_CustomList = new Dictionary<string, CustomList>();
Dictionary<string, TransactionBodyCustomField> _Dictionary_TransactionBodyCustomField = new Dictionary<string, TransactionBodyCustomField>();

private CustomFieldRef NetSuite_CreateSelectCustomFieldRef(string sName, string sValue)
{
//List or Record Type reference
SelectCustomFieldRef custbody_field = new SelectCustomFieldRef();
custbody_field.internalId = sName;
custbody_field.value = new ListOrRecordRef();

// Get the Targeted List that we point to in NetSuite
custbody_field.value.typeId = NetSuite_getTransactionBodyCustomFieldListInternalId(sName);

// Get ID of List Value from our targeted list in NetSuite
custbody_field.value.internalId = NetSuite_getCustomListValueID(custbody_field.value.typeId, sValue);

return custbody_field;
}

private string NetSuite_getTransactionBodyCustomFieldListInternalId(string sID)
{
string sReturnValue = string.Empty;

TransactionBodyCustomField tbCustomField = NetSuite_getTransactionBodyCustomField(sID);

if (tbCustomField != null)
{
sReturnValue = tbCustomField.selectRecordType.internalId;
}

return sReturnValue;
}

private TransactionBodyCustomField NetSuite_getTransactionBodyCustomField(string sID)
{
TransactionBodyCustomField tbCustomField = null;

if (!_Dictionary_TransactionBodyCustomField.TryGetValue(sID, out tbCustomField))
{
// Gets a specific custom body object
CustomizationRef cref = new CustomizationRef();
cref.internalId = sID;
cref.scriptId = sID;
cref.type = RecordType.transactionBodyCustomField;
cref.typeSpecified = true;
ReadResponse res = _service.get(cref);

if (res.status.isSuccess)
tbCustomField = res.record as TransactionBodyCustomField;

_Dictionary_TransactionBodyCustomField.Add(sID, tbCustomField);
}

return tbCustomField;
}

private bool NetSuite_TryGetCustomList(string sCustomListInternalID, out CustomList custList)
{
custList = null;
bool bSuccess = false;

if (!_Dictionary_CustomList.TryGetValue(sCustomListInternalID, out custList))
{
if (_Dictionary_CustomListRef.Count == 0)
initializeCustomListDictionary();

CustomizationRef crCustomList = null;

if (_Dictionary_CustomListRef.TryGetValue(sCustomListInternalID, out crCustomList))
{
RecordRef recRef = new RecordRef();
recRef.internalId = crCustomList.internalId;
recRef.type = RecordType.customList;
recRef.typeSpecified = true;
ReadResponse readResp = _service.get(recRef);

if (readResp.status.isSuccess)
custList = readResp.record as CustomList;

_Dictionary_CustomList.Add(sCustomListInternalID, custList);
}
}

if (custList == null)
bSuccess = false;
else
bSuccess = true;

return bSuccess;
}

private string NetSuite_getCustomListScriptID(string sCustomListInternalID)
{
string sReturnValue = string.Empty;
CustomList custList;

if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
sReturnValue = custList.scriptId;

return sReturnValue;
}

private string NetSuite_getCustomListValueID(string sCustomListInternalID, string sValue)
{
string sReturnValue = string.Empty;
CustomList custList;

if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
{
CustomListCustomValue[] clValueList = custList.customValueList.customValue;

foreach(CustomListCustomValue clValue in custList.customValueList.customValue)
{
if (clValue.value.ToUpper() == sValue.ToUpper())
{
sReturnValue = clValue.valueId.ToString();
break;
}
}
}

return sReturnValue;
}

private void initializeCustomListDictionary()
{
_Dictionary_CustomListRef.Clear();

// Gets all of the custom lists
CustomizationType ct = new CustomizationType();
ct.getCustomizationType = GetCustomizationType.customList;
ct.getCustomizationTypeSpecified = true;

GetCustomizationIdResult res = _service.getCustomizationId(ct, true);

foreach (CustomizationRef cref in res.customizationRefList)
_Dictionary_CustomListRef.Add(cref.internalId, cref);
}



Additionally when going back the other way (extracting a value) here is how to turn the ID back into the selected value text. The customField object is a CustomFieldRef obtained from the "options" field of the transaction (which is an array of CustomFieldRefs).

SelectCustomFieldRef selectCustFieldRef = customField as SelectCustomFieldRef;
sCustFieldRefId = selectCustFieldRef.internalId;
sCustFieldRefValue = NetSuite_getCustomListValueFromID(selectCustFieldRef.value.typeId, long.Parse(selectCustFieldRef.value.internalId));

private string NetSuite_getCustomListValueFromID(string sCustomListInternalID, long lValue)
{
string sReturnValue = string.Empty;
CustomList custList;

if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
{
CustomListCustomValue[] clValueList = custList.customValueList.customValue;

foreach (CustomListCustomValue clValue in custList.customValueList.customValue)
{
if (clValue.valueId == lValue)
{
sReturnValue = clValue.value;
break;
}
}
}

return sReturnValue;
}

Posted On : 2015-02-03 17:29:40
Satisfied : 1 Yes  0 No
profile Garima Gupta - anyforum.in Garima Gupta
596129554554
Reply This Thread
up-rate
2
down-rate



Post Answer
Please Login First to Post Answer: Login login with facebook - anyforum.in