Contents x
    Xero
    • 2 Minutes to read
    • Dark
      Light
    Contents

    Xero

    • 2 Minutes to read
    • Dark
      Light
    Article summary

    Xero is a cloud-based accounting software platform designed for small and medium-sized businesses. It offers tools for financial management, including features for invoicing, payroll, expense tracking, and reporting, enabling businesses to efficiently manage their finances and stay on top of their accounting tasks.

    Refer to our website for the list of metrics and attributes available in Dataddo.

    Authorize Connection to Xero

    To authorize this service, use OAuth 2.0 to share specific data with Dataddo while keeping usernames, passwords, and other information private.

    1. On the Authorizers page, click on Authorize New Service and select your service.
    2. Follow the on-screen prompts to grant Dataddo the necessary permissions to access and retrieve your data.
    3. [Optional] Once your authorizer is created, click on it to change the label for easier identification.

    Ensure that the account you're granting access to holds at least admin-level permissions. If necessary, assign a team member with the required permissions with the authorizer role to authenticate the service for you.

    For more information, see our article on authorizers.

    How to Create a Xero Data Source

    1. On the Sources page, click on the Create Source button and select the connector from the list.
    2. Select your dataset and click on Next to continue.
      DATADDO TIP

      If you are not sure which dataset you need but know the metrics and attributes, use the Search by Name or Attribute function.

      Fixed-schema connector
    3. From the drop-down menu, select your authorizer.
      Didn't find your authorizer?

      Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

    4. Name your data source and select your metrics and attributes. Keep in mind that metrics and attributes depend on the selected dataset.
    5. Configure your sync frequency or the exact synchronization time under Show advanced settings.
      DATADDO TIP

      If you need to load historical data, please refer to the Data Backfilling article.

    6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
    7. Click on Save and congratulations, your new data source is ready!

    Advanced Settings

    For the following Xero templates, you can choose to Get Cash Transactions Only:

    • Balance Sheet
    • Bank Summary
    • Reports - Bank Summary
    • Journals
    • Journal Lines
    • Journal Lines with Tracking
    • Manual Journals
    • Profit and Loss

    Please keep in mind that this metric is not available for other templates.

    Troubleshooting

    Data Preview Unavailable

    No data preview when you click on Test Data might be caused by an issue with your source configuration. The most common causes are:

    • Date range: Try a smaller date range. You can load the rest of your data afterward via manual data load.
    • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.

    Related Articles

    Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

    Sending Data to Dashboarding Apps

    Sending Data to Data Storages

    Other Resources

    Was this article helpful?
    What's Next