Lua

Shopware 6 - List Products

See more Shopware 6 Examples

Get a list of products. Lua

local chilkat = require("chilkat")

-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.

local http = chilkat.Http.new()

-- Sends the following POST

-- POST /store-api/v3/product
-- {
--     "includes": {
--         "product": ["id", "name"]
--     }
-- }

-- Use this online tool to generate code from sample JSON:
-- Generate Code to Create JSON

local json = chilkat.JsonObject.new()
json:update_string("includes.product[0]", "id")
json:update_string("includes.product[1]", "name")

-- This request simply authenticates with the sw-access-key you can interactively copy from your
-- sales channel in the Shopware 6 administration web portal.
-- We do NOT use OAuth2 for Store API requests.
http:set_request_header("sw-access-key", "<sales-channel-api-access-key>")

local resp = chilkat.HttpResponse.new()
local success = http:http_json("POST", "https://my-shopware-6-shop.de/store-api/v3/product", json, "application/json", resp)
if not success then
    print(http.last_error_text)
    return
end

local sbResponseBody = chilkat.StringBuilder.new()
resp:get_body_sb(sbResponseBody)
local jResp = chilkat.JsonObject.new()
jResp:load_sb(sbResponseBody)
jResp.emit_compact = false

print("Response Body:")
print(jResp:emit())

-- If we get a 401 response, it may be that our access token expired and we need to fetch a new one.
local respStatusCode = resp.status_code
print("Response Status Code = " .. respStatusCode)
if respStatusCode >= 400 then
    print("Response Header:")
    print(resp.header)
    print("Failed.")
    return
end

-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)

-- {
--   "total": 2,
--   "aggregations": [],
--   "elements": [
--     {
--       "id": "00a284072bcb42ed8fee31e26ea53b60",
--       "name": "Synergistic Wooden Coffee Patch",
--       "apiAlias": "product"
--     },
--     {
--       "id": "bd835e75afa14b09b7da156d095a9a30",
--       "name": "Intelligent Cotton Presto Pesto",
--       "apiAlias": "product"
--     }
--   ],
--   "apiAlias": "dal_entity_search_result"
-- }

-- Sample code for parsing the JSON response...
-- Use the following online tool to generate parsing code from sample JSON:
-- Generate Parsing Code from JSON

local id = ""
local name = ""

local total = jResp:int_of("total")
local apiAlias = jResp:string_of("apiAlias")
local i = 0
local count_i = jResp:size_of_array("elements")
while i < count_i do
    jResp.i = i
    id = jResp:string_of("elements[i].id")
    name = jResp:string_of("elements[i].name")
    apiAlias = jResp:string_of("elements[i].apiAlias")
    i = i + 1
end