List Expense Reports
List Expense Reports
Query parameters
Include raw response. Mostly used for debugging purposes
Cursor to start from. You can find cursors for next/previous pages in the meta.cursors property of the response.
Number of results to return. Minimum 1, Maximum 200, Default 20
The 'fields' parameter allows API users to specify the fields they want to include in the API response. If this parameter is not present, the API will return all available fields. If this parameter is present, only the fields specified in the comma-separated string will be included in the response. Nested properties can also be requested by using a dot notation. <br /><br />Example: fields=name,email,addresses.city<br /><br />In the example above, the response will only include the fields "name", "email" and "addresses.city". If any other fields are available, they will be excluded.
Apply filters
{
"updated_since": "2020-09-30T07:43:32.000Z",
"status": "submitted"
}Optional unmapped key/values that will be passed through to downstream as query parameters. Ie: ?pass_through[search]=leads becomes ?search=leads
{
"search": "San Francisco"
}Headers
ID of the consumer which you want to get or push data from
The ID of your Unify application
Provide the service id you want to call (e.g., pipedrive). Only needed when a consumer has activated multiple integrations for a Unified API.
Response
Expense Reports
Example response
{
"status_code": 200,
"status": "OK",
"service": "netsuite",
"resource": "ExpenseReports",
"operation": "all",
"data": [
{
"id": "12345",
"display_id": "123456",
"number": "ER-001",
"title": "Q1 Business Travel",
"employee": {
"id": "12345",
"display_name": "John Doe"
},
"status": "submitted",
"transaction_date": "2021-05-01T12:00:00.000Z",
"posting_date": "2024-06-01",
"due_date": "2024-06-15",
"currency": "USD",
"currency_rate": 0.69,
"sub_total": 250,
"total_tax": 25,
"total_amount": 1250.75,
"reimbursable_amount": 1100,
"memo": "Business travel expenses for Q1 client meetings",
"department": {
"id": "12345",
"display_id": "123456",
"name": "Acme Inc.",
"downstream_id": "12345"
},
"location": {
"id": "123456",
"display_id": "123456",
"name": "New York Office",
"downstream_id": "12345"
},
"account": {
"id": "123456",
"name": "Bank account",
"nominal_code": "N091",
"code": "453",
"parent_id": "123456",
"display_id": "123456"
},
"accounting_period": {
"id": "12345",
"name": "Q1 2024"
},
"line_items": [
{
"id": "12345",
"line_number": 1,
"expense_category": {
"id": "12345",
"downstream_id": "12345",
"display_id": "Airfare",
"name": "Airfare"
},
"account": {
"id": "123456",
"name": "Bank account",
"nominal_code": "N091",
"code": "453",
"parent_id": "123456",
"display_id": "123456"
},
"description": "Flight to New York",
"quantity": 1,
"unit_price": 27500.5,
"amount": 275,
"tax_rate": {
"id": "123456",
"code": "N-T",
"name": "GST on Purchases",
"rate": 10
},
"tax_amount": 27.5,
"total_amount": 302.5,
"transaction_date": "2024-05-15",
"billable": true,
"reimbursable": true,
"customer": {
"id": "12345",
"display_id": "CUST00101",
"display_name": "Windsurf Shop",
"name": "Windsurf Shop",
"company_name": "The boring company",
"email": "boring@boring.com"
},
"department": {
"id": "12345",
"display_id": "123456",
"name": "Acme Inc.",
"downstream_id": "12345"
},
"location": {
"id": "123456",
"display_id": "123456",
"name": "New York Office",
"downstream_id": "12345"
},
"tracking_categories": [
{
"id": "123456",
"code": "100",
"name": "New York",
"parent_id": "123456",
"parent_name": "New York"
}
],
"receipt_url": "https://example.com/receipts/123.pdf",
"currency": "USD",
"updated_by": "12345",
"created_by": "12345",
"updated_at": "2020-09-30T07:43:32.000Z",
"created_at": "2020-09-30T07:43:32.000Z"
}
],
"subsidiary": {
"id": "12345",
"display_id": "123456",
"name": "Acme Inc."
},
"tracking_categories": [
{
"id": "123456",
"code": "100",
"name": "New York",
"parent_id": "123456",
"parent_name": "New York"
}
],
"tax_inclusive": true,
"approved_by": {
"id": "12345",
"display_name": "Jane Smith"
},
"custom_fields": [
{
"id": "2389328923893298",
"name": "employee_level",
"description": "Employee Level",
"value": "Uses Salesforce and Marketo"
}
],
"row_version": "1-12345",
"updated_by": "12345",
"created_by": "12345",
"updated_at": "2020-09-30T07:43:32.000Z",
"created_at": "2020-09-30T07:43:32.000Z",
"pass_through": [
{
"extend_paths": [
{
"path": "$.nested.property",
"value": {
"TaxClassificationRef": {
"value": "EUC-99990201-V1-00020000"
}
}
}
]
}
]
}
],
"meta": {
"items_on_page": 50,
"cursors": {
"previous": "em9oby1jcm06OnBhZ2U6OjE=",
"current": "em9oby1jcm06OnBhZ2U6OjI=",
"next": "em9oby1jcm06OnBhZ2U6OjM="
},
"total_count": 1,
"warnings": [
{
"type": "downstream_request_failed",
"status_code": 429,
"operation": "getManager"
}
]
},
"links": {
"previous": "https://unify.apideck.com/crm/companies?cursor=em9oby1jcm06OnBhZ2U6OjE%3D",
"current": "https://unify.apideck.com/crm/companies",
"next": "https://unify.apideck.com/crm/companies?cursor=em9oby1jcm06OnBhZ2U6OjM"
}
}