Search: insert-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 393Activities
- 16akaBot Vision
- 14akaBot Center
- 4akaBot Insights
- 3Data Service
- … 5 more
Creator
- 261admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 100Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 49admin
- … 3 more
Upload date
For Each Row
Located in
- Rendered document content
loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
- Location
Data Table
- Raw document content
) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
Bulk Add Queue Items
Located in
- Rendered document content
to add a collection of items to a data table to a specific queue. Once it is added to the queue
…) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue
…Output Result (DataTable) - This is the data table that you have added to the queue.
- Raw document content
of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed
…. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want
…**Output** * **Result (DataTable) **- This is the data table that you have added to the queue
Write CSV File
Located in
- Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
…\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
Open Browser
Located in
- Rendered document content
) In the body of activity URL to be inserted (String)* - The URL that you want to open in the browser. The URL
…to public it. Remember to consider data security requirement before using it. Default is uncheck. Options
…will be passed to the browser directly when startups User Data Folder Mode (UserDataFolderMode
- Raw document content
]] (*For mandatory) == **In the body of activity** == * **URL to be inserted (String)*** - The URL that you want
…to consider data security requirement before using it. Default is uncheck. **Options** * **Hidden (Checkbox
…will be passed to the browser directly when startups * **User Data Folder Mode (UserDataFolderMode
[3] How to use Desktop Trigger
Located in
- Rendered document content
Trigger Choose a trigger at the table below, then click this button to edit that trigger 3 Enable/ Disable/ Delete trigger Choose a trigger at the table below, then click this button to enable/disable/delete
…the protocol: IMAP/ POP3 Dropdown Yes 3 Host Insert your email host Email Yes 4 Port Choose the port
- Raw document content
at the table below, then click this button to edit that trigger |3|(% style="width:264px" %)**Enable/ Disable/ Delete trigger**|(% style="width:816px" %)Choose a trigger at the table below, then click this button
…" %)Host|(% style="width:489px" %)Insert your email host|(% style="width:169px" %)Email|(% style="width
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
…want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole
Write Range
Located in
- Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Append Range
Located in
- Rendered document content
are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable
…in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you
- Raw document content
". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data
…and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added
…to public it. Remember to consider data security requirement before using it. * **Display Name (String
Add Data Column
Located in
- Rendered document content
want to add to the specified DataTable Object. String supported only. Data Table (DataTable
…Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements
…to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Data Table
…Add Data Column
- Raw document content
to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object
…DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
Remove Data Row
Located in
- Rendered document content
RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int
- Title
Remove Data Row
- Attachment name
remove data row.jpg
- Location
Data Table
…Remove Data Row
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable