Dataverse Input Tool
Dataverse Input Tool
Use Dataverse Input to read data from Dataverse tables to Designer. Go to Microsoft Dataverse to learn about known limitations. More information about Dataverse can be found on the Microsoft Dataverse documentation site.
Important
This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Marketplace.
To maintain full functionality of this data connector, note compatibility with Designer.
Designer version 2021.3.3 and later.
Designer versions 2021.2.1 - 2021.3.1.
Sign In to Dataverse
The OAuth method is used for authentication, so you can either use the default Alteryx application via the Sign in via Internet Browser option, or you can provide your own API application via the Provide authentication information option. Go to Custom API Application Setup for more information on how to create an API application.
To schedule your workflow on Server when using the Cloud services, you need to select Use Service Principal after you select Provide authentication information so that your token has an extended expiration, and you need to provide your own API application.
Sign In via Internet Browser
In Authentication Method, select Sign in via Internet Browser.
Select Connect.
Enter your credentials and sign in.
Provide Authentication Information
In Authentication Method, select Provide authentication information.
Enter Client ID and Tenant ID. If you want to schedule workflows, select Use Service Principal and enter Client ID, Client Secret, and Tenant ID.
Select Connect.
Enter your credentials and sign in.
Select a Table and Columns
In Table, select the table to read the data from.
In Columns, select only the columns to read. You can leave the field blank to read all the columns.
Select Propagate field immediately to the next tool in the Options tab to propagate all fields to a connected tool without the need to run the workflow.
Filter the Data
Use Dataverse Input filters to specify which data to read.
Saved Query: Select a predefined query. Max Number of Rows and Start From Rows (Offset) options are applicable.
Define filters – Manually: Select a column to apply a logical operation on. Max Number of Rows and Start From Rows (Offset) options are applicable.
Define filters – Custom OData Query: Enter a custom query in the text field.