Skip to main content
POST
/
it
/
calculator
/
pnl
/
other
Get P&L Sync
curl --request POST \
  --url https://api.sandbox.co.in/it/calculator/pnl/other \
  --header 'Authorization: <authorization>' \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <x-api-key>' \
  --header 'x-api-version: <x-api-version>' \
  --data '
{
  "name": "other_tradewise_settlement_workbook",
  "@entity": "workbook",
  "sheets": [
    {
      "name": "tradewise_settlement_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "tradewise_settlement_table",
          "@entity": "table",
          "header": [
            "serial_number",
            "asset_type",
            "asset_name",
            "country",
            "currency",
            "buy_date",
            "buy_price",
            "cost_of_acquisition",
            "sell_date",
            "sell_price",
            "transfer_expenses"
          ],
          "rows": [
            [
              "6abba3b3-d061-45f5-a947-c6a944663605",
              "jewelry",
              "jew",
              "india",
              "INR",
              1696185000000,
              25000000,
              25000000,
              1712255400000,
              17500100,
              10000
            ],
            [
              "592994fb-3b14-4ec7-9203-502cd8927bec",
              "art",
              "art",
              "india",
              "INR",
              1286649000000,
              9590000,
              9590000,
              1712169000000,
              24520000,
              17000
            ],
            [
              "991d604c-989f-4530-948b-fa2e609c2d56",
              "car",
              "car",
              "india",
              "INR",
              1286649000000,
              8590010,
              8590010,
              1712169000000,
              24582000,
              17000
            ],
            [
              "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
              "other",
              "other",
              "india",
              "INR",
              1697740200000,
              2301010,
              2301010,
              1712169000000,
              1309000,
              12400
            ]
          ]
        },
        {
          "name": "cost_of_improvement_table",
          "@entity": "table",
          "header": [
            "settlement_serial_number",
            "financial_year",
            "cost",
            "indexed_cost"
          ],
          "rows": [
            [
              "592994fb-3b14-4ec7-9203-502cd8927bec",
              "FY 2011-12",
              250000,
              null
            ],
            [
              "991d604c-989f-4530-948b-fa2e609c2d56",
              "FY 2012-13",
              250000,
              null
            ],
            [
              "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
              "FY 2023-24",
              1330,
              null
            ]
          ]
        }
      ]
    }
  ]
}
'
{
  "transaction_id": "9529f60d-ab22-4138-ac58-9b6bcdbd843c",
  "code": 200,
  "data": {
    "@entity": "workbook",
    "sheets": [
      {
        "@entity": "sheet",
        "blocks": [
          {
            "@entity": "table",
            "header": [
              "settlement_id",
              "asset_type",
              "asset_name",
              "country",
              "currency",
              "holding_period",
              "turnover",
              "turnover_inr",
              "buy_date",
              "buy_price",
              "buy_price_inr",
              "cost_of_acquisition",
              "cost_of_acquisition_inr",
              "sell_date",
              "sell_price",
              "sell_price_inr",
              "total_cost_of_improvement",
              "total_cost_of_improvement_inr",
              "realized_pnl",
              "realized_pnl_inr",
              "transfer_expenses",
              "transfer_expenses_inr",
              "net_realized_pnl",
              "net_realized_pnl_inr"
            ],
            "rows": [
              [
                "6abba3b3-d061-45f5-a947-c6a944663605",
                "jewelry",
                "jew",
                "India",
                "INR",
                "short_term",
                17500100,
                17500100,
                1696185000000,
                25000000,
                25000000,
                0,
                null,
                1712255400000,
                17500100,
                17500100,
                0,
                0,
                -7499900,
                -7499900,
                10000,
                10000,
                -7509900,
                -7509900
              ],
              [
                "592994fb-3b14-4ec7-9203-502cd8927bec",
                "art",
                "art",
                "India",
                "INR",
                "long_term",
                24520000,
                24520000,
                1286649000000,
                9590000,
                9590000,
                0,
                null,
                1712169000000,
                24520000,
                24520000,
                250000,
                250000,
                14930000,
                14930000,
                17000,
                17000,
                14663000,
                14663000
              ],
              [
                "991d604c-989f-4530-948b-fa2e609c2d56",
                "car",
                "car",
                "India",
                "INR",
                "long_term",
                24582000,
                24582000,
                1286649000000,
                8590010,
                8590010,
                0,
                null,
                1712169000000,
                24582000,
                24582000,
                250000,
                250000,
                15991990,
                15991990,
                17000,
                17000,
                15724990,
                15724990
              ],
              [
                "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
                "other",
                "other",
                "India",
                "INR",
                "short_term",
                1309000,
                1309000,
                1697740200000,
                2301010,
                2301010,
                0,
                null,
                1712169000000,
                1309000,
                1309000,
                1330,
                1330,
                -992010,
                -992010,
                12400,
                12400,
                -1005740,
                -1005740
              ]
            ],
            "name": "tradewise_pnl_table"
          },
          {
            "@entity": "table",
            "header": [
              "settlement_id",
              "financial_year",
              "cost",
              "indexed_cost"
            ],
            "rows": [
              [
                "592994fb-3b14-4ec7-9203-502cd8927bec",
                "FY 2011-12",
                250000,
                493206.52
              ],
              [
                "991d604c-989f-4530-948b-fa2e609c2d56",
                "FY 2012-13",
                250000,
                453750
              ],
              [
                "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
                "FY 2023-24",
                1330,
                1387.33
              ]
            ],
            "name": "cost_of_improvement_table"
          }
        ],
        "name": "tradewise_pnl_sheet"
      }
    ],
    "name": "other_tradewise_pnl_workbook"
  },
  "timestamp": "1740056171000"
}

Headers

x-api-key
string
required

Your API key used to authenticate and authorize the request.

x-api-version
string
required

Indicates the version of the API you want to use. Ensures backward-compatible behavior.

Authorization
string
required

Token for user-level authorization.

Body

application/json
name
string
@entity
string
sheets
object[]

Response

200 - application/json

200 OK

transaction_id
string
code
integer
data
object
timestamp
string<utc-millisec>