https://demos.telerik.com/kendo-ui/html5-dashboard-sample-app/products-orders.html
in this website lot of product code here i want to filter the Top 3 product code (11074,11075,11076) these 3 product code and get the details of the product code (PRODUCT NAME,Unit Price,Quantity,Discount,Total,Instock, In order ,Reorder,QTY.per unit and Grand total) these fields where extract the each product code and write on an Excel sheet using Find children activity
No need to use the Find children activity to scrap the text from the Webpage.
→ Use the Type into activity to type the product code in the field.
→ Use click activity to click on the Filter option.
→ After that use the Get text activity to scrap the text and required details. One Get text activity will get only one element value. Store the each value in variables.
→ use the Add data row activity to add the rows in the datatable.
Hope it helps!!
Hi @Melbin_Antu1 ,
Thanks for reaching out to UiPath community.
To have a work around, you can try these steps. It involves around 4-5 activities in UiPath.
Use the “Open Browser” activity in UiPath to navigate to the provided URL.
Utilize the “Find Children” activity to identify the elements containing the product codes and their details. You’ll likely use the “Data Scraping” wizard or the “Get Text” activity to extract the required data.
Filter Top 3 Product Codes: After extracting the data, you’ll need to filter it to keep only the details related to the product codes (11074, 11075, 11076). Loop through the extracted data and filter based on the specified product codes.
Store the extracted data into variables or data tables for each product code, ensuring you capture the necessary fields like Product Name, Unit Price, Quantity, etc.
Use the “Excel Application Scope” activity to open an Excel file. Then, use the “Write Range” activity to input the data into the Excel sheet.
Thanks,
@pratik.maskar
When you search with one code it will show three products right @Melbin_Antu1
