I'm running into an interesting issue trying to do a search (SOAP API) on the Fixed Asset Management modules FAM Asset Custom Record. Attached is a screenshot of the "ID" field which has the id "name" in the API. If I try to search 3570 under

id

, I get ALL FAM Assets (~1200 records). It doesn't look like

id

exists at all on the record:

$search = new SearchLongField();
$search->searchValue = '3570'; // 3570
$search->operator = SearchLongFieldOperator::equalTo;

$customRecordSearch = new CustomRecordSearch();
$customRecordSearch->basic = new CustomRecordSearchBasic();
$customRecordSearch->basic->recType = new RecordRef();
$customRecordSearch->basic->recType->type = RecordType::customRecord;
$customRecordSearch->basic->recType->internalId = 352;
$customRecordSearch->basic->id = $search;

$request = new SearchRequest();
$request->searchRecord = $customRecordSearch;

$response = $this->netSuite->search($request);

When I try to search by the

name

3570, I get no records:

$search = new SearchStringField();
$search->searchValue = '3570';
$search->operator = SearchStringFieldOperator::is;

$customRecordSearch = new CustomRecordSearch();
$customRecordSearch->basic = new CustomRecordSearchBasic();
$customRecordSearch->basic->recType = new RecordRef();
$customRecordSearch->basic->recType->type = RecordType::customRecord; // 'customRecord'
$customRecordSearch->basic->recType->internalId = 352;
$customRecordSearch->basic->name = $search;

$request = new SearchRequest();
$request->searchRecord = $customRecordSearch;

$response = $this->netSuite->search($request);

If I try to search by the

name

"Sierra 1500 4x4 Crew Cab SLE" I get 7 records:

$search = new SearchStringField();
$search->searchValue = 'Sierra 1500 4x4 Crew Cab SLE';
$search->operator = SearchStringFieldOperator::is;

$customRecordSearch = new CustomRecordSearch();
$customRecordSearch->basic = new CustomRecordSearchBasic();
$customRecordSearch->basic->recType = new RecordRef();
$customRecordSearch->basic->recType->type = RecordType::customRecord; // 'customRecord'
$customRecordSearch->basic->recType->internalId = 352;
$customRecordSearch->basic->name = $search;

$request = new SearchRequest();
$request->searchRecord = $customRecordSearch;

$response = $this->netSuite->search($request);

I dug into the records from my 7 record response, and it looks like the ID "3570" is held under

customRecordId

(screenshot 2). I'm not entirely sure how to do a

CustomRecordSearch

that searches that

customRecordId

column. Any ideas? I have to be able to search that "3570" that's being held in customRecordId because that's the only field that is synced between the two systems I'm integrating with.