| body |
{"product": {"rating": 4.5, "rating_count": 2, "remote_code": "7027297", "brand": "DKNY", "name": "Mabi Pointed Toe Pump", "description": "A sleek pointed toe and stiletto heel balance a scene-stealing pump that will highlight your showstopping style.\n 4\" heel\nSynthetic upper, lining and sole\nImported", "data": {"dataFacets": []}, "categories": ["Pumps - ADULT"], "gender": "Female", "product_images": [], "market_id": 76, "is_lost": 0, "variants": [{"remote_code": "4223331", "upc": "755406181715", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223331", "size": "8 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 140, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 8 M", "colors": ["BLACK"]}, {"remote_code": "4223330", "upc": "755406183313", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223330", "size": "7.5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 115, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 7.5 M", "colors": ["BLACK"]}, {"remote_code": "4223328", "upc": "755406183320", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223328", "size": "6.5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 82, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 6.5 M", "colors": ["BLACK"]}, {"remote_code": "4223325", "upc": "755406181739", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223325", "size": "5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 20, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 5 M", "colors": ["BLACK"]}, {"remote_code": "4223334", "upc": "755406180206", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223334", "size": "9.5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 77, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 9.5 M", "colors": ["BLACK"]}, {"remote_code": "4223327", "upc": "755406183337", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223327", "size": "6 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 89, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 6 M", "colors": ["BLACK"]}, {"remote_code": "4223333", "upc": "755406183290", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223333", "size": "9 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 107, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 9 M", "colors": ["BLACK"]}, {"remote_code": "4223336", "upc": "755406181746", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223336", "size": "11 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 27, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 11 M", "colors": ["BLACK"]}, {"remote_code": "4223329", "upc": "755406181722", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223329", "size": "7 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 130, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 7 M", "colors": ["BLACK"]}, {"remote_code": "4223332", "upc": "755406183306", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223332", "size": "8.5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 116, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 8.5 M", "colors": ["BLACK"]}, {"remote_code": "4223326", "upc": "755406180213", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223326", "size": "5.5 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 26, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 5.5 M", "colors": ["BLACK"]}, {"remote_code": "4223335", "upc": "755406183344", "email_meta": "f3bee55e-8ba3-4871-b8c2-73dd1cbde73f", "remote_url": "https://www.nordstrom.com/s/whatever/7027297?color=44444AGTCS&size=4223335", "size": "10 M", "origin_color": "BLACK", "price": 129.0, "variant_images": ["https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg", "https://n.nordstrommedia.com/it/1c02b013-c599-4102-80d7-fa961412b4c0.jpeg", "https://n.nordstrommedia.com/it/427fb833-2aee-45d3-b243-2d7b743f6190.jpeg", "https://n.nordstrommedia.com/it/f40ae08e-3749-4818-8bfd-000cb467606d.jpeg", "https://n.nordstrommedia.com/it/dd032136-e610-4b12-9dc5-d51fa5194a8d.jpeg", "https://n.nordstrommedia.com/it/d9f65484-9815-4f4a-95ab-6a4a4ba07edc.jpeg"], "stock_count": 80, "data": ["transfer"], "image_url": "https://n.nordstrommedia.com/it/f3bee55e-8ba3-4871-b8c2-73dd1cbde73f.jpeg?crop=pad&w=300&h=300", "description": "Color: BLACK; Size: 10 M", "colors": ["BLACK"]}]}, "remote_url": "https://www.nordstrom.com/s/7027297", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '7027297' - 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 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)
|