Classic ASP

Square API - List Catalog

See more Square Examples

Returns a list of CatalogObjects that includes all objects of a set of desired types (for example, all CatalogItem and CatalogTax objects) in the catalog. Classic ASP

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0

'  This example assumes the Chilkat API to have been previously unlocked.
'  See Global Unlock Sample for sample code.

set http = Server.CreateObject("Chilkat.Http")

'  Implements the following CURL command:

'  curl https://connect.squareup.com/v2/catalog/list?types=category%2Ctax \
'    -H 'Square-Version: 2020-07-22' \
'    -H 'Authorization: Bearer ACCESS_TOKEN' \
'    -H 'Content-Type: application/json'

'  Use the following online tool to generate HTTP code from a CURL command
'  Convert a cURL Command to HTTP Source Code

'  Adds the "Authorization: Bearer ACCESS_TOKEN" header.
http.AuthToken = "ACCESS_TOKEN"
http.SetRequestHeader "Square-Version","2020-07-22"
http.SetRequestHeader "Content-Type","application/json"

'  This example uses the sandbox: connect.squareupsandbox.com
'  Production should use connect.squareup.com
set sbResponseBody = Server.CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb("https://connect.squareupsandbox.com/v2/catalog/list?types=item,category,tax,image",sbResponseBody)
If (success = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
    Response.End
End If

set jResp = Server.CreateObject("Chilkat.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Response.Write "<pre>" & Server.HTMLEncode( "Response Body:") & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( jResp.Emit()) & "</pre>"

respStatusCode = http.LastStatus
Response.Write "<pre>" & Server.HTMLEncode( "Response Status Code = " & respStatusCode) & "</pre>"
If (respStatusCode >= 400) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Response Header:") & "</pre>"
    Response.Write "<pre>" & Server.HTMLEncode( http.LastHeader) & "</pre>"
    Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>"
    Response.End
End If

'  Sample JSON response:
'  (Sample code for parsing the JSON response is shown below)

'  {
'    "objects": [
'      {
'        "type": "CATEGORY",
'        "id": "5ZYQZZ2IECPVJ2IJ5KQPRDC3",
'        "updated_at": "2017-02-21T14:50:26.495Z",
'        "version": 1487688626495,
'        "is_deleted": false,
'        "present_at_all_locations": true,
'        "category_data": {
'          "name": "Beverages"
'        }
'      },
'      {
'        "type": "TAX",
'        "id": "L5R47DGBZOOVKCAFIXC56AEN",
'        "updated_at": "2017-02-21T14:50:26.495Z",
'        "version": 1487688626495,
'        "is_deleted": false,
'        "present_at_all_locations": true,
'        "tax_data": {
'          "name": "Sales Tax",
'          "calculation_phase": "TAX_SUBTOTAL_PHASE",
'          "inclusion_type": "ADDITIVE",
'          "percentage": "5.0",
'          "enabled": true
'        }
'      }
'    ]
'  }

'  Sample code for parsing the JSON response...
'  Use the following online tool to generate parsing code from sample JSON:
'  Generate Parsing Code from JSON

i = 0
count_i = jResp.SizeOfArray("objects")
Do While i < count_i
    jResp.I = i
    v_type = jResp.StringOf("objects[i].type")
    id = jResp.StringOf("objects[i].id")
    updated_at = jResp.StringOf("objects[i].updated_at")
    version = jResp.IntOf("objects[i].version")
    is_deleted = jResp.BoolOf("objects[i].is_deleted")
    present_at_all_locations = jResp.BoolOf("objects[i].present_at_all_locations")
    category_dataName = jResp.StringOf("objects[i].category_data.name")
    tax_dataName = jResp.StringOf("objects[i].tax_data.name")
    tax_dataCalculation_phase = jResp.StringOf("objects[i].tax_data.calculation_phase")
    tax_dataInclusion_type = jResp.StringOf("objects[i].tax_data.inclusion_type")
    tax_dataPercentage = jResp.StringOf("objects[i].tax_data.percentage")
    tax_dataEnabled = jResp.BoolOf("objects[i].tax_data.enabled")
    i = i + 1
Loop

%>
</body>
</html>