Getting your data
Looking to free your Lightspeed R-Series data? Good, you’ve come to the right place.
## Getting connected
1. Select **Connections** from the main menu
2. Click the **New** button
3. Select **Lightspeed R-Series**
4. Give it a name (this is especially useful if you’re creating multiple Lightspeed R-Series connections)
5. Authorise the connection by following the prompts to sign in to your Lightspeed R-Series account
6. Done. Now watch as SyncHub begins retrieving your historical data.
To connect multiple Lightspeed R-Series accounts, simply follow the steps above for each one. Just make sure to check that your SyncHub plan allows for multiple API connections.
## Available endpoints
SyncHub works by regularly querying each endpoint in the Lightspeed R-Series API, checking for new and modified data. For each endpoint SyncHub produces a corresponding data table in your reporting tool. These are the endpoints currently available:
- Category
- Contact
- Credit account
- Customer
- Customer type
- Discount
- Employee
- Employee hour
- Inventory count
- Inventory count item
- Inventory log
- Inventory transfer
- Inventory transfer item
- Item shop
- Item price
- Item tag
- Item custom field value
- Item
- Item attribute set
- Item custom field choice
- Item custom field
- Item matrix price
- Item matrix
- Item vendor
- Manufacturer
- Order
- Order custom field
- Order custom field choice
- Order line
- Order shipment item
- Order shipment
- Quote
- Register
- Sale
- Sale line
- Sale payment
- Shop
- Special order
- Tag
- Tax category
- Vendor
- Workorder
- Workorder item
- Workorder line
- Workorder status
- Credit account contact
- Order custom field value
- Sale note
Need more data? No problem, please [let us know](https://www.synchub.io/contact) and we'll see if we can add it. Or if you're a data nerd like us, feel free to check out the Lightspeed R-Series API documentation to see what’s available.
### What data does SyncHub take from Lightspeed R-Series?
SyncHub extracts the endpoints above from Lightspeed R-Series, and stores it in your data warehouse.
### What data does SyncHub create or modify in Lightspeed R-Series?
Nothing. SyncHub is read-only and never sends data back to Lightspeed R-Series.
## Building your reports
SyncHub stores data in a relational database optimized for reporting. This means that reporting from your favourite reporting tool is as easy as using their standard _database connector_. We have detailed walkthroughs for the most popular reporting tools here:
- [Power BI](/kb/powerbi?api=lightspeed)
- [Excel](/kb/excel?api=lightspeed)
- [Tableau](/kb/tableau?api=lightspeed)