I am trying to get transaction history for the following address 9QgXqrgdbVU8KcpfskqJpAXKzbaYQJecgMAruSWoXDkM from the https://explorer.solana.com website.

I have tried

url="https://explorer.solana.com/address/9QgXqrgdbVU8KcpfskqJpAXKzbaYQJecgMAruSWoXDkM"
output = requests.get(url).text
print(output)

However this gives me raw html output.

How can I get the transactions from the url?

CodePudding user response：

The history data is loaded from external URL via JavaScript. You can use requests module to simulate this call:

import requests
import pandas as pd


api_url = "https://explorer-api.mainnet-beta.solana.com/"

payload = {
    "id": "xxx",
    "jsonrpc": "2.0",
    "method": "getConfirmedSignaturesForAddress2",
    "params": ["9QgXqrgdbVU8KcpfskqJpAXKzbaYQJecgMAruSWoXDkM", {"limit": 25}],
}

data = requests.post(api_url, json=payload).json()

df = pd.DataFrame(data["result"])
df["blockTime"] = pd.to_datetime(df["blockTime"], unit="s")

print(df.to_markdown(index=False))

Prints: