Use Case for Getting Details of Vendors that are Assigned a Category

To get details of vendors that are assigned a category, send a SuiteQL query with the category. Note that Prefer: transient is a required header parameter.

          POST {{REST_SERVICES}}/query/v1/suiteql?
{
    "q": "SELECT id, legalname, expenseaccount FROM vendor WHERE category = 3"
} 

        

Following is a sample response:

          {
    "links": [
        {
            "rel": "self",
            "href": "https://<accountID>.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql"
        }
    ],
    "count": 2,
    "hasMore": false,
    "items": [
        {
            "links": [],
            "expenseaccount": "12",
            "id": "1725",
            "legalname": "BZ Vendor"
        },
        {
            "links": [],
            "expenseaccount": "10",
            "id": "1823",
            "legalname": "Test State Tax Agency"
        }
    ],
    "offset": 0,
    "totalResults": 2
} 

        

Related Topics

Vendor Use Cases

Use Case for Creating a Vendor

Use Case for Creating a Tax Agency Vendor

Use Case for Providing Role Access to a Vendor

Use Case for Inactivating a Vendor

Use Case for Setting Credit Limit for a Vendor

Use Case for Defining the Preferred Transaction Delivery Methods for a Vendor

Use Case for Finding Vendors that are Assigned an Expense Account

Use Case for Getting List of Vendors that have Credit Limits Above a Value

General Notices