Google DocsのスプレッドシートをCSVにしてローカルに落とすJavaサーブレット

DocumentListFeedを取る必要は無いような気がしていますが、ともかくGoogle DocsのスプレッドシートをCSVにしてローカルに落とすJavaサーブレットを作りたく、とりあえず落とすことには成功したコードをここに張っておきますので、プログラムをコピペで済まそうという輩はコピペして、あーそうすればいいわけか、なるほどね、とかしてみてはいかがでしょうか。

import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; import java.net.URL; import java.util.Date; import me.suzukiken.util.SystemProperties; import org.apache.log4j.Logger; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.google.gdata.client.GoogleAuthTokenFactory.UserToken; import com.google.gdata.client.docs.DocsService; import com.google.gdata.client.spreadsheet.SpreadsheetService; import com.google.gdata.data.DateTime; import com.google.gdata.data.MediaContent; import com.google.gdata.data.docs.DocumentListEntry; import com.google.gdata.data.docs.DocumentListFeed; import com.google.gdata.data.media.MediaSource; import com.google.gdata.util.ServiceException; public class DownloadDeviceCsv extends HttpServlet implements javax.servlet.Servlet{ static final long serialVersionUID = 1L; private SystemProperties properties = SystemProperties.getInstance(); private String resourceId; private String key; private DocsService docsService; private DocumentListEntry documentListEntry = null; private SpreadsheetService spreadsheetService; static final String appname = "suzuki-ken-1"; static final String mailaddr = "メールアドレス@gmail.com"; static final String password = "パスワード"; static final String title = "japanese_flashlite_enabled_mobile_device_list"; public DownloadDeviceCsv() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { out(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { out(request, response); } private void out(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String body = ""; try { docsService = new DocsService(appname); docsService.setUserCredentials(mailaddr, password); URL feedUri = new URL("https://docs.google.com/feeds/default/private/full"); DocumentListFeed feed = docsService.getFeed(feedUri, DocumentListFeed.class); for(DocumentListEntry tempEntry : feed.getEntries()) { if(title.equals(tempEntry.getTitle().getPlainText())) { documentListEntry = tempEntry; break; } } if(documentListEntry != null) { resourceId = documentListEntry.getResourceId(); key = resourceId.substring(resourceId.lastIndexOf(':') + 1); DateTime googleDate = documentListEntry.getUpdated(); File file = new File(properties.devices_csv); Date localDate = new Date(file.lastModified()); Logger.getLogger(DownloadDeviceCsv.class).debug(googleDate.toString() + " : " + localDate.toString()); body = "GoogleDocsドキュメントの最終更新時間。" + "こちらのサーバーに保存したドキュメントの最終更新時間"; if(localDate.getTime() < googleDate.getValue()) { spreadsheetService = new SpreadsheetService(appname); spreadsheetService.setUserCredentials(mailaddr, password); UserToken docsToken = (UserToken) docsService.getAuthTokenFactory().getAuthToken(); UserToken spreadsheetsToken = (UserToken) spreadsheetService.getAuthTokenFactory().getAuthToken(); docsService.setUserToken(spreadsheetsToken.getValue()); spreadsheetService.setUserToken(docsToken.getValue()); String exportUrl = "http://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=" + key + "&fmcmd=5&gid=0"; MediaContent mc = new MediaContent(); mc.setUri(exportUrl.toString()); MediaSource ms = docsService.getMedia(mc); InputStream inStream = null; FileOutputStream outStream = null; inStream = ms.getInputStream(); outStream = new FileOutputStream(properties.devices_csv); int c; while ((c = inStream.read()) != -1) { outStream.write(c); } if(inStream != null) { inStream.close(); } if(outStream != null) { outStream.flush(); outStream.close(); } body = "更新しました。"; }else{ body = "更新不用でした。"; } }else{ body = "ドキュメントはみつかりませんでした。"; } } catch (ServiceException e) { body = e.getMessage(); } response.setContentType("text/plain; charset=UTF-8"); PrintWriter out = response.getWriter(); out.write(body); } }

ちなみに必要かどうか細かいところまでは分からないのですが、ライブラリにはとりあえず、これらが入ってます。

commons-codec-1.3.jar

commons-fileupload-1.2.1.jar

commons-httpclient-3.1.jar

commons-io-1.3.2.jar

commons-logging-1.0.jar

gdata-base-1.0.jar

gdata-client-1.0.jar

gdata-core-1.0.jar

gdata-docs-3.0.jar

gdata-media-1.0.jar

gdata-spreadsheet-3.0.jar

google-collect-1.0.jar

jai_codec.jar

jai_core.jar

log4j.jar

mailapi.jar

ポイントは、http://www.oracle.com/technetwork/java/index-138643.htmlからJavaMailを取って来てmailapi.jarを入れる必要があったということです。