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

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

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”.

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”.

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"
            }
        ]
    }
}