I am getting exception while trying to get product with this API http://glue-backend.de.spryker.loca

mk00559179
mk00559179 Posts: 18 🧑🏻‍🚀 - Cadet
in Spryker Development

Propel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException - Unable to execute statement [SELECT spy_product_abstract.id_product_abstract, spy_product_abstract.fk_tax_set, spy_product_abstract.approval_status, spy_product_abstract.attributes, spy_product_abstract.color_code, spy_product_abstract.new_from, spy_product_abstract.new_to, spy_product_abstract.sku, spy_product_abstract.created_at, spy_product_abstract.updated_at FROM spy_product_abstract WHERE spy_product_abstract.id_product_abstract=:p1 AND spy_product_abstract.fk_tax_set=:p2 AND spy_product_abstract.approval_status=:p3 AND spy_product_abstract.attributes=:p4 AND spy_product_abstract.new_from=:p5 AND spy_product_abstract.new_to=:p6 AND spy_product_abstract.sku=:p7 AND spy_product_abstract.color_code=:p8 LIMIT 1000]

I am using API Key for authentication pupose and I am passing api_key in request params

Tagged:

Answers

  • fsmeier
    fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,079 ⚖️ - Guardians (admin)

    Heyhey @mk00559179 ,

    sadly we can not really help you without further information. Your post just states that you call some Spryker Glue Backend API endpoint (the endpoint was properly to long for the post title) and that there was this exception.

    So we dont know the endpoint and the parameters right now.

    In the end the exception tells that it has a problem building that query which should be send to the database later on. likely through falsy parameters and missing validation.

    All the best,

    Florian

  • mk00559179
    mk00559179 Posts: 18 🧑🏻‍🚀 - Cadet

    We used this API

    http://glue-backend.de.spryker.local/dynamic-entity/product-abstracts?filter%5Bproduct-abstracts.id_product_abstract%5D=0&filter%5Bproduct-abstracts.fk_tax_set%5D=0&filter%5Bproduct-abstracts.approval_status%5D=string&filter%5Bproduct-abstracts.attributes%5D=string&filter%5Bproduct-abstracts.new_from%5D=string&filter%5Bproduct-abstracts.new_to%5D=string&filter%5Bproduct-abstracts.sku%5D=M90851&filter%5Bproduct-abstracts.color_code%5D=string&offset=0&limit=0&api_key=77e18e589cb75ea55448b311e9b5caec

    With Filter parameter it is giving exception but if i remove filter params then authorization is working fine

Categories