row_id: 43832

Column Value
row_id 43832
time_created 2026-06-22 15:47:58.819536
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": null, "rating_count": null, "brand": "ZARA", "name": "SEMI-SHEER WRINKLE LOOK PANTS", "description": "High-waisted pants with elastic waistband. Front pockets. Short interior lining. Wide leg.\n\n<ul>\n<li><strong>Sizes XS</strong>\n<ul>\n<li>A - Waist: 35.5</li>\n<li>B - Hips: 50.0</li>\n<li>C - Front Length Lower: 106.5</li>\n<li>D - Front Rise: 32.0</li>\n<li>E - Back Rise: 33.0</li>\n</ul>\n</li>\n<li><strong>Sizes S</strong>\n<ul>\n<li>A - Waist: 36.5</li>\n<li>B - Hips: 51.0</li>\n<li>C - Front Length Lower: 107.0</li>\n<li>D - Front Rise: 33.0</li>\n<li>E - Back Rise: 34.0</li>\n</ul>\n</li>\n<li><strong>Sizes M</strong>\n<ul>\n<li>A - Waist: 37.5</li>\n<li>B - Hips: 52.0</li>\n<li>C - Front Length Lower: 107.5</li>\n<li>D - Front Rise: 34.0</li>\n<li>E - Back Rise: 35.0</li>\n</ul>\n</li>\n<li><strong>Sizes L</strong>\n<ul>\n<li>A - Waist: 38.5</li>\n<li>B - Hips: 53.0</li>\n<li>C - Front Length Lower: 108.0</li>\n<li>D - Front Rise: 35.0</li>\n<li>E - Back Rise: 36.0</li>\n</ul>\n</li>\n<li><strong>Sizes XL</strong>\n<ul>\n<li>A - Waist: 39.5</li>\n<li>B - Hips: 54.0</li>\n<li>C - Front Length Lower: 108.5</li>\n<li>D - Front Rise: 36.0</li>\n<li>E - Back Rise: 37.0</li>\n</ul>\n</li>\n</ul>", "data": {"dataFacets": []}, "gender": "WOMAN", "categories": ["TROUSERS - WOMAN"], "product_images": [], "market_id": 65, "remote_code": "wrinkle-look-semi-sheer-pants-p04387233.html", "is_lost": 0, "variants": [{"remote_code": "0438723340101-I2026", "upc": "zaraQR:0438723340101", "email_meta": "0438723340101", "additional_upc": "545416110", "remote_url": "https://www.zara.com/us/en/wrinkle-look-semi-sheer-pants-p04387233.html?v1=545416110", "size": "XS", "origin_color": "Navy blue", "price": 49.9, "variant_images": ["https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w={width}", "https://static.zara.net/assets/public/f7c7/ca1b/25a241b0a6a8/113ca252f570/04387233401-a1/04387233401-a1.jpg?ts=1778668044506&w={width}", "https://static.zara.net/assets/public/1016/bce7/ca134f88add0/abe6d59a6684/04387233401-a2/04387233401-a2.jpg?ts=1778668043568&w={width}", "https://static.zara.net/assets/public/4903/d1dd/abb1430a88e9/04c3a7f026de/04387233401-e1/04387233401-e1.jpg?ts=1778595373456&w={width}", "https://static.zara.net/assets/public/5b43/a391/1c0647c3b85f/1083c09ed8f1/04387233401-e2/04387233401-e2.jpg?ts=1778595373353&w={width}", "https://static.zara.net/assets/public/aead/5a24/5655442a9d82/fe30cc964348/04387233401-e3/04387233401-e3.jpg?ts=1778595374972&w={width}"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w=300", "description": "Color: Navy blue; Size: XS", "colors": ["Navy blue"]}, {"remote_code": "0438723340102-I2026", "upc": "zaraQR:0438723340102", "email_meta": "0438723340102", "additional_upc": "545416111", "remote_url": "https://www.zara.com/us/en/wrinkle-look-semi-sheer-pants-p04387233.html?v1=545416111", "size": "S", "origin_color": "Navy blue", "price": 49.9, "variant_images": ["https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w={width}", "https://static.zara.net/assets/public/f7c7/ca1b/25a241b0a6a8/113ca252f570/04387233401-a1/04387233401-a1.jpg?ts=1778668044506&w={width}", "https://static.zara.net/assets/public/1016/bce7/ca134f88add0/abe6d59a6684/04387233401-a2/04387233401-a2.jpg?ts=1778668043568&w={width}", "https://static.zara.net/assets/public/4903/d1dd/abb1430a88e9/04c3a7f026de/04387233401-e1/04387233401-e1.jpg?ts=1778595373456&w={width}", "https://static.zara.net/assets/public/5b43/a391/1c0647c3b85f/1083c09ed8f1/04387233401-e2/04387233401-e2.jpg?ts=1778595373353&w={width}", "https://static.zara.net/assets/public/aead/5a24/5655442a9d82/fe30cc964348/04387233401-e3/04387233401-e3.jpg?ts=1778595374972&w={width}"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w=300", "description": "Color: Navy blue; Size: S", "colors": ["Navy blue"]}, {"remote_code": "0438723340103-I2026", "upc": "zaraQR:0438723340103", "email_meta": "0438723340103", "additional_upc": "545416112", "remote_url": "https://www.zara.com/us/en/wrinkle-look-semi-sheer-pants-p04387233.html?v1=545416112", "size": "M", "origin_color": "Navy blue", "price": 49.9, "variant_images": ["https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w={width}", "https://static.zara.net/assets/public/f7c7/ca1b/25a241b0a6a8/113ca252f570/04387233401-a1/04387233401-a1.jpg?ts=1778668044506&w={width}", "https://static.zara.net/assets/public/1016/bce7/ca134f88add0/abe6d59a6684/04387233401-a2/04387233401-a2.jpg?ts=1778668043568&w={width}", "https://static.zara.net/assets/public/4903/d1dd/abb1430a88e9/04c3a7f026de/04387233401-e1/04387233401-e1.jpg?ts=1778595373456&w={width}", "https://static.zara.net/assets/public/5b43/a391/1c0647c3b85f/1083c09ed8f1/04387233401-e2/04387233401-e2.jpg?ts=1778595373353&w={width}", "https://static.zara.net/assets/public/aead/5a24/5655442a9d82/fe30cc964348/04387233401-e3/04387233401-e3.jpg?ts=1778595374972&w={width}"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w=300", "description": "Color: Navy blue; Size: M", "colors": ["Navy blue"]}, {"remote_code": "0438723340104-I2026", "upc": "zaraQR:0438723340104", "email_meta": "0438723340104", "additional_upc": "545416108", "remote_url": "https://www.zara.com/us/en/wrinkle-look-semi-sheer-pants-p04387233.html?v1=545416108", "size": "L", "origin_color": "Navy blue", "price": 49.9, "variant_images": ["https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w={width}", "https://static.zara.net/assets/public/f7c7/ca1b/25a241b0a6a8/113ca252f570/04387233401-a1/04387233401-a1.jpg?ts=1778668044506&w={width}", "https://static.zara.net/assets/public/1016/bce7/ca134f88add0/abe6d59a6684/04387233401-a2/04387233401-a2.jpg?ts=1778668043568&w={width}", "https://static.zara.net/assets/public/4903/d1dd/abb1430a88e9/04c3a7f026de/04387233401-e1/04387233401-e1.jpg?ts=1778595373456&w={width}", "https://static.zara.net/assets/public/5b43/a391/1c0647c3b85f/1083c09ed8f1/04387233401-e2/04387233401-e2.jpg?ts=1778595373353&w={width}", "https://static.zara.net/assets/public/aead/5a24/5655442a9d82/fe30cc964348/04387233401-e3/04387233401-e3.jpg?ts=1778595374972&w={width}"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.zara.net/assets/public/8613/c888/05444ed89922/809f0b98c2fc/04387233401-p/04387233401-p.jpg?ts=1778668045623&w=300", "description": "Color: Navy blue; Size: L", "colors": ["Navy blue"]}]}, "remote_url": "https://www.zara.com/us/en/wrinkle-look-semi-sheer-pants-p04387233.html", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'wrinkle-look-semi-sheer-pants-p04387233.html' - parsed successfully. additional_error_text=''"}
status_code 500
error_text File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 15, in dispatch response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 84, in call_next raise app_exc File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 70, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/usr/local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 83, in __call__ await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__ raise exc File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__ await self.app(scope, receive, sender) File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__ raise e File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__ await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__ await route.handle(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app response = await func(request) ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 274, in app raw_response = await run_endpoint_function( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 193, in run_endpoint_function return await run_in_threadpool(dependant.call, **values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/starlette/concurrency.py", line 41, in run_in_threadpool return await anyio.to_thread.run_sync(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/to_thread.py", line 33, in run_sync return await get_asynclib().run_sync_in_worker_thread( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 877, in run_sync_in_worker_thread return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 807, in run result = context.run(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/working_folder/api/logging_router/api/product_logging.py", line 495, in log_product_upload add_product_history(db, market_id, remote_code, json_data) File "/opt/working_folder/api/logging_router/api/product_logging.py", line 319, in add_product_history .first() ^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2728, in first return self.limit(1)._iter().first() # type: ignore ^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( ^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement result = conn.execute( ^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute return meth( ^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute cursor.execute(statement, parameters)