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 following two formats:
Tradebook
Click here to learn more about this JSON Payload
{
"@entity": "workbook",
"name": "tradebook_workbook",
"metadata": {
"currency": "INR"
},
"sheets": [
{
"@entity": "sheet",
"name": "stock_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "stock_tradebook_table",
"header": ["isin", "trade_id", "symbol", "quantity", "date", "price", "transaction_type", "transfer_expenses", "label", "product_type"],
"rows": []
},
{
"@entity": "table",
"name": "reference_data_table",
"header": ["isin", "symbol", "address", "country", "zip_code", "52_week_high", "closing_value"],
"rows": []
},
{
"@entity": "table",
"name": "dividend_table",
"header": ["isin", "symbol", "quantity", "date", "dividend_amount", "tax_withheld"],
"rows": []
}
]
},
{
"@entity": "sheet",
"name": "adr_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "adr_tradebook_table",
"header": ["isin", "trade_id", "symbol", "quantity", "date", "price", "transaction_type", "transfer_expenses", "label", "product_type"],
"rows": []
},
{
"@entity": "table",
"name": "reference_data_table",
"header": ["isin", "symbol", "address", "country", "zip_code", "52_week_high", "closing_value"],
"rows": []
},
{
"@entity": "table",
"name": "dividend_table",
"header": ["isin", "symbol", "quantity", "date", "dividend_amount", "tax_withheld"],
"rows": []
}
]
},
{
"@entity": "sheet",
"name": "mutual_fund_tradebook_",
"blocks": [
{
"@entity": "table",
"name": "mutual_fund_tradebook_table",
"header": ["isin", "trade_id", "symbol", "quantity", "date", "price", "transaction_type", "transfer_expenses", "label", "product_type"],
"rows": []
},
{
"@entity": "table",
"name": "reference_data_table",
"header": ["isin", "symbol", "address", "country", "zip_code", "52_week_high", "closing_value"],
"rows": []
},
{
"@entity": "table",
"name": "dividend_table",
"header": ["isin", "symbol", "quantity", "date", "dividend_amount", "tax_withheld"],
"rows": []
}
]
},
{
"@entity": "sheet",
"name": "etf_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "etf_tradebook_table",
"header": ["isin", "trade_id", "symbol", "quantity", "date", "price", "transaction_type", "transfer_expenses", "label", "product_type"],
"rows": []
},
{
"@entity": "table",
"name": "reference_data_table",
"header": ["isin", "symbol", "address", "country", "zip_code", "52_week_high", "closing_value"],
"rows": []
},
{
"@entity": "table",
"name": "dividend_table",
"header": ["isin", "symbol", "quantity", "date", "dividend_amount", "tax_withheld"],
"rows": []
}
]
},
{
"@entity": "sheet",
"name": "interest_income_sheet",
"blocks": [
{
"@entity": "table",
"name": "interest_income_table",
"header": ["description", "date", "amount", "tax_withheld"],
"rows": []
}
]
},
{
"@entity": "sheet",
"name": "client_details_sheet",
"blocks": [
{
"@entity": "list",
"name": "client_details_list",
"items": [
["name", ""],
["pan", ""],
["client_id", ""]
]
},
{
"@entity": "table",
"name": "client_tin_table",
"header": ["country", "tin"],
"rows": []
}
]
}
]
}
Tradewise PnL
Click here to learn more about this JSON Payload
{
"@entity": "workbook",
"name": "workbook",
"sheets": [
{
"@entity": "sheet",
"name": "client_details_sheet",
"blocks": [
{
"@entity": "table",
"name": "client_tin_table",
"header": [
"name"
],
"rows": [
[
"pan"
],
[
"client_id"
]
]
}
]
},
{
"@entity": "sheet",
"name": "stock_tradewise_settlement_sheet",
"blocks": [
{
"@entity": "table",
"name": "stock_tradewise_settlement_table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"stock_tradewise_holding_table"
],
[
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
[
"stock_tradewise_open_sell_table"
],
[
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
]
]
}
]
},
{
"@entity": "sheet",
"name": "adr_tradewise_settlement_sheet",
"blocks": [
{
"@entity": "table",
"name": "adr_tradewise_settlement_table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"adr_tradewise_holding_table"
],
[
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
[
"adr_tradewise_open_sell_table"
],
[
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
]
]
}
]
},
{
"@entity": "sheet",
"name": "mutual_fund_tradewise_settlemen",
"blocks": [
{
"@entity": "table",
"name": "mutual_fund_tradewise_settlement_table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"mutual_fund_tradewise_holding_table"
],
[
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
]
]
}
]
},
{
"@entity": "sheet",
"name": "etf_tradewise_settlement_sheet",
"blocks": [
{
"@entity": "table",
"name": "etf_tradewise_settlement_table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"currency",
"tax_withheld"
],
"rows": [
[
"etf_tradewise_holding_table"
],
[
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
[
"etf_tradewise_open_sell_table"
],
[
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_date",
"sell_price",
"currency",
"transaction_type",
"label",
"last_traded_price"
]
]
}
]
},
{
"@entity": "sheet",
"name": "interest_income_sheet",
"blocks": [
{
"@entity": "table",
"name": "__EMPTY",
"header": [
"interest_income_table"
],
"rows": [
[
"description",
"date",
"amount",
"currency",
"tax_witheld"
]
]
}
]
}
]
}