16. Data API Library for VBA
? VBA(Visual Basic for Applications)でData
APIを扱うライブラリ
? SixApart謹製JavaScriptライブラリに近い構
文
? VBAでプログラムを組んでOfficeアプリと
Movable Typeを連携
18. 初期化と認証
' 初期化
Set api = New MTDataAPI
api.init BASE, CLIENT_ID
' 認証
Set params = New Scripting.Dictionary
params("username") = USERNAME
params("password") = PASSWORD
Set response = api.send("authenticate",
params)
19. 記事作成部分
For i = 2 To 4
Set entry = New Scripting.Dictionary
entry("title") = Cells(i, 1).value
entry("body") = Cells(i, 2).value
entry("date") = api.convDate(Cells(i,3).value)
Set response = api.send("createEntry",
SITE_ID, entry)
Next