netsuite
Żądanie customField, customFieldList i customSearchJoin z PHP Advanced Search

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

Wprowadzenie

Te, w których niektóre z najtrudniejszych (i najmniej mówionych) tematów dotyczą zaawansowanego wyszukiwania interfejsu API PHP (w którym określasz, które pola).

Jestem w trakcie migracji do biblioteki github rest_suite, która używa RESTLET, i omija limit współbieżności użytkownika interfejsu API PHP wynoszący 1.

Ale zanim usunę mój stary kod, umieszczam go tutaj. Przykładowe specyfikacje dla tych pól można znaleźć tutaj: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/schema/search/transactionsearchrow.html?mode=package

Wykorzystanie customField i customFieldList

$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);

Wykorzystanie customSearchJoin

$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

Licencjonowany na podstawie CC BY-SA 3.0

Nie związany z Stack Overflow