2024 is the year of the connector - vote here

Knowledge base

Getting your data

![OnePageCRM](https://www.synchub.io/i/logos/onepagecrm.png) Looking to free your OnePageCRM 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 **OnePageCRM** 4. Give it a name (this is especially useful if you’re creating multiple OnePageCRM connections) 5. Authorise the connection by following the prompts to sign in to your OnePageCRM account 6. Done. Now watch as SyncHub begins retrieving your historical data. To connect multiple OnePageCRM 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 OnePageCRM 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: - Action - Call - Company - Company custom field - Contact - Contact custom field - Deal - Deal custom field - Filter - Item - Item group - Lead source - Meeting - Note - Pipeline - Status - Tag - User - Call attachment - Company custom field value - Company contact - Company pending deal - Company custom field choice - Contact tag - Contact custom field value - Contact address - Contact url - Contact phone - Contact email - Contact action - Contact custom field choice - Deal item - Deal attachment - Deal custom field value - Deal custom field choice - Filter condition - Item group item - Lead source user count - Meeting attachment - Note attachment - Pipeline stage - Status user count - User account right 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 OnePageCRM API documentation to see what’s available. ### What data does SyncHub take from Deputy? SyncHub extracts the endpoints above from Deputy, and stores it in your data warehouse. ### What data does SyncHub create or modify in Deputy? Nothing. SyncHub is read-only and never sends data back to Deputy. ## 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=onepagecrm) - [Excel](/kb/excel?api=onepagecrm) - [Tableau](/kb/tableau?api=onepagecrm)