| body |
{"product": {"rating": null, "rating_count": null, "sales_tag": "Clearance ", "brand": "Connected", "name": "Women's Ponte Front-Tuck Fit & Flare Dress", "description": "Connected's fit and flare dress showcases versatile, effortless style. Crafted from structured ponte knit, this style offers a polished look with a soft-feel comfort, making it a perfect choice for long office days or evening gatherings.\n", "data": {"dataFacets": []}, "categories": ["Women's Fashion, Shoes & Accessories > Dresses > Flare Dress"], "gender": "Women", "product_images": [], "market_id": 4, "remote_code": "25425687", "is_lost": 0, "variants": [{"remote_code": "57227576", "upc": "696691080614", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=0", "size": "4P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 4P-Petite", "colors": ["BLS"]}, {"remote_code": "57227578", "upc": "696691080621", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=1", "size": "6P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 6P-Petite", "colors": ["BLS"]}, {"remote_code": "57227588", "upc": "696691080638", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=2", "size": "8P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 8P-Petite", "colors": ["BLS"]}, {"remote_code": "57227590", "upc": "696691080645", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=3", "size": "10P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 10P-Petite", "colors": ["BLS"]}, {"remote_code": "57227603", "upc": "696691080652", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=4", "size": "12P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 12P-Petite", "colors": ["BLS"]}, {"remote_code": "57227618", "upc": "696691080669", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=5", "size": "14P-Petite", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 14P-Petite", "colors": ["BLS"]}, {"remote_code": "57227573", "upc": "696691080546", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=6", "size": "4-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 4-Regular", "colors": ["BLS"]}, {"remote_code": "57227574", "upc": "696691080553", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=7", "size": "6-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 6-Regular", "colors": ["BLS"]}, {"remote_code": "57227582", "upc": "696691080560", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=8", "size": "8-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 8-Regular", "colors": ["BLS"]}, {"remote_code": "57227584", "upc": "696691080577", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=9", "size": "10-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 10-Regular", "colors": ["BLS"]}, {"remote_code": "57227595", "upc": "696691080584", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=10", "size": "12-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 12-Regular", "colors": ["BLS"]}, {"remote_code": "57227597", "upc": "696691080591", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=11", "size": "14-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 14-Regular", "colors": ["BLS"]}, {"remote_code": "57227611", "upc": "696691080607", "remote_url": "https://www.macys.com/shop/product/~?ID=25425687&swatchColor=BLS&swatchSize=12", "size": "16-Regular", "origin_color": "BLS", "price": 53.4, "price_full": 89.0, "variant_images": ["https://slimages.macysassets.com/is/image/MCY/products/5/optimized/35376835_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/7/optimized/35376867_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376836_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/8/optimized/35376868_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp", "https://slimages.macysassets.com/is/image/MCY/products/6/optimized/35376866_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/5/optimized/35376835_fpx.tif", "description": "Color: BLS; Size: 16-Regular", "colors": ["BLS"]}]}, "remote_url": "https://www.macys.com/xapi/digital/v1/product/25425687", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '25425687' - parsed successfully. additional_error_text=''"} |
| 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)
|