|
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
(AutoIt) Akeneo: Get List of Products (using StringBuilder)Using a previously obtained request token, demonstrates how to get a list of products using a Chilkat StringBuilder. Using the StringBuilder is convenient because it prevents returning a potentially large string. Instead, the result is deposited into the StringBuilder object.
; This example requires the Chilkat API to have been previously unlocked. ; See Global Unlock Sample for sample code. $oHttp = ObjCreate("Chilkat.Http") ; Use your previously obtained access token. ; See Get Akeneo Access Token $oHttp.AuthToken = "access_token" $oSbJson = ObjCreate("Chilkat.StringBuilder") Local $bSuccess = $oHttp.QuickGetSb("http://pim.my-akeneo-site.com/api/rest/v1/products",$oSbJson) If ($bSuccess <> True) Then ConsoleWrite($oHttp.LastHeader & @CRLF) ConsoleWrite($oHttp.LastErrorText & @CRLF) Exit EndIf ; A sample response looks like this. ; See below for sample code to parse the JSON response.. ; { ; "_links": { ; "self": { ; "href": "https://demo.akeneo.com/api/rest/v1/products?page=3&limit=3" ; }, ; "first": { ; "href": "https://demo.akeneo.com/api/rest/v1/products?page=1&limit=3" ; }, ; "previous": { ; "href": "https://demo.akeneo.com/api/rest/v1/products?page=2&limit=3" ; }, ; "next": { ; "href": "https://demo.akeneo.com/api/rest/v1/products?page=4&limit=3" ; } ; }, ; "current_page": 3, ; "_embedded": { ; "_items": [ ; { ; "_links": { ; "self": { ; "href": "https://demo.akeneo.com/api/rest/v1/product/top" ; } ; }, ; "identifier": "top", ; "family": "tshirt", ; "groups": [], ; "parent": null, ; "categories": [ ; "summer_collection" ; ], ; "enabled": true, ; "values": { ; "name": [ ; { ; "data": "Top", ; "locale": "en_US", ; "scope": null ; }, ; { ; "data": "D�bardeur", ; "locale": "fr_FR", ; "scope": null ; } ; ], ; "description": [ ; { ; "data": "Summer top", ; "locale": "en_US", ; "scope": "ecommerce" ; }, ; { ; "data": "Top", ; "locale": "en_US", ; "scope": "tablet" ; }, ; { ; "data": "D�bardeur pour l'�t�", ; "locale": "fr_FR", ; "scope": "ecommerce" ; }, ; { ; "data": "D�bardeur", ; "locale": "fr_FR", ; "scope": "tablet" ; } ; ], ; "price": [ ; { ; "locale": null, ; "scope": null, ; "data": [ ; { ; "amount": "15.5", ; "currency": "EUR" ; }, ; { ; "amount": "15", ; "currency": "USD" ; } ; ] ; } ; ], ; "color": [ ; { ; "locale": null, ; "scope": null, ; "data": "black" ; } ; ], ; "size": [ ; { ; "locale": null, ; "scope": null, ; "data": "m" ; } ; ] ; }, ; "created": "2016-06-23T18:24:44+02:00", ; "updated": "2016-06-25T17:56:12+02:00", ; "associations": { ; "PACK": { ; "products": [ ; "sunglasses" ; ], ; "groups": [] ; } ; } ; }, ; { ; "_links": { ; "self": { ; "href": "https://demo.akeneo.com/api/rest/v1/product/cap" ; } ; }, ; "identifier": "cap", ; "family": "caps", ; "groups": [], ; "parent": null, ; "categories": [ ; "summer_collection" ; ], ; "enabled": true, ; "values": { ; "name": [ ; { ; "data": "Cap", ; "locale": "en_US", ; "scope": null ; }, ; { ; "data": "Casquette", ; "locale": "fr_FR", ; "scope": null ; } ; ], ; "description": [ ; { ; "data": "Cap unisex", ; "locale": "en_US", ; "scope": "ecommerce" ; }, ; { ; "data": "Cap unisex", ; "locale": "en_US", ; "scope": "tablet" ; }, ; { ; "data": "Casquette unisexe", ; "locale": "fr_FR", ; "scope": "ecommerce" ; }, ; { ; "data": "Casquette unisexe", ; "locale": "fr_FR", ; "scope": "tablet" ; } ; ], ; "price": [ ; { ; "locale": null, ; "scope": null, ; "data": [ ; { ; "amount": "20", ; "currency": "EUR" ; }, ; { ; "amount": "20", ; "currency": "USD" ; } ; ] ; } ; ], ; "color": [ ; { ; "locale": null, ; "scope": null, ; "data": "black" ; } ; ] ; }, ; "created": "2016-06-23T18:24:44+02:00", ; "updated": "2016-06-25T17:56:12+02:00", ; "associations": { ; "PACK": { ; "products": [ ; "sunglasses" ; ], ; "groups": [] ; } ; } ; }, ; { ; "_links": { ; "self": { ; "href": "https://demo.akeneo.com/api/rest/v1/product/sweat" ; } ; }, ; "identifier": "sweat", ; "family": null, ; "groups": [], ; "parent": null, ; "categories": [ ; "winter_collection" ; ], ; "enabled": true, ; "values": {}, ; "created": "2016-06-23T11:24:44+02:00", ; "updated": "2016-06-23T11:24:44+02:00", ; "associations": {} ; } ; ] ; } ; } ; $oJson = ObjCreate("Chilkat.JsonObject") $oJson.LoadSb($oSbJson) Local $sV_linksSelfHref Local $sV_linksFirstHref Local $iCurrent_page Local $i Local $iCount_i Local $sIdentifier Local $sFamily Local $sParent Local $bEnabled Local $sCreated Local $sUpdated Local $iJ Local $iCount_j Local $strVal Local $sLocale Local $scope Local $bData Local $sData_str Local $sV_linksDownloadHref Local $iData_int Local $sDataAmount Local $sDataUnit $sV_linksSelfHref = $oJson.StringOf("_links.self.href") $sV_linksFirstHref = $oJson.StringOf("_links.first.href") $iCurrent_page = $oJson.IntOf("current_page") $i = 0 $iCount_i = $oJson.SizeOfArray("_embedded.items") While $i < $iCount_i $oJson.I = $i $sV_linksSelfHref = $oJson.StringOf("_embedded.items[i]._links.self.href") $sIdentifier = $oJson.StringOf("_embedded.items[i].identifier") $sFamily = $oJson.StringOf("_embedded.items[i].family") $sParent = $oJson.StringOf("_embedded.items[i].parent") $bEnabled = $oJson.BoolOf("_embedded.items[i].enabled") $sCreated = $oJson.StringOf("_embedded.items[i].created") $sUpdated = $oJson.StringOf("_embedded.items[i].updated") $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].groups") While $iJ < $iCount_j $oJson.J = $iJ $strVal = $oJson.StringOf("_embedded.items[i].groups[j]") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].categories") While $iJ < $iCount_j $oJson.J = $iJ $strVal = $oJson.StringOf("_embedded.items[i].categories[j]") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.blocked") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.blocked[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.blocked[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.blocked[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.can_cut") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.can_cut[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.can_cut[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.can_cut[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.not_used") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.not_used[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.not_used[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.not_used[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.deny_delivery") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.deny_delivery[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.deny_delivery[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.deny_delivery[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.can_split_package") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.can_split_package[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.can_split_package[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.can_split_package[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.transfer_to_warehouse") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.transfer_to_warehouse[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.transfer_to_warehouse[j].scope") $bData = $oJson.BoolOf("_embedded.items[i].values.transfer_to_warehouse[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.product_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.product_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.product_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.product_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.nuotrauka") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.nuotrauka[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.nuotrauka[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.nuotrauka[j].data") $sV_linksDownloadHref = $oJson.StringOf("_embedded.items[i].values.nuotrauka[j]._links.download.href") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.minimum_quantity") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.minimum_quantity[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.minimum_quantity[j].scope") $iData_int = $oJson.IntOf("_embedded.items[i].values.minimum_quantity[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.code[j].scope") $iData_int = $oJson.IntOf("_embedded.items[i].values.code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.name") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.name[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.name[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.name[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.fsc_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.fsc_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.fsc_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.fsc_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.warehouse") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.warehouse[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.warehouse[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.warehouse[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.item_volume") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.item_volume[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.item_volume[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.item_volume[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.item_volume[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.customs_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.customs_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.customs_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.customs_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.product_type") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.product_type[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.product_type[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.product_type[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.weight_netto") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.weight_netto[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.weight_netto[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.weight_netto[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.weight_netto[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.supplier_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.supplier_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.supplier_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.supplier_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.tariff_number") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.tariff_number[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.tariff_number[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.tariff_number[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.weight_brutto") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.weight_brutto[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.weight_brutto[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.weight_brutto[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.weight_brutto[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_code_1") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_code_1[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_code_1[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.package_code_1[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_code_2") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_code_2[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_code_2[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.package_code_2[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_code_3") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_code_3[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_code_3[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.package_code_3[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.supplier_number") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.supplier_number[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.supplier_number[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.supplier_number[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_volume_1") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_volume_1[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_volume_1[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_volume_1[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_volume_1[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_volume_2") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_volume_2[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_volume_2[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_volume_2[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_volume_2[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_volume_3") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_volume_3[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_volume_3[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_volume_3[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_volume_3[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_weight_1") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_weight_1[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_weight_1[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_weight_1[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_weight_1[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_weight_2") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_weight_2[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_weight_2[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_weight_2[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_weight_2[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.package_weight_3") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.package_weight_3[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.package_weight_3[j].scope") $sDataAmount = $oJson.StringOf("_embedded.items[i].values.package_weight_3[j].data.amount") $sDataUnit = $oJson.StringOf("_embedded.items[i].values.package_weight_3[j].data.unit") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.country_of_origin") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.country_of_origin[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.country_of_origin[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.country_of_origin[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.product_group_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.product_group_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.product_group_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.product_group_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.base_measurement_unit") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.measurement_unit_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.measurement_unit_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.measurement_unit_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.measurement_unit_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.product_category_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.product_category_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.product_category_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.product_category_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.sale_measurement_unit") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.sale_measurement_unit[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.sale_measurement_unit[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.sale_measurement_unit[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.country_of_origin_code") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.country_of_origin_code[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.country_of_origin_code[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.country_of_origin_code[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.vat_registration_group") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.vat_registration_group[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.vat_registration_group[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.vat_registration_group[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.critical_amount_of_stock") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.critical_amount_of_stock[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.critical_amount_of_stock[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.critical_amount_of_stock[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.stock_registration_group") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.stock_registration_group[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.stock_registration_group[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.stock_registration_group[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.purchase_measurement_unit") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.purchase_measurement_unit[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.purchase_measurement_unit[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.purchase_measurement_unit[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.product_registration_group") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.product_registration_group[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.product_registration_group[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.product_registration_group[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.base_measurement_unit_quantity") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit_quantity[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit_quantity[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.base_measurement_unit_quantity[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.comment") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.comment[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.comment[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.comment[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.units_in_pallet") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.units_in_pallet[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.units_in_pallet[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.units_in_pallet[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.first_description") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.first_description[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.first_description[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.first_description[j].data") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJson.SizeOfArray("_embedded.items[i].values.second_description") While $iJ < $iCount_j $oJson.J = $iJ $sLocale = $oJson.StringOf("_embedded.items[i].values.second_description[j].locale") $scope = $oJson.StringOf("_embedded.items[i].values.second_description[j].scope") $sData_str = $oJson.StringOf("_embedded.items[i].values.second_description[j].data") $iJ = $iJ + 1 Wend $i = $i + 1 Wend ConsoleWrite("Success." & @CRLF) |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.