How to get the value based on internal id and type using the NetSuite Get Snap

Question

Hi All,
We are trying to get the Values based on Internal Id using the NetSuite Get Snap.
{
{“@internalId”:“3550”
“@scriptId”:“custcol_associatedconsole”
“@xsi:type”:“platformCore:SearchColumnSelectCustomField”
“platformCore:searchValue”:{
“@internalId”:“51”
“@typeId”:“395”
}
“platformCore:customLabel”:“ASSOCIATED CONSOLE _LINE”
}
In the Snap I am Passing the InternalId Is “@internalId”:“51”
Any one have Idea Please help me on this.

Thanks,
kullayappa

ptaylor · Answer

Use the NetSuite Get snap with $baseRef.type = “customList” and $baseRef.internalId = 395.  That will output the full metadata for the custom list with id 395.
Send the output through a JSON Splitter with JSON Path = “$[‘soapenv:Body’].getResponse.readResponse.record[‘setupCustom:customValueList’][‘setupCustom:customValue’]”
In each output record, setupCustom:valueId is the id of the list item, setupCustom:value is the text name of that list item.
I suggest adding a Mapper to map setupCustom:valueId and setupCustom:value to simpler names, such as listValueId and listValueName.
Now you can use the Join snap to join the output from this Mapper to the output from your Search.  Use an Inner join on the listValueId from the Mapper to the platformCore:searchValue.@internalId from the Search (in your example output the value is 51).

Forum Discussion

How to get the value based on internal id and type using the NetSuite Get Snap

1 Reply

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?