This guide will teach you how to export data with VXL. We will use a list API for exporting items and connect each item to a get API for including more details.

Click "Function" menu item to view the function list

Click "+Configurator" to create new function

Add some metadata to the function and select "Export data from M3 BE"

Select "Without Excel file" and optionally edit sheet name and start rows

Select list API

Select list API and optionally edit "Max rows". This is the maximum rows returned by the API. APIs can also by found with Advanced API search.

Select input fields. By selecting "Text Field", an input field will be created in the VXL user interface. Optionally edit the user interface label.

Add multiple output fields

Select some output fields from the list API. Once added the Sorting output fields.

Join get API to get warehouse information

To get warehouse information on each item, the transaction GetItmWhsBasic will be used. Click "Add new API transaction"