Accounting Objects
- Accounts
- Addresses
- Attachments
- Balance Sheets
- Cash Flow Statements
- Company Infos
- Contacts
- Credit Notes
- Expenses
- Income Statements
- Invoices
- Items
- Journal Entries
- Payments
- Phone Numbers
- Purchase Orders
- Tax Rates
- Tracking Categories
- Transactions
- Vendor Credits
List Expenses
import { Panora } from "@panora/sdk";
const panora = new Panora({
apiKey: "<YOUR_API_KEY_HERE>",
});
async function run() {
const result = await panora.accounting.expenses.list({
xConnectionToken: "<value>",
remoteData: true,
limit: 10,
cursor: "1b8b05bb-5273-4012-b520-8657b0b90874",
});
for await (const page of result) {
// Handle the page
console.log(page);
}
}
run();
{
"prev_cursor": "<string>",
"next_cursor": "<string>",
"data": [
{
"transaction_date": "2024-06-15T12:00:00Z",
"total_amount": 10000,
"sub_total": 9000,
"total_tax_amount": 1000,
"currency": "USD",
"exchange_rate": "1.2",
"memo": "Business lunch with client",
"account_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"contact_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"tracking_categories": [
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
],
"line_items": [
{
"name": "Net Income",
"value": 100000,
"type": "Operating Activities",
"parent_item": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"remote_id": "report_item_1234",
"remote_generated_at": "2024-07-01T12:00:00Z",
"company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"created_at": "2024-06-15T12:00:00Z",
"modified_at": "2024-06-15T12:00:00Z"
}
],
"field_mappings": {
"custom_field_1": "value1",
"custom_field_2": "value2"
},
"id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"remote_id": "expense_1234",
"remote_data": {
"raw_data": {
"additional_field": "some value"
}
},
"remote_created_at": "2024-06-15T12:00:00Z",
"created_at": "2024-06-15T12:00:00Z",
"modified_at": "2024-06-15T12:00:00Z"
}
]
}
Authorizations
Headers
The connection token
Query Parameters
Set to true to include data from the original software.
Set to get the number of records.
Set to get the number of records after this cursor.
Response
The date of the expense transaction
"2024-06-15T12:00:00Z"
The total amount of the expense
10000
The sub-total amount of the expense (before tax)
9000
The total tax amount of the expense
1000
The currency of the expense
"USD"
The exchange rate applied to the expense
"1.2"
A memo or description for the expense
"Business lunch with client"
The UUID of the associated account
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The UUID of the associated contact
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The UUID of the associated company info
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The UUIDs of the tracking categories associated with the expense
["801f9ede-c698-4e66-a7fc-48d19eebaa4f"]
The line items associated with this expense
The name of the report item
"Net Income"
The value of the report item
100000
The type of the report item
"Operating Activities"
The UUID of the parent item
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The remote ID of the report item
"report_item_1234"
The date when the report item was generated in the remote system
"2024-07-01T12:00:00Z"
The UUID of the associated company info object
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The created date of the report item
"2024-06-15T12:00:00Z"
The last modified date of the report item
"2024-06-15T12:00:00Z"
The custom field mappings of the object between the remote 3rd party & Panora
{
"custom_field_1": "value1",
"custom_field_2": "value2"
}
The UUID of the expense record
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
The remote ID of the expense in the context of the 3rd Party
"expense_1234"
The remote data of the expense in the context of the 3rd Party
{
"raw_data": { "additional_field": "some value" }
}
The date when the expense was created in the remote system
"2024-06-15T12:00:00Z"
The created date of the expense record
"2024-06-15T12:00:00Z"
The last modified date of the expense record
"2024-06-15T12:00:00Z"
Was this page helpful?
import { Panora } from "@panora/sdk";
const panora = new Panora({
apiKey: "<YOUR_API_KEY_HERE>",
});
async function run() {
const result = await panora.accounting.expenses.list({
xConnectionToken: "<value>",
remoteData: true,
limit: 10,
cursor: "1b8b05bb-5273-4012-b520-8657b0b90874",
});
for await (const page of result) {
// Handle the page
console.log(page);
}
}
run();
{
"prev_cursor": "<string>",
"next_cursor": "<string>",
"data": [
{
"transaction_date": "2024-06-15T12:00:00Z",
"total_amount": 10000,
"sub_total": 9000,
"total_tax_amount": 1000,
"currency": "USD",
"exchange_rate": "1.2",
"memo": "Business lunch with client",
"account_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"contact_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"tracking_categories": [
"801f9ede-c698-4e66-a7fc-48d19eebaa4f"
],
"line_items": [
{
"name": "Net Income",
"value": 100000,
"type": "Operating Activities",
"parent_item": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"remote_id": "report_item_1234",
"remote_generated_at": "2024-07-01T12:00:00Z",
"company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"created_at": "2024-06-15T12:00:00Z",
"modified_at": "2024-06-15T12:00:00Z"
}
],
"field_mappings": {
"custom_field_1": "value1",
"custom_field_2": "value2"
},
"id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
"remote_id": "expense_1234",
"remote_data": {
"raw_data": {
"additional_field": "some value"
}
},
"remote_created_at": "2024-06-15T12:00:00Z",
"created_at": "2024-06-15T12:00:00Z",
"modified_at": "2024-06-15T12:00:00Z"
}
]
}