I am working on a solution on workato automation tool where I have to search newly created or updated invoices from NetSuite and get it synced to salesforce.
As per this requirement I am performing a netsuite search operation in workato, which internally using "TransactionSearchAdvanced" in netsuite.
The response I am getting is having internal ids of currency and payment terms not the name. As show below.
My requirement is to get currency name e.g "UDS" and payment term name e.g. "Net 45".
I had developed a similar solution using mulesoft and in mulesot currenyName and termName meta data were automatically coming to select but in workato it is not coming.
Is there any special join I can use in netsuite save search? I have tried save search as well but counldnt find the relation between transaction and terms.
Below are the requests I can see in the netsutie web service log when I execute the search operation in workato.
And this is the xml requiest this connector is making to netsutie.
<env:Envelope xmlns:transactionsInventoryTypes="urn:types.inventory_2020_2.transactions.webservices.netsuite.com" xmlns:setupCustomization="urn:customization_2020_2.setup.webservices.netsuite.com" xmlns:listsSupplychainTypes="urn:types.supplychain_2020_2.lists.webservices.netsuite.com" xmlns:transactionsGeneral="urn:general_2020_2.transactions.webservices.netsuite.com" xmlns:platformCore="urn:core_2020_2.platform.webservices.netsuite.com" xmlns:transactionsDemandplanningTypes="urn:types.demandplanning_2020_2.transactions.webservices.netsuite.com" xmlns:transactionsDemandPlanning="urn:demandplanning_2020_2.transactions.webservices.netsuite.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:generalCommunicationTypes="urn:types.communication_2020_2.general.webservices.netsuite.com" xmlns:listsRelationshipsTypes="urn:types.relationships_2020_2.lists.webservices.netsuite.com" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:platformCommon="urn:common_2020_2.platform.webservices.netsuite.com" xmlns:generalCommunication="urn:communication_2020_2.general.webservices.netsuite.com" xmlns:transactionsInventory="urn:inventory_2020_2.transactions.webservices.netsuite.com" xmlns:listsWebsite="urn:website_2020_2.lists.webservices.netsuite.com" xmlns:listsSupplyChain="urn:supplychain_2020_2.lists.webservices.netsuite.com" xmlns:listsAccountingTypes="urn:types.accounting_2020_2.lists.webservices.netsuite.com" xmlns:platformMsgs="urn:messages_2020_2.platform.webservices.netsuite.com" xmlns:listsEmployees="urn:employees_2020_2.lists.webservices.netsuite.com" xmlns:listsMarketing="urn:marketing_2020_2.lists.webservices.netsuite.com" xmlns:transactionsCustomers="urn:customers_2020_2.transactions.webservices.netsuite.com" xmlns:activitiesSchedulingTypes="urn:types.scheduling_2020_2.activities.webservices.netsuite.com" xmlns:transactionsSales="urn:sales_2020_2.transactions.webservices.netsuite.com" xmlns:listsWebsiteTypes="urn:types.website_2020_2.lists.webservices.netsuite.com" xmlns:listsRelationships="urn:relationships_2020_2.lists.webservices.netsuite.com" xmlns:transactionsBank="urn:bank_2020_2.transactions.webservices.netsuite.com" xmlns:listsMarketingTypes="urn:types.marketing_2020_2.lists.webservices.netsuite.com" xmlns:listsSupportTypes="urn:types.support_2020_2.lists.webservices.netsuite.com" xmlns:platformFaults="urn:faults_2020_2.platform.webservices.netsuite.com" xmlns:documentsFileCabinet="urn:filecabinet_2020_2.documents.webservices.netsuite.com" xmlns:transactionsFinancial="urn:financial_2020_2.transactions.webservices.netsuite.com" xmlns:listsSupport="urn:support_2020_2.lists.webservices.netsuite.com" xmlns:setupCustomizationTypes="urn:types.customization_2020_2.setup.webservices.netsuite.com" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:transactionsEmployees="urn:employees_2020_2.transactions.webservices.netsuite.com" xmlns:activitiesScheduling="urn:scheduling_2020_2.activities.webservices.netsuite.com" xmlns:documentsFilecabinetTypes="urn:types.filecabinet_2020_2.documents.webservices.netsuite.com" xmlns:transactionsSalesTypes="urn:types.sales_2020_2.transactions.webservices.netsuite.com" xmlns:listsAccounting="urn:accounting_2020_2.lists.webservices.netsuite.com" xmlns:transactionsPurchases="urn:purchases_2020_2.transactions.webservices.netsuite.com" xmlns:listsEmployeesTypes="urn:types.employees_2020_2.lists.webservices.netsuite.com">
<env:Header>
<platformCore:tokenPassport>
<platformCore:account>******</platformCore:account>
<platformCore:consumerKey>****************************************************************</platformCore:consumerKey>
<platformCore:token>****************************************************************</platformCore:token>
<platformCore:nonce>*****</platformCore:nonce>
<platformCore:timestamp>******</platformCore:timestamp>
<platformCore:signature algorithm="HMAC_SHA256">*********************************************</platformCore:signature>
</platformCore:tokenPassport>
<platformMsgs:searchPreferences>
<platformMsgs:pageSize>200</platformMsgs:pageSize>
<platformMsgs:bodyFieldsOnly>false</platformMsgs:bodyFieldsOnly>
</platformMsgs:searchPreferences>
</env:Header>
<env:Body>
<platformMsgs:search>
<platformMsgs:searchRecord xsi:type="transactionsSales:TransactionSearchAdvanced">
<transactionsSales:criteria>
<transactionsSales:basic>
<platformCommon:lastModifiedDate operator="after">
<platformCore:searchValue>2022-08-01T03:42:08+00:00</platformCore:searchValue>
</platformCommon:lastModifiedDate>
<platformCommon:mainLine>
<platformCore:searchValue>true</platformCore:searchValue>
</platformCommon:mainLine>
<platformCommon:type operator="anyOf">
<platformCore:searchValue>_invoice</platformCore:searchValue>
</platformCommon:type>
</transactionsSales:basic>
</transactionsSales:criteria>
<transactionsSales:columns>
<transactionsSales:basic>
<platformCommon:amountRemaining>nil</platformCommon:amountRemaining>
<platformCommon:tranDate>nil</platformCommon:tranDate>
<platformCommon:dueDate>nil</platformCommon:dueDate>
<platformCommon:status>nil</platformCommon:status>
<platformCommon:recordType>nil</platformCommon:recordType>
<platformCommon:total>nil</platformCommon:total>
<platformCommon:terms>nil</platformCommon:terms>
<platformCommon:otherRefNum>nil</platformCommon:otherRefNum>
<platformCommon:tranId>nil</platformCommon:tranId>
<platformCommon:internalId>nil</platformCommon:internalId>
<platformCommon:salesRep>nil</platformCommon:salesRep>
<platformCommon:currency>nil</platformCommon:currency>
<platformCommon:exchangeRate>nil</platformCommon:exchangeRate>
<platformCommon:lastModifiedDate>nil</platformCommon:lastModifiedDate>
<platformCommon:customFieldList>
<platformCore:customField scriptId="custbody_sfdc_customer_id" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custbody_collections_notes" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custbody_sfdc_opp_int_id" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custbody_customer_success_manager" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_expense_url" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_far_trn_relatedasset" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_2663_lastname" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_2663_firstname" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_2663_companyname" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_2663_isperson" xsi:type="platformCore:SearchColumnBooleanCustomField"/>
<platformCore:customField scriptId="custcol_2663_eft_file_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9997_dd_file_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_nsts_gaw_col_approver" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_tran_no" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_opp_type" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_po_line_id" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_coursera_term_in_days_so" xsi:type="platformCore:SearchColumnLongCustomField"/>
<platformCore:customField scriptId="custcol_coursera_term_end_date" xsi:type="platformCore:SearchColumnDateCustomField"/>
<platformCore:customField scriptId="custcol_coursera_term_start_date" xsi:type="platformCore:SearchColumnDateCustomField"/>
<platformCore:customField scriptId="custcol_coursera_rev_rec_rule_so" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_is_a_mod" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_system_contract" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_content_fee_unit_price" xsi:type="platformCore:SearchColumnDoubleCustomField"/>
<platformCore:customField scriptId="custcol_degree_item" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_degree_term" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_9572_eft_entitybank_sub" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_eft_entitybank_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_dd_entitybank_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_dd_entitybank_sub" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_dd_file_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_cr_entitybank_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_cr_entitybank_sub" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol_9572_custref_file_format" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol1" xsi:type="platformCore:SearchColumnBooleanCustomField"/>
<platformCore:customField scriptId="custcol2" xsi:type="platformCore:SearchColumnDateCustomField"/>
<platformCore:customField scriptId="custcol3" xsi:type="platformCore:SearchColumnBooleanCustomField"/>
<platformCore:customField scriptId="custcol4" xsi:type="platformCore:SearchColumnBooleanCustomField"/>
<platformCore:customField scriptId="custcol_ibm_project" xsi:type="platformCore:SearchColumnSelectCustomField"/>
<platformCore:customField scriptId="custcol13" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_15529_eft_enabled" xsi:type="platformCore:SearchColumnBooleanCustomField"/>
<platformCore:customField scriptId="custcol_coupa_er_lineid" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_coupa_er_desc" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_coupa_er_reason" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_coupa_po_url" xsi:type="platformCore:SearchColumnStringCustomField"/>
<platformCore:customField scriptId="custcol_sfdc_line_id" xsi:type="platformCore:SearchColumnLongCustomField"/>
<platformCore:customField scriptId="custcol_cseg1" xsi:type="platformCore:SearchColumnSelectCustomField"/>
</platformCommon:customFieldList>
</transactionsSales:basic>
</transactionsSales:columns>
</platformMsgs:searchRecord>
</platformMsgs:search>
</env:Body>
</env:Envelope>
