PUT Request on Presigned URL
Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More
JSON Payload
This API accepts payload in the following format:
Tradebook
Click here to learn more about this JSON Payload
{
"@entity": "workbook",
"name": "tradebook_workbook",
"sheets": [
{
"name": "crypto_currency_spot_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_spot_tradebook_table",
"@entity": "table",
"header": ["id", "date_epoch", "transaction_type", "label", "received_currency", "received_quantity", "price", "price_currency", "price_in_inr", "sent_currency", "sent_quantity", "fee_currency", "fee_amount", "fee_in_inr"],
"rows": [
["acdcwefew3e1113vcd", 1682985600000, "buy", null, "BTC", 8.4567, 265, "INR", 2241.0254999999997, null, null, "INR", 20, 20],
["nknee38ni9cd3defeve", 1687132800000, "buy", null, "XRP", 9.0123, 58.68, "INR", 528.841764, null, null, "INR", 50, 50],
["nrezxcetgf2334jk0333d", 1690416000000, "sell", null, null, null, 278.98, "INR", 995.3532134000001, "BTC", 3.56783, "INR", 10.4564, 10.4564],
["fwhjceco2trsc344f322e", 1690934400000, "buy", null, "BTC", 10.9873, 309.8, "INR", 3403.86554, null, null, "INR", 288, 288],
["fwhjceco2trsc344f322e", 1690934400000, "sell", null, null, null, 75.35, "INR", 679.0768049999999, "XRP", 6.3544, "INR", 145.89, 145.89],
["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", null, null, null, 48.49, "INR", 65.92700399999998, "XRP", 1.3595999999999997, null, null, null],
["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", null, null, null, 48.49, "INR", 62.954567000000004, "XRP", 1.2983, null, null, null],
["klop3sdcwf23445dwedc", 1594684800000, "buy", null, "ETH", 0.9822, 120.455, "INR", 118.31090099999999, null, null, null, null, null],
["klop3sdcwf2347d12wxbk", 1708646400000, "sell", null, null, null, 511.698, "INR", 233.79481619999999, "ETH", 0.4569, null, null, null],
["efvdf3vmndvnor349023s", 1711843200000, "buy", null, "SOL", 2000, 0.3117, "INR", 623.4, null, null, null, null, null],
["wg3rg43wfege1dbdg33f", 1687392000000, "trade", null, "MATIC", 100, 2.45, "SOL", 88.3669, "SOL", 245, null, null, null],
["gjekbek45vdge32w3fegf", 1692057600000, "send", "staking", null, null, null, null, 560.456, "MATIC", 50, null, null, null],
["egrgrbko4542gfvfg4gv332", 1693008000000, "receive", "staking_reward", "MATIC", 12.568, null, null, 140.8762, null, null, null, null, null],
["efkpfemfpe45efrG3r32f2A", 1695859200000, "receive", "staking", "MATIC", 50, null, null, 715.255, null, null, null, null, null],
["acdcwefew3e1113vcd", 1682985600000, "buy", null, "USDT", 350, 84.311, "INR", 29508.850000000002, null, null, "INR", 20, 20],
["nknee38ni9cd3defeve", 1687132800000, "sell", null, null, null, 85.23, "INR", 4261.5, "USDT", 50, "INR", 50, 50],
["kyjrtgew45568efeg12ds", 1687219200000, "send", "margin", null, null, 84.311, "INR", 5901.77, "USDT", 70, null, null, null],
["hjdj0plsejw3n227890c", 1687824000000, "receive", "margin", "USDT", 70, 84.311, "INR", 5901.77, null, null, null, null, null],
["nrezxcetgf2334jk0333d", 1690416000000, "receive", "margin_gain", "USDT", 40, 85, "INR", 3400, null, null, null, null, null],
["fwhjceco2trsc344f322e", 1690934400000, "send", "margin", "USDT", null, 86.55, "INR", 13848, "USDT", 160, null, null, null],
["fwhjceco2trsc344f322e", 1691020800000, "sell", null, null, null, 88, "INR", 8800, "USDT", 100, "INR", 145.89, 145.89],
["zxc1rtvmk3456hkkve3w", 1691020800000, "send", "margin", null, null, 88.35, "INR", 4417.5, "USDT", 50, null, null, null],
["zxc1rtvmk3456hkkve3w", 1694131200000, "receive", "margin", "USDT", 160, 86.55, "INR", 13848, null, null, null, null, null],
["klop3sdcwf23445dwedc", 1694131200000, "send", "margin_loss", null, null, 89, "INR", 4450, "USDT", 50, null, null, null],
["klop3sdcwf2347d12wxbk", 1708646400000, "sell", null, null, null, 91.09, "INR", 3643.6000000000004, "USDT", 40, null, null, null]
]
},
{
"name": "crypto_currency_spot_last_traded_price_list",
"@entity": "list",
"items": [
["cryptocurrency_name", "last_traded_price"],
["BTC", 299.785],
["USDT", 95.45],
["XRP", 38.45],
["SOL", 0.0145],
["ETH", 89.566],
["MATIC", 1256.789]
]
}
]
},
{
"name": "crypto_currency_future_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_future_tradebook_table",
"@entity": "table",
"header": ["id", "contract_name", "date_epoch", "transaction_type", "quantity", "price", "price_currency", "price_in_inr", "fee_amount", "fee_currency", "fee_in_inr"],
"rows": [
["addf3434mkvefv456h", "BTC-USDT", 1687219200000, "buy", 1, 70, "USDT", 5901.77, 1000, "INR", 1000],
["fege4343gbgee344tg", "BTC-USDT", 1687305600000, "sell", 1, 110, "USDT", 9350, 400, "INR", 400],
["fhtyjrg35n788985gff3", "ETH-USDT", 1690934400000, "buy", 3, 160, "USDT", 14640, 500, "INR", 500],
["fhtyjrg35n788985gff4", "XRP-USDT", 1691020800000, "buy", 2, 65, "USDT", 5742.75, 233, "INR", 233],
["fhtyjrg35n788985gff5", "ETH-USDT", 1694131200000, "sell", 3, 110, "USDT", 9790, null, null, null]
]
},
{
"name": "crypto_currency_future_last_traded_price_list",
"@entity": "list",
"items": [
["contract_name", "last_traded_price"],
["BTC-USDT", 145],
["XRP-USDT", 85]
]
}
]
}
]
}