netsuite
Anfordern von customField, customFieldList & customSearchJoin mit der erweiterten PHP-API

.NET Framework C# Language CSS HTML Java Language JavaScript MySQL PHP Python Language SQL

Einführung

Dies waren einige der schwierigsten (und am wenigsten besprochenen) Dinge, die mit der erweiterten PHP-API-Suche (wo Sie welche Felder angeben) zu tun haben.

Ich bin dabei, zur rest_suite github-Bibliothek zu migrieren, die RESTLET verwendet, und das PHP-Parallelisierungslimit für PHP-Benutzer von 1 zu umgehen.

Aber bevor ich meinen alten Code lösche, poste ich ihn hier. Beispielspezifikationen für diese Felder finden Sie hier: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/schema/search/transactionsearchrow.html?mode=package

customField & customFieldList-Verwendung

$service = new NetSuiteService();
$search = new TransactionSearchAdvanced();
$internalId = '123';//transaction internalId

$search->criteria->basic->internalIdNumber->searchValue = $internalId;
$search->criteria->basic->internalIdNumber->operator = "equalTo";

$field = new SearchColumnSelectCustomField();
$field->scriptId = 'custbody_os_freight_company';//this is specific to you & found in netsuite
$search->columns->basic->customFieldList->customField[] = $field;

$field = new SearchColumnStringCustomField();
$field->scriptId = 'custbody_os_warehouse_instructions';//this is specific to you & found in netsuite
$search->columns->basic->customFieldList->customField[] = $field;

//and so on, you can keep adding to the customField array the custom fields you want

$request = new SearchRequest();

$request->searchRecord = $search;

$searchResponse = $service->search($request);

customSearchJoin-Nutzung

$service = new NetSuiteService();
$search = new TransactionSearchAdvanced();
$internalId = '123';//transaction internalId

$search->criteria->basic->internalIdNumber->searchValue = $internalId;
$search->criteria->basic->internalIdNumber->operator = "equalTo";

$CustomSearchRowBasic = new CustomSearchRowBasic();
$CustomSearchRowBasic->customizationRef->scriptId = 'custbody_os_entered_by';//this is specific to you & found in netsuite
$CustomSearchRowBasic->searchRowBasic = new EmployeeSearchRowBasic();
$CustomSearchRowBasic->searchRowBasic->entityId = new SearchColumnStringField();

$search->columns->customSearchJoin[] = $CustomSearchRowBasic;
//and so on, you can keep adding to the customSearchJoin array the custom fields you want         

$request = new SearchRequest();

$request->searchRecord = $search;

$searchResponse = $service->search($request);

Modified text is an extract of the original Stack Overflow Documentation

Lizenziert unter CC BY-SA 3.0

Nicht angeschlossen an Stack Overflow