2025-11-24 04:33:27 [scrapy.utils.log] INFO: Scrapy 2.12.0 started (bot: zomato_dining) 2025-11-24 04:33:27 [scrapy.utils.log] INFO: Versions: lxml 5.3.0.0, libxml2 2.12.9, cssselect 1.2.0, parsel 1.9.1, w3lib 2.2.1, Twisted 24.11.0, Python 3.10.12 (main, Aug 15 2025, 14:32:43) [GCC 11.4.0], pyOpenSSL 24.3.0 (OpenSSL 3.4.0 22 Oct 2024), cryptography 44.0.0, Platform Linux-6.8.0-1040-aws-aarch64-with-glibc2.35 2025-11-24 04:33:27 [dining_transaction_history_zomato] INFO: Dynamic attribute _job = 123_2025-11-24T04_30_02 2025-11-24 04:33:27 [dining_transaction_history_zomato] INFO: Dynamic attribute scheduled_job_id = 8091 2025-11-24 04:33:27 [dining_transaction_history_zomato] INFO: Dynamic attribute SCRAPEOPS_JOB_NAME = 123 2025-11-24 04:33:27 [scrapy.addons] INFO: Enabled addons: [] 2025-11-24 04:33:27 [py.warnings] WARNING: /home/ubuntu/restaverse_spiders/venv/lib/python3.10/site-packages/scrapy/utils/request.py:120: ScrapyDeprecationWarning: 'REQUEST_FINGERPRINTER_IMPLEMENTATION' is a deprecated setting. It will be removed in a future version of Scrapy. return cls(crawler) 2025-11-24 04:33:27 [asyncio] DEBUG: Using selector: EpollSelector 2025-11-24 04:33:27 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.asyncioreactor.AsyncioSelectorReactor 2025-11-24 04:33:27 [scrapy.utils.log] DEBUG: Using asyncio event loop: asyncio.unix_events._UnixSelectorEventLoop 2025-11-24 04:33:27 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.asyncioreactor.AsyncioSelectorReactor 2025-11-24 04:33:27 [scrapy.utils.log] DEBUG: Using asyncio event loop: asyncio.unix_events._UnixSelectorEventLoop 2025-11-24 04:33:27 [scrapy.extensions.telnet] INFO: Telnet Password: 17dbc6cd2f477345 2025-11-24 04:33:27 [scrapy.middleware] INFO: Enabled extensions: ['scrapy.extensions.corestats.CoreStats', 'scrapy.extensions.telnet.TelnetConsole', 'scrapy.extensions.memusage.MemoryUsage', 'scrapy.extensions.logstats.LogStats', 'scrapy_extensions.extension.BandwidthLoggerExtension', 'scrapeops_scrapy.extension.ScrapeOpsMonitor'] 2025-11-24 04:33:27 [scrapy.crawler] INFO: Overridden settings: {'BOT_NAME': 'zomato_dining', 'CONCURRENT_REQUESTS': 8, 'DOWNLOAD_DELAY': 0.5, 'FEED_EXPORT_ENCODING': 'utf-8', 'LOG_FILE': '/home/ubuntu/restaverse_spiders/logs/zomato_dining/dining_transaction_history_zomato/123_2025-11-24T04_30_02.log', 'NEWSPIDER_MODULE': 'zomato_dining.spiders', 'REQUEST_FINGERPRINTER_IMPLEMENTATION': '2.7', 'SPIDER_MODULES': ['zomato_dining.spiders'], 'TWISTED_REACTOR': 'twisted.internet.asyncioreactor.AsyncioSelectorReactor', 'USER_AGENT': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, ' 'like Gecko) Chrome/127.0.0.0 Safari/537.36'} 2025-11-24 04:33:27 [faker.factory] DEBUG: Not in REPL -> leaving logger event level as is. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.address`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.address` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.automotive`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.automotive` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.bank`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Specified locale `en_US` is not available for provider `faker.providers.bank`. Locale reset to `en_GB` for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.barcode`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.barcode` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.color`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.color` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.company`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.company` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.credit_card`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.credit_card` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.currency`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.currency` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.date_time`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.date_time` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.emoji` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.file` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.geo`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.geo` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.internet`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.internet` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.isbn`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.isbn` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.job`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.job` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.lorem`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.lorem` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.misc`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.misc` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.passport`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.passport` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.person`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.person` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.phone_number`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.phone_number` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.profile` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.python` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.sbn` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [faker.factory] DEBUG: Looking for locale `en_US` in provider `faker.providers.ssn`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.ssn` has been localized to `en_US`. 2025-11-24 04:33:27 [faker.factory] DEBUG: Provider `faker.providers.user_agent` does not feature localization. Specified locale `en_US` is not utilized for this provider. 2025-11-24 04:33:27 [scrapy_fake_useragent.middleware] DEBUG: Loaded User-Agent provider: scrapy_fake_useragent.providers.FakerProvider 2025-11-24 04:33:27 [scrapy_fake_useragent.middleware] INFO: Using '' as the User-Agent provider 2025-11-24 04:33:27 [scrapy.middleware] INFO: Enabled downloader middlewares: ['scrapy.downloadermiddlewares.offsite.OffsiteMiddleware', 'zomato_dining.middlewares.RedisCacheMiddleware', 'scrapy.downloadermiddlewares.httpauth.HttpAuthMiddleware', 'scrapy.downloadermiddlewares.downloadtimeout.DownloadTimeoutMiddleware', 'scrapy.downloadermiddlewares.defaultheaders.DefaultHeadersMiddleware', 'scrapy_fake_useragent.middleware.RandomUserAgentMiddleware', 'scrapy.downloadermiddlewares.useragent.UserAgentMiddleware', 'scrapeops_scrapy.middleware.retry.RetryMiddleware', 'scrapy.downloadermiddlewares.redirect.MetaRefreshMiddleware', 'scrapy.downloadermiddlewares.httpcompression.HttpCompressionMiddleware', 'scrapy.downloadermiddlewares.redirect.RedirectMiddleware', 'scrapy.downloadermiddlewares.cookies.CookiesMiddleware', 'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware', 'scrapy.downloadermiddlewares.stats.DownloaderStats'] 2025-11-24 04:33:27 [scrapy.middleware] INFO: Enabled spider middlewares: ['scrapy.spidermiddlewares.httperror.HttpErrorMiddleware', 'zomato_dining.middlewares.ZomatoDiningSpiderMiddleware', 'scrapy.spidermiddlewares.referer.RefererMiddleware', 'scrapy.spidermiddlewares.urllength.UrlLengthMiddleware', 'scrapy.spidermiddlewares.depth.DepthMiddleware'] 2025-11-24 04:33:27 [scrapy.middleware] INFO: Enabled item pipelines: ['zomato_dining.pipelines.ZomatoDiningPipeline'] 2025-11-24 04:33:27 [scrapy.core.engine] INFO: Spider opened 2025-11-24 04:33:27 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min) 2025-11-24 04:33:27 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/setup/ HTTP/11" 200 None 2025-11-24 04:33:28 [dining_transaction_history_zomato] INFO: Spider opened: dining_transaction_history_zomato 2025-11-24 04:33:28 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6034 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): cron.restaverse.com:443 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: https://cron.restaverse.com:443 "POST /api/db_services/fetch-query HTTP/11" 200 2867 2025-11-24 04:33:28 [scrapy_fake_useragent.middleware] DEBUG: Assign User-Agent Opera/9.49.(Windows NT 11.0; uk-UA) Presto/2.9.170 Version/10.00 to Proxy http://scrapeops.country=in:dbc08e8a-4f73-4088-9f13-c2db0a774557@residential-proxy.scrapeops.io:8181 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/normalizer/proxy_port/?job_id=5464007 HTTP/11" 200 None 2025-11-24 04:33:28 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:33:29 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/normalizer/domain/?domain=zomato.com HTTP/11" 200 241 2025-11-24 04:33:30 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://www.zomato.com/partners/onlineordering/orderHistory/) 2025-11-24 04:33:32 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://www.zomato.com/webroutes/auth/csrf?service_type=dine_out) 2025-11-24 04:33:32 [dining_transaction_history_zomato] INFO: [CACHE KEY GENERATED] https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out 2025-11-24 04:33:32 [dining_transaction_history_zomato] INFO: [CACHE HIT] https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out 2025-11-24 04:33:32 [scrapy.core.engine] DEBUG: Crawled (299) (referer: https://api.zomato.com/dining-gw/csrf/get?service_type=dine_out) 2025-11-24 04:33:33 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:35 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:35 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:36 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:36 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:36 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=21377731&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '309', 'confirmation_code': 1892, 'created_by': 'Jayani Gudhka', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9309"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b946.35", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b946.35"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9262.65"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9262.65"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b930.98", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b926.26"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b94.72"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9247.16"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 21377731, 'settlement_amount': '247.16', 'status': 'success', 'timestamp': '2025-11-23T16:23:00+00:00', 'transaction_id': 4235468167, 'user_paid_amount': '262.65'} 2025-11-24 04:33:37 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:37 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:38 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:38 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:39 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:40 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:40 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:41 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:41 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:42 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:33:42 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/stats/ HTTP/11" 200 109 2025-11-24 04:33:42 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18598703&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '230', 'confirmation_code': 6080, 'created_by': 'Kajal Shah', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9230"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b934.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b934.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9195.5"}]', 'payout_info': 'null', 'payout_settlement_date': None, 'payout_status': None, 'rating': None, 'res_id': 18598703, 'settlement_amount': 'None', 'status': 'failed', 'timestamp': '2025-11-23T16:17:00+00:00', 'transaction_id': 6112620430, 'user_paid_amount': '195.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18598703&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '230', 'confirmation_code': 3293, 'created_by': 'Kajal Shah', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9230"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b934.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b934.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9195.5"}]', 'payout_info': 'null', 'payout_settlement_date': None, 'payout_status': None, 'rating': None, 'res_id': 18598703, 'settlement_amount': 'None', 'status': 'failed', 'timestamp': '2025-11-23T16:17:00+00:00', 'transaction_id': 5635033966, 'user_paid_amount': '195.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18598703&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '230', 'confirmation_code': 7970, 'created_by': 'Kajal Shah', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9230"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b934.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b934.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9195.5"}]', 'payout_info': 'null', 'payout_settlement_date': None, 'payout_status': None, 'rating': None, 'res_id': 18598703, 'settlement_amount': 'None', 'status': 'failed', 'timestamp': '2025-11-23T16:16:00+00:00', 'transaction_id': 9856555723, 'user_paid_amount': '195.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18598703&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '230', 'confirmation_code': 8057, 'created_by': 'Kajal Shah', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9230"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b934.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b934.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9195.5"}]', 'payout_info': 'null', 'payout_settlement_date': None, 'payout_status': None, 'rating': None, 'res_id': 18598703, 'settlement_amount': 'None', 'status': 'failed', 'timestamp': '2025-11-23T16:14:00+00:00', 'transaction_id': 4180430018, 'user_paid_amount': '195.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18598703&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '230', 'confirmation_code': 8438, 'created_by': 'Kajal Shah', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9230"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b934.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b934.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9195.5"}]', 'payout_info': 'null', 'payout_settlement_date': None, 'payout_status': None, 'rating': None, 'res_id': 18598703, 'settlement_amount': 'None', 'status': 'failed', 'timestamp': '2025-11-23T16:12:00+00:00', 'transaction_id': 6142832116, 'user_paid_amount': '195.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18541277&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '350', 'confirmation_code': 9052, 'created_by': 'Angel Arwix', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9350"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b952.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b952.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9297.5"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9297.5"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b935.12", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b929.76"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b95.36"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9279.94"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 18541277, 'settlement_amount': '279.94', 'status': 'success', 'timestamp': '2025-11-23T16:46:00+00:00', 'transaction_id': 1736219402, 'user_paid_amount': '297.5'} 2025-11-24 04:33:42 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=18541277&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '413', 'confirmation_code': 1088, 'created_by': 'Pragati', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9413"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b961.95", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b961.95"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9351.05"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9351.05"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b941.42", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b935.1"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b96.32"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9330.34"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 18541277, 'settlement_amount': '330.34', 'status': 'success', 'timestamp': '2025-11-23T16:37:00+00:00', 'transaction_id': 7730182553, 'user_paid_amount': '351.05'} 2025-11-24 04:33:43 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:43 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:44 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:44 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:45 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:45 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:46 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:46 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:47 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:48 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:48 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:49 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:49 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:50 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:51 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:52 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:53 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:53 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:54 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:54 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=19863949&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '399', 'confirmation_code': 1106, 'created_by': 'Abhishek Waghmare', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9399"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b979.8", "items": [{"type": ' '"user_salt_discount", "label": "Pre-book discount", "value": ' '"\\u20b979.8"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9319.2"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9319.2"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b937.66", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b931.92"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b95.74"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9300.37"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 19863949, 'settlement_amount': '300.37', 'status': 'success', 'timestamp': '2025-11-23T16:35:00+00:00', 'transaction_id': 7921233558, 'user_paid_amount': '319.2'} 2025-11-24 04:33:54 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=19863949&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '180', 'confirmation_code': 7018, 'created_by': 'Priyal', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9180"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b927", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b927"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9153"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9153"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b918.06", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b915.3"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b92.76"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9143.97"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 19863949, 'settlement_amount': '143.97', 'status': 'success', 'timestamp': '2025-11-23T16:35:00+00:00', 'transaction_id': 8466262518, 'user_paid_amount': '153'} 2025-11-24 04:33:54 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:55 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=19256913&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '250', 'confirmation_code': 1495, 'created_by': 'Pragathish', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9250"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b937.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b937.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9212.5"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9212.5"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b925.06", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b921.24"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b93.82"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9199.97"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 19256913, 'settlement_amount': '199.97', 'status': 'success', 'timestamp': '2025-11-23T16:12:00+00:00', 'transaction_id': 9789831567, 'user_paid_amount': '212.5'} 2025-11-24 04:33:55 [scrapy.core.scraper] DEBUG: Scraped from <200 https://api.zomato.com/dining-gw/merchant/web/transactions/history?select=transactions&res_id=19256913&start_date=2025-11-23&end_date=2025-11-23&offset=0&limit=10&activeTabId=transactions&service_type=dine_out> {'bill_amount': '210', 'confirmation_code': 7117, 'created_by': 'Ankit Reddy', 'payment_info': '[{"type": "bill_amount", "label": "Bill amount", "value": ' '"\\u20b9210"}, {"type": "discount", "label": "Total ' 'discount", "value": "\\u20b931.5", "items": [{"type": ' '"instant_discount", "label": "Instant discount", "value": ' '"\\u20b931.5"}]}, {"type": "tip_amount", "label": "Tips", ' '"value": ""}, {"type": "user_paid_amount", "label": "Paid ' 'amount", "value": "\\u20b9178.5"}]', 'payout_info': '[{"type": "gross_revenue_a", "label": "Gross revenue after ' 'discounts (A)", "value": "\\u20b9178.5"}, {"type": ' '"additions_b", "label": "Additions (B)", "value": "", ' '"items": [{"type": "tip", "label": "Tip for the staff", ' '"value": ""}]}, {"type": "deductions_b", "label": "Deductions ' '(C)", "value": "\\u20b921.07", "items": [{"type": ' '"commission", "label": "Commission", "value": ' '"-\\u20b917.85"}, {"type": "tax_on_commission", "label": "Tax ' 'on commission", "value": "-\\u20b93.22"}]}, {"type": ' '"net_receivable", "label": "Net receivable (A+B-C)", "value": ' '"\\u20b9167.97"}]', 'payout_settlement_date': '2025-11-26', 'payout_status': 'pending', 'rating': None, 'res_id': 19256913, 'settlement_amount': '167.97', 'status': 'success', 'timestamp': '2025-11-23T12:32:00+00:00', 'transaction_id': 9657946637, 'user_paid_amount': '178.5'} 2025-11-24 04:33:55 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:55 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:56 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:57 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:33:57 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/stats/ HTTP/11" 200 109 2025-11-24 04:33:57 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:57 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:33:58 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:34:00 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://api.zomato.com/dining-gw/merchant/web/restaurants/get-all?page=1&service_type=dine_out) 2025-11-24 04:34:00 [scrapy.core.engine] INFO: Closing spider (finished) 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): cron.restaverse.com:443 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: https://cron.restaverse.com:443 "POST /api/db_services/fetch-query HTTP/11" 200 504 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): cron.restaverse.com:443 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: https://cron.restaverse.com:443 "POST /insert_data/ HTTP/11" 201 112 2025-11-24 04:34:00 [dining_transaction_history_zomato] INFO: Logger Payload: {'run_id': 'c79b1ebf-5318-4b1e-a612-e52f9fb21dee', 'timestamp': '2025-11-24T04:34:00Z', 'spider': 'dining_transaction_history_zomato', 'client_id': '123', 'domain': 'www.zomato.com', 'bytes_sent': 0, 'bytes_received': 70, 'duration_seconds': 33.05, 'host': 'ip-172-31-16-168', 'status': 'finished'} 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: Starting new HTTP connection (1): watchdog.restaverse.com:9200 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: http://watchdog.restaverse.com:9200 "POST /scrapy-2025-11-24/_doc HTTP/11" 201 166 2025-11-24 04:34:00 [dining_transaction_history_zomato] INFO: Logger Payload: {'run_id': 'c79b1ebf-5318-4b1e-a612-e52f9fb21dee', 'timestamp': '2025-11-24T04:34:00Z', 'spider': 'dining_transaction_history_zomato', 'client_id': '123', 'domain': 'api.zomato.com', 'bytes_sent': 0, 'bytes_received': 15028, 'duration_seconds': 33.05, 'host': 'ip-172-31-16-168', 'status': 'finished'} 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: Starting new HTTP connection (1): watchdog.restaverse.com:9200 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: http://watchdog.restaverse.com:9200 "POST /scrapy-2025-11-24/_doc HTTP/11" 201 166 2025-11-24 04:34:00 [urllib3.connectionpool] DEBUG: Starting new HTTPS connection (1): api.scrapeops.io:443 2025-11-24 04:34:01 [urllib3.connectionpool] DEBUG: https://api.scrapeops.io:443 "POST /api/v1/stats/ HTTP/11" 200 109 2025-11-24 04:34:01 [scrapy.statscollectors] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 200454, 'downloader/request_count': 44, 'downloader/request_method_count/GET': 44, 'downloader/response_bytes': 55771, 'downloader/response_count': 45, 'downloader/response_status_count/200': 44, 'downloader/response_status_count/299': 1, 'elapsed_time_seconds': 33.054443, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2025, 11, 24, 4, 34, 0, 425212, tzinfo=datetime.timezone.utc), 'httpcompression/response_bytes': 13512, 'httpcompression/response_count': 6, 'item_scraped_count': 12, 'items_per_minute': None, 'log_count/DEBUG': 131, 'log_count/INFO': 16, 'log_count/WARNING': 1, 'memusage/max': 116289536, 'memusage/startup': 116289536, 'request_depth_max': 3, 'response_received_count': 45, 'responses_per_minute': None, 'scheduler/dequeued': 45, 'scheduler/dequeued/memory': 45, 'scheduler/enqueued': 45, 'scheduler/enqueued/memory': 45, 'start_time': datetime.datetime(2025, 11, 24, 4, 33, 27, 370769, tzinfo=datetime.timezone.utc)} 2025-11-24 04:34:01 [scrapy.core.engine] INFO: Spider closed (finished)