PowerShell
PowerShell
Square API - Batch Retrieve Catalog Objects
See more Square Examples
Returns a set of objects based on the provided ID.Chilkat PowerShell Downloads
Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"
$success = $false
# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
$http = New-Object Chilkat.Http
# Implements the following CURL command:
# curl https://connect.squareup.com/v2/catalog/batch-retrieve \
# -X POST \
# -H 'Square-Version: 2020-07-22' \
# -H 'Authorization: Bearer ACCESS_TOKEN' \
# -H 'Content-Type: application/json' \
# -d '{
# "object_ids": [
# "W62UWFY35CWMYGVWK6TWJDNI",
# "AA27W3M2GGTF3H6AVPNB77CK"
# ],
# "include_related_objects": true
# }'
# Use the following online tool to generate HTTP code from a CURL command
# Convert a cURL Command to HTTP Source Code
# Use this online tool to generate code from sample JSON:
# Generate Code to Create JSON
# The following JSON is sent in the request body.
# {
# "object_ids": [
# "W62UWFY35CWMYGVWK6TWJDNI",
# "AA27W3M2GGTF3H6AVPNB77CK"
# ],
# "include_related_objects": true
# }
$json = New-Object Chilkat.JsonObject
$i = 0
$json.I = $i
$json.UpdateString("object_ids[i]","W62UWFY35CWMYGVWK6TWJDNI")
$i = $i + 1
$json.I = $i
$json.UpdateString("object_ids[i]","AA27W3M2GGTF3H6AVPNB77CK")
$json.UpdateBool("include_related_objects",$true)
# Adds the "Authorization: Bearer ACCESS_TOKEN" header.
$http.AuthToken = "ACCESS_TOKEN"
$http.SetRequestHeader("Square-Version","2020-07-22")
# This example uses the sandbox: connect.squareupsandbox.com
# Production should use connect.squareup.com
$resp = New-Object Chilkat.HttpResponse
$success = $http.HttpJson("POST","https://connect.squareupsandbox.com/v2/catalog/batch-retrieve",$json,"application/json",$resp)
if ($success -eq $false) {
$($http.LastErrorText)
exit
}
$sbResponseBody = New-Object Chilkat.StringBuilder
$resp.GetBodySb($sbResponseBody)
$jResp = New-Object Chilkat.JsonObject
$jResp.LoadSb($sbResponseBody)
$jResp.EmitCompact = $false
$("Response Body:")
$($jResp.Emit())
$respStatusCode = $resp.StatusCode
$("Response Status Code = " + $respStatusCode)
if ($respStatusCode -ge 400) {
$("Response Header:")
$($resp.Header)
$("Failed.")
exit
}
# Sample JSON response:
# (Sample code for parsing the JSON response is shown below)
# {
# "objects": [
# {
# "type": "ITEM",
# "id": "W62UWFY35CWMYGVWK6TWJDNI",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "item_data": {
# "name": "Tea",
# "description": "Hot Leaf Juice",
# "category_id": "BJNQCF2FJ6S6UIDT65ABHLRX",
# "tax_ids": [
# "HURXQOOAIC4IZSI2BEXQRYFY"
# ],
# "variations": [
# {
# "type": "ITEM_VARIATION",
# "id": "2TZFAOHWGG7PAK2QEXWYPZSP",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "item_variation_data": {
# "item_id": "W62UWFY35CWMYGVWK6TWJDNI",
# "name": "Mug",
# "ordinal": 0,
# "pricing_type": "FIXED_PRICING",
# "price_money": {
# "amount": 150,
# "currency": "USD"
# }
# }
# }
# ]
# }
# },
# {
# "type": "ITEM",
# "id": "AA27W3M2GGTF3H6AVPNB77CK",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "item_data": {
# "name": "Coffee",
# "description": "Hot Bean Juice",
# "category_id": "BJNQCF2FJ6S6UIDT65ABHLRX",
# "tax_ids": [
# "HURXQOOAIC4IZSI2BEXQRYFY"
# ],
# "variations": [
# {
# "type": "ITEM_VARIATION",
# "id": "LBTYIHNHU52WOIHWT7SNRIYH",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "item_variation_data": {
# "item_id": "AA27W3M2GGTF3H6AVPNB77CK",
# "name": "Regular",
# "ordinal": 0,
# "pricing_type": "FIXED_PRICING",
# "price_money": {
# "amount": 250,
# "currency": "USD"
# }
# }
# },
# {
# "type": "ITEM_VARIATION",
# "id": "PKYIC7HGGKW5CYVSCVDEIMHY",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "item_variation_data": {
# "item_id": "AA27W3M2GGTF3H6AVPNB77CK",
# "name": "Large",
# "ordinal": 1,
# "pricing_type": "FIXED_PRICING",
# "price_money": {
# "amount": 350,
# "currency": "USD"
# }
# }
# }
# ]
# }
# }
# ],
# "related_objects": [
# {
# "type": "CATEGORY",
# "id": "BJNQCF2FJ6S6UIDT65ABHLRX",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "is_deleted": false,
# "present_at_all_locations": true,
# "category_data": {
# "name": "Beverages"
# }
# },
# {
# "type": "TAX",
# "id": "HURXQOOAIC4IZSI2BEXQRYFY",
# "updated_at": "2016-11-16T22:25:24.878Z",
# "version": 1479335124878,
# "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")
while ($i -lt $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")
$item_dataName = $jResp.StringOf("objects[i].item_data.name")
$item_dataDescription = $jResp.StringOf("objects[i].item_data.description")
$item_dataCategory_id = $jResp.StringOf("objects[i].item_data.category_id")
$j = 0
$count_j = $jResp.SizeOfArray("objects[i].item_data.tax_ids")
while ($j -lt $count_j) {
$jResp.J = $j
$strVal = $jResp.StringOf("objects[i].item_data.tax_ids[j]")
$j = $j + 1
}
$j = 0
$count_j = $jResp.SizeOfArray("objects[i].item_data.variations")
while ($j -lt $count_j) {
$jResp.J = $j
$v_type = $jResp.StringOf("objects[i].item_data.variations[j].type")
$id = $jResp.StringOf("objects[i].item_data.variations[j].id")
$updated_at = $jResp.StringOf("objects[i].item_data.variations[j].updated_at")
$version = $jResp.IntOf("objects[i].item_data.variations[j].version")
$is_deleted = $jResp.BoolOf("objects[i].item_data.variations[j].is_deleted")
$present_at_all_locations = $jResp.BoolOf("objects[i].item_data.variations[j].present_at_all_locations")
$item_variation_dataItem_id = $jResp.StringOf("objects[i].item_data.variations[j].item_variation_data.item_id")
$item_variation_dataName = $jResp.StringOf("objects[i].item_data.variations[j].item_variation_data.name")
$item_variation_dataOrdinal = $jResp.IntOf("objects[i].item_data.variations[j].item_variation_data.ordinal")
$item_variation_dataPricing_type = $jResp.StringOf("objects[i].item_data.variations[j].item_variation_data.pricing_type")
$item_variation_dataPrice_moneyAmount = $jResp.IntOf("objects[i].item_data.variations[j].item_variation_data.price_money.amount")
$item_variation_dataPrice_moneyCurrency = $jResp.StringOf("objects[i].item_data.variations[j].item_variation_data.price_money.currency")
$j = $j + 1
}
$i = $i + 1
}
$i = 0
$count_i = $jResp.SizeOfArray("related_objects")
while ($i -lt $count_i) {
$jResp.I = $i
$v_type = $jResp.StringOf("related_objects[i].type")
$id = $jResp.StringOf("related_objects[i].id")
$updated_at = $jResp.StringOf("related_objects[i].updated_at")
$version = $jResp.IntOf("related_objects[i].version")
$is_deleted = $jResp.BoolOf("related_objects[i].is_deleted")
$present_at_all_locations = $jResp.BoolOf("related_objects[i].present_at_all_locations")
$category_dataName = $jResp.StringOf("related_objects[i].category_data.name")
$tax_dataName = $jResp.StringOf("related_objects[i].tax_data.name")
$tax_dataCalculation_phase = $jResp.StringOf("related_objects[i].tax_data.calculation_phase")
$tax_dataInclusion_type = $jResp.StringOf("related_objects[i].tax_data.inclusion_type")
$tax_dataPercentage = $jResp.StringOf("related_objects[i].tax_data.percentage")
$tax_dataEnabled = $jResp.BoolOf("related_objects[i].tax_data.enabled")
$i = $i + 1
}