WorkSuite

worksuite is a platform that allows for a customizable client and internal organization project and administration system, especially used to manage your global freelance workforce efficiently connector pre requisites connecting to worksuite, you need to make sure that you or the user configuring the worksuite connector have administrative access to the cloud based application and are able to obtain the following api and access information for your enteprise level account sub domain of your account client id client secret instructions (basic connection setup) remember datalakehouse io securely connects to your worksuite account instance and does not capture or store your password/credentials using the form please complete the following basic steps enter a name or alias for this connection, in the 'name/alias' field, that is unique from other connectors enter in the 'target schema prefix' field, a name that will be unique in your data cloud destination where you wish to land the data for example, worksuite main enter the 'sub domain' from your account's api integration see the how to request client id and secret section below to get this info enter the 'client id' from your account's api integration see the how to request client id and secret section below to get this info enter the 'client secret' credential from your account's api integration see the how to request client id and secret section below to get this info click the authorize your account button once your credentials are accepted you will be automatically redirected back to the datalakehouse io portal and you should be able to see a successful connection issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com how to request client id and client secret info 1\) log into your worksuite account and access the api section of the account you will need to submit a request/ticket with worksuite and your account manager will provide you with access to yur client id, secret, and correct sub domain information per the worksuite documentation, https //api worksuite com/docs/setup requirements https //api worksuite com/docs/setup requirements 2\) submit a request / support ticket by providing something like the note below hello, we are working with our partner aicg and dlh io to build an integration with worksuite's api this integration will set the stage for our analytics and downstream processes which will automate highly manual processes and allow us to align team members actions with their productivity please provide us with our client id, secret, and sub domain for developing applications with the worksuite rest api the redirect uri is https //app datalakehouse io/dashboard/oauth redirect, if that is required 3\) once your receive the information from your account manager after sending the request in step #2, you wll then use that information in the dlh io source connection if you need assistance from dlh io, please submit a support ticket or contact your dlh io success manager to assist you with completing the dlh io setup how to video \[coming soon] replicated or synchronized entities/tables the following entities are replicated by defualt to your what is a target connection? docid 3wx 24ml25noxc1atdbs4 these are the table names you will see in your target connection job openings job openings applicants partner types payments payments line item projects tasks timesheets users faq none which entities do not have cdc/incremental loading none all entities are available for incremental data synchronization