Submit Tax P&L Job
curl --request POST \
--url https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <x-api-key>' \
--header 'x-api-version: <x-api-version>' \
--data '
{
"@entity": "workbook",
"name": "crypto_currency_tradebook_workbook",
"sheets": [
{
"name": "spot_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "spot_tradebook_table",
"@entity": "table",
"header": [
"id",
"date",
"transaction_type",
"label",
"received_currency",
"received_quantity",
"price",
"price_currency",
"price_inr",
"sent_currency",
"sent_quantity",
"fee_currency",
"fee_amount",
"fee_amount_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.3596,
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,
"INR",
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.85,
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": "spot_last_traded_price_table",
"@entity": "table",
"header": [
"symbol",
"currency",
"last_traded_price",
"last_traded_price_inr"
],
"rows": [
[
"BTC",
"INR",
299.785,
299.785
],
[
"USDT",
"INR",
95.45,
95.45
],
[
"XRP",
"INR",
38.45,
38.45
],
[
"SOL",
"INR",
0.0145,
0.0145
],
[
"ETH",
"INR",
89.566,
89.566
],
[
"MATIC",
"INR",
1256.789,
1256.789
]
]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradebook_table",
"@entity": "table",
"header": [
"id",
"contract_name",
"transaction_type",
"date",
"quantity",
"price",
"price_currency",
"price_inr",
"fee_amount",
"fee_currency",
"fee_amount_inr"
],
"rows": [
[
"addf3434mkvefv456h",
"BTC-USDT",
"buy",
1687219200000,
1,
70,
"USDT",
5901.77,
1000,
"INR",
1000
],
[
"fege4343gbgee344tg",
"BTC-USDT",
"sell",
1687305600000,
1,
110,
"USDT",
9350,
400,
"INR",
400
],
[
"fhtyjrg35n788985gff3",
"ETH-USDT",
"buy",
1690934400000,
3,
160,
"USDT",
14640,
500,
"INR",
500
],
[
"fhtyjrg35n788985gff4",
"XRP-USDT",
"buy",
1691020800000,
2,
65,
"USDT",
5742.75,
233,
"INR",
233
],
[
"fhtyjrg35n788985gff5",
"ETH-USDT",
"sell",
1694131200000,
3,
110,
"USDT",
9790,
null,
null,
null
]
]
},
{
"name": "future_last_traded_price_table",
"@entity": "table",
"header": [
"contract_name",
"currency",
"last_traded_price",
"last_traded_price_inr"
],
"rows": [
[
"BTC-USDT",
"USDT",
145,
145
],
[
"XRP-USDT",
"USDT",
85,
85
]
]
}
]
}
]
}
'import requests
url = "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto"
payload = {
"@entity": "workbook",
"name": "crypto_currency_tradebook_workbook",
"sheets": [
{
"name": "spot_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "spot_tradebook_table",
"@entity": "table",
"header": ["id", "date", "transaction_type", "label", "received_currency", "received_quantity", "price", "price_currency", "price_inr", "sent_currency", "sent_quantity", "fee_currency", "fee_amount", "fee_amount_inr"],
"rows": [["acdcwefew3e1113vcd", 1682985600000, "buy", None, "BTC", 8.4567, 265, "INR", 2241.0254999999997, None, None, "INR", 20, 20], ["nknee38ni9cd3defeve", 1687132800000, "buy", None, "XRP", 9.0123, 58.68, "INR", 528.841764, None, None, "INR", 50, 50], ["nrezxcetgf2334jk0333d", 1690416000000, "sell", None, None, None, 278.98, "INR", 995.3532134000001, "BTC", 3.56783, "INR", 10.4564, 10.4564], ["fwhjceco2trsc344f322e", 1690934400000, "buy", None, "BTC", 10.9873, 309.8, "INR", 3403.86554, None, None, "INR", 288, 288], ["fwhjceco2trsc344f322e", 1690934400000, "sell", None, None, None, 75.35, "INR", 679.0768049999999, "XRP", 6.3544, "INR", 145.89, 145.89], ["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", None, None, None, 48.49, "INR", 65.92700399999998, "XRP", 1.3596, None, None, None], ["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", None, None, None, 48.49, "INR", 62.954567000000004, "XRP", 1.2983, None, None, None], ["klop3sdcwf23445dwedc", 1594684800000, "buy", None, "ETH", 0.9822, 120.455, "INR", 118.31090099999999, None, None, None, None, None], ["klop3sdcwf2347d12wxbk", 1708646400000, "sell", None, None, None, 511.698, "INR", 233.79481619999999, "ETH", 0.4569, None, None, None], ["efvdf3vmndvnor349023s", 1711843200000, "buy", None, "SOL", 2000, 0.3117, "INR", 623.4, None, None, None, None, None], ["wg3rg43wfege1dbdg33f", 1687392000000, "trade", None, "MATIC", 100, 2.45, "SOL", 88.3669, "SOL", 245, None, None, None], ["gjekbek45vdge32w3fegf", 1692057600000, "send", "staking", None, None, None, "INR", 560.456, "MATIC", 50, None, None, None], ["egrgrbko4542gfvfg4gv332", 1693008000000, "receive", "staking_reward", "MATIC", 12.568, None, None, 140.8762, None, None, None, None, None], ["efkpfemfpe45efrG3r32f2A", 1695859200000, "receive", "staking", "MATIC", 50, None, None, 715.255, None, None, None, None, None], ["acdcwefew3e1113vcd", 1682985600000, "buy", None, "USDT", 350, 84.311, "INR", 29508.85, None, None, "INR", 20, 20], ["nknee38ni9cd3defeve", 1687132800000, "sell", None, None, None, 85.23, "INR", 4261.5, "USDT", 50, "INR", 50, 50], ["kyjrtgew45568efeg12ds", 1687219200000, "send", "margin", None, None, 84.311, "INR", 5901.77, "USDT", 70, None, None, None], ["hjdj0plsejw3n227890c", 1687824000000, "receive", "margin", "USDT", 70, 84.311, "INR", 5901.77, None, None, None, None, None], ["nrezxcetgf2334jk0333d", 1690416000000, "receive", "margin_gain", "USDT", 40, 85, "INR", 3400, None, None, None, None, None], ["fwhjceco2trsc344f322e", 1690934400000, "send", "margin", "USDT", None, 86.55, "INR", 13848, "USDT", 160, None, None, None], ["fwhjceco2trsc344f322e", 1691020800000, "sell", None, None, None, 88, "INR", 8800, "USDT", 100, "INR", 145.89, 145.89], ["zxc1rtvmk3456hkkve3w", 1691020800000, "send", "margin", None, None, 88.35, "INR", 4417.5, "USDT", 50, None, None, None], ["zxc1rtvmk3456hkkve3w", 1694131200000, "receive", "margin", "USDT", 160, 86.55, "INR", 13848, None, None, None, None, None], ["klop3sdcwf23445dwedc", 1694131200000, "send", "margin_loss", None, None, 89, "INR", 4450, "USDT", 50, None, None, None], ["klop3sdcwf2347d12wxbk", 1708646400000, "sell", None, None, None, 91.09, "INR", 3643.6000000000004, "USDT", 40, None, None, None]]
},
{
"name": "spot_last_traded_price_table",
"@entity": "table",
"header": ["symbol", "currency", "last_traded_price", "last_traded_price_inr"],
"rows": [["BTC", "INR", 299.785, 299.785], ["USDT", "INR", 95.45, 95.45], ["XRP", "INR", 38.45, 38.45], ["SOL", "INR", 0.0145, 0.0145], ["ETH", "INR", 89.566, 89.566], ["MATIC", "INR", 1256.789, 1256.789]]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradebook_table",
"@entity": "table",
"header": ["id", "contract_name", "transaction_type", "date", "quantity", "price", "price_currency", "price_inr", "fee_amount", "fee_currency", "fee_amount_inr"],
"rows": [["addf3434mkvefv456h", "BTC-USDT", "buy", 1687219200000, 1, 70, "USDT", 5901.77, 1000, "INR", 1000], ["fege4343gbgee344tg", "BTC-USDT", "sell", 1687305600000, 1, 110, "USDT", 9350, 400, "INR", 400], ["fhtyjrg35n788985gff3", "ETH-USDT", "buy", 1690934400000, 3, 160, "USDT", 14640, 500, "INR", 500], ["fhtyjrg35n788985gff4", "XRP-USDT", "buy", 1691020800000, 2, 65, "USDT", 5742.75, 233, "INR", 233], ["fhtyjrg35n788985gff5", "ETH-USDT", "sell", 1694131200000, 3, 110, "USDT", 9790, None, None, None]]
},
{
"name": "future_last_traded_price_table",
"@entity": "table",
"header": ["contract_name", "currency", "last_traded_price", "last_traded_price_inr"],
"rows": [["BTC-USDT", "USDT", 145, 145], ["XRP-USDT", "USDT", 85, 85]]
}
]
}
]
}
headers = {
"x-api-key": "<x-api-key>",
"x-api-version": "<x-api-version>",
"Authorization": "<authorization>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {
'x-api-key': '<x-api-key>',
'x-api-version': '<x-api-version>',
Authorization: '<authorization>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
'@entity': 'workbook',
name: 'crypto_currency_tradebook_workbook',
sheets: [
{
name: 'spot_sheet',
'@entity': 'sheet',
blocks: [
{
name: 'spot_tradebook_table',
'@entity': 'table',
header: [
'id',
'date',
'transaction_type',
'label',
'received_currency',
'received_quantity',
'price',
'price_currency',
'price_inr',
'sent_currency',
'sent_quantity',
'fee_currency',
'fee_amount',
'fee_amount_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.3596,
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,
'INR',
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.85,
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: 'spot_last_traded_price_table',
'@entity': 'table',
header: ['symbol', 'currency', 'last_traded_price', 'last_traded_price_inr'],
rows: [
['BTC', 'INR', 299.785, 299.785],
['USDT', 'INR', 95.45, 95.45],
['XRP', 'INR', 38.45, 38.45],
['SOL', 'INR', 0.0145, 0.0145],
['ETH', 'INR', 89.566, 89.566],
['MATIC', 'INR', 1256.789, 1256.789]
]
}
]
},
{
name: 'future_sheet',
'@entity': 'sheet',
blocks: [
{
name: 'future_tradebook_table',
'@entity': 'table',
header: [
'id',
'contract_name',
'transaction_type',
'date',
'quantity',
'price',
'price_currency',
'price_inr',
'fee_amount',
'fee_currency',
'fee_amount_inr'
],
rows: [
[
'addf3434mkvefv456h',
'BTC-USDT',
'buy',
1687219200000,
1,
70,
'USDT',
5901.77,
1000,
'INR',
1000
],
[
'fege4343gbgee344tg',
'BTC-USDT',
'sell',
1687305600000,
1,
110,
'USDT',
9350,
400,
'INR',
400
],
[
'fhtyjrg35n788985gff3',
'ETH-USDT',
'buy',
1690934400000,
3,
160,
'USDT',
14640,
500,
'INR',
500
],
[
'fhtyjrg35n788985gff4',
'XRP-USDT',
'buy',
1691020800000,
2,
65,
'USDT',
5742.75,
233,
'INR',
233
],
[
'fhtyjrg35n788985gff5',
'ETH-USDT',
'sell',
1694131200000,
3,
110,
'USDT',
9790,
null,
null,
null
]
]
},
{
name: 'future_last_traded_price_table',
'@entity': 'table',
header: ['contract_name', 'currency', 'last_traded_price', 'last_traded_price_inr'],
rows: [['BTC-USDT', 'USDT', 145, 145], ['XRP-USDT', 'USDT', 85, 85]]
}
]
}
]
})
};
fetch('https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'@entity' => 'workbook',
'name' => 'crypto_currency_tradebook_workbook',
'sheets' => [
[
'name' => 'spot_sheet',
'@entity' => 'sheet',
'blocks' => [
[
'name' => 'spot_tradebook_table',
'@entity' => 'table',
'header' => [
'id',
'date',
'transaction_type',
'label',
'received_currency',
'received_quantity',
'price',
'price_currency',
'price_inr',
'sent_currency',
'sent_quantity',
'fee_currency',
'fee_amount',
'fee_amount_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.3596,
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,
'INR',
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.85,
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' => 'spot_last_traded_price_table',
'@entity' => 'table',
'header' => [
'symbol',
'currency',
'last_traded_price',
'last_traded_price_inr'
],
'rows' => [
[
'BTC',
'INR',
299.785,
299.785
],
[
'USDT',
'INR',
95.45,
95.45
],
[
'XRP',
'INR',
38.45,
38.45
],
[
'SOL',
'INR',
0.0145,
0.0145
],
[
'ETH',
'INR',
89.566,
89.566
],
[
'MATIC',
'INR',
1256.789,
1256.789
]
]
]
]
],
[
'name' => 'future_sheet',
'@entity' => 'sheet',
'blocks' => [
[
'name' => 'future_tradebook_table',
'@entity' => 'table',
'header' => [
'id',
'contract_name',
'transaction_type',
'date',
'quantity',
'price',
'price_currency',
'price_inr',
'fee_amount',
'fee_currency',
'fee_amount_inr'
],
'rows' => [
[
'addf3434mkvefv456h',
'BTC-USDT',
'buy',
1687219200000,
1,
70,
'USDT',
5901.77,
1000,
'INR',
1000
],
[
'fege4343gbgee344tg',
'BTC-USDT',
'sell',
1687305600000,
1,
110,
'USDT',
9350,
400,
'INR',
400
],
[
'fhtyjrg35n788985gff3',
'ETH-USDT',
'buy',
1690934400000,
3,
160,
'USDT',
14640,
500,
'INR',
500
],
[
'fhtyjrg35n788985gff4',
'XRP-USDT',
'buy',
1691020800000,
2,
65,
'USDT',
5742.75,
233,
'INR',
233
],
[
'fhtyjrg35n788985gff5',
'ETH-USDT',
'sell',
1694131200000,
3,
110,
'USDT',
9790,
null,
null,
null
]
]
],
[
'name' => 'future_last_traded_price_table',
'@entity' => 'table',
'header' => [
'contract_name',
'currency',
'last_traded_price',
'last_traded_price_inr'
],
'rows' => [
[
'BTC-USDT',
'USDT',
145,
145
],
[
'XRP-USDT',
'USDT',
85,
85
]
]
]
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <authorization>",
"Content-Type: application/json",
"x-api-key: <x-api-key>",
"x-api-version: <x-api-version>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto"
payload := strings.NewReader("{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-api-key", "<x-api-key>")
req.Header.Add("x-api-version", "<x-api-version>")
req.Header.Add("Authorization", "<authorization>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto")
.header("x-api-key", "<x-api-key>")
.header("x-api-version", "<x-api-version>")
.header("Authorization", "<authorization>")
.header("Content-Type", "application/json")
.body("{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-api-key"] = '<x-api-key>'
request["x-api-version"] = '<x-api-version>'
request["Authorization"] = '<authorization>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"code": 200,
"timestamp": 1676979940157,
"transaction_id": "c01f847c-c42e-4577-9d01-a7208401a922",
"data": {
"@entity": "in.co.sandbox.it.calculator.cryto.tax_pnl.job",
"job_id": "c01f847c-c42e-4577-9d01-a7208401a922",
"report": "tradewise",
"from": 1682945614000,
"to": 1683291214000,
"status": "created",
"tradebook_url": "https://test-api.sandbox.co.in/it/calculator/in-co-sandbox-it-calculator-crypto-tax-pnl-dev/c01f847c-c42e-4577-9d01-a7208401a922.json"
}
}{
"code": 422,
"timestamp": 1619519433924,
"transaction_id": "328e459b-5be7-4658-b490-ceee6adbc0a8",
"message": "Invalid report: tradewize"
}Create a crypto Tax P&L calculation job by sending the report type, date window, and auth headers; the response returns a job_id, status, and the presigned tradebook_url you’ll use to upload your payload before processing begins.
POST
/
it
/
calculator
/
tax-pnl
/
crypto
Submit Tax P&L Job
curl --request POST \
--url https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <x-api-key>' \
--header 'x-api-version: <x-api-version>' \
--data '
{
"@entity": "workbook",
"name": "crypto_currency_tradebook_workbook",
"sheets": [
{
"name": "spot_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "spot_tradebook_table",
"@entity": "table",
"header": [
"id",
"date",
"transaction_type",
"label",
"received_currency",
"received_quantity",
"price",
"price_currency",
"price_inr",
"sent_currency",
"sent_quantity",
"fee_currency",
"fee_amount",
"fee_amount_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.3596,
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,
"INR",
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.85,
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": "spot_last_traded_price_table",
"@entity": "table",
"header": [
"symbol",
"currency",
"last_traded_price",
"last_traded_price_inr"
],
"rows": [
[
"BTC",
"INR",
299.785,
299.785
],
[
"USDT",
"INR",
95.45,
95.45
],
[
"XRP",
"INR",
38.45,
38.45
],
[
"SOL",
"INR",
0.0145,
0.0145
],
[
"ETH",
"INR",
89.566,
89.566
],
[
"MATIC",
"INR",
1256.789,
1256.789
]
]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradebook_table",
"@entity": "table",
"header": [
"id",
"contract_name",
"transaction_type",
"date",
"quantity",
"price",
"price_currency",
"price_inr",
"fee_amount",
"fee_currency",
"fee_amount_inr"
],
"rows": [
[
"addf3434mkvefv456h",
"BTC-USDT",
"buy",
1687219200000,
1,
70,
"USDT",
5901.77,
1000,
"INR",
1000
],
[
"fege4343gbgee344tg",
"BTC-USDT",
"sell",
1687305600000,
1,
110,
"USDT",
9350,
400,
"INR",
400
],
[
"fhtyjrg35n788985gff3",
"ETH-USDT",
"buy",
1690934400000,
3,
160,
"USDT",
14640,
500,
"INR",
500
],
[
"fhtyjrg35n788985gff4",
"XRP-USDT",
"buy",
1691020800000,
2,
65,
"USDT",
5742.75,
233,
"INR",
233
],
[
"fhtyjrg35n788985gff5",
"ETH-USDT",
"sell",
1694131200000,
3,
110,
"USDT",
9790,
null,
null,
null
]
]
},
{
"name": "future_last_traded_price_table",
"@entity": "table",
"header": [
"contract_name",
"currency",
"last_traded_price",
"last_traded_price_inr"
],
"rows": [
[
"BTC-USDT",
"USDT",
145,
145
],
[
"XRP-USDT",
"USDT",
85,
85
]
]
}
]
}
]
}
'import requests
url = "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto"
payload = {
"@entity": "workbook",
"name": "crypto_currency_tradebook_workbook",
"sheets": [
{
"name": "spot_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "spot_tradebook_table",
"@entity": "table",
"header": ["id", "date", "transaction_type", "label", "received_currency", "received_quantity", "price", "price_currency", "price_inr", "sent_currency", "sent_quantity", "fee_currency", "fee_amount", "fee_amount_inr"],
"rows": [["acdcwefew3e1113vcd", 1682985600000, "buy", None, "BTC", 8.4567, 265, "INR", 2241.0254999999997, None, None, "INR", 20, 20], ["nknee38ni9cd3defeve", 1687132800000, "buy", None, "XRP", 9.0123, 58.68, "INR", 528.841764, None, None, "INR", 50, 50], ["nrezxcetgf2334jk0333d", 1690416000000, "sell", None, None, None, 278.98, "INR", 995.3532134000001, "BTC", 3.56783, "INR", 10.4564, 10.4564], ["fwhjceco2trsc344f322e", 1690934400000, "buy", None, "BTC", 10.9873, 309.8, "INR", 3403.86554, None, None, "INR", 288, 288], ["fwhjceco2trsc344f322e", 1690934400000, "sell", None, None, None, 75.35, "INR", 679.0768049999999, "XRP", 6.3544, "INR", 145.89, 145.89], ["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", None, None, None, 48.49, "INR", 65.92700399999998, "XRP", 1.3596, None, None, None], ["zxc1rtvmk3456hkkve3w", 1696291200000, "sell", None, None, None, 48.49, "INR", 62.954567000000004, "XRP", 1.2983, None, None, None], ["klop3sdcwf23445dwedc", 1594684800000, "buy", None, "ETH", 0.9822, 120.455, "INR", 118.31090099999999, None, None, None, None, None], ["klop3sdcwf2347d12wxbk", 1708646400000, "sell", None, None, None, 511.698, "INR", 233.79481619999999, "ETH", 0.4569, None, None, None], ["efvdf3vmndvnor349023s", 1711843200000, "buy", None, "SOL", 2000, 0.3117, "INR", 623.4, None, None, None, None, None], ["wg3rg43wfege1dbdg33f", 1687392000000, "trade", None, "MATIC", 100, 2.45, "SOL", 88.3669, "SOL", 245, None, None, None], ["gjekbek45vdge32w3fegf", 1692057600000, "send", "staking", None, None, None, "INR", 560.456, "MATIC", 50, None, None, None], ["egrgrbko4542gfvfg4gv332", 1693008000000, "receive", "staking_reward", "MATIC", 12.568, None, None, 140.8762, None, None, None, None, None], ["efkpfemfpe45efrG3r32f2A", 1695859200000, "receive", "staking", "MATIC", 50, None, None, 715.255, None, None, None, None, None], ["acdcwefew3e1113vcd", 1682985600000, "buy", None, "USDT", 350, 84.311, "INR", 29508.85, None, None, "INR", 20, 20], ["nknee38ni9cd3defeve", 1687132800000, "sell", None, None, None, 85.23, "INR", 4261.5, "USDT", 50, "INR", 50, 50], ["kyjrtgew45568efeg12ds", 1687219200000, "send", "margin", None, None, 84.311, "INR", 5901.77, "USDT", 70, None, None, None], ["hjdj0plsejw3n227890c", 1687824000000, "receive", "margin", "USDT", 70, 84.311, "INR", 5901.77, None, None, None, None, None], ["nrezxcetgf2334jk0333d", 1690416000000, "receive", "margin_gain", "USDT", 40, 85, "INR", 3400, None, None, None, None, None], ["fwhjceco2trsc344f322e", 1690934400000, "send", "margin", "USDT", None, 86.55, "INR", 13848, "USDT", 160, None, None, None], ["fwhjceco2trsc344f322e", 1691020800000, "sell", None, None, None, 88, "INR", 8800, "USDT", 100, "INR", 145.89, 145.89], ["zxc1rtvmk3456hkkve3w", 1691020800000, "send", "margin", None, None, 88.35, "INR", 4417.5, "USDT", 50, None, None, None], ["zxc1rtvmk3456hkkve3w", 1694131200000, "receive", "margin", "USDT", 160, 86.55, "INR", 13848, None, None, None, None, None], ["klop3sdcwf23445dwedc", 1694131200000, "send", "margin_loss", None, None, 89, "INR", 4450, "USDT", 50, None, None, None], ["klop3sdcwf2347d12wxbk", 1708646400000, "sell", None, None, None, 91.09, "INR", 3643.6000000000004, "USDT", 40, None, None, None]]
},
{
"name": "spot_last_traded_price_table",
"@entity": "table",
"header": ["symbol", "currency", "last_traded_price", "last_traded_price_inr"],
"rows": [["BTC", "INR", 299.785, 299.785], ["USDT", "INR", 95.45, 95.45], ["XRP", "INR", 38.45, 38.45], ["SOL", "INR", 0.0145, 0.0145], ["ETH", "INR", 89.566, 89.566], ["MATIC", "INR", 1256.789, 1256.789]]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradebook_table",
"@entity": "table",
"header": ["id", "contract_name", "transaction_type", "date", "quantity", "price", "price_currency", "price_inr", "fee_amount", "fee_currency", "fee_amount_inr"],
"rows": [["addf3434mkvefv456h", "BTC-USDT", "buy", 1687219200000, 1, 70, "USDT", 5901.77, 1000, "INR", 1000], ["fege4343gbgee344tg", "BTC-USDT", "sell", 1687305600000, 1, 110, "USDT", 9350, 400, "INR", 400], ["fhtyjrg35n788985gff3", "ETH-USDT", "buy", 1690934400000, 3, 160, "USDT", 14640, 500, "INR", 500], ["fhtyjrg35n788985gff4", "XRP-USDT", "buy", 1691020800000, 2, 65, "USDT", 5742.75, 233, "INR", 233], ["fhtyjrg35n788985gff5", "ETH-USDT", "sell", 1694131200000, 3, 110, "USDT", 9790, None, None, None]]
},
{
"name": "future_last_traded_price_table",
"@entity": "table",
"header": ["contract_name", "currency", "last_traded_price", "last_traded_price_inr"],
"rows": [["BTC-USDT", "USDT", 145, 145], ["XRP-USDT", "USDT", 85, 85]]
}
]
}
]
}
headers = {
"x-api-key": "<x-api-key>",
"x-api-version": "<x-api-version>",
"Authorization": "<authorization>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {
'x-api-key': '<x-api-key>',
'x-api-version': '<x-api-version>',
Authorization: '<authorization>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
'@entity': 'workbook',
name: 'crypto_currency_tradebook_workbook',
sheets: [
{
name: 'spot_sheet',
'@entity': 'sheet',
blocks: [
{
name: 'spot_tradebook_table',
'@entity': 'table',
header: [
'id',
'date',
'transaction_type',
'label',
'received_currency',
'received_quantity',
'price',
'price_currency',
'price_inr',
'sent_currency',
'sent_quantity',
'fee_currency',
'fee_amount',
'fee_amount_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.3596,
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,
'INR',
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.85,
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: 'spot_last_traded_price_table',
'@entity': 'table',
header: ['symbol', 'currency', 'last_traded_price', 'last_traded_price_inr'],
rows: [
['BTC', 'INR', 299.785, 299.785],
['USDT', 'INR', 95.45, 95.45],
['XRP', 'INR', 38.45, 38.45],
['SOL', 'INR', 0.0145, 0.0145],
['ETH', 'INR', 89.566, 89.566],
['MATIC', 'INR', 1256.789, 1256.789]
]
}
]
},
{
name: 'future_sheet',
'@entity': 'sheet',
blocks: [
{
name: 'future_tradebook_table',
'@entity': 'table',
header: [
'id',
'contract_name',
'transaction_type',
'date',
'quantity',
'price',
'price_currency',
'price_inr',
'fee_amount',
'fee_currency',
'fee_amount_inr'
],
rows: [
[
'addf3434mkvefv456h',
'BTC-USDT',
'buy',
1687219200000,
1,
70,
'USDT',
5901.77,
1000,
'INR',
1000
],
[
'fege4343gbgee344tg',
'BTC-USDT',
'sell',
1687305600000,
1,
110,
'USDT',
9350,
400,
'INR',
400
],
[
'fhtyjrg35n788985gff3',
'ETH-USDT',
'buy',
1690934400000,
3,
160,
'USDT',
14640,
500,
'INR',
500
],
[
'fhtyjrg35n788985gff4',
'XRP-USDT',
'buy',
1691020800000,
2,
65,
'USDT',
5742.75,
233,
'INR',
233
],
[
'fhtyjrg35n788985gff5',
'ETH-USDT',
'sell',
1694131200000,
3,
110,
'USDT',
9790,
null,
null,
null
]
]
},
{
name: 'future_last_traded_price_table',
'@entity': 'table',
header: ['contract_name', 'currency', 'last_traded_price', 'last_traded_price_inr'],
rows: [['BTC-USDT', 'USDT', 145, 145], ['XRP-USDT', 'USDT', 85, 85]]
}
]
}
]
})
};
fetch('https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'@entity' => 'workbook',
'name' => 'crypto_currency_tradebook_workbook',
'sheets' => [
[
'name' => 'spot_sheet',
'@entity' => 'sheet',
'blocks' => [
[
'name' => 'spot_tradebook_table',
'@entity' => 'table',
'header' => [
'id',
'date',
'transaction_type',
'label',
'received_currency',
'received_quantity',
'price',
'price_currency',
'price_inr',
'sent_currency',
'sent_quantity',
'fee_currency',
'fee_amount',
'fee_amount_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.3596,
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,
'INR',
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.85,
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' => 'spot_last_traded_price_table',
'@entity' => 'table',
'header' => [
'symbol',
'currency',
'last_traded_price',
'last_traded_price_inr'
],
'rows' => [
[
'BTC',
'INR',
299.785,
299.785
],
[
'USDT',
'INR',
95.45,
95.45
],
[
'XRP',
'INR',
38.45,
38.45
],
[
'SOL',
'INR',
0.0145,
0.0145
],
[
'ETH',
'INR',
89.566,
89.566
],
[
'MATIC',
'INR',
1256.789,
1256.789
]
]
]
]
],
[
'name' => 'future_sheet',
'@entity' => 'sheet',
'blocks' => [
[
'name' => 'future_tradebook_table',
'@entity' => 'table',
'header' => [
'id',
'contract_name',
'transaction_type',
'date',
'quantity',
'price',
'price_currency',
'price_inr',
'fee_amount',
'fee_currency',
'fee_amount_inr'
],
'rows' => [
[
'addf3434mkvefv456h',
'BTC-USDT',
'buy',
1687219200000,
1,
70,
'USDT',
5901.77,
1000,
'INR',
1000
],
[
'fege4343gbgee344tg',
'BTC-USDT',
'sell',
1687305600000,
1,
110,
'USDT',
9350,
400,
'INR',
400
],
[
'fhtyjrg35n788985gff3',
'ETH-USDT',
'buy',
1690934400000,
3,
160,
'USDT',
14640,
500,
'INR',
500
],
[
'fhtyjrg35n788985gff4',
'XRP-USDT',
'buy',
1691020800000,
2,
65,
'USDT',
5742.75,
233,
'INR',
233
],
[
'fhtyjrg35n788985gff5',
'ETH-USDT',
'sell',
1694131200000,
3,
110,
'USDT',
9790,
null,
null,
null
]
]
],
[
'name' => 'future_last_traded_price_table',
'@entity' => 'table',
'header' => [
'contract_name',
'currency',
'last_traded_price',
'last_traded_price_inr'
],
'rows' => [
[
'BTC-USDT',
'USDT',
145,
145
],
[
'XRP-USDT',
'USDT',
85,
85
]
]
]
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <authorization>",
"Content-Type: application/json",
"x-api-key: <x-api-key>",
"x-api-version: <x-api-version>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto"
payload := strings.NewReader("{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-api-key", "<x-api-key>")
req.Header.Add("x-api-version", "<x-api-version>")
req.Header.Add("Authorization", "<authorization>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto")
.header("x-api-key", "<x-api-key>")
.header("x-api-version", "<x-api-version>")
.header("Authorization", "<authorization>")
.header("Content-Type", "application/json")
.body("{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://test-api.sandbox.co.in/it/calculator/tax-pnl/crypto")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-api-key"] = '<x-api-key>'
request["x-api-version"] = '<x-api-version>'
request["Authorization"] = '<authorization>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"@entity\": \"workbook\",\n \"name\": \"crypto_currency_tradebook_workbook\",\n \"sheets\": [\n {\n \"name\": \"spot_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"spot_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"date\",\n \"transaction_type\",\n \"label\",\n \"received_currency\",\n \"received_quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"sent_currency\",\n \"sent_quantity\",\n \"fee_currency\",\n \"fee_amount\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"BTC\",\n 8.4567,\n 265,\n \"INR\",\n 2241.0254999999997,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"buy\",\n null,\n \"XRP\",\n 9.0123,\n 58.68,\n \"INR\",\n 528.841764,\n null,\n null,\n \"INR\",\n 50,\n 50\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"sell\",\n null,\n null,\n null,\n 278.98,\n \"INR\",\n 995.3532134000001,\n \"BTC\",\n 3.56783,\n \"INR\",\n 10.4564,\n 10.4564\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"buy\",\n null,\n \"BTC\",\n 10.9873,\n 309.8,\n \"INR\",\n 3403.86554,\n null,\n null,\n \"INR\",\n 288,\n 288\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"sell\",\n null,\n null,\n null,\n 75.35,\n \"INR\",\n 679.0768049999999,\n \"XRP\",\n 6.3544,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 65.92700399999998,\n \"XRP\",\n 1.3596,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1696291200000,\n \"sell\",\n null,\n null,\n null,\n 48.49,\n \"INR\",\n 62.954567000000004,\n \"XRP\",\n 1.2983,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1594684800000,\n \"buy\",\n null,\n \"ETH\",\n 0.9822,\n 120.455,\n \"INR\",\n 118.31090099999999,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 511.698,\n \"INR\",\n 233.79481619999999,\n \"ETH\",\n 0.4569,\n null,\n null,\n null\n ],\n [\n \"efvdf3vmndvnor349023s\",\n 1711843200000,\n \"buy\",\n null,\n \"SOL\",\n 2000,\n 0.3117,\n \"INR\",\n 623.4,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"wg3rg43wfege1dbdg33f\",\n 1687392000000,\n \"trade\",\n null,\n \"MATIC\",\n 100,\n 2.45,\n \"SOL\",\n 88.3669,\n \"SOL\",\n 245,\n null,\n null,\n null\n ],\n [\n \"gjekbek45vdge32w3fegf\",\n 1692057600000,\n \"send\",\n \"staking\",\n null,\n null,\n null,\n \"INR\",\n 560.456,\n \"MATIC\",\n 50,\n null,\n null,\n null\n ],\n [\n \"egrgrbko4542gfvfg4gv332\",\n 1693008000000,\n \"receive\",\n \"staking_reward\",\n \"MATIC\",\n 12.568,\n null,\n null,\n 140.8762,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"efkpfemfpe45efrG3r32f2A\",\n 1695859200000,\n \"receive\",\n \"staking\",\n \"MATIC\",\n 50,\n null,\n null,\n 715.255,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"acdcwefew3e1113vcd\",\n 1682985600000,\n \"buy\",\n null,\n \"USDT\",\n 350,\n 84.311,\n \"INR\",\n 29508.85,\n null,\n null,\n \"INR\",\n 20,\n 20\n ],\n [\n \"nknee38ni9cd3defeve\",\n 1687132800000,\n \"sell\",\n null,\n null,\n null,\n 85.23,\n \"INR\",\n 4261.5,\n \"USDT\",\n 50,\n \"INR\",\n 50,\n 50\n ],\n [\n \"kyjrtgew45568efeg12ds\",\n 1687219200000,\n \"send\",\n \"margin\",\n null,\n null,\n 84.311,\n \"INR\",\n 5901.77,\n \"USDT\",\n 70,\n null,\n null,\n null\n ],\n [\n \"hjdj0plsejw3n227890c\",\n 1687824000000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 70,\n 84.311,\n \"INR\",\n 5901.77,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"nrezxcetgf2334jk0333d\",\n 1690416000000,\n \"receive\",\n \"margin_gain\",\n \"USDT\",\n 40,\n 85,\n \"INR\",\n 3400,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1690934400000,\n \"send\",\n \"margin\",\n \"USDT\",\n null,\n 86.55,\n \"INR\",\n 13848,\n \"USDT\",\n 160,\n null,\n null,\n null\n ],\n [\n \"fwhjceco2trsc344f322e\",\n 1691020800000,\n \"sell\",\n null,\n null,\n null,\n 88,\n \"INR\",\n 8800,\n \"USDT\",\n 100,\n \"INR\",\n 145.89,\n 145.89\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1691020800000,\n \"send\",\n \"margin\",\n null,\n null,\n 88.35,\n \"INR\",\n 4417.5,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"zxc1rtvmk3456hkkve3w\",\n 1694131200000,\n \"receive\",\n \"margin\",\n \"USDT\",\n 160,\n 86.55,\n \"INR\",\n 13848,\n null,\n null,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf23445dwedc\",\n 1694131200000,\n \"send\",\n \"margin_loss\",\n null,\n null,\n 89,\n \"INR\",\n 4450,\n \"USDT\",\n 50,\n null,\n null,\n null\n ],\n [\n \"klop3sdcwf2347d12wxbk\",\n 1708646400000,\n \"sell\",\n null,\n null,\n null,\n 91.09,\n \"INR\",\n 3643.6000000000004,\n \"USDT\",\n 40,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"spot_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"symbol\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC\",\n \"INR\",\n 299.785,\n 299.785\n ],\n [\n \"USDT\",\n \"INR\",\n 95.45,\n 95.45\n ],\n [\n \"XRP\",\n \"INR\",\n 38.45,\n 38.45\n ],\n [\n \"SOL\",\n \"INR\",\n 0.0145,\n 0.0145\n ],\n [\n \"ETH\",\n \"INR\",\n 89.566,\n 89.566\n ],\n [\n \"MATIC\",\n \"INR\",\n 1256.789,\n 1256.789\n ]\n ]\n }\n ]\n },\n {\n \"name\": \"future_sheet\",\n \"@entity\": \"sheet\",\n \"blocks\": [\n {\n \"name\": \"future_tradebook_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"id\",\n \"contract_name\",\n \"transaction_type\",\n \"date\",\n \"quantity\",\n \"price\",\n \"price_currency\",\n \"price_inr\",\n \"fee_amount\",\n \"fee_currency\",\n \"fee_amount_inr\"\n ],\n \"rows\": [\n [\n \"addf3434mkvefv456h\",\n \"BTC-USDT\",\n \"buy\",\n 1687219200000,\n 1,\n 70,\n \"USDT\",\n 5901.77,\n 1000,\n \"INR\",\n 1000\n ],\n [\n \"fege4343gbgee344tg\",\n \"BTC-USDT\",\n \"sell\",\n 1687305600000,\n 1,\n 110,\n \"USDT\",\n 9350,\n 400,\n \"INR\",\n 400\n ],\n [\n \"fhtyjrg35n788985gff3\",\n \"ETH-USDT\",\n \"buy\",\n 1690934400000,\n 3,\n 160,\n \"USDT\",\n 14640,\n 500,\n \"INR\",\n 500\n ],\n [\n \"fhtyjrg35n788985gff4\",\n \"XRP-USDT\",\n \"buy\",\n 1691020800000,\n 2,\n 65,\n \"USDT\",\n 5742.75,\n 233,\n \"INR\",\n 233\n ],\n [\n \"fhtyjrg35n788985gff5\",\n \"ETH-USDT\",\n \"sell\",\n 1694131200000,\n 3,\n 110,\n \"USDT\",\n 9790,\n null,\n null,\n null\n ]\n ]\n },\n {\n \"name\": \"future_last_traded_price_table\",\n \"@entity\": \"table\",\n \"header\": [\n \"contract_name\",\n \"currency\",\n \"last_traded_price\",\n \"last_traded_price_inr\"\n ],\n \"rows\": [\n [\n \"BTC-USDT\",\n \"USDT\",\n 145,\n 145\n ],\n [\n \"XRP-USDT\",\n \"USDT\",\n 85,\n 85\n ]\n ]\n }\n ]\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"code": 200,
"timestamp": 1676979940157,
"transaction_id": "c01f847c-c42e-4577-9d01-a7208401a922",
"data": {
"@entity": "in.co.sandbox.it.calculator.cryto.tax_pnl.job",
"job_id": "c01f847c-c42e-4577-9d01-a7208401a922",
"report": "tradewise",
"from": 1682945614000,
"to": 1683291214000,
"status": "created",
"tradebook_url": "https://test-api.sandbox.co.in/it/calculator/in-co-sandbox-it-calculator-crypto-tax-pnl-dev/c01f847c-c42e-4577-9d01-a7208401a922.json"
}
}{
"code": 422,
"timestamp": 1619519433924,
"transaction_id": "328e459b-5be7-4658-b490-ceee6adbc0a8",
"message": "Invalid report: tradewize"
}
Run in Postman
Headers
Specifies the response format expected from the API. Use application/json for JSON responses or application/xlsx for Excel file downloads.application/xlsx
Indicates the version of the API you want to use. Ensures backward-compatible behavior.
Token for user-level authorization.
Query Parameters
Was this page helpful?
⌘I