Skip to main content

​
Intro

SmartDB is a no-code/low-code development platform equipped with workflow and web database functionalities. In Domo, you can connect to the SmartDB API and retrieve data from any binder view on SmartDB. You connect to your SmartDB account in the Data Center. This topic discusses the fields and menus that are specific to the Xero connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in DataSet Using a Data Connector.

​
Prerequisites

To create a DataSet by connecting to a SmartDB account, a binder token is required. For information on how to obtain the binder token, please refer to the SmartDB website.

​
Connecting to Your SmartDB Account

This section enumerates the options in the Credentials and Details panes in the SmartDB Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

​
Credentials Pane

The Domo Xero connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click Connect (or select Add Account if you have existing Xero accounts in Domo) to open the Xero OAuth screen where you can enter your Xero credentials. Once you have entered valid Xero credentials, you can use the same account any time you go to create a new Xero DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.
Field Description
Domain Enter the subdomain of your SmartDB account.
Binder Token Enter your binder token.
For information about obtaining these credentials, see Prerequisites above. Once you have entered valid Spotify credentials, you can use the same account any time you go to create a new SmartDB DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the report you want to run. Currently, ‘ビューの文書一覧’ (List of Documents in a View) is the only available option.

Binder ID Enter the binder ID or binder key you wish to retrieve.
View ID Enter the view ID or view key you wish to retrieve.
Date Type Select the type of date for the data to be retrieved. You can choose between ‘最終更新日’ (Last Updated Date) and ‘登録日’ (Registered Date).
Date

Select in Date selection whether a single day or a date range when filter the result by update date of items.

Single date Select the specific or relative single date.
Date range Select the specific or relative date range.
Time period Select the time period from Time period dropdown for your report.

Date – Date

Select in Date Type from the followings whether the report data is for a specific date or for a relative number of days back from today:

Relative Enter the number of days back that you would like to get data for in the Days Back field. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
Specific Select the specific date using the date selector in the Date field.
Date – Start Date

Select in Date Type from the followings:

Relative

Enter the number of days back that you would like to get data from (start day). Combine with End Date to create a range of represented days.

For example, if you entered 10 for Start Date and 5 for End Date , the report would contain data for 10 days ago up until 5 days ago.

Specific Select the first date in your date range using the date selector.
Date – End Date

Select in Date Type from the followings:

Relative

Enter the number of days back that you would like to get data to (end day). Combine with Start Date to create a range of represented days.

For example, if you entered 10 for Start Date and 5 for End Date , the report would contain data for 10 days ago up until 5 days ago.

Specific Select the last date in your date range using the date selector.
Date – Time period

Choose the time period for which you would like to receive data.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see a DataSet Using a Data Connector.