|
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) Square API - Batch Upsert Catalog ObjectsCreates or updates up to 10,000 target objects based on the provided list of objects. The target objects are grouped into batches and each batch is inserted/updated in an all-or-nothing manner. For more information, see https://developer.squareup.com/reference/square/catalog-api/batch-upsert-catalog-objects
LOCAL loHttp LOCAL lnSuccess LOCAL i LOCAL j LOCAL k LOCAL loJson LOCAL loResp LOCAL loSbResponseBody LOCAL loJResp LOCAL lnRespStatusCode LOCAL lcV_type LOCAL lcId LOCAL lcUpdated_at LOCAL lnVersion LOCAL lnIs_deleted LOCAL lnPresent_at_all_locations LOCAL lcItem_dataName LOCAL lcItem_dataDescription LOCAL lcItem_dataCategory_id LOCAL lcCategory_dataName LOCAL lcTax_dataName LOCAL lcTax_dataCalculation_phase LOCAL lcTax_dataInclusion_type LOCAL lcTax_dataPercentage LOCAL lnTax_dataApplies_to_custom_amounts LOCAL lnTax_dataEnabled LOCAL lnCount_j LOCAL lcStrVal LOCAL lcItem_variation_dataItem_id LOCAL lcItem_variation_dataName LOCAL lnItem_variation_dataOrdinal LOCAL lcItem_variation_dataPricing_type LOCAL lnItem_variation_dataPrice_moneyAmount LOCAL lcItem_variation_dataPrice_moneyCurrency LOCAL lcClient_object_id LOCAL lcObject_id LOCAL lnCount_i * This example assumes the Chilkat API to have been previously unlocked. * See Global Unlock Sample for sample code. * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http') loHttp = CreateObject('Chilkat.Http') * Use this online tool to generate code from sample JSON: * Generate Code to Create JSON * The following JSON is sent in the request body. * { * "idempotency_key": "789ff020-f723-43a9-b4b5-43b5dc1fa3dc", * "batches": [ * { * "objects": [ * { * "type": "ITEM", * "id": "#Tea", * "present_at_all_locations": true, * "item_data": { * "name": "Tea", * "description": "Hot Leaf Juice", * "category_id": "#Beverages", * "tax_ids": [ * "#SalesTax" * ], * "variations": [ * { * "type": "ITEM_VARIATION", * "id": "#Tea_Mug", * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "#Tea", * "name": "Mug", * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 150, * "currency": "USD" * } * } * } * ] * } * }, * { * "type": "ITEM", * "id": "#Coffee", * "present_at_all_locations": true, * "item_data": { * "name": "Coffee", * "description": "Hot Bean Juice", * "category_id": "#Beverages", * "tax_ids": [ * "#SalesTax" * ], * "variations": [ * { * "type": "ITEM_VARIATION", * "id": "#Coffee_Regular", * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "#Coffee", * "name": "Regular", * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 250, * "currency": "USD" * } * } * }, * { * "type": "ITEM_VARIATION", * "id": "#Coffee_Large", * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "#Coffee", * "name": "Large", * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 350, * "currency": "USD" * } * } * } * ] * } * }, * { * "type": "CATEGORY", * "id": "#Beverages", * "present_at_all_locations": true, * "category_data": { * "name": "Beverages" * } * }, * { * "type": "TAX", * "id": "#SalesTax", * "present_at_all_locations": true, * "tax_data": { * "name": "Sales Tax", * "calculation_phase": "TAX_SUBTOTAL_PHASE", * "inclusion_type": "ADDITIVE", * "percentage": "5.0", * "applies_to_custom_amounts": true, * "enabled": true * } * } * ] * } * ] * } * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJson = CreateObject('Chilkat.JsonObject') loJson.UpdateString("idempotency_key","789ff020-f723-43a9-b4b5-43b5dc1fa3dc") i = 0 loJson.I = i j = 0 loJson.J = j loJson.UpdateString("batches[i].objects[j].type","ITEM") loJson.UpdateString("batches[i].objects[j].id","#Tea") loJson.UpdateBool("batches[i].objects[j].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].item_data.name","Tea") loJson.UpdateString("batches[i].objects[j].item_data.description","Hot Leaf Juice") loJson.UpdateString("batches[i].objects[j].item_data.category_id","#Beverages") loJson.UpdateString("batches[i].objects[j].item_data.tax_ids[0]","#SalesTax") loJson.UpdateString("batches[i].objects[j].item_data.variations[0].type","ITEM_VARIATION") loJson.UpdateString("batches[i].objects[j].item_data.variations[0].id","#Tea_Mug") loJson.UpdateBool("batches[i].objects[j].item_data.variations[0].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].item_data.variations[0].item_variation_data.item_id","#Tea") loJson.UpdateString("batches[i].objects[j].item_data.variations[0].item_variation_data.name","Mug") loJson.UpdateString("batches[i].objects[j].item_data.variations[0].item_variation_data.pricing_type","FIXED_PRICING") loJson.UpdateInt("batches[i].objects[j].item_data.variations[0].item_variation_data.price_money.amount",150) loJson.UpdateString("batches[i].objects[j].item_data.variations[0].item_variation_data.price_money.currency","USD") j = j + 1 loJson.J = j loJson.UpdateString("batches[i].objects[j].type","ITEM") loJson.UpdateString("batches[i].objects[j].id","#Coffee") loJson.UpdateBool("batches[i].objects[j].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].item_data.name","Coffee") loJson.UpdateString("batches[i].objects[j].item_data.description","Hot Bean Juice") loJson.UpdateString("batches[i].objects[j].item_data.category_id","#Beverages") loJson.UpdateString("batches[i].objects[j].item_data.tax_ids[0]","#SalesTax") k = 0 loJson.K = k loJson.UpdateString("batches[i].objects[j].item_data.variations[k].type","ITEM_VARIATION") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].id","#Coffee_Regular") loJson.UpdateBool("batches[i].objects[j].item_data.variations[k].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.item_id","#Coffee") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.name","Regular") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.pricing_type","FIXED_PRICING") loJson.UpdateInt("batches[i].objects[j].item_data.variations[k].item_variation_data.price_money.amount",250) loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.price_money.currency","USD") k = k + 1 loJson.K = k loJson.UpdateString("batches[i].objects[j].item_data.variations[k].type","ITEM_VARIATION") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].id","#Coffee_Large") loJson.UpdateBool("batches[i].objects[j].item_data.variations[k].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.item_id","#Coffee") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.name","Large") loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.pricing_type","FIXED_PRICING") loJson.UpdateInt("batches[i].objects[j].item_data.variations[k].item_variation_data.price_money.amount",350) loJson.UpdateString("batches[i].objects[j].item_data.variations[k].item_variation_data.price_money.currency","USD") j = j + 1 loJson.J = j loJson.UpdateString("batches[i].objects[j].type","CATEGORY") loJson.UpdateString("batches[i].objects[j].id","#Beverages") loJson.UpdateBool("batches[i].objects[j].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].category_data.name","Beverages") j = j + 1 loJson.J = j loJson.UpdateString("batches[i].objects[j].type","TAX") loJson.UpdateString("batches[i].objects[j].id","#SalesTax") loJson.UpdateBool("batches[i].objects[j].present_at_all_locations",1) loJson.UpdateString("batches[i].objects[j].tax_data.name","Sales Tax") loJson.UpdateString("batches[i].objects[j].tax_data.calculation_phase","TAX_SUBTOTAL_PHASE") loJson.UpdateString("batches[i].objects[j].tax_data.inclusion_type","ADDITIVE") loJson.UpdateString("batches[i].objects[j].tax_data.percentage","5.0") loJson.UpdateBool("batches[i].objects[j].tax_data.applies_to_custom_amounts",1) loJson.UpdateBool("batches[i].objects[j].tax_data.enabled",1) * Adds the "Authorization: Bearer ACCESS_TOKEN" header. loHttp.AuthToken = "ACCESS_TOKEN" loHttp.SetRequestHeader("Square-Version","2020-07-22") loHttp.SetRequestHeader("Content-Type","application/json") * This example uses the sandbox: connect.squareupsandbox.com * Production should use connect.squareup.com loResp = loHttp.PostJson3("https://connect.squareupsandbox.com/v2/catalog/batch-upsert","application/json",loJson) IF (loHttp.LastMethodSuccess = 0) THEN ? loHttp.LastErrorText RELEASE loHttp RELEASE loJson CANCEL ENDIF * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder') loSbResponseBody = CreateObject('Chilkat.StringBuilder') loResp.GetBodySb(loSbResponseBody) * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJResp = CreateObject('Chilkat.JsonObject') loJResp.LoadSb(loSbResponseBody) loJResp.EmitCompact = 0 ? "Response Body:" ? loJResp.Emit() lnRespStatusCode = loResp.StatusCode ? "Response Status Code = " + STR(lnRespStatusCode) IF (lnRespStatusCode >= 400) THEN ? "Response Header:" ? loResp.Header ? "Failed." RELEASE loResp RELEASE loHttp RELEASE loJson RELEASE loSbResponseBody RELEASE loJResp CANCEL ENDIF RELEASE loResp * Sample JSON response: * (Sample code for parsing the JSON response is shown below) * { * "objects": [ * { * "type": "ITEM", * "id": "ZSDZN34NAXDLC6D5ZQMNSOUM", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "item_data": { * "name": "Tea", * "description": "Hot Leaf Juice", * "category_id": "LYT72K3WGJFFCIMB63XARP3I", * "tax_ids": [ * "XHSHLHNWSI3HVI4BW5ZUZXI3" * ], * "variations": [ * { * "type": "ITEM_VARIATION", * "id": "NAYHET5R52MIYCEF34ZMAHFM", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "ZSDZN34NAXDLC6D5ZQMNSOUM", * "name": "Mug", * "ordinal": 0, * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 150, * "currency": "USD" * } * } * } * ] * } * }, * { * "type": "ITEM", * "id": "PJMCEBHHUS3OKDB6PYUHLCPP", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "item_data": { * "name": "Coffee", * "description": "Hot Bean Juice", * "category_id": "LYT72K3WGJFFCIMB63XARP3I", * "tax_ids": [ * "XHSHLHNWSI3HVI4BW5ZUZXI3" * ], * "variations": [ * { * "type": "ITEM_VARIATION", * "id": "OTYDX45SPG7LJQUVCBZI4INH", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "PJMCEBHHUS3OKDB6PYUHLCPP", * "name": "Regular", * "ordinal": 0, * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 250, * "currency": "USD" * } * } * }, * { * "type": "ITEM_VARIATION", * "id": "GZDA3JB37FYVOPI4AOEBOITI", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "item_variation_data": { * "item_id": "PJMCEBHHUS3OKDB6PYUHLCPP", * "name": "Large", * "ordinal": 1, * "pricing_type": "FIXED_PRICING", * "price_money": { * "amount": 350, * "currency": "USD" * } * } * } * ] * } * }, * { * "type": "CATEGORY", * "id": "LYT72K3WGJFFCIMB63XARP3I", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "category_data": { * "name": "Beverages" * } * }, * { * "type": "TAX", * "id": "XHSHLHNWSI3HVI4BW5ZUZXI3", * "updated_at": "2017-05-10T18:48:39.798Z", * "version": 1494442119798, * "is_deleted": false, * "present_at_all_locations": true, * "tax_data": { * "name": "Sales Tax", * "calculation_phase": "TAX_SUBTOTAL_PHASE", * "inclusion_type": "ADDITIVE", * "percentage": "5.0", * "applies_to_custom_amounts": true, * "enabled": true * } * } * ], * "id_mappings": [ * { * "client_object_id": "#Tea", * "object_id": "ZSDZN34NAXDLC6D5ZQMNSOUM" * }, * { * "client_object_id": "#Coffee", * "object_id": "PJMCEBHHUS3OKDB6PYUHLCPP" * }, * { * "client_object_id": "#Beverages", * "object_id": "LYT72K3WGJFFCIMB63XARP3I" * }, * { * "client_object_id": "#SalesTax", * "object_id": "XHSHLHNWSI3HVI4BW5ZUZXI3" * }, * { * "client_object_id": "#Tea_Mug", * "object_id": "NAYHET5R52MIYCEF34ZMAHFM" * }, * { * "client_object_id": "#Coffee_Regular", * "object_id": "OTYDX45SPG7LJQUVCBZI4INH" * }, * { * "client_object_id": "#Coffee_Large", * "object_id": "GZDA3JB37FYVOPI4AOEBOITI" * } * ] * } * 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 lnCount_i = loJResp.SizeOfArray("objects") DO WHILE i < lnCount_i loJResp.I = i lcV_type = loJResp.StringOf("objects[i].type") lcId = loJResp.StringOf("objects[i].id") lcUpdated_at = loJResp.StringOf("objects[i].updated_at") lnVersion = loJResp.IntOf("objects[i].version") lnIs_deleted = loJResp.BoolOf("objects[i].is_deleted") lnPresent_at_all_locations = loJResp.BoolOf("objects[i].present_at_all_locations") lcItem_dataName = loJResp.StringOf("objects[i].item_data.name") lcItem_dataDescription = loJResp.StringOf("objects[i].item_data.description") lcItem_dataCategory_id = loJResp.StringOf("objects[i].item_data.category_id") lcCategory_dataName = loJResp.StringOf("objects[i].category_data.name") lcTax_dataName = loJResp.StringOf("objects[i].tax_data.name") lcTax_dataCalculation_phase = loJResp.StringOf("objects[i].tax_data.calculation_phase") lcTax_dataInclusion_type = loJResp.StringOf("objects[i].tax_data.inclusion_type") lcTax_dataPercentage = loJResp.StringOf("objects[i].tax_data.percentage") lnTax_dataApplies_to_custom_amounts = loJResp.BoolOf("objects[i].tax_data.applies_to_custom_amounts") lnTax_dataEnabled = loJResp.BoolOf("objects[i].tax_data.enabled") j = 0 lnCount_j = loJResp.SizeOfArray("objects[i].item_data.tax_ids") DO WHILE j < lnCount_j loJResp.J = j lcStrVal = loJResp.StringOf("objects[i].item_data.tax_ids[j]") j = j + 1 ENDDO j = 0 lnCount_j = loJResp.SizeOfArray("objects[i].item_data.variations") DO WHILE j < lnCount_j loJResp.J = j lcV_type = loJResp.StringOf("objects[i].item_data.variations[j].type") lcId = loJResp.StringOf("objects[i].item_data.variations[j].id") lcUpdated_at = loJResp.StringOf("objects[i].item_data.variations[j].updated_at") lnVersion = loJResp.IntOf("objects[i].item_data.variations[j].version") lnIs_deleted = loJResp.BoolOf("objects[i].item_data.variations[j].is_deleted") lnPresent_at_all_locations = loJResp.BoolOf("objects[i].item_data.variations[j].present_at_all_locations") lcItem_variation_dataItem_id = loJResp.StringOf("objects[i].item_data.variations[j].item_variation_data.item_id") lcItem_variation_dataName = loJResp.StringOf("objects[i].item_data.variations[j].item_variation_data.name") lnItem_variation_dataOrdinal = loJResp.IntOf("objects[i].item_data.variations[j].item_variation_data.ordinal") lcItem_variation_dataPricing_type = loJResp.StringOf("objects[i].item_data.variations[j].item_variation_data.pricing_type") lnItem_variation_dataPrice_moneyAmount = loJResp.IntOf("objects[i].item_data.variations[j].item_variation_data.price_money.amount") lcItem_variation_dataPrice_moneyCurrency = loJResp.StringOf("objects[i].item_data.variations[j].item_variation_data.price_money.currency") j = j + 1 ENDDO i = i + 1 ENDDO i = 0 lnCount_i = loJResp.SizeOfArray("id_mappings") DO WHILE i < lnCount_i loJResp.I = i lcClient_object_id = loJResp.StringOf("id_mappings[i].client_object_id") lcObject_id = loJResp.StringOf("id_mappings[i].object_id") i = i + 1 ENDDO RELEASE loHttp RELEASE loJson RELEASE loSbResponseBody RELEASE loJResp |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.