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