Get products from all orders at once

janson1972janson1972 Posts: 1Member
The API documentation of the GET OrderProduct endpoint says "Retrieve a list of all order products from this shop." But in the example URL and order id must be given. Does anyone know how to retrieve all products from all orders at once?
I need this to get all orders and ordered products in a Power BI report.


  • Alex LugoAlex Lugo Posts: 106Administrator, Lightspeed Staff moderator
    Hello @janson1972,

    You need to fetch all the orders id first (Order endpoint) and then using the OrderProduct endpoint obtain the products assigned to each order.
    Alex Lugo
    API Support Specialist
    Lightspeed HQ
Sign In or Register to comment.