RE: Validate Locations using SOAP request
Hey,
I am trying to filter using subsidiary in the Location record using SOAP request.but it’s not working .getting is is not legal operator
Could you pls advise me.
<soapenv:Body>
<search xmlns=”urn:messages_2019_1.platform.webservices.netsuite.com”>
<searchRecord xmlns:q1=”urn:accounting_2019_1.lists.webservices.netsuite.com” xsi:type=”q1:LocationSearch”>
<q1:basic>
<subsidiary operator=”is” xmlns=”urn:common_2019_1.platform.webservices.netsuite.com”>
<searchValue xmlns=”urn:core_2019_1.platform.webservices.netsuite.com”>USA</searchValue>
</subsidiary>
</q1:basic>
</searchRecord>
</search>
</soapenv:Body>
Could you please try:
<subsidiary operator=”anyof” xmlns=”urn:common_2019_1.platform.webservices.netsuite.com”>
Thanks for the assist, but is it possible to validate Using the Subsidiary Name replacing of Subsidiary Id?
Unfortunately, the answer is no. If you are using the suitetalk soap api, you can only use the internalId
. If you want to use the REST api, you can drop a suiteql query where you can do a join and match on the name.