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

To get vendors that have a credit limit above a certain value, send a SuiteQL query with the credit limit. Note that Prefer: transient is a required header parameter.

          POST {{REST_SERVICES}}/query/v1/suiteql?
{
    "q": "SELECT id, entityid AS 'vendor name', creditlimit FROM vendor WHERE creditlimit > 5000"
} 

        

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": [],
            "creditlimit": "8000",
            "id": "1725",
            "vendor name": "BZ Vendor"
        },
        {
            "links": [],
            "creditlimit": "10000",
            "id": "1722",
            "vendor name": "Test"
        }
    ],
    "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 Details of Vendors that are Assigned a Category

General Notices