Extract table data timing issue

[Niranjan_k]

Hi all,

I’m using extract table data tool in workflow. When data found in web page it executes quickly. When there is no data to extract it is waiting for so long. How to reduce when data not found how to skip the step in 1 or 2 seconds. Please suggest

Thanks in advance
Niranjan

[mkankatala (Mahesh Kankatala)]

Hi @Niranjan_k

→ Use check app state activity to check the table exist in the webpage.
→ In check app state activity indicate the table which contains the reference data.
→ In the Target appear block insert the Extract datatable activity to extract the table.
→ In the Target doesn’t appear don’t give any activity.
→ There is Seconds field in check app state activity give the value of 5 in dropdown.

Check the below image for better understanding,

Hope it helps!!

[rlgandu]

@Niranjan_k

Sequence:
Try
Extract Table Data Activity
TimeoutMS: 2000
Catch TimeoutException
Log Message or other actions

[Niranjan_k]

@mkankatala if no data I’m getting error here

Write Range: Object reference not set to an instance of an object

I’m not sure about the error, any suggestions please

[mkankatala (Mahesh Kankatala)]

Are you used Check app state, @Niranjan_k

Send the screenshot of your webpage when datatable exist and datatable doesn’t exist and your workflow
Share this if it’s not a sensitive data.

[sai_gupta]

@Niranjan_k

try this :

Sequence
Element Exists
Properties:
Selector: Indicate the element representing the table
TimeoutMS: 2000 (or your preferred timeout)
Output:
elementExists (Boolean variable)
If
Condition: elementExists = True
Then
Extract Table Data (or other relevant activities)

cheers!!!

[Niranjan_k]

@mkankatala extremely sorry I can’t share the image bcz of data sensitivity. But as per your image I have built I got the same error again

Error:

Write Range: object reference not set instance of an object

[Niranjan_k]

@sai_gupta could you please help me with screen shot, I can try to build the workflow as suggested

[Niranjan_k]

@rlgandu where should I mention this time in properties common section

[mkankatala (Mahesh Kankatala)]

Okay @Niranjan_k

Have you inserted the Write range workbook activity next to the Extract datatable activity inside the Target appears block in check app state activity.

Check the below image,

Note : If the Datatable appear in this condition give the activities in target appears block, if datatable doesn’t appear give the activities in target doesn’t appear block.

Hope you understand!!

Hope you understand!!

[Kanak_Lata_Singh]

Hi @Niranjan_k

You can give it try the below steps
1 . Use Extract Table data activity , and assign the output to a datable variable
2 . Then try to read the rowcount , if rowcount = 0 , then there is no data and vice versa .

Hope it helps

Thanks

[rlgandu]

@Niranjan_k

[Niranjan_k]

@mkankatal amazing it’s working. I was packing write outside check app state

[mkankatala (Mahesh Kankatala)]

Thank you @Niranjan_k

Happy Automation!!

[Niranjan_k]

@Kanak_Lata_Singh thank you for quick reply

[Niranjan_k]

@rlgandu thanks a lot for replying promptly

[Niranjan_k]

@sai_gupta thank you for quick reply