Xero

Dataddo Xero connector enables simple API data extraction without writing a single line of code.

This article explains the Dataddo Xero connector's capabilities along with a guide containing specific steps for creating a data source including the authorization of your Xero account. Then we will continue through creating a data flow, i.e. connecting your data source to a destination. Finally, we will answer some frequently asked questions.

Data Integration

Dataddo's Xero connector can extract all the data available through the official Xero API and connect them to a dashboarding or BI app or a data warehouse such as Power BI, Google Data Studio, MySQL, and many others. The data are separated into different datasets such as Accounts, Bank Transactions, Contacts, Journals and the full list of available API endpoints can be found in the official Xero API documentation. You can schedule automatic synchronizations to have your data extracted from Xero hourly, daily, weekly, or monthly depending on your needs.

Creating a Xero Data Source

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

Then click on New Sources from the top right corner.

From the list of connectors, choose the Xero connector.

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

If you are not sure which Dataset you need, but -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 available attributes and metrics for each Dataset by clicking Show attributes on the right side of any dataset. 

Missing a metric or attribute?

If any metrics or attributes that you would like to work with 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. You will be requested to grant Dataddo authorization to connect with your Xero account.

Your Xero Account will be automatically assigned after the authorization process and you will be asked to select your Xero Tenant. If you have more than one Xero account connected to Dataddo, your other accounts can be seen and selected in the drop-down Xero Account menu.

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

Now you will need to set up your snapshotting preferences. To help you with the snapshotting setting, you can follow our suggestions depending 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 configuration, you can go ahead and proceed without selecting one of the two templates.

You can alter the default selections and configure your snapshotting preferences, choosing Snapshotting frequency, and Snapshotting retention yourself. 


Click on See Preview to review all the selections you've made before saving the Data Source using the button in the top right corner. Here you can select either Save and Exit or Save & Create Flow.

Creating a Xero Data Flow

Data flows allow you to orchestrate the integration of your data from various online services (in this case Xero) to your desired destinations including BI tools such as Tableau or Google Data Studio, as well as big data storages such as Google Big Query or AWS Redshift, file storages or SQL-based data warehouses. Within a single data flow, you can include data from multiple data connections. This is particularly useful for organizations that handle multiple social media accounts and need to merge data from different services together for a consolidated output.

To create a Xero data flow, navigate to Data Flows at the top left of the Dataddo app.

Then click on New Flow in the top right corner.

Click on Add Source.

Below, you will see any data sources you have created and saved previously. Select one of the data sources from the list or click Create New Source.

Once you click on the data source, you will see a preview of your dataset. If you happen to have another source with the same columns (for example for a different Xero account or tenant), you can add this as well, creating one final table in your destination instead of two.

If everything looks ok, you can  select the destination where you want to send your data. Click on Add Destination.

You can set the destination based on the saved destinations you have created before, or you can simply Create a New Destination.Once you select the destination that you want to send your data to, you can proceed by clicking Configuration.

Now you can label the Data Flow and then click on Create Flow.

If you selected a dashboarding or BI app, you will need to configure your dashboard by following the steps in the Configure dashboard window, using the Dataddo API keys and API Endpoints ID.

Data Blending

In data blending mode, you can merge two data sources to one destination. To blend data, first turn on data blending mode.

Choose two data sources to blend them together.

Now you'll need to select a Left Source Column and a Right Source Column of the same type, in order to join the two sources together. You can also exclude a column from the final result by clicking on it.

You can select the type of joining for the data sources.

  • Left Join returns records from the left column source and those records that satisfy a condition from the right column source. In this example, CurrencyCode.
  • Inner Join returns records which values are only matching in both column sources.

You can have more than one operation. Simply click on Add Operation to have another JOIN connection. (Optional)

Finally, you can choose a destination where you want us to move the dataset. Name the data flow, and press on Configuration.

FAQ

  • No data?

                 

Don't worry, there are many quick ways to fix this issue:

  1. Your account may 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 small 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 different combination of metrics.

  • Problem Connecting?

                  

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

 

  • How do I reauthorize an account in Dataddo?

Screenshot 2021-01-08 at 14.52.22

Check whether your account has the correct permissions to access this dataset. Navigate to Settings > Connected accounts. If your account is OK, click on Test. If your account is broken, click on re-authorize

  • How do I deactivate my account?

If you want to deactivate your Dataddo account, you can contact us or create a ticket and we will handle it as soon as possible.


Video Tutorial