Scrape page url and save to csv

Ui.Vision HowTo
,
1

Hi I have list of shortened url . I just need to open link and write the final links in csv and save file
any body can help please ??

I’m able to open links :slight_smile: but not able to save the each url to csv and then save the file

{
“Name”: “pin”,
“CreationDate”: “2020-8-2”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “book2.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “{!col1}", "Value": "" }, { "Command": "storeEval", "Target": "var string = \"{!col1}”; var stripped = string.replace(/[^A-Za-z0-9]/g, ‘’); stripped;",
“Value”: “alphanumericonly”
},
{
“Command”: “csvSave”,
“Target”: “links”,
“Value”: “”
},
{
“Command”: “localStorageExport”,
“Target”: “links.csv”,
“Value”: “”
}
]
}

any help please

2

After you opened the url and load the final url you can save it with this command

{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},

After you save ${MyUrl} in csv

3

thanks for replying but I got error after add the command

There are errors in the source

any recomandation ?

4

What error ?

Post complete macro code and complete log

Thanks

5

thanks

{
“Name”: “pin”,
“CreationDate”: “2020-8-3”,
“Commands”: [
{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},
]
}

Unexpected token ‘“’ at 10:1
“Command”: “executeScript”,
^

{
“Name”: “pin”,
“CreationDate”: “2020-8-3”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “book2.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “{!col1}", "Value": "" }, { "Command": "storeEval", "Target": "var string = \"{!col1}”; var stripped = string.replace(/[^A-Za-z0-9]/g, ‘’); stripped;",
“Value”: “alphanumericonly”
}
{
“Command”: “executeScript”,
“Target”: “return (window.location.href)”,
“Value”: “MyUrl”
},
]
}
Unexpected token ‘{’ at 20:5

I will realy appriciate if you can write the whole map I just have links in csv need open click links write final links and save all in csv file

thanks in advance

6

Your code is wrong, you must create a code reading docs command

https://ui.vision/rpa/docs

Latest command do not require ,

storeEval is deprecated, remove it and use update command.

before create a macro you must study the docs with all command and not copy and paste command codes otherwise you have errors.

7

How can i save to csv just the domain names from the entire url? Note that the domains are random…Please help.

8

Use split function and save the part you need

Here example