row_id: 42788

Column Value
row_id 42788
time_created 2026-06-22 11:10:27.962422
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": null, "rating_count": null, "remote_code": "9005921", "brand": "Modenaire", "name": "Mixed Texture Sleeveless Embossed Blazer Top", "description": "This modern sleeveless blazer top features a bold mixed-texture design, combining smooth fabric with a croc-embossed panel for a striking contrast. The structured silhouette is enhanced by sharp lapels and strong shoulders, creating a contemporary, tailored look. A single button closure adds a clean, minimalist finish. Perfect for layering, it pairs effortlessly with trousers or skirts for an elevated, fashion-forward outfit.\n 50% PU, 50% Polyester\nProduct length: 23-24 inches\nModel height & size: 5'8\", S\nHand Wash\nMixed texture with croc embossed panel detail\nSingle-button closure", "data": {"dataFacets": []}, "categories": ["Blouse/Top - ADULT - Top"], "gender": "Female", "product_images": [], "market_id": 76, "is_lost": 0, "variants": [{"remote_code": "B0890328", "upc": "721553072084", "email_meta": "3ad72455-4b69-4058-a176-5e9f7b868fa2", "remote_url": "https://www.nordstrom.com/s/whatever/9005921?color=44444FWRFS&size=B0890328", "size": "Small", "origin_color": "Black", "price": 145.0, "variant_images": ["https://n.nordstrommedia.com/it/3ad72455-4b69-4058-a176-5e9f7b868fa2.png", "https://n.nordstrommedia.com/it/9cc4aef7-c332-42c7-8cd5-7398492ea94c.png", "https://n.nordstrommedia.com/it/27a1d9c8-a7ff-4f51-b258-1f61758fda19.jpeg", "https://n.nordstrommedia.com/it/dd30f196-f2a3-41f8-9812-d3323bd63096.png", "https://n.nordstrommedia.com/it/b1ee99d9-3ceb-4d29-82a8-a7b6dc77b536.jpeg", "https://n.nordstrommedia.com/it/2f96873f-2512-43f4-bbaa-4f25417fff17.png", "https://n.nordstrommedia.com/it/d4df4975-a67e-43a7-b446-c09af460b355.jpeg", "https://n.nordstrommedia.com/it/e9a52a91-1f59-4d8b-abd9-a5e6c2382e74.png", "https://n.nordstrommedia.com/it/ca507e2d-c0fa-4d55-9890-3489877d2744.jpeg"], "stock_count": 5, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/3ad72455-4b69-4058-a176-5e9f7b868fa2.png?crop=pad&w=300&h=300", "description": "Color: Black; Size: Small", "colors": ["Black"]}, {"remote_code": "B0890327", "upc": "721553072091", "email_meta": "3ad72455-4b69-4058-a176-5e9f7b868fa2", "remote_url": "https://www.nordstrom.com/s/whatever/9005921?color=44444FWRFS&size=B0890327", "size": "Medium", "origin_color": "Black", "price": 145.0, "variant_images": ["https://n.nordstrommedia.com/it/3ad72455-4b69-4058-a176-5e9f7b868fa2.png", "https://n.nordstrommedia.com/it/9cc4aef7-c332-42c7-8cd5-7398492ea94c.png", "https://n.nordstrommedia.com/it/27a1d9c8-a7ff-4f51-b258-1f61758fda19.jpeg", "https://n.nordstrommedia.com/it/dd30f196-f2a3-41f8-9812-d3323bd63096.png", "https://n.nordstrommedia.com/it/b1ee99d9-3ceb-4d29-82a8-a7b6dc77b536.jpeg", "https://n.nordstrommedia.com/it/2f96873f-2512-43f4-bbaa-4f25417fff17.png", "https://n.nordstrommedia.com/it/d4df4975-a67e-43a7-b446-c09af460b355.jpeg", "https://n.nordstrommedia.com/it/e9a52a91-1f59-4d8b-abd9-a5e6c2382e74.png", "https://n.nordstrommedia.com/it/ca507e2d-c0fa-4d55-9890-3489877d2744.jpeg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/3ad72455-4b69-4058-a176-5e9f7b868fa2.png?crop=pad&w=300&h=300", "description": "Color: Black; Size: Medium", "colors": ["Black"]}]}, "remote_url": "https://www.nordstrom.com/s/9005921", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '9005921' - 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 705, in log_product_upload upsert_product_hash( File "/opt/working_folder/api/logging_router/api/product_logging.py", line 368, in upsert_product_hash db.execute(stmt) 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 2256, in _execute_internal 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)