VXL Live can be used to export data from REST APIs into Excel.

Create a new workflow

Create a new workflow and add the label VXL to it - this enables the workflow to be visible in VXL Live.

Untitled

<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" /> All workflows with M3 API and Excel steps are already available in VXL Live.

</aside>

Add Rest API step

Please see Rest API configuration on how to configure the Rest API step in more detail.

{
  "connectionId": "CONNECTION-789eb5a92120417190d7564e32a7a5a2",
  "endpoint": "<https://api.dev.vincelive.dev/users>",
  "method": "get",
  "headers": {
    "content-type": "application/json"
  }
}

Add a Transform step

The transform step needs to ensure that the output data is Excel-compatible