| body |
{"product": {"rating": null, "rating_count": null, "brand": "The Tao of Tea", "name": "The Tao of Tea, Black Tea Blend, Lychee, 4 oz (114 g)", "description": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nSweet and FruityPure Leaf TeasBrews 50 CupsOrigin\u00a0BlendLychee is a blend of fine black tea and natural lychee essence. Together, they make a refreshing tea that can be enjoyed either warm or iced.Full Leaf Specialty BlackRepresenting orthodox manufacture, whereby the leaf is hand-plucked and maintains an unbroken appearance, the tea leaves for this blend are selected fresh throughout various growing seasons of the year.LycheeLychee is native to Southeast Asia and the Indian sub-continent. Harvested in the peak of the summer, it is considered cooling with rejuvenating properties. It is a small plum sized fruit, with red outer skin, and sweet juicy fruit inside.PairingLychee complements well with slightly spicy, dry foods and nuts. It is also great for making sorbet and ice cream.Flavor ProfileSweet, rich flavor and aroma similar to red roses. Full-bodied, smooth brew with little or no astringency.\n\n\n\n\nSpecifications\n\n\n First available: \n 09/2023 \n\n\n Shipping weight:\n \n 0.5 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: TOT-71040\nUPC: 689951710406\nPackage quantity:\n \n 4 oz\n \n\n\n Dimensions:\n \n 4.45 x 3.25 x 3.25 in\n , \n 0.5 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nBrew one teaspoon of leaf in eight ounces of pure spring or filtered water at 185\u00b0F for four minutes. Provides at least two infusions.\n\n\n\n\n\n\nOther ingredients\n\nBlack tea leaves, natural lychee (litchi chinensis) essence.\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "data": {"dataFacets": []}, "categories": ["Brands A-Z > The Tao of Tea", "Categories > Grocery > Tea & Beverages > Tea > Black Tea", "Categories > Grocery > Tea & Beverages > Tea > Fruit Tea"], "gender": "Unisex", "product_images": [], "market_id": 89, "remote_code": "the-tao-of-tea-black-tea-blend-lychee", "is_lost": 0, "variants": [{"remote_code": "45571", "name": "The Tao of Tea, Black Tea Blend, Lychee, 4 oz (114 g)", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nSweet and FruityPure Leaf TeasBrews 50 CupsOrigin\u00a0BlendLychee is a blend of fine black tea and natural lychee essence. Together, they make a refreshing tea that can be enjoyed either warm or iced.Full Leaf Specialty BlackRepresenting orthodox manufacture, whereby the leaf is hand-plucked and maintains an unbroken appearance, the tea leaves for this blend are selected fresh throughout various growing seasons of the year.LycheeLychee is native to Southeast Asia and the Indian sub-continent. Harvested in the peak of the summer, it is considered cooling with rejuvenating properties. It is a small plum sized fruit, with red outer skin, and sweet juicy fruit inside.PairingLychee complements well with slightly spicy, dry foods and nuts. It is also great for making sorbet and ice cream.Flavor ProfileSweet, rich flavor and aroma similar to red roses. Full-bodied, smooth brew with little or no astringency.\n\n\n\n\nSpecifications\n\n\n First available: \n 09/2023 \n\n\n Shipping weight:\n \n 0.5 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: TOT-71040\nUPC: 689951710406\nPackage quantity:\n \n 4 oz\n \n\n\n Dimensions:\n \n 4.45 x 3.25 x 3.25 in\n , \n 0.5 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nBrew one teaspoon of leaf in eight ounces of pure spring or filtered water at 185\u00b0F for four minutes. Provides at least two infusions.\n\n\n\n\n\n\nOther ingredients\n\nBlack tea leaves, natural lychee (litchi chinensis) essence.\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "689951710406", "email_meta": "tot/tot71040", "remote_url": "https://www.iherb.com/pr/~/45571", "size": "Lychee", "origin_color": "NO_COLOR", "price": 13.0, "variant_images": ["https://s3.images-iherb.com/tot/tot71040/l/27.jpg", "https://s3.images-iherb.com/tot/tot71040/l/31.jpg", "https://s3.images-iherb.com/cms/banners/dPDP-US-JP-Quality-Promise_007en-us.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://s3.images-iherb.com/tot/tot71040/l/27.jpg", "description": "Color: NO_COLOR; Size: Lychee", "colors": ["NO_COLOR"], "combo_key": "LycheeNO_COLOR"}, {"remote_code": "56467", "name": "The Tao of Tea, Scented Black Tea, Hand Blended, Ginger Peach, 4 oz (114 g)", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nPure Leaf TeasBrews 50 CupsOrigin, BlendGinger Peach is a blend of fine black tea, dried ginger, calendula flower petals and natural peach essence. Together, they blend to make a refreshing tea that can be enjoyed either warm or iced.Full Leaf Specialty BlackThis tea is made using an orthodox manufacturing process in which the leaf is hand-plucked and maintains an unbroken appearance. The tea leaves for this blend are selected fresh during the growing seasons of the year.Peach Native to China, Peach has been widely cultivated in places like Persia, Greece and Spain. In the 16th century, peach also began being cultivated in America. Peaches are low in calories and a good source of healthy carbs. Peaches also contain antioxidants, which stimulate the immune system, and flavonoids, which help regulate cellular activity.\u00a0Ginger We use dried ginger root with mildly spicy flavor undertones to balance the sweet lushness of peach in this blend. Ginger is often used as a digestive remedy.Flavor ProfileSweet, rich, smooth taste. Full bodied brew, without astringency.\n\n\n\n\nSpecifications\n\n\n First available: \n 04/2014 \n\n\n Shipping weight:\n \n 0.5 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: TOT-71060\nUPC: 689951710604\nPackage quantity:\n \n 4 oz\n \n\n\n Dimensions:\n \n 4.45 x 3.25 x 3.25 in\n , \n 0.5 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nBrew two teaspoons of leaf in eight ounces of pure spring or filtered water at 185\u00b0 F. \u00a0for four minutes. Provides at least two infusions.\n\n\n\n\n\n\nOther ingredients\n\nBlack tea leaves, organic dried ginger, calendula flower petals and natural peach essence.\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "689951710604", "email_meta": "tot/tot71060", "remote_url": "https://www.iherb.com/pr/~/56467", "size": "Ginger peach", "origin_color": "NO_COLOR", "price": 13.0, "variant_images": ["https://s3.images-iherb.com/tot/tot71060/l/37.jpg", "https://s3.images-iherb.com/tot/tot71060/l/39.jpg", "https://s3.images-iherb.com/cms/banners/dPDP-US-JP-Quality-Promise_007en-us.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://s3.images-iherb.com/tot/tot71060/l/37.jpg", "description": "Color: NO_COLOR; Size: Ginger peach", "colors": ["NO_COLOR"], "combo_key": "Ginger peachNO_COLOR"}]}, "remote_url": "https://api.scrape.do/?token=c38f147cd67c49d8a38cb4f2d704e6acf0663ff8c9d&super=true&geoCode=us&url=https://www.iherb.com/pr/~/45571", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'the-tao-of-tea-black-tea-blend-lychee' - 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)
|