Tried to fetch transaction of a certain address with Trongrid API but got following error
Error executing query error: value "13200000000000000000" is out of range for type bigint
I’m really confused with how and where from this value comes. Any help is appreciated!
My code for fetching:
async function searchTxTRC20(network_id, walletAddressTemp) {
network_id = 5000;
try {
const config = {
headers: {
'TRON-PRO-API-KEY': ''
}
};
const limit = 200;
let transactions = [];
let moreTransactions = true;
let url = `https://api.trongrid.io/v1/accounts/` + walletAddressTemp + `/transactions/trc20?&only_confirmed=true&only_to=true&limit=200`;
while (moreTransactions) {
const response = await axios.get(url, config);
await new Promise(resolve => setTimeout(resolve, 100));
if (response.data && response.data.data && response.data.data.length > 0 && response.data.meta.links) {
console.log(response.data.data.length, " ", response.data.meta.at, " ", transactions.length)
console.log(url)
console.log(transactions.slice(-1))
transactions = transactions.concat(response.data.data);
url = response.data.meta.links.next
} else {
moreTransactions = false;
}
}
for (const t of transactions) {
await addTxTRC20(t, network_id);
}
console.log(`Finished download.`);
} catch (err) {
console.error('Error executing query', err.stack);
}
}
exports.searchTxTRC20 = searchTxTRC20;
addTxTRC20 = async function(trx, network_id, block_num_input = -1){
const contract_addr = fromHEX(trx.token_info.address)
const to = fromHEX(trx.to)
const from = fromHEX(trx.from)
const t = await pool.query(
"SELECT * FROM f_add_tx($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12)",
[
trx.transaction_id,
+trx.block_timestamp,
+network_id,
from,
to,
contract_addr,
parseInt(trx.value),
allToHEX(trx.value),
(trx.blockNumber !== undefined) ? trx.blockNumber : -1,
0,
'',
trx.type
]
)
console.log('tx_id is :',t.rows[0].id)
}
exports.addTxTRC20 = addTxTRC20
add tx to table function:
create function f_add_tx(v_hash character varying, v_ts bigint, v_network_id smallint, v_address_from character varying, v_address_to character varying, v_token character varying, v_value bigint, v_value_txt character varying, v_block integer, v_tx_fee numeric, v_tx_fee_txt character varying, v_info character varying) returns tx
language plpgsql
as
$$
DECLARE
v_result tx%ROWTYPE;
v_t tokens%ROWTYPE;
BEGIN
IF v_hash ISNULL THEN
RAISE 'Wrong parameters. hash: %', v_hash USING ERRCODE = '23502';
END IF;
SELECT * FROM tx WHERE token_id = 0 AND network_id = v_network_id AND hash = v_hash INTO v_result; -- token_id = 0
IF v_result.id IS NULL THEN
SELECT * from tokens WHERE network_id = v_network_id AND id = 0 AND contract IS NULL INTO v_t;
IF v_t.id IS NULL THEN
INSERT INTO tokens(id, network_id, contract)
values (0, v_network_id, v_token)
returning * INTO v_t;
end if;
v_result.token_id = v_t.id;
IF v_address_to IS NULL THEN
v_address_to = 0;
END IF;
SELECT id from addresses WHERE v_address_to = address INTO v_result.to_id;
IF v_result.to_id IS NULL THEN
INSERT INTO addresses(address, network_id)
values(v_address_to,v_network_id)
returning id INTO v_result.to_id;
end if;
SELECT id from addresses WHERE v_address_from = address INTO v_result.from_id;
IF v_result.from_id IS NULL THEN
INSERT INTO addresses(address, network_id)
values(v_address_from,v_network_id)
returning id INTO v_result.from_id;
end if;
INSERT INTO tx(from_id, to_id, network_id, value, value_txt, block, hash, token_id, tx_fee, tx_fee_txt, ts, info)
VALUES(v_result.from_id, v_result.to_id, v_network_id, v_value/(10^v_t.decimals), v_value_txt, v_block, v_hash, v_result.token_id, v_tx_fee/ (10^v_t.decimals), v_tx_fee_txt, v_ts, v_info)
RETURNING id INTO v_result.id;
END IF;
RETURN v_result;
END
$$;
