Gusto

Our Gusto connector enables simple API data extraction without writing a single line of code.

Introduction

In this article, we are going to walk you through Dataddo's Gusto connector and the data integration it provides. First, we are going to give you an overview of the integration mentioning all the possible data you are able to get from Gusto using Dataddo, then we are going to go through creating a data source, next we will move to how to create a data flow that connects data from a source to a destination, and finally, we are going to answer some frequently asked questions and issues you might encounter.

Gusto data integration

Dataddo's Gusto connector can extract all the data available through the official Gusto API and connect them to a dashboarding or BI app such as Power BI, Google Data Studio or Klipfolio, or a data warehouse such as MySQL, Big Query and many more. The data are separated into different datasets and the full list of available API endpoints can be found in the official Gusto API documentation. You can set up an automatic synchronization to have your data pulled from Gusto hourly, daily, weekly, or monthly giving you almost real-time access to all the data you need.

Creating a Gusto Data Source

To create a Gusto data source, navigate to Sources at the top left of the Dataddo app.

Then click on New Source in the top right corner.

From the list of connectors, choose the Gusto connector.

You will be redirected into the Gusto connector where you can select the required Dataset.

2 copy-png-2


If you are not sure which Dataset you need, but you, for example, know which metrics and attributes you are looking for, you can use the Search for Dataset function on the left or you can browse through all the possible attributes and metrics for each Dataset by clicking on the right arrow.

3-png-3

Missing metric or attribute?

If you feel like some metrics or attributes that you would like to use are missing, you can contact us or create a ticket and we will add it for you if possible.


Once you select a Dataset, you can start with the configuration by clicking on Next. First of all, you will need to give Dataddo authorization to connect with your Gusto account. Once you click on Authorize, you will be redirected to your account to log in.

After you log in and give Dataddo necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more Gusto accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu. If applicable, you can also select company. 

Next, you can name your data source, and select the required attributes.

The last step consists of selecting your snapshotting preferences. To help you with the snapshot mapping, we make it easier for you to create a connection based on your destination.

  • Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
  • Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
  • If you are already experienced with the snapshotting setup, you can go ahead and process without selecting any of the two options.

You can check whether the suggested setting suits you, or you can make amends and configure your snapshotting preferences, choosing Snapshotting frequency, and Snapshotting retention yourself. 

Now you are all set and ready. Click on See Preview to review all the selections made by you before saving the Data Source using the buttons in the top right corner - either Save and Exit or Save & Create Flow. To create a flow, please follow our Creating a data flow guide.

Potential Issues and how to troubleshoot them  

  • Are no data available?

           

Do not worry, this is a common issue that occurs to some users. Quick ways to fix this issue,

  1. Your account might not have any records for the dates you specified. Try changing the date range to a different date or a longer period (last 30 days, this year) to obtain data.
  2. You could have made a slight mistake when configuring your account, but it's ok. You can restart the process of configuration again and check the connector configuration. You can also try to use a different account or a different combination of metrics.
  • Did something go wrong?
            

If you get the 'Something went wrong' message, please make sure that your account has sufficient permissions and the configuration looks correct. If the issue still persists, please contact us or create a ticket and we will address it as soon as possible

  • Is your account unauthorized?

Screenshot 2021-01-08 at 14.52.22

Check whether your account has the correct permissions to access this API endpoint. If yes, check whether your account is correctly authorized in Dataddo by navigating to Settings > Connected accounts. If your account is OK, click on Test. If your account is broken, click on Re-authorize.
  • How to deactivate Dataddo account?

If you no longer want to use your Dataddo account, please contact us and we will deactivate it for you.

  • Unable to put more sources into one flow?

When creating a data flow, you can select more than one source. This is only possible if the number and type of columns are the same. Please make sure that the columns are indeed the same or navigate to our guide for more information.

  • Unable to delete a source?

If you are unable to delete a source - the bin icon is light grey and cannot be clicked on, this is because the source is being used in at least one data flow. You will first need to delete all the data flows that are using the source and then you will be able to delete the source.