Exporting Data from SAP Commerce by ImpEx
From time to time I need to export data from SAP Commerce Cloud system. For me the best approach is to have them in Excel where I can filter them out nicely. I usually use for that ImpEx Export with flexibleSearch query. Here is an example of that kind of script: in export line there is FlexibleSearch query with WHERE clause which I use to filter out data for my needs. Usually I run ImpEx Export from hac cockpit, where I have zip file listed right away after execution. Package contains CSV file, which I open in Excel/Calc/Numbers and do the filtering. Recently I had to remove large volume of business processes after load tests. For that I have created similar impex, but with more user-friendly method for querying data to be filtered. Here I have used exportItemsFlexibleSearch method. impex.exportItemsFlexibleSearch(""/* flexible search query */""); Here as you can see, there is only query used, with no additional parameters required. Generated zip f...