Netsuite search select custom field

Question

I am developing an app based on netsuite suitetalk api for webservices, specifically for search. I am able to search for custom multiselectfield using the soap api. Multiselect internalId is 16. Sample below

 <core:customField xsi:type="core:SearchMultiSelectCustomField" internalId="16" operator="anyOf">
           <core:searchValue internalId="1">
  </core:customField>

However when I use the same api, with internalId 5690, it says it is not valid, this is the soap api. 5690 represents a select custom field as opposed to a multi select custom field

 <core:customField xsi:type="core:SearchMultiSelectCustomField" internalId="5690" operator="anyOf">
           <core:searchValue internalId="1">
  </core:customField>

This is the result

<platformCore:status isSuccess="false">
                   <platformCore:statusDetail type="ERROR">
                      <platformCore:code>INVALID_SEARCH_FIELD_OBJ</platformCore:code>
                      <platformCore:message>custentity41 is not a valid search custom field</platformCore:message>
                   </platformCore:statusDetail>
                </platformCore:status>
             </platformCore:searchResult>

what is the operation used to search custom selectfield in netsuite via soap. Is it exposed ? I can do this from netsuite UI. But not finding a way to do it from soap

score 0 · Answer 1 · answered Dec 25 '19 at 11:50

0

I always use SuiteScript inside NetSuite, so I'm not 100% on this... But, I'd say the issue is that you are looking for "core:SearchMultiSelectCustomField" on the Select call. Shouldn't that be changed to "core:SearchSelectCustomField" instead?

answered Dec 25 '19 at 11:50

w3bguy

2,215
1
19
34

1

I think this is the field SearchCustomFieldList. Looking at the schema here. https://webservices.na0.netsuite.com/xsd/platform/v2018_2_0/core.xsd – Sandeep Deshpande Dec 26 '19 at 00:49
1

SearchSelectCustomField doesn't exist. Have checked the schema – Sandeep Deshpande Dec 26 '19 at 01:11
Interesting. I found it referenced in the docs, previously. Maybe they removed it.? – w3bguy Dec 27 '19 at 13:06

score 0 · Answer 2 · answered Dec 30 '19 at 04:11

SearchMultiSelectCustomField type works for SelectCustomField as well. Maybe my soap request was constructed wrong. Or something else. Weird. Basically this works

<core:customField xsi:type="core:SearchMultiSelectCustomField" internalId="5690" operator="anyOf">
       <core:searchValue internalId="1"/>
     </core:customField>

where 5690 is a selectcustomfield ref

Netsuite search select custom field

2 Answers2