Sales by product from Dear API
We need to export our sales for each product to a spreadsheet for forecasting and order calculation.
I would like to replicate the 'Sales By Product Details Report' with the API.
The difficulty is that we have to get the sale list and then loop through for each sale and download the invoice lines, however I have not managed to extract the invoice lines from the JSON in excel.
Does anyone know a more direct way of accessing invoice lines or how to get the invoice lines from the Sale JSON?
2 people have this question