AutoIt
AutoIt
Akeneo: Get List of Products
See more HTTP Misc Examples
Using a previously obtained request token, demonstrates how to get a list of products.Chilkat AutoIt Downloads
; 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"
Local $sJsonResponse = $oHttp.QuickGetStr("http://pim.my-akeneo-site.com/api/rest/v1/products")
If ($oHttp.LastMethodSuccess <> True) Then
ConsoleWrite($oHttp.LastHeader & @CRLF)
ConsoleWrite($oHttp.LastErrorText & @CRLF)
Exit
EndIf
ConsoleWrite($sJsonResponse & @CRLF)
; 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.Load($sJsonResponse)
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