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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/0bb45d28-037e-4c7c-bb58-a090dfcf49d3/image2017-3-27_13-7-6.png

Click "+Configurator" to create new function

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/e7c7b9ff-7d7d-4625-b62c-5eed01ac82bd/image2017-4-17_20-29-1.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/0b3a99f5-2788-4361-86ee-6bd9d1b4c534/image2017-4-17_20-29-54.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/6597767d-d284-406f-b46f-6cf94f9a6d5e/image2017-3-27_13-26-18.png

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.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/5c43ec36-adc4-49e5-a7ad-697a524ea164/image2017-3-27_13-30-18.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/59cb834a-1b71-4c98-beaa-96734135a118/image2017-3-27_13-34-31.png

Add multiple output fields

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/24f4efee-e1c9-4b54-8fda-571f1456a334/image2017-3-27_13-44-9.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/c5dc8d98-246a-4875-a863-a016e54984f8/image2017-3-27_13-45-11.png

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"