In the purchase ledger signed URL, API user needs to pass the purchase ledger sheet JSON as a PUT request. The purchase ledger will have the invoices and the debit notes for the passed return period.
Sample Payload
{
"name": "purchase_ledger_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "invoice_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "purchase_invoice_table",
"@entity": "table",
"header": [
"supplier_name",
"supplier_gstin",
"invoice_number",
"invoice_date_epoch",
"irn",
"place_of_supply",
"sub_total",
"gst_rate",
"cgst",
"sgst",
"igst",
"cess",
"total"
],
"rows": [
[
"BHARTI AIRTEL LTD.",
"24AAACB2894G1ZT",
"HT2424I001485717",
1721241000000,
"a2sc8rhd55b3ceed1dbsc8rh29ada8d103sc8rha8e5d92sc8rhae75641369580",
"24",
3999,
"18",
359.91,
359.91,
0,
0,
4718.82
],
[
"BHARTI AIRTEL LTD.",
"24AAACB2894G1ZT",
"HT2424I001485720",
1720290600000,
"z4sc8rhd55b3ceed1dbsc8rh29ada8d103sc8rha8e5d92sc8rhae75641369580",
"24",
3999,
"18",
359.91,
359.91,
0,
0,
4718.82
],
[
"BHARTI AIRTEL LTD.",
"24AAACB2894G1ZT",
"HT2424I001485721",
1720290600000,
"y4sc8rhd55b3ceed1dbsc8rh29ada8d103sc8rha8e5d92sc8rhae75641369580",
"24",
3999,
"18",
359.91,
359.91,
0,
0,
4718.82
],
[
"GSTN",
"01AABCE2207R1Z5",
"S008400",
1721759400000,
null,
"24",
5931.36,
"18",
0,
0,
1067.64,
0,
6999
],
[
"AWS INDIA PRIVATE LIMITED",
"07AAJCA9880A1ZL",
"ACN2324000103340",
1720809000000,
"723024781f7f4kr7799229784bd7e98f577f4kr58f5cb674f534617f4krfde51",
"24",
3116.94,
"18",
0,
0,
561.05,
0,
3677.99
]
]
}
]
},
{
"name": "note_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debit_note_table",
"@entity": "table",
"header": [
"supplier_name",
"supplier_gstin",
"note_number",
"note_date_epoch",
"irn",
"place_of_supply",
"sub_total",
"gst_rate",
"cgst",
"sgst",
"igst",
"cess",
"total"
],
"rows": [
[
"AWS INDIA PRIVATE LIMITED",
"07AAJCA9880A1ZL",
"ACN2324000103340",
1720809000000,
"1f33d0856cf71d6f836ed56cd20648994ba0332fe2e3659a2638e01047d12ce9",
"24",
3116.94,
"18",
0,
0,
561.05,
0,
3677.99
],
[
"AWS INDIA PRIVATE LIMITED",
"07AAJCA9880A1ZL",
"ACN2324000103341",
1720722600000,
"4b6c5d74157759eb327d98c6473a9355ea1bac713a5325d1b9f214d8be15d154",
"24",
3116.94,
"18",
0,
0,
561.05,
0,
3677.99
],
[
"AWS INDIA PRIVATE LIMITED",
"07AAJCA9880A1ZL",
"ACN2324000103342",
1720809000000,
"239890856cf71d6f836ed56cd20648994ba0332fe2e3659a2638e01047d12ce9",
"24",
3116.94,
"18",
0,
0,
561.05,
0,
3677.99
],
[
"BHARTI AIRTEL LTD.",
"24AAACB2894G1ZT",
"DBN124I001485",
1720290600000,
"y4sc8rhd55b3ceed1dbsc8rh29ada8d103sc8rha8e5d92sc8rhae75641123abc",
"24",
3999,
"18",
359.91,
359.91,
0,
0,
4718.82
],
[
"GSTN",
"01AAAAP1208Q1ZS",
"533515",
1721673000000,
null,
"24",
400,
"18",
0,
0,
72,
0,
472
]
]
}
]
}
]
}