Search: look-up-data-table

All objects created in Data Service are referred to as Entities. Step 1: To begin, click on the "Add Entity" button Step 2: Provide the required information. Step 3: Once you have entered

Entity without closing pop-up

Data Service

[2] How to use Data Service

All objects created in Data Service are referred to as **Entities**. (% class="box infomessage" %) ((( **Step 1**: To begin, click on the "Add Entity" button ))) [[image:image-20230630130806-1.png

" %) ((( **Note**: Check Create Another if you want to create add another Entity without closing pop-up )))

of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable

of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append

\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV

)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction

[6] Customize Data Extract

Customizing Data Extract

* [[Automation of Fields>>path:/bin/view/akaBot%20Vision/Customizing%20Data%20Extract/Automation%20of%20Fields%20in%20akaBot%20Vision/]] * [[Capture Custom Table Data>>path:/bin/view/akaBot%20Vision

/Configure%20Automation%20Type%20for%20Pipeline%20/]] * [[Configure Fields for Data Extraction>>path:/bin

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

Data Table

) == **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

extracting the data fields. The AI extraction typically takes up to 5 seconds for 1 A4 page. After

]] [[image:image-20220420184331-2.png||data-xwiki-image-style-alignment="center"]] Click “OK” and the AI will automatically begin extracting the data fields. The AI extraction typically takes up to 5 seconds for 1 A4 page. [[image:image-20220420184331-3.png||data-xwiki-image-style-alignment="center"]] After processing

” or "Exit" button as soon as the pop up window appears. ・GETTEXT - Gets the text from alert box. ・SENDKEYS

up window appears. ・GETTEXT - Gets the text from alert box. ・SENDKEYS – Sends string of text

). E.g: {ENTER}, {TAB}.. Misc Public (Checkbox) - If you check it, the data of this activity

- Clicks on the “Cancel” or "Exit" button as soon as the pop up window appears. ・GETTEXT - Gets the text

- Clicks on the “Cancel” or "Exit" button as soon as the pop up window appears. ・GETTEXT - Gets the text

** * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful

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

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.

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

the edit option from Action next to the corresponding OU Name S4: After clicking, a pop-up form shows up

: Then a pop-up form will show up for you to fill in S4: Tick in the box to give permission for your new

/ Edit button, the system will show a form for you to fill in. Details in the table below: After

-20230308181201-4.png]] S4: After clicking, a pop-up form shows up for you to fill in the information

-20230308181201-7.png]] S3: Then a pop-up form will show up for you to fill in [[image:image-20230308181201-8

on** Create New/ Edit** button, the system will show a form for you to fill in. Details in the table below

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

. Reference Filter Strategy - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks

filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks for items whose references

if you want to publicize it. Remember to consider data security requirements before using it. * **Display