How do i list all purchase orders? https://system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2023.1/index.html#tag-purchaseOrder i am doing GET

{{REST_SERVICES}}/record/v1/purchaseOrder?q=test

The error coming is

{
  "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Invalid search query. Provide a valid search query.",
      "o:errorQueryParam": "q",
      "o:errorCode": "INVALID_PARAMETER"
    }
  ]
}

Can anyone help me out in this?

“test” is not a query?

i tried using the suiteql

SELECT * from purchaseOrder

but it gave error

the q query parameter is used with Record Filtering

@battk

{{REST_SERVICES}}/record/v1/purchaseOrder?q=email EMPTY_NOT

on running this i am still getting this error

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

i checked in netsuite every purchase order has field email but it is not showing here

Try this :

/services/rest/query/v1/suiteql

"q": "SELECT email FROM transaction WHERE type = 'PurchOrd' GROUP BY email "

@Muhammad Hafiz

{
  "type": "<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'transaction' was not found.",
      "o:errorQueryParam": "q",
      "o:errorCode": "INVALID_PARAMETER"
    }
  ]
}

your role is missing the permission to find transactions

I have given full permission for this. Still getting the same error

which permissions does the role have

Full permission for purchase order

whats the internal id of the role

that is not administrator

@battk thanks added find transaction and it worked