Data scraping wizard and SSMS

Help
1

I tried the Data Scraping Wizard on the results pane for a query in SQL Server Management Studio and, to my surprise, it failed completely to find any data, let alone to detect a table. I know such a scenario is unusual, but why didn’t it work? Should I not expect it to work for other Windows applications?

2

Hi
if its a database then we can use UiPath.Database activities to get that table as datatable here in the studio with EXECUTE QUERY activity where we can mention the select query we want

for that go to design tab → manage pacakges → and in official tab search as uipath.database and install that

once after installing choose EXECUTE QUERY activity and get the table as datatable

Cheers @Craig1

3

Yes I know that, but UiPath is supposed to work with almost any application isn’t it? Why does it fail so badly with a table of data presented by SSMS?

4

@Craig1
The data scraping utility works best with websites (I don’t know how exactly it works, but it’s possible it’s looking for <table> tags, which SSMS wouldn’t have). As @Palaniyappan said, if you’re trying to get SQL data it will be far faster and more accurate to query the database.

1 Like
5

I got the same issue. Bot successfully opened and Executed a sql script file in SSMS but it failed to copy data from the query result pane in SSMS via Data scraping wizard.