Visual Basic 6.0
Visual Basic 6.0
Twilio List Log Messages
See more Twilio Examples
Fetch the log containing information about SMS messages previously sent (or failed to be sent).Chilkat Visual Basic 6.0 Downloads
Dim success As Long
success = 0
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
' Implements the following CURL command:
' curl -X GET 'https://api.twilio.com/2010-04-01/Accounts/TWILIO_ACCOUNT_SID/Messages.json?PageSize=20' \
' -u TWILIO_ACCOUNT_SID:TWILIO_AUTH_TOKEN
' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code
http.Login = "TWILIO_ACCOUNT_SID"
http.Password = "TWILIO_AUTH_TOKEN"
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://api.twilio.com/2010-04-01/Accounts/TWILIO_ACCOUNT_SID/Messages.json?PageSize=20",sbResponseBody)
If (success = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim json As New ChilkatJsonObject
success = json.LoadSb(sbResponseBody)
json.EmitCompact = 0
Debug.Print "Response Body:"
Debug.Print json.Emit()
Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print http.LastHeader
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "end": 1,
' "first_page_uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages.json?To=%2B123456789&From=%2B987654321&DateSent%3E=2008-01-02&PageSize=2&Page=0",
' "next_page_uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages.json?To=%2B123456789&From=%2B987654321&DateSent%3E=2008-01-02&PageSize=2&Page=1&PageToken=PAMMc26223853f8c46b4ab7dfaa6abba0a26",
' "page": 0,
' "page_size": 2,
' "previous_page_uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages.json?To=%2B123456789&From=%2B987654321&DateSent%3E=2008-01-02&PageSize=2&Page=0",
' "messages": [
' {
' "account_sid": "ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
' "api_version": "2010-04-01",
' "body": "testing",
' "date_created": "Fri, 24 May 2019 17:44:46 +0000",
' "date_sent": "Fri, 24 May 2019 17:44:50 +0000",
' "date_updated": "Fri, 24 May 2019 17:44:50 +0000",
' "direction": "outbound-api",
' "error_code": null,
' "error_message": null,
' "from": "+12019235161",
' "messaging_service_sid": null,
' "num_media": "0",
' "num_segments": "1",
' "price": "-0.00750",
' "price_unit": "USD",
' "sid": "SMded05904ccb347238880ca9264e8fe1c",
' "status": "sent",
' "subresource_uris": {
' "media": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/SMded05904ccb347238880ca9264e8fe1c/Media.json",
' "feedback": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/SMded05904ccb347238880ca9264e8fe1c/Feedback.json"
' },
' "to": "+18182008801",
' "uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/SMded05904ccb347238880ca9264e8fe1c.json"
' },
' {
' "account_sid": "ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
' "api_version": "2010-04-01",
' "body": "look mom I have media!",
' "date_created": "Fri, 24 May 2019 17:44:46 +0000",
' "date_sent": "Fri, 24 May 2019 17:44:49 +0000",
' "date_updated": "Fri, 24 May 2019 17:44:49 +0000",
' "direction": "inbound",
' "error_code": 30004,
' "error_message": "Message blocked",
' "from": "+12019235161",
' "messaging_service_sid": null,
' "num_media": "3",
' "num_segments": "1",
' "price": "-0.00750",
' "price_unit": "USD",
' "sid": "MMc26223853f8c46b4ab7dfaa6abba0a26",
' "status": "received",
' "subresource_uris": {
' "media": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/MMc26223853f8c46b4ab7dfaa6abba0a26/Media.json",
' "feedback": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/MMc26223853f8c46b4ab7dfaa6abba0a26/Feedback.json"
' },
' "to": "+18182008801",
' "uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages/MMc26223853f8c46b4ab7dfaa6abba0a26.json"
' }
' ],
' "start": 0,
' "uri": "/2010-04-01/Accounts/ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/Messages.json?To=%2B123456789&From=%2B987654321&DateSent%3E=2008-01-02&PageSize=2&Page=0"
' }
' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON
Dim account_sid As String
Dim api_version As String
Dim body As String
Dim date_created As String
Dim date_sent As String
Dim date_updated As String
Dim direction As String
Dim error_code As String
Dim error_message As String
Dim from As String
Dim messaging_service_sid As String
Dim num_media As String
Dim num_segments As String
Dim price As String
Dim price_unit As String
Dim sid As String
Dim status As String
Dim subresource_urisMedia As String
Dim subresource_urisFeedback As String
Dim v_to As String
Dim end As Long
end = json.IntOf("end")
Dim first_page_uri As String
first_page_uri = json.StringOf("first_page_uri")
Dim next_page_uri As String
next_page_uri = json.StringOf("next_page_uri")
Dim page As Long
page = json.IntOf("page")
Dim page_size As Long
page_size = json.IntOf("page_size")
Dim previous_page_uri As String
previous_page_uri = json.StringOf("previous_page_uri")
Dim start As Long
start = json.IntOf("start")
Dim uri As String
uri = json.StringOf("uri")
Dim i As Long
i = 0
Dim count_i As Long
count_i = json.SizeOfArray("messages")
Do While i < count_i
json.I = i
account_sid = json.StringOf("messages[i].account_sid")
api_version = json.StringOf("messages[i].api_version")
body = json.StringOf("messages[i].body")
date_created = json.StringOf("messages[i].date_created")
date_sent = json.StringOf("messages[i].date_sent")
date_updated = json.StringOf("messages[i].date_updated")
direction = json.StringOf("messages[i].direction")
error_code = json.StringOf("messages[i].error_code")
error_message = json.StringOf("messages[i].error_message")
from = json.StringOf("messages[i].from")
messaging_service_sid = json.StringOf("messages[i].messaging_service_sid")
num_media = json.StringOf("messages[i].num_media")
num_segments = json.StringOf("messages[i].num_segments")
price = json.StringOf("messages[i].price")
price_unit = json.StringOf("messages[i].price_unit")
sid = json.StringOf("messages[i].sid")
status = json.StringOf("messages[i].status")
subresource_urisMedia = json.StringOf("messages[i].subresource_uris.media")
subresource_urisFeedback = json.StringOf("messages[i].subresource_uris.feedback")
v_to = json.StringOf("messages[i].to")
uri = json.StringOf("messages[i].uri")
i = i + 1
Loop