| body |
{"product": {"category_meta_splitter": null, "meta_category": ["N/A"], "origin_url": null, "rating": 4.63, "rating_count": 1628, "brand": "SheaMoisture", "name": "SheaMoisture Manuka Honey & Mafura Oil Intensive Hydration Hair Mask", "description": "This intensive hydration hair masque infuses hair with a powerful dose of moisture and nutrients. This deep conditioning hair treatment masque is made with Shea Butter, and Mafura and Baobab Oils that are blended with antioxidant-rich African Rock Fig to restore and lock in moisture while deeply conditioning. Smoothes and fortifies follicles for stronger, healthier, frizz-free hair. This hair masque blends certified organic Shea Butter, Honey, and Mafura and Baobab Oils with antioxidant-rich African Rock Fig to restore and lock in moisture. As is the case with all SheaMoisture hair products, this intensive hydration hair masque is formulated with no sulfates, no parabens, no phthalates, no mineral oil, no animal testing, and no petrolatum. To use: Section clean, wet hair. Apply this deep conditioner generously. Use a wide tooth comb to distribute this hair product evenly from root to ends. Leave in for 5 minutes. Rinse thoroughly. For extra conditioning, cover hair with a plastic cap. Apply moderate heat for up to 30 minutes. When using a steamer, do not cover hair. Moist heat will add to the masque's hydration. Our Story: SheaMoisture is the legacy of Sofi Tucker, a pioneering mother of four and entrepreneur, who sold Shea Butter, African Black Soap and homemade beauty preparations in Sierra Leone in 1912. We honor her vision by continuing to formulate with Raw Shea Butter handcrafted by women in Africa. With every purchase, you show support of our mission to reinvest back in our communities.\n •SheaMoisture Intensive Hydration Hair Masque infuses hair with a powerful dose of moisture and provides intense conditioning for hair that is thirsty for moisture, especially curly hair.<br>•This deep conditioning hair masque fortifies follicles and smooths over-processed hair, damaged hair or color-treated hair for stronger, healthier and frizz-free hair.<br>•This deep conditioning hair treatment masque blends certified organic Shea Butter, Honey, Mafura and Baobab Oils with antioxidant-rich African Rock Fig to restore and lock in moisture.<br>•Apply this deep hair conditioner generously on clean, wet hair. Use a wide tooth comb to distribute the hair masque evenly from root to ends. Leave in for 5 minutes. Rinse thoroughly.<br>•All SheaMoisture hair products, like this deep conditioning masque, are ethically traded, sustainably produced and cruelty-free.<br>•This intensive hydration hair mask is formulated with no sulfates, no parabens, no phthalates, no mineral oil, no animal testing and no petrolatum.", "data": {"dataFacets": []}, "categories": ["Beauty > Hair Care > Hair & Scalp Treatments > Hair Masks"], "gender": "N/A", "location": "OxfordValley;Neshaminy;PhiladelphiaRooseveltBlvd;AbingtonTownship;PhiladelphiaCottman", "product_images": [], "market_id": 84, "remote_code": "51084290", "is_lost": 0, "variants": [{"remote_code": "15651079", "upc": "764302231066", "remote_url": "https://www.target.com/p/~/-/A-15651079", "size": "11.5oz", "origin_color": "N/A", "price": 12.99, "price_full": null, "variant_images": ["https://target.scene7.com/is/image/Target/GUEST_804b97d7-fcc0-4881-a2ae-7b778d7e65c2?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_95c30335-a74a-4af5-9ab0-3b2ca4415d06?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_6538a7d5-9581-403f-8c02-296b646b7c73?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_24d81def-9bc5-43a8-984c-601fb095e3e0?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_34cbb899-202a-4bf5-8103-3a73c77838d9?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_c28f269e-967c-490d-8505-69650229ffa0?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_12558492-f608-4896-9748-c79d405e9b4f?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_8719ce09-fe4e-4057-b68a-703e95599d99?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_740d4503-c203-43e1-aee7-cf70c009dfb1?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_8c7134c8-9571-444b-ab1c-5ee5de3ddfee?wid=1200&hei=1200"], "stock_count": 1, "data": ["transfer"], "image_url": "https://target.scene7.com/is/image/Target/GUEST_24d81def-9bc5-43a8-984c-601fb095e3e0", "description": "Color: N/A; Size: 11.5oz", "colors": ["N/A"]}, {"remote_code": "51084290", "upc": "764302231332", "remote_url": "https://www.target.com/p/~/-/A-51084290", "size": "2 fl oz", "origin_color": "N/A", "price": 2.99, "price_full": null, "variant_images": ["https://target.scene7.com/is/image/Target/GUEST_33a9e27d-04d0-44f7-90f1-ca6964ca7801?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_7311106a-1f3c-4d8a-af23-97949fb35c79?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_eb02093a-7b19-4e74-821a-d9d98c4bf631?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_7389213e-81e9-4685-bd3a-a0b5612ce78f?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_afc0e46b-b8e1-4f93-b3f7-503071529538?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_394bedf1-ce7c-4d49-8c7f-453ef23aa872?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_c40fa09f-40f0-4bb9-8507-d4e25d7eb70a?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_337eec27-2adf-4855-9a09-002b4bbae45e?wid=1200&hei=1200"], "stock_count": 1, "data": ["transfer"], "image_url": "https://target.scene7.com/is/image/Target/GUEST_eb02093a-7b19-4e74-821a-d9d98c4bf631", "description": "Color: N/A; Size: 2 fl oz", "colors": ["N/A"]}]}, "remote_url": "https://www.target.com/p/~/-/A-51084290", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '51084290' - 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 2237, in _execute_internal
conn = self._connection_for_bind(bind)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2106, in _connection_for_bind
return trans._connection_for_bind(engine, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in _connection_for_bind
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1189, in _connection_for_bind
conn = bind.connect()
^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3278, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 148, in __init__
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2442, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3302, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
self.__connect()
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
with util.safe_reraise():
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|