Advanced search API

Integrate advanced search in your applications.

Query

Example: Search for all Payment transactions with DestinationTag value equal to 1337:

ES Query

curl -XPOST 'https://console.xrpscan.com/api/v1/search' -d '
{
  "bool": {
    "must": [
      { "term": { "TransactionType": "Payment" } },
      { "term": { "DestinationTag": 1337 } }
    ]
  }
}'

Response

{
  "took": 31,
  "timed_out": false,
  "_shards": {
    "total": 98,
    "successful": 98,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 7382,
      "relation": "eq"
    },
    "max_score": null,
    "hits": [
      {
        "_index": "platform.xrpl.transactions-97m",
        "_id": "F2E402B43EDE6EA9E7BD87CDCAA4236834E89236F8ACB3445F558534741C3012",
        "_score": 1.4392471,
        "_source": {
          "Account": "rJHkpNJVRUKMGV3NV6FNccySKNwEFF9C4c",
          "Amount": {
            "_currency": "XRP",
            "_value": 176032.226409,
            "currency": "XRP",
            "native": true,
            "value": "176032226409"
          },
          "DeliverMax": {
            "_currency": "XRP",
            "_value": 176032.226409,
            "currency": "XRP",
            "native": true,
            "value": "176032226409"
          },
          "Destination": "rLHzPsX6oXkzU2qL12kHCH8G8cnZv1rBJh",
          "DestinationTag": 1337,
          "Fee": 24,
                    "Flags": 2147483648,
          "LastLedgerSequence": 97359736,
          "Sequence": 89292640,
          "SigningPubKey": "02ED1CCA3DBC1971D38E72ECF74452739C9A4FD8C77EC2E3C5C4561371BF7B1ADF",
          "TransactionType": "Payment",
          "TxnSignature": "304502210097F5922FA7E0EF817EA5FC678A82766798C3BE0AAC636A2CACE846A98CBED83A02206BC6D2CB3ED8E8E5306D342063549C2BC16F6421B87AA80AAAA9D1F4E457E
619",
          "_Fee": 0.000024,
          "_date": "2025-07-08T12:02:02Z",
          "ctid": "C5CD330800420000",
          "date": 805291322,
          "hash": "F2E402B43EDE6EA9E7BD87CDCAA4236834E89236F8ACB3445F558534741C3012",
          "ledger_index": 97334024,
          "meta": {
            "TransactionIndex": 66,
            "TransactionResult": "tesSUCCESS",
            "delivered_amount": {
              "_currency": "XRP",
              "_value": 176032.226409,
              "currency": "XRP",
              "native": true,
              "value": "176032226409"
            }
          },
          "validated": true
        },
        "sort": [
          97334024,
          1.4392471
        ]
      },
      ...
      ...
    ]
  }
}