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 ...
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 ...
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 ...