Microsoft Dataverse (Dynamics 365)
CRM & supportOAuth 2.0
Read and write Dataverse tables through the Web API, including Dynamics 365 Sales accounts, contacts, leads and notes.
13 actions
| Action | Effect | Data handled | Scope |
|---|---|---|---|
| microsoft_dataverse_list_tablesLists the tables of the environment with the logical name, entity set name (used in row paths) and primary columns | read | General | |
| microsoft_dataverse_list_columnsLists a table's columns with their logical names and types, to know what to select, filter or write | read | General | |
| microsoft_dataverse_list_rowsLists rows of a table with OData $select, $filter, $orderby, $expand and $top | read | Personal data | |
| microsoft_dataverse_get_rowReads one row of a table by its id | read | Personal data | |
| microsoft_dataverse_create_rowCreates a row in any table from column values; lookups are set with 'column@odata.bind': '/entityset(id)' | write | Personal data | |
| microsoft_dataverse_update_rowChanges columns of an existing row | write | Personal data | |
| microsoft_dataverse_delete_rowDeletes a row from a table | destructive | General | |
| microsoft_dataverse_query_fetchxmlRuns a FetchXML query, for joins and aggregates OData cannot express | read | Personal data | |
| microsoft_dataverse_create_accountCreates a Dynamics 365 account (company) | write | Personal data | |
| microsoft_dataverse_create_contactCreates a Dynamics 365 contact, optionally linked to its account | write | Personal data | |
| microsoft_dataverse_create_leadCreates a Dynamics 365 Sales lead | write | Personal data | |
| microsoft_dataverse_qualify_leadQualifies a Dynamics 365 Sales lead, creating the chosen account, contact and opportunity, and returns the records created | write | Personal data | |
| microsoft_dataverse_add_noteAdds a note to an account, contact, lead, opportunity or case timeline | write | Personal data |