Data From Lightspeed

Relevant API Endpoints and Sample Data

Overview

Lightspeed has granted Oz access to most, if not all, of its API endpoints. Using basic authentication (find credentials in Last Pass) the API returns JSON by default. The only endpoints useful for LPE's purposes are documented below.

Returns a list of dealerships we have access to

GET https://int.LightspeedADP.com/lsapi/Dealer

200: OK List of dealerships and their account numbers (CMFs)

{
    [
    {
        "Cmf": "76210637",
        "DealershipName": "Young Powersports of Ogden",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2019-07-02T00:00:00"
    },
    {
        "Cmf": "76210638",
        "DealershipName": "Young Powersports of Layton",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2020-11-30T00:00:00"
    },
    {
        "Cmf": "76210748",
        "DealershipName": "Young Powersports of Idaho",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2020-01-06T00:00:00"
    },
    {
        "Cmf": "76221085",
        "DealershipName": "Young Powersports of Pleasant View",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2020-11-09T00:00:00"
    },
    {
        "Cmf": "76221609",
        "DealershipName": "Young Powersports of Centerville",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2020-11-23T00:00:00"
    },
    {
        "Cmf": "76221634",
        "DealershipName": "Young Powersports of Centerville 2",
        "DealerNumber": "",
        "DirectConnect": 1,
        "DirectConnectDate": "2020-11-23T00:00:00"
    },
    {
        "Cmf": "",
        "DealershipName": "",
        "DealerNumber": "",
        "DirectConnect": 0,
        "DirectConnectDate": null
    }
]
}

Returns all parts with availability greater than 1 for a given dealership

GET https://int.LightspeedADP.com/lsapi/Part/{CMF}?$filter=Avail gt 0

Path Parameters

Name	Type	Description
CMF*	String	The Lightspeed ID of a given dealership

200: OK An array of parts and all fields

{ // Just showing one part
    [
    {
        "Cmf": "76210637",
        "DealerId": "",
        "PartNumber": "0800-012001",
        "SupplierCode": "CF",
        "DateGathered": "2021-11-15T10:29:17.409",
        "Description": "GASKET, CVT CASE (1)",
        "OnHand": 1,
        "Avail": 1,
        "OnOrder": 0,
        "OnOrderAvail": 0,
        "LastSoldDate": "2021-11-15T17:29:17.408",
        "LastReceivedDate": "2021-08-12T13:18:27.296",
        "LastAdjustmentDate": "2021-08-12T19:18:27.296",
        "ReOrderMethod": "N",
        "MinimumQty": 0,
        "MaximumQty": 0,
        "Cost": 6.49,
        "CurrentActivePrice": 9.99,
        "OrderUnit": "",
        "OrderUnitQty": 0,
        "Retail": 9.9900,
        "LastCountDate": "1000-01-01T00:00:00",
        "SupersededTo": "",
        "UPC": "",
        "Bin1": "",
        "Bin2": "",
        "Bin3": "",
        "category": "ACC",
        "similarparttype": null,
        "activepricetype": "Standard",
        "escalationtype": "Cost and Retail",
        "reordertype": "Force to Zero",
        "quantitysoldlastweek": 0.0,
        "quantitysoldlast2weeks": 0.0,
        "quantitysoldlast2years": 1.0,
        "quantitysoldlast3years": 1.0,
        "quantitysoldlast4years": 1.0,
        "quantitysoldlast5years": 1.0,
        "quantitysoldlast10years": 1.0,
        "comments": "*** Added by Conversion***",
        "indealerpricebook": "0",
        "glaccountcode": "120703",
        "lostsaleslastyear": 0,
        "lostsalesytd": 0,
        "lostsalesmtd": 0,
        "monthsnosale": 0,
        "saleslastyeartotal": 0,
        "salesthisyeartotal": 1,
        "saleslast01": 0,
        "saleslast02": 0,
        "saleslast03": 0,
        "saleslast04": 0,
        "saleslast05": 0,
        "saleslast06": 0,
        "saleslast07": 0,
        "saleslast08": 0,
        "saleslast09": 0,
        "saleslast10": 0,
        "saleslast11": 0,
        "saleslast12": 0,
        "salesthis01": 0,
        "salesthis02": 0,
        "salesthis03": 0,
        "salesthis04": 0,
        "salesthis05": 0,
        "salesthis06": 0,
        "salesthis07": 0,
        "salesthis08": 2,
        "salesthis09": -1,
        "salesthis10": 0,
        "salesthis11": 0,
        "salesthis12": 0,
        "specialordersmtd": 0,
        "specialordersytd": 20000,
        "movementcode": "",
        "nodiscountpart": 0,
        "secondarypartnum": "",
        "oemreplenishment": false,
        "reorderpoint": 0,
        "suggestedsellqty": 0,
        "saleprice": 0.0,
        "specialprice1": 0.0,
        "specialprice2": 0.0,
        "specialprice3": 0.0,
        "usepkgcost": 0.0,
        "usepkgprice": 0.0,
        "lastupdatedate": "2021-08-12T19:18:27.442"
    },
    ]
}