cancel
Showing results for 
Search instead for 
Did you mean: 

Export data using flexible search query

Former Member
0 Kudos

Tried using exportItemsFlexibleSearch to export data but got error. Exportitems method worked though. Will appreciate any help.

Former Member
0 Kudos

you might be added wrong query to below method exportItemsFlexibleSearch, method returns a specified item type therefor you can export only one type(like product, customer etc..) and all attributes which are metioned in your impex header of that type would be exported in to CSV file. Make sure you have written a query which is returning PK of a type only.

Ex-

INSERT Customer;customerId[unique=true] "#% impex.exportItemsFlexibleSearch(""SELECT {c:pk} FROM {Customer as C}"");"

Accepted Solutions (0)

Answers (0)