transformations:importodata
Table of Contents
IMPORT FROM ODATA
Category: Import / App/Cloud
Description
This action allows data to be imported from any OData provider. OData versions 3 and 4 are supported.
Action settings
| Setting | Description |
|---|---|
| Connector* | Select a configured Web Location connector or Microsoft Graph OData connector. |
| Command | Select the process to perform in the OData environment. Options: Import entity, List entities, or List entity columns. |
* Setting can be specified using a parameter.
Import entity settings
| Setting | Description |
|---|---|
| Entity* | Enter or select the OData entity to import. |
* Setting can be specified using a parameter.
Columns tab
| Setting | Description |
|---|---|
| Import all columns | Choose this option to import all columns of the selected entity. |
| Import selected columns | Choose this option to import specific columns and select those columns from the list that appears. |
Filter tab
| Setting | Description |
|---|---|
| Load the first | Check this option on to import a limited number of rows from the top of the entity. Specify the number of rows to import*. |
| Add filter | Choose this to add one or more filters to the imported data. Options: Simple filter (and enter the values* to build the filter, or Custom OData filter (and enter an OData filter query*). |
* Setting can be specified using a parameter.
List entities
Description: Choose this Command to list all entities found in the OData environment.
List entity columns
| Setting | Description |
|---|---|
| Entity* | Enter or select an entity to list the columns of. |
* Setting can be specified using a parameter.
Remarks
This action works with two types of connectors:
Shortcuts
Fast ways to create the action:
- Press the "Add data" menu button. Pick "Fetch from cloud/application".
See also
transformations/importodata.txt · Last modified: 2025/01/26 19:46 by dmitry