Need to know an activity so that status is accurately captured

Help Activities
, ,
1

Hi everyone.

I have a list of IDs in an Excel file, and I need to record the communication status for each ID.
The communication status will be either “OK” or “NG.”
I’m unsure which activity should I use so that the automation can accurately capture and record the communication status for each ID.

Thank you in advance.

Screenshot 2024-08-30 150649
Screenshot 2024-08-30 150649911×273 11.8 KB

2

@Aakash_Sharma4,

Use Table Extraction to get ID and Communication Status columns.

Thanks,
Ashok :slight_smile:

3

Thank you for replying.

I update different IDs in Excel on a daily basis, so I want UiPath to pick up the IDs from Excel and paste the status back into Excel.

4

@Aakash_Sharma4,

Follow this approach.

  1. Extract Table extraction data with Status from web application.
  2. Read Id’s from excel
  3. Iterate through Id from excel
  4. Use this LINQ to get status of the ID being iterated.
dtStatus = tableExtractionDataTable.Select("ID=" + currentIDVariable).CopyToDataTable

statusVariable = dtStatus .Rows(0)("Status").ToString
  1. Write this status back to excel one by one or you can update it into a Datatable and then write it at once.

Thanks,
Ashok :slight_smile:

5

Sorry for the late reply. I practice UiPath in my free time.

The IDs I’m searching for are on different websites. If I use table extraction, it will only capture the IDs and statuses from the specific page I provide for the extraction activity, and I won’t be able to get data from multiple websites. Correct me if I’m wrong.

Here are the steps I’ve taken so far:

  1. I pick up the link from Excel.
  2. I input the login credentials.
  3. I retrieve the ID from Excel and search for it on the website.

Now, I just need to obtain the communication status. Kindly advice.