AutoIt
AutoIt
Shopify List Products
See more Shopify Examples
Receive a list of all ProductsChilkat AutoIt Downloads
Local $bSuccess = False
$oRest = ObjCreate("Chilkat.Rest")
$oRest.SetAuthBasic("SHOPIFY_API_KEY","SHOPIFY_API_SECRET_KEY")
$bSuccess = $oRest.Connect("chilkat.myshopify.com",443,True,True)
If ($bSuccess <> True) Then
ConsoleWrite($oRest.LastErrorText & @CRLF)
Exit
EndIf
$oSbJson = ObjCreate("Chilkat.StringBuilder")
$bSuccess = $oRest.FullRequestNoBodySb("GET","/admin/products.json",$oSbJson)
If ($bSuccess <> True) Then
ConsoleWrite($oRest.LastErrorText & @CRLF)
Exit
EndIf
If ($oRest.ResponseStatusCode <> 200) Then
ConsoleWrite("Received error response code: " & $oRest.ResponseStatusCode & @CRLF)
ConsoleWrite("Response body:" & @CRLF)
ConsoleWrite($oSbJson.GetAsString() & @CRLF)
Exit
EndIf
$oJson = ObjCreate("Chilkat.JsonObject")
$oJson.LoadSb($oSbJson)
; The following code parses the JSON response.
; A sample JSON response is shown below the sample code.
Local $i
Local $iCount_i
Local $id
Local $sTitle
Local $sBody_html
Local $sVendor
Local $sProduct_type
Local $sCreated_at
Local $sHandle
Local $sUpdated_at
Local $sPublished_at
Local $bTemplate_suffix
Local $sPublished_scope
Local $sTags
Local $imageId
Local $imageProduct_id
Local $imagePosition
Local $sImageCreated_at
Local $sImageUpdated_at
Local $imageWidth
Local $imageHeight
Local $sImageSrc
Local $bImage
Local $iJ
Local $iCount_j
Local $iProduct_id
Local $sPrice
Local $sku
Local $iPosition
Local $iGrams
Local $sInventory_policy
Local $bCompare_at_price
Local $sFulfillment_service
Local $sInventory_management
Local $sOption1
Local $bOption2
Local $bOption3
Local $bTaxable
Local $sBarcode
Local $image_id
Local $inventory_quantity
Local $iWeight
Local $sWeight_unit
Local $iOld_inventory_quantity
Local $bRequires_shipping
Local $sName
Local $iK
Local $iCount_k
Local $strVal
Local $iWidth
Local $iHeight
Local $src
Local $intVal
$i = 0
$iCount_i = $oJson.SizeOfArray("products")
While $i < $iCount_i
$oJson.I = $i
$id = $oJson.IntOf("products[i].id")
$sTitle = $oJson.StringOf("products[i].title")
$sBody_html = $oJson.StringOf("products[i].body_html")
$sVendor = $oJson.StringOf("products[i].vendor")
$sProduct_type = $oJson.StringOf("products[i].product_type")
$sCreated_at = $oJson.StringOf("products[i].created_at")
$sHandle = $oJson.StringOf("products[i].handle")
$sUpdated_at = $oJson.StringOf("products[i].updated_at")
$sPublished_at = $oJson.StringOf("products[i].published_at")
$bTemplate_suffix = $oJson.IsNullOf("products[i].template_suffix")
$sPublished_scope = $oJson.StringOf("products[i].published_scope")
$sTags = $oJson.StringOf("products[i].tags")
$imageId = $oJson.IntOf("products[i].image.id")
$imageProduct_id = $oJson.IntOf("products[i].image.product_id")
$imagePosition = $oJson.IntOf("products[i].image.position")
$sImageCreated_at = $oJson.StringOf("products[i].image.created_at")
$sImageUpdated_at = $oJson.StringOf("products[i].image.updated_at")
$imageWidth = $oJson.IntOf("products[i].image.width")
$imageHeight = $oJson.IntOf("products[i].image.height")
$sImageSrc = $oJson.StringOf("products[i].image.src")
$bImage = $oJson.IsNullOf("products[i].image")
$iJ = 0
$iCount_j = $oJson.SizeOfArray("products[i].variants")
While $iJ < $iCount_j
$oJson.J = $iJ
$id = $oJson.IntOf("products[i].variants[j].id")
$iProduct_id = $oJson.IntOf("products[i].variants[j].product_id")
$sTitle = $oJson.StringOf("products[i].variants[j].title")
$sPrice = $oJson.StringOf("products[i].variants[j].price")
$sku = $oJson.StringOf("products[i].variants[j].sku")
$iPosition = $oJson.IntOf("products[i].variants[j].position")
$iGrams = $oJson.IntOf("products[i].variants[j].grams")
$sInventory_policy = $oJson.StringOf("products[i].variants[j].inventory_policy")
$bCompare_at_price = $oJson.IsNullOf("products[i].variants[j].compare_at_price")
$sFulfillment_service = $oJson.StringOf("products[i].variants[j].fulfillment_service")
$sInventory_management = $oJson.StringOf("products[i].variants[j].inventory_management")
$sOption1 = $oJson.StringOf("products[i].variants[j].option1")
$bOption2 = $oJson.IsNullOf("products[i].variants[j].option2")
$bOption3 = $oJson.IsNullOf("products[i].variants[j].option3")
$sCreated_at = $oJson.StringOf("products[i].variants[j].created_at")
$sUpdated_at = $oJson.StringOf("products[i].variants[j].updated_at")
$bTaxable = $oJson.BoolOf("products[i].variants[j].taxable")
$sBarcode = $oJson.StringOf("products[i].variants[j].barcode")
$image_id = $oJson.IntOf("products[i].variants[j].image_id")
$inventory_quantity = $oJson.IntOf("products[i].variants[j].inventory_quantity")
$iWeight = $oJson.IntOf("products[i].variants[j].weight")
$sWeight_unit = $oJson.StringOf("products[i].variants[j].weight_unit")
$iOld_inventory_quantity = $oJson.IntOf("products[i].variants[j].old_inventory_quantity")
$bRequires_shipping = $oJson.BoolOf("products[i].variants[j].requires_shipping")
$iJ = $iJ + 1
Wend
$iJ = 0
$iCount_j = $oJson.SizeOfArray("products[i].options")
While $iJ < $iCount_j
$oJson.J = $iJ
$id = $oJson.IntOf("products[i].options[j].id")
$iProduct_id = $oJson.IntOf("products[i].options[j].product_id")
$sName = $oJson.StringOf("products[i].options[j].name")
$iPosition = $oJson.IntOf("products[i].options[j].position")
$iK = 0
$iCount_k = $oJson.SizeOfArray("products[i].options[j].values")
While $iK < $iCount_k
$oJson.K = $iK
$strVal = $oJson.StringOf("products[i].options[j].values[k]")
$iK = $iK + 1
Wend
$iJ = $iJ + 1
Wend
$iJ = 0
$iCount_j = $oJson.SizeOfArray("products[i].images")
While $iJ < $iCount_j
$oJson.J = $iJ
$id = $oJson.IntOf("products[i].images[j].id")
$iProduct_id = $oJson.IntOf("products[i].images[j].product_id")
$iPosition = $oJson.IntOf("products[i].images[j].position")
$sCreated_at = $oJson.StringOf("products[i].images[j].created_at")
$sUpdated_at = $oJson.StringOf("products[i].images[j].updated_at")
$iWidth = $oJson.IntOf("products[i].images[j].width")
$iHeight = $oJson.IntOf("products[i].images[j].height")
$src = $oJson.StringOf("products[i].images[j].src")
$iK = 0
$iCount_k = $oJson.SizeOfArray("products[i].images[j].variant_ids")
While $iK < $iCount_k
$oJson.K = $iK
$intVal = $oJson.IntOf("products[i].images[j].variant_ids[k]")
$iK = $iK + 1
Wend
$iJ = $iJ + 1
Wend
$iJ = 0
$iCount_j = $oJson.SizeOfArray("products[i].image.variant_ids")
While $iJ < $iCount_j
$oJson.J = $iJ
$iJ = $iJ + 1
Wend
$i = $i + 1
Wend
; A sample JSON response body that is parsed by the above code:
; {
; "products": [
; {
; "id": 632910392,
; "title": "IPod Nano - 8GB",
; "body_html": "<p>It's the small iPod with one very big idea: Video. Now the world's most popular music player, available in 4GB and 8GB models, lets you enjoy TV shows, movies, video podcasts, and more. The larger, brighter display means amazing picture quality. In six eye-catching colors, iPod nano is stunning all around. And with models starting at just $149, little speaks volumes.<\/p>",
; "vendor": "Apple",
; "product_type": "Cult Products",
; "created_at": "2017-09-22T14:08:02-04:00",
; "handle": "ipod-nano",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "published_at": "2007-12-31T19:00:00-05:00",
; "template_suffix": null,
; "published_scope": "web",
; "tags": "Emotive, Flash Memory, MP3, Music",
; "variants": [
; {
; "id": 808950810,
; "product_id": 632910392,
; "title": "Pink",
; "price": "199.00",
; "sku": "IPOD2008PINK",
; "position": 1,
; "grams": 567,
; "inventory_policy": "continue",
; "compare_at_price": null,
; "fulfillment_service": "manual",
; "inventory_management": "shopify",
; "option1": "Pink",
; "option2": null,
; "option3": null,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "taxable": true,
; "barcode": "1234_pink",
; "image_id": 562641783,
; "inventory_quantity": 10,
; "weight": 1.25,
; "weight_unit": "lb",
; "old_inventory_quantity": 10,
; "requires_shipping": true
; },
; {
; "id": 49148385,
; "product_id": 632910392,
; "title": "Red",
; "price": "199.00",
; "sku": "IPOD2008RED",
; "position": 2,
; "grams": 567,
; "inventory_policy": "continue",
; "compare_at_price": null,
; "fulfillment_service": "manual",
; "inventory_management": "shopify",
; "option1": "Red",
; "option2": null,
; "option3": null,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "taxable": true,
; "barcode": "1234_red",
; "image_id": null,
; "inventory_quantity": 20,
; "weight": 1.25,
; "weight_unit": "lb",
; "old_inventory_quantity": 20,
; "requires_shipping": true
; },
; {
; "id": 39072856,
; "product_id": 632910392,
; "title": "Green",
; "price": "199.00",
; "sku": "IPOD2008GREEN",
; "position": 3,
; "grams": 567,
; "inventory_policy": "continue",
; "compare_at_price": null,
; "fulfillment_service": "manual",
; "inventory_management": "shopify",
; "option1": "Green",
; "option2": null,
; "option3": null,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "taxable": true,
; "barcode": "1234_green",
; "image_id": null,
; "inventory_quantity": 30,
; "weight": 1.25,
; "weight_unit": "lb",
; "old_inventory_quantity": 30,
; "requires_shipping": true
; },
; {
; "id": 457924702,
; "product_id": 632910392,
; "title": "Black",
; "price": "199.00",
; "sku": "IPOD2008BLACK",
; "position": 4,
; "grams": 567,
; "inventory_policy": "continue",
; "compare_at_price": null,
; "fulfillment_service": "manual",
; "inventory_management": "shopify",
; "option1": "Black",
; "option2": null,
; "option3": null,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "taxable": true,
; "barcode": "1234_black",
; "image_id": null,
; "inventory_quantity": 40,
; "weight": 1.25,
; "weight_unit": "lb",
; "old_inventory_quantity": 40,
; "requires_shipping": true
; }
; ],
; "options": [
; {
; "id": 594680422,
; "product_id": 632910392,
; "name": "Color",
; "position": 1,
; "values": [
; "Pink",
; "Red",
; "Green",
; "Black"
; ]
; }
; ],
; "images": [
; {
; "id": 850703190,
; "product_id": 632910392,
; "position": 1,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "width": 123,
; "height": 456,
; "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano.png?v=1506103682",
; "variant_ids": [
; ]
; },
; {
; "id": 562641783,
; "product_id": 632910392,
; "position": 2,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "width": 123,
; "height": 456,
; "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano-2.png?v=1506103682",
; "variant_ids": [
; 808950810
; ]
; }
; ],
; "image": {
; "id": 850703190,
; "product_id": 632910392,
; "position": 1,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "width": 123,
; "height": 456,
; "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano.png?v=1506103682",
; "variant_ids": [
; ]
; }
; },
; {
; "id": 921728736,
; "title": "IPod Touch 8GB",
; "body_html": "<p>The iPod Touch has the iPhone's multi-touch interface, with a physical home button off the touch screen. The home screen has a list of buttons for the available applications.<\/p>",
; "vendor": "Apple",
; "product_type": "Cult Products",
; "created_at": "2017-09-22T14:08:02-04:00",
; "handle": "ipod-touch",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "published_at": "2008-09-25T20:00:00-04:00",
; "template_suffix": null,
; "published_scope": "global",
; "tags": "",
; "variants": [
; {
; "id": 447654529,
; "product_id": 921728736,
; "title": "Black",
; "price": "199.00",
; "sku": "IPOD2009BLACK",
; "position": 1,
; "grams": 567,
; "inventory_policy": "continue",
; "compare_at_price": null,
; "fulfillment_service": "manual",
; "inventory_management": "shopify",
; "option1": "Black",
; "option2": null,
; "option3": null,
; "created_at": "2017-09-22T14:08:02-04:00",
; "updated_at": "2017-09-22T14:08:02-04:00",
; "taxable": true,
; "barcode": "1234_black",
; "image_id": null,
; "inventory_quantity": 13,
; "weight": 1.25,
; "weight_unit": "lb",
; "old_inventory_quantity": 13,
; "requires_shipping": true
; }
; ],
; "options": [
; {
; "id": 891236591,
; "product_id": 921728736,
; "name": "Title",
; "position": 1,
; "values": [
; "Black"
; ]
; }
; ],
; "images": [
; ],
; "image": null
; }
; ]
; }
ConsoleWrite("Example Completed." & @CRLF)