Search: clear-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
Result type
- 435Document
- 26Attachment
- 3Object
- 2Object property
Location
- 414Activities
- 23akaBot Vision
- 12akaBot Center
- 6Data Service
- 4akaBot Insights
- … 4 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 65VuNH54
- 61admin
- 59Nhan Nguyen
- … 3 more
Creator
- 255admin
- 67Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 10Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 122Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 49admin
- … 3 more
Upload date
- Sort by:
- Relevance
Activities
Located in
- Objects
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
…/Collection/Activities/%5B01%5DClear%20Collection/">Clear Collection</a> <a href="/bin/view
Execute Query
Located in
- Rendered document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable
…Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command
…to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- Raw document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable
…connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities
…to consider data security requirement before using it. * **Display Name (String)** - The name of this activity
Excel Copy Paste Range
Located in
- Rendered document content
or sheet (including values, formulas, table format, and cell format) and pastes it to another location
…Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports
…the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” Input
- Raw document content
, table format, and cell format) and pastes it to another location in the current workbook
…to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data
…)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g
Read CSV File
Located in
- Rendered document content
Data Table (DataTable) - Represents the output DataTable that contains the information obtained from
…of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String
- Raw document content
, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains
…” **Misc** * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity
Execute SOQL
Located in
- Rendered document content
. Only Data Table variable supported. Salesforce Status – The status returned from Salesforce once
- Raw document content
of running the SOQL command in Salesforce, stored in a DataTable variable. Only Data Table variable supported
Quit Browser (NB)
Located in
- Rendered document content
and structure your code better. Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before using it. Default is uncheck. Table of Content
- Raw document content
)** - Check if you want to public it. Remember to consider data security requirement before using it. Default is uncheck. ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth
[17]Extract Structured Data
Located in
- Rendered document content
further. The default amount of time is 30000 milliseconds. E.g: 30000 Output Result (Data Table
…RCA.Activities.Browser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (* For mandatory) In the body of the activity Pick
- Title
[17]Extract Structured Data
- Location
[17]Extract Structured Data
- Raw document content
of time is 30000 milliseconds. E.g: 30000 **Output** * **Result (Data Table)* **- The outputted
…" %) ((( RCA.Activities.Browser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
…(String)** - This property allows you to input the page source contained the Structure Data needed
Excel Insert Rows
Located in
- Rendered document content
RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
…Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
- Raw document content
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}
Extract Structured Data
Located in
- Rendered document content
: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’.
…RCA.Activities.Common.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (*For mandatory) In the body of activity Open
- Title
Extract Structured Data
- Location
Extract Structured Data
- Raw document content
** * **Result (Data Table)** - The outputted data with type = ‘DataTable’. ))) {{velocity
…" %) ((( RCA.Activities.Common.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
…milliseconds. E.g: 200 **Input** * **Selector (String)** - The outputted data with type 'DataTable'. **Misc
[1] Create an Account
Located in
- Rendered document content
1. Create an Account Note: Although akaBot Vision currently supports Pre-trained data fields only for Invoice processing, the technology is documented agnostic and can extract data from any
…customizable, so you can add/group/remove pipelines as needed. Table of Content
- Raw document content
currently supports Pre-trained data fields only for Invoice processing, the technology is documented agnostic and can extract data from any structured document including receipts, purchase orders, shipping
…-20220420182302-1.png||alt="image-20220420183141-4.png" data-xwiki-image-style-alignment="center"]] **Step 2