VBScript Stripe: List all Cards

Back to Index

List the cards belonging to a customer or recipient.

Documentation: https://stripe.com/docs/api/curl#list_cards

CURL Command

curl "https://api.stripe.com/v1/customers/cus_CBbg3iRMzWBjoe/sources?object=card&limit=3" \
   -u STRIPE_SECRET_KEY: \
   -G

VBScript Example

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

set rest = CreateObject("Chilkat_9_5_0.Rest")

'  URL: https://api.stripe.com/v1/customers/cus_CBbg3iRMzWBjoe/sources?object=card&limit=3
bTls = 1
port = 443
bAutoReconnect = 1
success = rest.Connect("api.stripe.com",port,bTls,bAutoReconnect)
If (success <> 1) Then
    outFile.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

success = rest.SetAuthBasic("STRIPE_SECRET_KEY","")

set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/v1/customers/cus_CBbg3iRMzWBjoe/sources?object=card&limit=3",sbResponseBody)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

set jsonResponse = CreateObject("Chilkat_9_5_0.JsonObject")
success = jsonResponse.LoadSb(sbResponseBody)

object = jsonResponse.StringOf("object")
url = jsonResponse.StringOf("url")
has_more = jsonResponse.BoolOf("has_more")
i = 0
count_i = jsonResponse.SizeOfArray("data")
Do While i < count_i
    jsonResponse.I = i
    id = jsonResponse.StringOf("data[i].id")
    object = jsonResponse.StringOf("data[i].object")
    address_city = jsonResponse.IsNullOf("data[i].address_city")
    address_country = jsonResponse.IsNullOf("data[i].address_country")
    address_line1 = jsonResponse.IsNullOf("data[i].address_line1")
    address_line1_check = jsonResponse.IsNullOf("data[i].address_line1_check")
    address_line2 = jsonResponse.IsNullOf("data[i].address_line2")
    address_state = jsonResponse.IsNullOf("data[i].address_state")
    address_zip = jsonResponse.IsNullOf("data[i].address_zip")
    address_zip_check = jsonResponse.IsNullOf("data[i].address_zip_check")
    brand = jsonResponse.StringOf("data[i].brand")
    country = jsonResponse.StringOf("data[i].country")
    customer = jsonResponse.StringOf("data[i].customer")
    cvc_check = jsonResponse.IsNullOf("data[i].cvc_check")
    dynamic_last4 = jsonResponse.IsNullOf("data[i].dynamic_last4")
    exp_month = jsonResponse.IntOf("data[i].exp_month")
    exp_year = jsonResponse.IntOf("data[i].exp_year")
    fingerprint = jsonResponse.StringOf("data[i].fingerprint")
    funding = jsonResponse.StringOf("data[i].funding")
    last4 = jsonResponse.StringOf("data[i].last4")
    name = jsonResponse.IsNullOf("data[i].name")
    tokenization_method = jsonResponse.IsNullOf("data[i].tokenization_method")
    i = i + 1
Loop

outFile.Close

Sample JSON Response Body

{
  "object": "list",
  "url": "/v1/customers/cus_CBbg3iRMzWBjoe/sources",
  "has_more": false,
  "data": [
    {
      "id": "card_1BnETKGswQrCoh0Xhu1A6BfL",
      "object": "card",
      "address_city": null,
      "address_country": null,
      "address_line1": null,
      "address_line1_check": null,
      "address_line2": null,
      "address_state": null,
      "address_zip": null,
      "address_zip_check": null,
      "brand": "Visa",
      "country": "US",
      "customer": "cus_CBbg3iRMzWBjoe",
      "cvc_check": null,
      "dynamic_last4": null,
      "exp_month": 8,
      "exp_year": 2019,
      "fingerprint": "F9mANtIt1TaukpRJ",
      "funding": "credit",
      "last4": "4242",
      "metadata": {},
      "name": null,
      "tokenization_method": null
    }
  ]
}