NetSuite Source: How to retrieve transaction records like Sales Orders
Sales order records are found under the general transactions record. To retrieve them, specify a SearchXml statement. For sales order records, specifically, you can use the following statement:
1 2 3 4 5 | <TransactionSearchBasic> <type operator="anyOf"> <searchValue>_salesOrder</searchValue> </type></TransactionSearchBasic> |
Book a Presales Call
Related Articles
NetSuite Source: How to modify the SearchXML statement dynamically at runtime
The SearchXML parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired SearchXML statement. Right-click on the data flow canvas and select ...Where can I find the documentation for the NetSuite Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the NetSuite Source can be found at the following link. For many of the components you can find resources ...How to work with composite records handling in a Netsuite source component.
The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with blank row (all NULLs). For ...How can I retrieve updated and deleted Salesforce records?
You can use the following reusable script with the JavaScript component to retrieve records that were deleted from Salesforce between specified dates: https://www.cozyroc.com/ssis/script-salesforce-get-deleted-source To retrieve records that have ...How to work with composite records handling in a Netsuite destination component.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received ...