Is there a way to get a list of payments on account along with the transaction memo?

Question

It seems the the transactions for account will give you back a memo, but no way to get the payments info such as the amount without making another API call on the individual payment for transaction.

Right now I am just getting the list of payments for the account but I also want to display the memo. Is there some kind of undocumented include query on the transactions API so it will include payments with it?

Answer 1

The detail of a transaction's operations are encoded in the field envelope_xdr. You can decode this value to obtain the payments and other operations.

For example, this transaction with memo "Fruitcakes for Iguanas" has an envelope_xdr that decodes to show the payment details.

So if you can approach your problem by fetching transactions instead of payments you'll have all the data you need in a single call.

Answer 2

The memo is associated with the transaction, so you'll have to actually pull the transaction for each payment.

Here is some code for how I've handled it in the past with the JS SDK:

function watchForPayments(publicKey, { onPayment, cursor }) {
  const paymentsCallBuilder = server.payments().forAccount(publicKey);

  if (cursor) {
    paymentsCallBuilder.cursor(cursor);
  }

  return paymentsCallBuilder.stream({
    onmessage: async record => {
      const transaction = await record.transaction();

      onPayment({
        memo: transaction.memo,
        amount: record.amount,
        createdAt: new Date(record.created_at),
        asset: record.asset_type,
        cursor: record.paging_token,
        to: record.to,
        from: record.from,
        hash: record.transaction_hash
      });
    }
  });
}

The key part is const transaction = await record.transaction();, which makes another request to get the transaction (which contains the memo) associated with the operation.

Answer 3

I've made Payment Locator tool with public API that exactly matches your case.

Some highlights:

• Lookup by transaction memo, amount, asset, source/destination account.
• Search by a single parameter or a complex criteria.
• All operations are supported: PAYMENT, PATH_PAYMENT, CREATE_ACCOUNT, MERGE_ACCOUNT.
• Find everything, no matter how long ago operations were submitted.
• Works even with deleted(merged) accounts.

If you don't need the API, you can search for payments using simple UI form directly from the browser.