This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is anyone able to use the Web Services REST API to query transaction records, for example the invoice record by externalId or otherRefNum?  Another example would be the purchaseOrder record by externalId.   GET https://{accountinfo}.<http://suitetalk.api.netsuite.com/services/rest/record/v1/invoice?q=externalId|suitetalk.api.netsuite.com/services/rest/record/v1/invoice?q=externalId> IS IN0012345
I keep getting the following error.  I'm able to do this type of query with the customer record without any error.
I'm able to query the invoice transaction record a different way without an error (GET https://{accountinfo}.<http://suitetalk.api.netsuite.com/services/rest/record/v1/invoice/eid:IN0012345)|suitetalk.api.netsuite.com/services/rest/record/v1/invoice/eid:IN0012345)>.

{
    "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1>",
    "title": "Bad Request",
    "status": 400,
    "o:errorDetails": [
        {
            "detail": "Unknown field name 'externalId' in the search query. The field does not exist on this record type.",
            "o:errorQueryParam": "q",
            "o:errorCode": "NONEXISTENT_FIELD"
        }
    ]
}

This might be related to permissions because it does work if I use the Administrator role...