How can I make an export that looks like this?

Guillermo Monguió

Hi, I need more or less these columns in one place
Its basically the Lines report but I need to add product SKU and Payment method

ID

,Date,

sku

Qty,

Retail

,Subtotal,

Discount

,Tax

,Total

,Customer

,Payment  Method

Guillermo Monguió

So I mean
need:
Sale ID
Sku
qty
payment method

Adrian Samuel

Hey @Guillermo Monguió you'll need to make a request to the Sale endpoint and then filter and sort through the data accordingly, removing what you need and keeping what you want.

SaleLines.Item & SalePayments.PaymentType are the relations you'll want to load

You can read more about this endpoint here:
https://developers.lightspeedhq.com/retail/endpoints/Sale/

Adrian Samuel

Also, please post your Retail API questions here in future: 
https://community.lightspeedhq.com/en/categories/retail-development