Integration Specifications
This article will help you learn about how Daasity replicates data from Lightspeed, limitations to the data we can extract and where the data is stored in the Lightspeed schema
Integration Overview
Lightspeed is a cloud-based point-of-sale and e-commerce platform for retail, hospitality and golf merchants around the world to simplify, sale and provide customer experiences.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
API Endpoints
The Daasity Lightspeed extractor is built based on this Lightspeed API documentation. The following endpoints are used by Daasity to replicate data from Lightspeed:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Lightspeed integration illustrating the different tables and keys to join across tables
Lightspeed Schema
The Daasity Lightspeed extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Accounts
Endpoint: Account
Update Method: UPSERT
Table Name: [
lightspeed.accounts]
Customers
Endpoint: Customer
Update Method: UPSERT
Table Name: [
lightspeed.customers]
Employees
Endpoint: Employee
Update Method: UPSERT
Table Name: [
lightspeed.employees]
Sales
Endpoint: Sale
Update Method: UPSERT
Table Name: [
lightspeed.sales]
Sale Payments
Endpoint: Sale Payment
Update Method: UPSERT
Table Name: [
lightspeed.sale_payments]
Order Discounts
Endpoint: Discount
Update Method: UPSERT
Table Name: [
lightspeed.order_discounts]
Sale Lines
Endpoint: Sale Lines
Update Method: UPSERT
Table Name: [
lightspeed.salelines]
Items
Endpoint: Item
Update Method: UPSERT
Table Name: [
lightspeed.items]
Item Prices
Endpoint: Item
Update Method: UPSERT
Table Name: [
lightspeed.item_prices]
Items Matrix
Endpoint: Item Matrix
Update Method: UPSERT
Table Name: [
lightspeed.items_matrix]
Item Matrix Prices
Endpoint: Item Matrix
Update Method: UPSERT
Table Name: [
lightspeed.item_matrix_prices]
Inventory
Endpoint: Inventory Count Item
Update Method: UPSERT
Table Name: [
lightspeed.inventory]
Locations
Endpoint: Shop
Update Method: UPSERT
Table Name: [
lightspeed.locations]
Last updated