2024 is the year of the connector - vote here

Knowledge base

Getting your data

![Projectworks](https://www.synchub.io/i/logos/projectworks.png) Looking to free your Projectworks 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 **Projectworks** 4. Give it a name (this is especially useful if you’re creating multiple Projectworks connections) 5. Authorise the connection by following the prompts to sign in to your Projectworks account 6. Done. Now watch as SyncHub begins retrieving your historical data. To connect multiple Projectworks 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 Projectworks 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: - Billing contact - Client - Country - Currency - Custom field - Expense claim - Leave - Location - Module - Module custom field value - Office - Project - Project custom field value - Project status - Project type - Task - Task custom field value - Tax type - Team - Timesheet - User - User custom field value - Client project - Client billing contact - Client type - Custom field project type - Custom field project status - Custom field option - Expense claim file - Module task - Module custom field option value - Project module - Project custom field option value - Task user - Task custom field option value - User custom field option value 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 Projectworks 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=projectworks) - [Excel](/kb/excel?api=projectworks) - [Tableau](/kb/tableau?api=projectworks)