Get an Expense Report

GET /expense-reports/{id} — Use this method to retrieve 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). Note: The `expand` value must contain only attributes referencing a supported object type. If `return_object` is set to any value other than `0` (zero), and the comma-separated list includes at least one attribute that is not available for expansion, the request fails — an error is returned and the object is not added or updated. For more information about attributes available for expansion and supported object types, see Available Expansions and Supported Object Types.	string
`fields`	Optional	A comma-separated list of attributes to include in the response. If not specified, the response includes all attributes for the expense report returned. Response Data Modifiers.	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

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

Note:

The expand value must contain only attributes referencing a supported object type. If return_object is set to any value other than 0 (zero), and the comma-separated list includes at least one attribute that is not available for expansion, the request fails — an error is returned and the object is not added or updated. For more information about attributes available for expansion and supported object types, see Available Expansions and Supported Object Types.

string

fields

Optional

A comma-separated list of attributes to include in the response. If not specified, the response includes all attributes for the expense report returned. Response Data Modifiers.

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

Response definitions

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

Property	Description
`data`	An array containing the expense report requested. See Returned Data.
`included`	An array of expanded objects, if the `expand` parameter was set in the request. See Referenced Objects and Expansion.
`meta`	An object containing information about 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 expense report requested. See Returned Data.

included

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

See Referenced Objects and Expansion.

meta

An object containing information about 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.

Property

Description

message

A string containing a brief message about the status of your request.

Sample request

            GET /rest/v1/expense-reports/237 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": [
      {
            "totalReceipts": 2,
            "isForeignCurrencyExchangeIntolerance": false,
            "externalId": "",
            "status": "A",
            "date": "2019-10-01",
            "isAdjusting": false,
            "accountingDate": "2019-09-30",
            "taxLocationId": 0,
            "currency": "USD",
            "updated": "2019-10-21 03:04:57",
            "totalReimburse": 1260,
            "submitDate": "2019-10-01",
            "id": 237,
            "attachments": [],
            "userId": 54,
            "name": "September Expenses",
            "isAccounting": false,
            "total": 1260,
            "description": "September 2019 Expenses",
            "created": "2019-10-01 14:12:38",
            "balance": 1000,
            "notes": "",
            "endDate": "0000-00-00",
            "approveDate": "2019-10-21",
            "exported": "0000-00-00 00:00:00",
            "trackingNumber": "1113",
            "startDate": "0000-00-00"      }
   ],
   "message": "success"
   "meta": {
       "relationships": [
            {
                "attachments": {
                    "data": {
                        "id": [
                            43
                        ],
                        "type": "attachment"
                    }
                },
                "userId": {
                    "data": {
                        "id": 54,
                        "type": "userDisplayName"
                    }
                }
            }
       ]
   }
}