=InternetArchiveFirstSeen


#1

Hi,

Using this formula -> =InternetArchiveFirstSeen(A1) , where A1 has the url i want to check but i'm not getting any results.

No idea if i'm missing something?

Thxs


#2

Hi Dave,

You must be using an old version of Seotools? That formula was depreciated a long time ago.

You should get the latest version and use the new Wayback Machine Connector:
https://seotoolsforexcel.com/wayback-machine/

Here is a formula producing the same results as the InternetArchiveFirstSeen:
=Connector("WaybackMachine.Snapshots";A1;"exact";;;;1;"first";"Timestamp";TRUE)


#3

Ow ok thxs... it's indeed still the version from 2 years ago :slight_smile:


#5

Other issue i can't really figure out..

When using this formula i get the correct date:

=Dump(Connector("WaybackMachine.Snapshots";"https://www.instructables.com/id/Building-a-Simple-Patio-Using-Paving-Stones/";"exact";;;;1;"first";"Url,Timestamp";TRUE))

When replacing the url by the cell number (A1 for example because i need to get the date of few 100 url's/lines at once) & deleting the Url parameter i get another date:
=Dump(Connector("WaybackMachine.Snapshots";"A1;"exact";;;;1;"first";"Timestamp";TRUE))

Any idea where i screw it up :slight_smile: ?

Thxs


#6

Perhaps the second formula references a blank cell ausch as A7? I get a different date when referencing blank cells. Otherwise, I get the same dates:


#7

I've changed the Connector so the URL input is required and empty cell references aren't allowed. You can update the connector from the Manager:
https://seotoolsforexcel.com/manage-connectors/


#8

Thxs but same result here. I might be doing something wrong as well :slight_smile:

Is there any working example somewhere with the formula and a few lines?


#9

Send me the workbook and I'll take a look :slight_smile:
victor@seotoolsforexcel.com


#10

done :wink: #thxsforchecking


#11

Returned back the workbook with proper formula. Also, for other users: