PUT Request

๐Ÿ“˜

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

View Workbook

๐Ÿ‘

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",
						"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",
						"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
						]
					]
				}
			]
		}
	]
}