|
Field |
Description |
|---|---|
|
Client ID |
{" "} Enter your Client ID. For step-by-step instructions on obtaining a Client ID and Client Secret, see {" "} [https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app\{](https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app\{)" "} .{" "} |
|
Client Secret |
{" "} Enter your Client Secret. For step-by-step instructions on obtaining a Client ID and Client Secret, see {" "} [https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app\{](https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app\{)" "} .{" "} |
3. Fill out the registration form as follows:
* Name: Enter name for your application.
* Supported account types: Select an option to specify who can use this application or access this API.
* Redirect URI: Enter the redirect URI as:
**[https://oauth.domo.com/api/data/v1/oauth/providers/mail-exchange-rest/exchange](https://oauth.domo.com/api/data/v1/oauth/providers/mail-exchange-rest/exchange)**
4. Click
**Register**. An overview of your registered App will appear. The **Application ID** that appears here is the **Client ID** you will enter in the **Credentials** pane in Domo.
5. Click
**API Permissions >> +Add a permission**.
6. **Request API permissions** section appears. Add the API permissions for your application.
7. Now, click on
**Certificates and secrets**. Certificates can be used as secrets to prove the application's identity when requesting a token. Also, can be referred to as public keys.
8. Click
**+New client secret**.
9. Specify the client secret description and the expiry period for your client secret, and click
**Add**.
10. Copy the value and paste it into the
**Client Secret** field in the **Connector credentials** section in Domo.
### 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 Microsoft Exchange report you want to run. The following reports are available:
|
||||||||
|
Folder |
Select the folder containing the content you want to import. |
||||||||
|
Search Type |
{" "} Select whether you want to search for a specific term or apply filters to import a subset of a collection.{" "} |
||||||||
|
Filter Type |
{" "} Select a filter type, either Starts with or Equals . If you select Starts with , all files starting with the specified characters will be returned. If you select Equals , only files that are an exact match will be returned.{" "} |
||||||||
|
Subject (Optional) |
Enter a subject to filter to show all emails containing the given subject line. |
||||||||
|
From (Optional) |
Enter the ID of a user to filter returned data specific to that user. |
||||||||
|
Search Option |
{" "} Select the desired search method. If you select Custom Search , you are prompted to enter a subject line and sender name for the search. If you select Query , you are prompted to enter a search query string.{" "} |
||||||||
|
Query |
{" "} Enter a Keyword Query Language (KQL) query. For more information about searchable email properties, KQL syntax, supported operators, and search tips, see the Microsoft Exchange user documentation.{" "} |
||||||||
|
Calendar Type |
{" "} Select whether you want to import a shared or personal ( Own ) calendar.{" "} |
||||||||
|
Shared Calendar Search Type |
Select whether you want to search for shared calendars by name or email address. |
||||||||
|
Shared Calendars |
Select the shared calendar(s) you want to import into Domo. |
||||||||
|
Shared Users Email Address |
Enter the email address of the user whose calendar you want to retrieve. |
||||||||
|
File Type |
Select whether the attachment you are importing is a CSV, XLS, XLSX, JSON, or XML file. |
||||||||
|
File Name |
{" "} Enter the name of the attachment you want to import. If the file name contains an extension, you must include the extension.{" "} |
||||||||
|
Folder Path (Optional) |
{" "} Enter the path of the folder containing messages you want to search. If you do not enter a folder path, the "Inbox" folder will be searched. For example, if the root folder was "DOMO" and in that root folder you had a folder called "DOMO\_TEST," you would enter the following to return messages for "DOMO\_TEST": {" "} DOMO/DOMO\_TEST{" "} |
||||||||
|
File Password (Optional) |
If the file you are uploading is password-protected, enter the password here. |
||||||||
|
Delimiter |
{" "} Select the delimiter to use in parsing CSV files. If your desired delimiter is not in the menu, select {" "} Other{" "} then enter the delimiter in the Custom Delimiter field.{" "} |
||||||||
|
Custom Delimiter |
{" "} Enter the custom delimiter for your CSV file. Enter \t for tab or Unicode characters in \uxxxx form (e.g. {" "} \u005e{" "} ).{" "} |
||||||||
|
Quote Character |
Select the desired quote character for parsing your CSV file. A double quote (") is the CSV standard. |
||||||||
|
Custom Quote Character |
{" "} Enter the desired custom quote character. Enter \t for tab or Unicode characters in \uxxxx form (e.g. {" "} \u005e{" "} ).{" "} |
||||||||
|
Escape Character |
{" "} Select the escape character to use in parsing CSV files. If your desired escape character is not in the menu, select{" "} Other then enter the escape character in the Custom Escape Character field.{" "} |
||||||||
|
Custom Escape Character |
{" "} Enter the custom escape character for your CSV file. Enter \t for tab or Unicode characters in \uxxxx form (e.g. {" "} \u005e{" "} ).{" "} |
||||||||
|
Start Days |
{" "} Enter the number of days back you want to begin pulling data for. For example, if you entered {" "} 7{" "} here, each time the report ran it would pull data from 7 days ago up until today.{" "} |
||||||||
|
Header Start Row (Optional) |
Enter the header row number. If you do not enter a number, the first row is considered the header row. |
||||||||
|
Data Start Row (Optional) |
{" "} Enter the starting data row number. If you do not enter a number, the first row after the header row is considered the starting row.{" "} |
||||||||
|
Footer Rows to Skip (Optional) |
{" "} If there are one or more rows at the bottom of the file you do not want to import, enter the number of rows to skip.{" "} |
||||||||
|
Sheet Name (Optional) |
{" "} If the Excel file you are uploading is found on a specific sheet, enter the sheet name here. If you do not enter a sheet name, the first sheet of the workbook will be used.{" "} |
||||||||
|
Date Field Key |
Enter the data tag in your JSON or XML file. |
||||||||
|
Sublist to Flatten |
Enter the lists you want to flatten, separated by commas. |
||||||||
|
Report Date |
Select whether the report data is for a specific date or for a relative number of days back from today. |
||||||||
|
Select Specific Date |
Select the date for the report. |
||||||||
|
Days Back |
Enter the number of past days that should appear in the report. |
||||||||
|
Start Date |
{" "} Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date .{" "} |
||||||||
|
End Date |
{" "} Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date .{" "} |
||||||||
|
Select Specific Start Date |
Select the first date in your date range. |
||||||||
|
Select Specific End Date |
Select the second date in your date range. |
||||||||
|
Days Back to Start From |
{" "} Enter the number of the farthest day back that should be represented in the report. Combine with {" "} Days Back to End At{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |
||||||||
|
Days Back to End At |
{" "} Enter the number of the most recent day back that should be represented in the report. Combine with {" "} Days Back to Start From{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |
||||||||
|
Report Date |
Select whether the report data is for a specific date or for a relative number of days back from today. |
||||||||
|
Select Specific Date |
Select the date for the report. |
||||||||
|
Days Back |
Enter the number of past days that should appear in the report. |
||||||||
|
Start Date |
{" "} Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date .{" "} |
||||||||
|
End Date |
{" "} Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date .{" "} |
||||||||
|
Select Specific Start Date |
Select the first date in your date range. |
||||||||
|
Select Specific End Date |
Select the second date in your date range. |
||||||||
|
Days Back to Start From |
{" "} Enter the number of the farthest day back that should be represented in the report. Combine with {" "} Days Back to End At{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |
||||||||
|
Days Back to End At |
{" "} Enter the number of the most recent day back that should be represented in the report. Combine with {" "} Days Back to Start From{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |