Fetch all Paytm Transactions

paytm_transactions.py

import json
import pandas as pd

from requests import get


URL = "https://paytm.com/v1/api/wallet/txnhistory?page_size=199&page_number={}"
COOKIE = "connect.sid=s%3AofLVI3Sfk29a5WofL892sj6BX0c1ZMgV.tWVDqXZGV3rjZ7g3%2FG4g9FozYcnfblY9Trv8lsuQbKo;" # This is an example. Set this to a valid session cookie.
RAW_RESP = []

resp = get(URL.format("0"), headers={"Cookie": COOKIE}).content
data = json.loads(resp)
RAW_RESP = data['response']
count = 1
while (data['has_next']):
    resp = get(URL.format(str(count)), headers={"Cookie": COOKIE}).content
    data = json.loads(resp)
    RAW_RESP += data['response']
    count += 1

USEFUL_RESP = []
for response in RAW_RESP:
    USEFUL_RESP.append({
        "txnamount" : response['txnamount'],
        "closingBalance" : response['extendedTxnInfo'][0]['closingBalance'],
        "mode" : response['mode'],
        "newNarration" : response['newNarration'],
        "payeeId" : response['payeeId'],
        "txnDescription1" : response['txnDescription1'],
        "txnStatus" : response['txnStatus'],
        "txndate" : response['txndate'],
        "txntype" : response['txntype'],
        "type" : response['type'],
        "walletOrderId" : response['walletOrderId'],
        "txnFrom" : response['txnFrom'],
        "txnTo" : response['txnTo'],
        "totalBalance" : response['totalBalance'],
    })

df = pd.DataFrame.from_dict(USEFUL_RESP)
df.to_csv('transactions.csv')