Overview
After submitting a job, the API responds with a presigned S3 URL.Use this URL to upload the workbook via an HTTP PUT request.
It’s a temporary AWS S3 presigned URL generated uniquely for each job.
Example Presigned URL
https://in-co-sandbox-it-reports-tax-pnl-sec-dev.s3.ap-south-1.amazonaws.com/{{file_path}}?{{signed_query_params}}JSON Payload
This API accepts payload in following formats:Tradebook
Click > Click here to learn more about this JSON payload.
Copy
{
"name": "tradebook_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "client_details_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "client_details_list",
"@entity": "list",
"items": [
{
"name":
"n"
},
{
"pan":
"FKFPS2020A"
},
{
"client_id":
293932
},
{
"country":
"India"
}
]
}
]
},
{
"name": "stock_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "stock_tradebook_table",
"@entity": "table",
"header": [
"isin",
"trade_id",
"symbol",
"quantity",
"date",
"price",
"transaction_type",
"transfer_expenses",
"label",
"product_type"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
"AMAZON",
10,
1711929600000,
55,
"buy",
7,
null,
"intraday"
],
[
"INE767A01016",
"ZVQAT2PZ1RSLYWWYZTXP",
"APPLE",
50,
1672531200000,
46,
"buy",
5,
null,
"delivery"
]
]
},
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"INE03Q201024",
"AMAZON",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE767A01016",
"APPLE",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE00E101023",
"ALPHABET",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE462A01022",
"META",
"x",
"USA",
12345645,
1000,
1200
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"INE03Q201024",
"AMAZON",
1,
1711929600000,
100,
"USD",
5
]
]
}
]
},
{
"name": "dr_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "dr_tradebook_table",
"@entity": "table",
"header": [
"isin",
"trade_id",
"symbol",
"quantity",
"date",
"price",
"transaction_type",
"transfer_expenses",
"label",
"product_type"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
"FACEBOOK",
10,
1711929600000,
640,
"buy",
7,
null,
"intraday"
],
[
"INE767A01016",
"ZVQAT2PZ1RSLYWWYZTXP",
"BERKSHIRE",
50,
1672531200000,
270,
"buy",
5,
null,
"delivery"
]
]
},
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE767A01016",
"ZVQAT2PZ1RSLYWWYZTXP",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE00E101023",
"VTHPFZ7KXVG5LMNZNBHT",
"x",
"USA",
12345645,
1000,
1200
],
[
"INE462A01022",
"SUNMAQYIBRDSM4Y2TVW9",
"x",
"USA",
12345645,
1000,
1200
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
4,
1738368000000,
60,
"USD",
5
]
]
}
]
},
{
"name": "mutual_fund_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_tradebook_table",
"@entity": "table",
"header": [
"isin",
"trade_id",
"scheme_name",
"scheme_type",
"quantity",
"date",
"price",
"transaction_type",
"transfer_expenses",
"label"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
"Fidelity",
"equity",
10,
1711929600000,
640,
"buy",
4,
null
],
[
"INE767A01016",
"ZVQAT2PZ1RSLYWWYZTXP",
"Blackrock",
"debt",
50,
1672531200000,
270,
"buy",
1,
null
]
]
},
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": []
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": []
}
]
},
{
"name": "etf_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_tradebook_table",
"@entity": "table",
"header": [
"isin",
"trade_id",
"scheme_name",
"scheme_type",
"quantity",
"date",
"price",
"transaction_type",
"transfer_expenses",
"label",
"product_type"
],
"rows": [
[
"INE03Q201024",
"KZUG2ZMGMH4WFE2C9RMG",
"Fidelity",
"equity",
10,
1711929600000,
640,
"buy",
4,
null,
"intraday"
],
[
"INE767A01016",
"ZVQAT2PZ1RSLYWWYZTXP",
"Blackrock",
"debt",
50,
1672531200000,
270,
"buy",
1,
null,
"delivery"
]
]
},
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": []
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": []
}
]
},
{
"name": "interest_income_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "interest_income_table",
"@entity": "table",
"header": [
"description",
"date",
"amount",
"amount_inr",
"currency",
"tax_witheld",
"tax_witheld_inr"
],
"rows": [
[
"GG",
1463356800000,
8,
null,
"USD",
0.12,
null
],
[
"WP",
1692316800000,
54,
null,
"EUR",
2,
null
]
]
}
]
}
]
}
Tradewise PnL
Click here to learn more about this JSON payload.
Copy
{
"name": "tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "option_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "option_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
"INNOTAVALIAB",
"equity_1",
"equity",
1,
null,
1718389800000,
665,
null,
1718389800000,
423,
"USD",
19,
"trade"
],
[
"INNOTAVALIAB",
"equity_2",
"equity",
1,
null,
1726338600000,
536,
null,
1726338600000,
26,
"EUR",
7,
"trade"
],
[
"INNOTAVALIAB",
"equity_1",
"equity",
1,
null,
1734201000000,
168,
null,
1734201000000,
728,
"INR",
5,
"trade"
],
[
"INNOTAVALIAB",
"equity_2",
"equity",
1,
null,
1741977000000,
481,
null,
1741977000000,
589,
"USD",
16,
"trade"
],
[
"INNOTAVALIAB",
"commodity_1",
"commodity",
1,
null,
1718389800000,
265,
null,
1718389800000,
970,
"EUR",
13,
"trade"
],
[
"INNOTAVALIAB",
"commodity_2",
"commodity",
1,
null,
1726338600000,
543,
null,
1726338600000,
680,
"INR",
6,
"trade"
],
[
"INNOTAVALIAB",
"commodity_1",
"commodity",
1,
null,
1734201000000,
229,
null,
1734201000000,
744,
"USD",
21,
"trade"
],
[
"INNOTAVALIAB",
"commodity_2",
"commodity",
1,
null,
1741977000000,
263,
null,
1741977000000,
63,
"EUR",
1,
"trade"
],
[
"INNOTAVALIAB",
"currency_1",
"currency",
1,
null,
1718389800000,
140,
null,
1718389800000,
147,
"INR",
22,
"trade"
],
[
"INNOTAVALIAB",
"currency_2",
"currency",
1,
null,
1726338600000,
395,
null,
1726338600000,
691,
"USD",
18,
"trade"
],
[
"INNOTAVALIAB",
"currency_1",
"currency",
1,
null,
1734201000000,
261,
null,
1734201000000,
821,
"EUR",
16,
"trade"
],
[
"INNOTAVALIAB",
"currency_2",
"currency",
1,
null,
1741977000000,
79,
null,
1741977000000,
505,
"INR",
9,
"trade"
]
]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
"INNOTAVALIAB",
"equity_1",
"equity",
1,
null,
1718389800000,
665,
null,
1718389800000,
423,
"USD",
19,
"trade"
],
[
"INNOTAVALIAB",
"equity_2",
"equity",
1,
null,
1726338600000,
536,
null,
1726338600000,
26,
"EUR",
7,
"trade"
],
[
"INNOTAVALIAB",
"equity_1",
"equity",
1,
null,
1734201000000,
168,
null,
1734201000000,
728,
"INR",
5,
"trade"
],
[
"INNOTAVALIAB",
"equity_2",
"equity",
1,
null,
1741977000000,
481,
null,
1741977000000,
589,
"USD",
16,
"trade"
],
[
"INNOTAVALIAB",
"commodity_1",
"commodity",
1,
null,
1718389800000,
265,
null,
1718389800000,
970,
"EUR",
13,
"trade"
],
[
"INNOTAVALIAB",
"commodity_2",
"commodity",
1,
null,
1726338600000,
543,
null,
1726338600000,
680,
"INR",
6,
"trade"
],
[
"INNOTAVALIAB",
"commodity_1",
"commodity",
1,
null,
1734201000000,
229,
null,
1734201000000,
744,
"USD",
21,
"trade"
],
[
"INNOTAVALIAB",
"commodity_2",
"commodity",
1,
null,
1741977000000,
263,
null,
1741977000000,
63,
"EUR",
1,
"trade"
],
[
"INNOTAVALIAB",
"currency_1",
"currency",
1,
null,
1718389800000,
140,
null,
1718389800000,
147,
"INR",
22,
"trade"
],
[
"INNOTAVALIAB",
"currency_2",
"currency",
1,
null,
1726338600000,
395,
null,
1726338600000,
691,
"USD",
18,
"trade"
],
[
"INNOTAVALIAB",
"currency_1",
"currency",
1,
null,
1734201000000,
261,
null,
1734201000000,
821,
"EUR",
16,
"trade"
],
[
"INNOTAVALIAB",
"currency_2",
"currency",
1,
null,
1741977000000,
79,
null,
1741977000000,
505,
"INR",
9,
"trade"
]
]
}
]
}
]
}