google photos search your input information

GOOGLE PHOTOS SEARCH YOUR INPUT INFORMATION HOW TO
GOOGLE PHOTOS SEARCH YOUR INPUT INFORMATION CODE

XmlHTTP.Open 'GET', url, False 'initialize GET request Set xmlHTTP = CreateObject('MSXML2.XMLHTTP') 'create XML/HTTP object 'equivalent to Excel's WEBSERVICE function :-) Public Function getHTTP(ByVal url As String) As String If you're interested in seeing the rest, add a comment and I'll look harder. The simple function for retrieving the source from a URL is below.

GOOGLE PHOTOS SEARCH YOUR INPUT INFORMATION CODE

While writing this answer I seem to have misplaced my related code (side effect of over-multitasking?!) - but if you made it this far, you probably get the gist of it. It's messy, but I've used it as a 'quick fix' to retrieve several types of data from several types of sites. Thus, my preferred method for parsing XML is to simply load it into a String with an HttpRequest and then use Instr and Mid to locate the values I'm interested in. (or maybe I'm just doing something wrong. but not even the newest features seem to support enough variations in XML style/source, to be of use to me.

Webservice & FilterXML (Worksheet Functions) Excel 2013+.

Connect to an XML file (Power Query) Excel 2010+.

Import XML Data (Developer Tab) Excel 2007+.

List all Google Photos using VBA: (The'Web-Scrapey Way' with Excel)Įxcel has built-in XML-Parsing functionality, in various forms: NET Developer's Guide: Request a List of Photos ★ The string ' default' can be used in place of a real username, in which case the server will use the username of the current user credentials used to authenticate the request. NET Example from Google: PhotoQuery query = new PhotoQuery(PicasaQuery.CreatePicasaUri(username, albumid)) įoreach (PicasaEntry entry in feed.Entries) Retrieving the List Programmatically: (The '.

The GET call to list all photos within an album is: _ The GET call to list your Google Photos albums is: Therefore, in order to list all photos, you must parse all of your albums, listing the photos in each one. If you have a preferred method of sending GET requests then all you'll need is two URL's.Īs I understand it, all Google Photos are stored in Albums (even if they don't appear to be).

This will allow you to use the generic addresses listed below - otherwise the word ' default' would need to be replaced with your Google ID, as as well as other changes to accomodate Google API Authentication. Go back to the photo list, click your browser's Back button and repeat for each album.Īuthentication: For the sake of simplicty, first make sure you are signed in to your Google account from any Google page, such as from the top-right corner of the Google Search page. Go to your favorite text editor ( Notepad++, Excel, oldschool Notepad, etc) and hit Ctrl+ V Hit Ctrl+ A then Ctrl+ C to copy text from the page I know you don't want to copy your list of photos manually, but I suspect others that come across this question want the 'easy' way:Īfter opening the API URL, click the first album link. Both the album list and the photo list look suspiciously like RSS Feeds (and can be bookmarked as such if you should so desire). You'll get a text-based list of all your Google Photos Albums. Make sure you're logged into your Google Account on your 'usual' (default) browser. Like so many things in life, there's an easy way and a hard way.ĭepending on your point of view, the hard way is often more fun and/or more fulfilling. My initial goal was to be able to determine which photos had/had not properly uploaded before I risk deleting anything as valuable as even my '3rd backup copy' of old photos. It's not necessarily 'secret information', but I suppose most users are perfectly happy viewing their Google Photos 'the old fashioned way'. I was surprised at how long it took me to find this API.

GOOGLE PHOTOS SEARCH YOUR INPUT INFORMATION HOW TO

This answer is outdated and will no longer work as Picasa and its API have been shut down How to list all files in your Google Photos:

Google photos search your input information