row_id: 45413

Column Value
row_id 45413
time_created 2026-06-23 00:43:06.266258
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": null, "rating_count": null, "sales_tag": null, "brand": "Anne Klein", "name": "Women's Cotton Eyelet Tiered Swing Shirt Dress", "description": "Anne Klein offers a fresh update on a classic cotton eyelet dress. The swingy, tiered silhouette is detailed with ruffled cuffs for a feminine finishing touch.\n", "data": {"dataFacets": []}, "categories": ["Women's Fashion, Shoes & Accessories > Dresses > Shirt"], "gender": "Women", "product_images": [], "market_id": 4, "remote_code": "26391714", "is_lost": 0, "variants": [{"remote_code": "57657005", "upc": "91312330725", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=0", "size": "XS-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: XS-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657006", "upc": "91312330732", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=1", "size": "S-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: S-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657007", "upc": "91312330749", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=2", "size": "M-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: M-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657008", "upc": "91312330756", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=3", "size": "L-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: L-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657009", "upc": "91312330763", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=4", "size": "XL-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: XL-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657010", "upc": "91312330770", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=5", "size": "XXL-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: XXL-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57657011", "upc": "91312330718", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=6", "size": "XXS-Regular", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: XXS-Regular", "colors": ["Dark Chocolate"]}, {"remote_code": "57666759", "upc": "91312333672", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=7", "size": "P/XL-Petite", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: P/XL-Petite", "colors": ["Dark Chocolate"]}, {"remote_code": "57666775", "upc": "91312333634", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=8", "size": "P/XS-Petite", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: P/XS-Petite", "colors": ["Dark Chocolate"]}, {"remote_code": "57666781", "upc": "91312333641", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=9", "size": "P/S-Petite", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: P/S-Petite", "colors": ["Dark Chocolate"]}, {"remote_code": "57666785", "upc": "91312333658", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=10", "size": "P/M-Petite", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: P/M-Petite", "colors": ["Dark Chocolate"]}, {"remote_code": "57666787", "upc": "91312333665", "remote_url": "https://www.macys.com/shop/product/~?ID=26391714&swatchColor=Dark Chocolate&swatchSize=11", "size": "P/L-Petite", "origin_color": "Dark Chocolate", "price": 159.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/36152797_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/9/optimized/36152799_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/0/optimized/36152800_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/4/optimized/36314004_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"], "stock_count": 1, "data": ["transfer"], "image_url": "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/36152798_fpx.tif", "description": "Color: Dark Chocolate; Size: P/L-Petite", "colors": ["Dark Chocolate"]}]}, "remote_url": "https://www.macys.com/xapi/digital/v1/product/26391714", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '26391714' - 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)