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
- 392Activities
- 16akaBot Vision
- 14akaBot Center
- 4akaBot Insights
- 3Data Service
- … 5 more
Last author
- 93Nga Nguyen
- 70Tuan Nguyen
- 66admin
- 64VuNH54
- 59Nhan Nguyen
- … 3 more
Creator
- 260admin
- 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
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
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
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
[01]Open Browser
Located in
- Rendered document content
) 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
- Raw document content
** == * **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
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
[1] Design Form
Located in
- Rendered document content
Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit
…the ability to collect user data UI components are divided into 5 main groups, based on their functions
…to fill in. Then click Save when you are done. The below table describes frequently used configure
- Raw document content
|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components used to collect data|((( * Hidden * Container * Data map * Data grid * Edit grid * Tree ))) |Premium
…provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014
[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
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