Get the List of Receipts in an Expense Report

GET /expense-reports/{id}/receipts/ — Use this method to retrieve the collection of receipts in the expense report with the specified internal ID.

Parameters

Path parameters

Path parameter	Required / Optional	Description	Type
`{id}`	Required	The internal ID of the expense report.	integer

Path parameter

Required / Optional

Description

Type

{id}

Required

The internal ID of the expense report.

integer

Query string parameter

Path parameter	Required / Optional	Description	Type
`expand`	Optional	A comma-separated list of attributes available for expansion. The comma-separated list may include spaces (or `%20` in the URL encoded string).	string
`fields`	Optional	A comma-separated list of attributes to include in the response. If not specified, the response includes all attributes for each receipt returned. Response Data Modifiers. For information about `Receipt` object properties, see Receipt object properties.	string
`filterSetId`	Optional	The internal ID of the filter set to be applied. When specified, the response includes only data that is available when the specified filter set is active in SuiteProjects Pro. The filter set with the specified internal ID must exist and must be associated with the user who authorized the application as per the access token. Otherwise and by default, the primary filter set associated with the user who authorized the application is applied.	integer
`limit`	Optional	A limit on the length of the page. See Pagination.	integer
`offset`	Optional	A cursor for use in pagination. See Pagination.	integer
`orderBy`	Optional	The attribute to sort the list by. Use a plus sign (`+`) or minus sign (`-`) before the attribute name to specify an ascending (`+`) or descending (`-`) sort order. An ascending sort order is used if the sort order is not specified. See Sorting.	string
`q`	Optional	A URL-encoded query expression used to filter the resource collection and return the objects matching the specified search criteria. See Filtering.	string

Path parameter

Required / Optional

Description

Type

expand

Optional

A comma-separated list of attributes available for expansion. The comma-separated list may include spaces (or %20 in the URL encoded string).

string

fields

Optional

A comma-separated list of attributes to include in the response. If not specified, the response includes all attributes for each receipt returned. Response Data Modifiers. For information about Receipt object properties, see Receipt object properties.

string

filterSetId

Optional

The internal ID of the filter set to be applied.

When specified, the response includes only data that is available when the specified filter set is active in SuiteProjects Pro. The filter set with the specified internal ID must exist and must be associated with the user who authorized the application as per the access token.
Otherwise and by default, the primary filter set associated with the user who authorized the application is applied.

integer

limit

Optional

A limit on the length of the page. See Pagination.

integer

offset

Optional

A cursor for use in pagination. See Pagination.

integer

orderBy

Optional

The attribute to sort the list by. Use a plus sign (+) or minus sign (-) before the attribute name to specify an ascending (+) or descending (-) sort order. An ascending sort order is used if the sort order is not specified. See Sorting.

string

q

Optional

A URL-encoded query expression used to filter the resource collection and return the objects matching the specified search criteria. See Filtering.

string

Response definitions

A successful request returns a JSON object with the following properties:

Property	Description
`data`	An array containing the list of receipts in the expense report with the specified internal ID. See Returned Data. For information about `Receipt` object properties, see Receipt object properties.
`included`	An array of expanded objects, if the `expand` parameter was set in the request. See Referenced Objects and Expansion.
`meta`	An object containing response metadata. The `meta` object may include information about: The page returned, the number of objects per page, the total number of pages and objects in the list, and links to other pages. See Pagination. Objects referenced by internal ID in the `data` array (object type and internal ID). See Referenced Objects and Expansion.
`message`	A string containing a brief message about the status of your request — for example, `“Success”`.

Property

Description

data

An array containing the list of receipts in the expense report with the specified internal ID. See Returned Data. For information about Receipt object properties, see Receipt object properties.

included

An array of expanded objects, if the expand parameter was set in the request.

See Referenced Objects and Expansion.

meta

An object containing response metadata. The meta object may include information about:

The page returned, the number of objects per page, the total number of pages and objects in the list, and links to other pages. See Pagination.
Objects referenced by internal ID in the data array (object type and internal ID). See Referenced Objects and Expansion.

message

A string containing a brief message about the status of your request — for example, “Success”.

A failed request returns a JSON object with the following properties:

Property	Description
`message`	A string containing a brief message about the status of your request — for example, `“Expense report #237 not found”`.

Property

Description

message

A string containing a brief message about the status of your request — for example, “Expense report #237 not found”.

Sample request

            GET /rest/v1/expense-reports/237/receipts/ HTTP/1.1
Host: company-id.app.netsuitesuiteprojectspro.com
Authorization: Bearer <OAuth2_access_token>

In the example, <OAuth2_access_token> is the OAuth 2.0 access token obtained for the client application connecting to SuiteProjects Pro. See Authentication.

Sample response

            {
    "data": [
        {
            "foreignCurrencySymbol": "",
            "expenseReportId": 237,
            "date": "2019-10-01",
            "costPerUnit": 680,
            "taxLocationId": 0,
            "foreignCurrencyRate": 0,
            "projectTaskId": 0,
            "updated": "2019-10-21 03:04:58",
            "id": 2659,
            "slipId": 0,
            "paymentTypeId": 0,
            "total": 680,
            "description": "Miscellaneous",
            "itemId": 7,
            "customerId": 50,
            "totalTaxPaid": 0,
            "costCenterId": 0,
            "trackingNumber": "1",
            "isForeignCurrencyExchangeIntolerance": false,
            "externalId": "",
            "userLocationId": 0,
            "isNonBillable": false,
            "accountingDate": "0000-00-00",
            "foreignCurrencyCost": 0,
            "currency": "USD",
            "foreignCurrencyTotalTaxPaid": 0,
            "projectId": 54,
            "isTaxIncludedInCost": false,
            "attachments": [3719],
            "userId": 49,
            "quantity": 1,
            "created": "2019-10-01 14:12:50",
            "isReimbursable": true,
            "totalNoTax": 680,
            "notes": ""
        },
        {
            "foreignCurrencySymbol": "",
            "expenseReportId": 237,
            "date": "2019-10-01",
            "costPerUnit": 580,
            "taxLocationId": 0,
            "foreignCurrencyRate": 0,
            "projectTaskId": 0,
            "updated": "2019-10-21 03:04:58",
            "id": 2674,
            "slipId": 0,
            "paymentTypeId": 0,
            "total": 580,
            "description": "Miscellaneous",
            "itemId": 7,
            "customerId": 50,
            "totalTaxPaid": 0,
            "costCenterId": 0,
            "trackingNumber": "2",
            "isForeignCurrencyExchangeIntolerance": false,
            "externalId": "",
            "userLocationId": 0,
            "isNonBillable": true,
            "accountingDate": "0000-00-00",
            "foreignCurrencyCost": 0,
            "currency": "USD",
            "foreignCurrencyTotalTaxPaid": 0,
            "projectId": 54,
            "isTaxIncludedInCost": false,
            "attachments": [3745],
            "userId": 49,
            "quantity": 1,
            "created": "2019-10-01 14:13:03",
            "isReimbursable": true,
            "totalNoTax": 580,
            "notes": ""
        }
    ],
    "message": "success",
    "meta": {
        "relationships": [
            {
                "attachments": {
                    "data": {
                        "id": [
                            3719
                        ],
                        "type": "attachment"
                    }
                },
                "userId": {
                    "data": {
                        "id": 49,
                        "type": "userDisplayName"
                    }
                }
            },
            {
                "attachments": {
                    "data": {
                        "id": [
                            3745
                        ],
                        "type": "attachment"
                    }
                },
                "userId": {
                    "data": {
                        "id": 49,
                        "type": "userDisplayName"
                    }
                }
            }
        ],
        "rowsPerPage": 100,
        "totalPages": 1,
        "totalRows": 2,
        "links": [
            {
                "rel": "self",
                "href": "https://company-id.app.netsuitesuiteprojectspro.com/rest/v1/expense-reports/237/receipts"
            }
        ]
    }
}