|
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
(Visual FoxPro) Shopify Add a metafield to an existing productAdd a metafield to an existing product
LOCAL loRest LOCAL lnSuccess LOCAL loJsonReq LOCAL loSbReq LOCAL loSbJson LOCAL loJson LOCAL lnProductId LOCAL lcProductTitle LOCAL lcProductBody_html LOCAL lcProductVendor LOCAL lcProductProduct_type LOCAL lcProductCreated_at LOCAL lcProductHandle LOCAL lcProductUpdated_at LOCAL lcProductPublished_at LOCAL lnProductTemplate_suffix LOCAL lcProductPublished_scope LOCAL lcProductTags LOCAL lnProductImageId LOCAL lnProductImageProduct_id LOCAL lnProductImagePosition LOCAL lcProductImageCreated_at LOCAL lcProductImageUpdated_at LOCAL lnProductImageWidth LOCAL lnProductImageHeight LOCAL lcProductImageSrc LOCAL i LOCAL lnCount_i LOCAL lnId LOCAL lnProduct_id LOCAL lcTitle LOCAL lcPrice LOCAL lcSku LOCAL lnPosition LOCAL lnGrams LOCAL lcInventory_policy LOCAL lnCompare_at_price LOCAL lcFulfillment_service LOCAL lcInventory_management LOCAL lcOption1 LOCAL lnOption2 LOCAL lnOption3 LOCAL lcCreated_at LOCAL lcUpdated_at LOCAL lnTaxable LOCAL lcBarcode LOCAL lnImage_id LOCAL lnInventory_quantity LOCAL lnWeight LOCAL lcWeight_unit LOCAL lnOld_inventory_quantity LOCAL lnRequires_shipping LOCAL lcName LOCAL j LOCAL lnCount_j LOCAL lcStrVal LOCAL lnWidth LOCAL lnHeight LOCAL lcSrc LOCAL lnIntVal * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Rest') loRest = CreateObject('Chilkat.Rest') loRest.SetAuthBasic("SHOPIFY_PRIVATE_API_KEY","SHOPIFY_PRIVATE_API_KEY") lnSuccess = loRest.Connect("chilkat.myshopify.com",443,1,1) IF (lnSuccess <> 1) THEN ? loRest.LastErrorText RELEASE loRest CANCEL ENDIF * The following code creates the JSON request body. * The JSON created by this code is shown below. * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJsonReq = CreateObject('Chilkat.JsonObject') loJsonReq.UpdateNumber("product.id","632910392") loJsonReq.UpdateString("product.metafields[0].key","new") loJsonReq.UpdateString("product.metafields[0].value","newvalue") loJsonReq.UpdateString("product.metafields[0].value_type","string") loJsonReq.UpdateString("product.metafields[0].namespace","global") * The JSON request body created by the above code: * { * "product": { * "id": 632910392, * "metafields": [ * { * "key": "new", * "value": "newvalue", * "value_type": "string", * "namespace": "global" * } * ] * } * } * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder') loSbReq = CreateObject('Chilkat.StringBuilder') loJsonReq.EmitSb(loSbReq) loRest.AddHeader("Content-Type","application/json") * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder') loSbJson = CreateObject('Chilkat.StringBuilder') lnSuccess = loRest.FullRequestSb("PUT","/admin/products/#{id}.json",loSbReq,loSbJson) IF (lnSuccess <> 1) THEN ? loRest.LastErrorText RELEASE loRest RELEASE loJsonReq RELEASE loSbReq RELEASE loSbJson CANCEL ENDIF IF (loRest.ResponseStatusCode <> 200) THEN ? "Received error response code: " + STR(loRest.ResponseStatusCode) ? "Response body:" ? loSbJson.GetAsString() RELEASE loRest RELEASE loJsonReq RELEASE loSbReq RELEASE loSbJson CANCEL ENDIF * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJson = CreateObject('Chilkat.JsonObject') loJson.LoadSb(loSbJson) * The following code parses the JSON response. * A sample JSON response is shown below the sample code. lnProductId = loJson.IntOf("product.id") lcProductTitle = loJson.StringOf("product.title") lcProductBody_html = loJson.StringOf("product.body_html") lcProductVendor = loJson.StringOf("product.vendor") lcProductProduct_type = loJson.StringOf("product.product_type") lcProductCreated_at = loJson.StringOf("product.created_at") lcProductHandle = loJson.StringOf("product.handle") lcProductUpdated_at = loJson.StringOf("product.updated_at") lcProductPublished_at = loJson.StringOf("product.published_at") lnProductTemplate_suffix = loJson.IsNullOf("product.template_suffix") lcProductPublished_scope = loJson.StringOf("product.published_scope") lcProductTags = loJson.StringOf("product.tags") lnProductImageId = loJson.IntOf("product.image.id") lnProductImageProduct_id = loJson.IntOf("product.image.product_id") lnProductImagePosition = loJson.IntOf("product.image.position") lcProductImageCreated_at = loJson.StringOf("product.image.created_at") lcProductImageUpdated_at = loJson.StringOf("product.image.updated_at") lnProductImageWidth = loJson.IntOf("product.image.width") lnProductImageHeight = loJson.IntOf("product.image.height") lcProductImageSrc = loJson.StringOf("product.image.src") i = 0 lnCount_i = loJson.SizeOfArray("product.variants") DO WHILE i < lnCount_i loJson.I = i lnId = loJson.IntOf("product.variants[i].id") lnProduct_id = loJson.IntOf("product.variants[i].product_id") lcTitle = loJson.StringOf("product.variants[i].title") lcPrice = loJson.StringOf("product.variants[i].price") lcSku = loJson.StringOf("product.variants[i].sku") lnPosition = loJson.IntOf("product.variants[i].position") lnGrams = loJson.IntOf("product.variants[i].grams") lcInventory_policy = loJson.StringOf("product.variants[i].inventory_policy") lnCompare_at_price = loJson.IsNullOf("product.variants[i].compare_at_price") lcFulfillment_service = loJson.StringOf("product.variants[i].fulfillment_service") lcInventory_management = loJson.StringOf("product.variants[i].inventory_management") lcOption1 = loJson.StringOf("product.variants[i].option1") lnOption2 = loJson.IsNullOf("product.variants[i].option2") lnOption3 = loJson.IsNullOf("product.variants[i].option3") lcCreated_at = loJson.StringOf("product.variants[i].created_at") lcUpdated_at = loJson.StringOf("product.variants[i].updated_at") lnTaxable = loJson.BoolOf("product.variants[i].taxable") lcBarcode = loJson.StringOf("product.variants[i].barcode") lnImage_id = loJson.IntOf("product.variants[i].image_id") lnInventory_quantity = loJson.IntOf("product.variants[i].inventory_quantity") lnWeight = loJson.IntOf("product.variants[i].weight") lcWeight_unit = loJson.StringOf("product.variants[i].weight_unit") lnOld_inventory_quantity = loJson.IntOf("product.variants[i].old_inventory_quantity") lnRequires_shipping = loJson.BoolOf("product.variants[i].requires_shipping") i = i + 1 ENDDO i = 0 lnCount_i = loJson.SizeOfArray("product.options") DO WHILE i < lnCount_i loJson.I = i lnId = loJson.IntOf("product.options[i].id") lnProduct_id = loJson.IntOf("product.options[i].product_id") lcName = loJson.StringOf("product.options[i].name") lnPosition = loJson.IntOf("product.options[i].position") j = 0 lnCount_j = loJson.SizeOfArray("product.options[i].values") DO WHILE j < lnCount_j loJson.J = j lcStrVal = loJson.StringOf("product.options[i].values[j]") j = j + 1 ENDDO i = i + 1 ENDDO i = 0 lnCount_i = loJson.SizeOfArray("product.images") DO WHILE i < lnCount_i loJson.I = i lnId = loJson.IntOf("product.images[i].id") lnProduct_id = loJson.IntOf("product.images[i].product_id") lnPosition = loJson.IntOf("product.images[i].position") lcCreated_at = loJson.StringOf("product.images[i].created_at") lcUpdated_at = loJson.StringOf("product.images[i].updated_at") lnWidth = loJson.IntOf("product.images[i].width") lnHeight = loJson.IntOf("product.images[i].height") lcSrc = loJson.StringOf("product.images[i].src") j = 0 lnCount_j = loJson.SizeOfArray("product.images[i].variant_ids") DO WHILE j < lnCount_j loJson.J = j lnIntVal = loJson.IntOf("product.images[i].variant_ids[j]") j = j + 1 ENDDO i = i + 1 ENDDO i = 0 lnCount_i = loJson.SizeOfArray("image.product.variant_ids") DO WHILE i < lnCount_i loJson.I = i i = i + 1 ENDDO * A sample JSON response body that is parsed by the above code: * { * "product": { * "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:48:57-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:48:57-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." RELEASE loRest RELEASE loJsonReq RELEASE loSbReq RELEASE loSbJson RELEASE loJson |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.