Spreadsheets
| Module | Type | Description |
|---|---|---|
Excel | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. | |
InitializeTarget | Initializes a connection for saving output data records. | |
LookupRecord | Gets a specific record from a data source | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
ExcelOnline | CloseSource | The CloseExcelOnlineSource activity closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
ExcelServices | CloseSource | The CloseExcelServicesSource activity closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
LookupRecord | Fetches a specific record from a source connection | |
GoogleSheets | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record |
Last updated