Search: insert-data-table

Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table

/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https://docs.akabot.com/bin/view/Activities/Database/Activities/Insert%20Data%20Table/]]

The DataTable Activities belongs to Core Activities Pack. It contains several activities that enable the robots to manipulate data tables by adding or extracting information. See also: Release Notes Activities

Data Table

Data Table

the robots to manipulate data tables by adding or extracting information. ))) See also: * [[Release Notes>>path:/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/]] * [[Activities>>path:/bin/view/Activities/Data%20Table/Activities/]] ))) )))

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel

/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table

%20Table/]] * [[Excel Insert Or Delete Columns>>url:https://docs.akabot.com/bin/view/Activities/Excel

Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

in the .csv file that contains the job data. By default, this property is set to COMMA. The following options

in the .csv file that contains job data. File Path – The full path to the .csv file that contains the job data. Only String variables supported. Line Ending - Specifies the line ending which marks the end of a data

for columns in the .csv file that contains the job data. By default, this property is set to **COMMA

operations. The field values must also be found in the .csv file that contains job data. * **File Path **– The full path to the .csv file that contains the job data. Only String variables supported. * **Line Ending

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

Data Table

/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/]] * [[Clear Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Clear%20Data%20Table/]] * [[Filter Data Table>>url:https://docs.akabot.com

, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable

it, the data of this activity will be shown in the log. Be careful, consider data security before using

" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables

) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece

. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity

. Only Data Table variable supported. Salesforce Status – The status returned from Salesforce once

of running the SOQL command in Salesforce, stored in a DataTable variable. Only Data Table variable supported

) In the body of the activity URL to be inserted (String)* - The URL that you want to open in the browser

if you want to public it. Remember to consider data security requirement before using it. Display name

** == * **URL to be inserted (String)*** - The URL that you want to open in the browser. The URL must be quoted

” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security

') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start

class="akb-card"> <div class="akb-card-title">Data Table</div> <div class="akb-card-body"> <div class="akb-link-list"> <a href="/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/">Release Notes</a> <a href="/bin/view/Activities/Data%20Table/Activities/Add%20Data

RCA.Activities.DataService.DataServiceScope Description This scope helps to run Data Service activities Properties Input Authentication Type: Determines the method used to authenticate with the Data Service. There are two options available: Agent and ManagedToken Data Service Client: Re-use token

[1] Data Service Scope

Data Service Activities

" %) ((( RCA.Activities.DataService.DataServiceScope == **Description** == (% class="wikigeneratedid" %) This scope helps to run Data Service

to authenticate with the Data Service. There are two options available: Agent and ManagedToken ** **Data Service Client: **Re-use token of previous Data Service Scope * **Manage Token**:  ** **Authentication Token