|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(PowerShell) Shopify Get all products that belong to a certain collectionGet all products that belong to a certain collection
Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll" $rest = New-Object Chilkat.Rest $rest.SetAuthBasic("SHOPIFY_PRIVATE_API_KEY","SHOPIFY_PRIVATE_API_KEY") $success = $rest.Connect("chilkat.myshopify.com",443,$true,$true) if ($success -ne $true) { $($rest.LastErrorText) exit } $sbJson = New-Object Chilkat.StringBuilder $success = $rest.FullRequestNoBodySb("GET","/admin/products.json?collection_id=841564295",$sbJson) if ($success -ne $true) { $($rest.LastErrorText) exit } if ($rest.ResponseStatusCode -ne 200) { $("Received error response code: " + $rest.ResponseStatusCode) $("Response body:") $($sbJson.GetAsString()) exit } $json = New-Object Chilkat.JsonObject $json.LoadSb($sbJson) # The following code parses the JSON response. # A sample JSON response is shown below the sample code. $i = 0 $count_i = $json.SizeOfArray("products") while ($i -lt $count_i) { $json.I = $i $id = $json.IntOf("products[i].id") $title = $json.StringOf("products[i].title") $body_html = $json.StringOf("products[i].body_html") $vendor = $json.StringOf("products[i].vendor") $product_type = $json.StringOf("products[i].product_type") $created_at = $json.StringOf("products[i].created_at") $handle = $json.StringOf("products[i].handle") $updated_at = $json.StringOf("products[i].updated_at") $published_at = $json.StringOf("products[i].published_at") $template_suffix = $json.IsNullOf("products[i].template_suffix") $published_scope = $json.StringOf("products[i].published_scope") $tags = $json.StringOf("products[i].tags") $imageId = $json.IntOf("products[i].image.id") $imageProduct_id = $json.IntOf("products[i].image.product_id") $imagePosition = $json.IntOf("products[i].image.position") $imageCreated_at = $json.StringOf("products[i].image.created_at") $imageUpdated_at = $json.StringOf("products[i].image.updated_at") $imageWidth = $json.IntOf("products[i].image.width") $imageHeight = $json.IntOf("products[i].image.height") $imageSrc = $json.StringOf("products[i].image.src") $j = 0 $count_j = $json.SizeOfArray("products[i].variants") while ($j -lt $count_j) { $json.J = $j $id = $json.IntOf("products[i].variants[j].id") $product_id = $json.IntOf("products[i].variants[j].product_id") $title = $json.StringOf("products[i].variants[j].title") $price = $json.StringOf("products[i].variants[j].price") $sku = $json.StringOf("products[i].variants[j].sku") $position = $json.IntOf("products[i].variants[j].position") $grams = $json.IntOf("products[i].variants[j].grams") $inventory_policy = $json.StringOf("products[i].variants[j].inventory_policy") $compare_at_price = $json.IsNullOf("products[i].variants[j].compare_at_price") $fulfillment_service = $json.StringOf("products[i].variants[j].fulfillment_service") $inventory_management = $json.StringOf("products[i].variants[j].inventory_management") $option1 = $json.StringOf("products[i].variants[j].option1") $option2 = $json.IsNullOf("products[i].variants[j].option2") $option3 = $json.IsNullOf("products[i].variants[j].option3") $created_at = $json.StringOf("products[i].variants[j].created_at") $updated_at = $json.StringOf("products[i].variants[j].updated_at") $taxable = $json.BoolOf("products[i].variants[j].taxable") $barcode = $json.StringOf("products[i].variants[j].barcode") $image_id = $json.IntOf("products[i].variants[j].image_id") $inventory_quantity = $json.IntOf("products[i].variants[j].inventory_quantity") $weight = $json.IntOf("products[i].variants[j].weight") $weight_unit = $json.StringOf("products[i].variants[j].weight_unit") $old_inventory_quantity = $json.IntOf("products[i].variants[j].old_inventory_quantity") $requires_shipping = $json.BoolOf("products[i].variants[j].requires_shipping") $j = $j + 1 } $j = 0 $count_j = $json.SizeOfArray("products[i].options") while ($j -lt $count_j) { $json.J = $j $id = $json.IntOf("products[i].options[j].id") $product_id = $json.IntOf("products[i].options[j].product_id") $name = $json.StringOf("products[i].options[j].name") $position = $json.IntOf("products[i].options[j].position") $k = 0 $count_k = $json.SizeOfArray("products[i].options[j].values") while ($k -lt $count_k) { $json.K = $k $strVal = $json.StringOf("products[i].options[j].values[k]") $k = $k + 1 } $j = $j + 1 } $j = 0 $count_j = $json.SizeOfArray("products[i].images") while ($j -lt $count_j) { $json.J = $j $id = $json.IntOf("products[i].images[j].id") $product_id = $json.IntOf("products[i].images[j].product_id") $position = $json.IntOf("products[i].images[j].position") $created_at = $json.StringOf("products[i].images[j].created_at") $updated_at = $json.StringOf("products[i].images[j].updated_at") $width = $json.IntOf("products[i].images[j].width") $height = $json.IntOf("products[i].images[j].height") $src = $json.StringOf("products[i].images[j].src") $k = 0 $count_k = $json.SizeOfArray("products[i].images[j].variant_ids") while ($k -lt $count_k) { $json.K = $k $intVal = $json.IntOf("products[i].images[j].variant_ids[k]") $k = $k + 1 } $j = $j + 1 } $j = 0 $count_j = $json.SizeOfArray("products[i].image.variant_ids") while ($j -lt $count_j) { $json.J = $j $j = $j + 1 } $i = $i + 1 } # 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": [ # ] # } # } # ] # } $("Example Completed.") |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.