> This page is for API Reference.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.navipartner.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.navipartner.com/_mcp/server.

# Get Variety Tables

GET https://api.npretail.app/{tenant}/{environment}/{company}/inventory/varietytable

Get a list of variety tables with pagination. Filter on `type` to get every table of one variety.

Reference: https://docs.navipartner.com/apis/api-reference/inventory/variety/get-variety-tables

## Authentication

- `x-np-api-key` header (required) — API Key authentication via header

## Request

### Path parameters

- `tenant` (string, required) — Your Entra Tenant ID. [More details.](/paths#1-tenant)
- `environment` (string, required) — Your Business Central Environment. [More details.](/paths#2-environment)
- `company` (string, required) — Your Business Central Company. [More details.](/paths#3-company)

### Query parameters

- `type` (string, optional)
- `code` (string, optional)
- `pageSize` (integer, optional)
- `pageKey` (string, optional)
- `lastRowVersion` (string, optional)
- `sync` (boolean, optional)

## Response

### 200

- `morePages` (boolean, required)
- `nextPageKey` (string, required)
- `nextPageURL` (string, required)
- `data` (list of VarietyTable, required)

## Types

### VarietyTable

A variety table is a named set of values for one variety, for example the EU shoe sizes of the `SIZE` variety.

- `id` (UUID, required)
- `type` (string, required) — The variety code. Matches `code` in `GET /inventory/variety`.
- `code` (string, required)
- `description` (string, required) — The display name of the dimension, for example "Shoe size".
- `useInVariantDescription` (boolean, required) — When false, Business Central and the Shopify integration leave this variety out of the variant description and the product options.
- `preTagInVariantDescription` (string, required) — Text that Business Central and the Shopify integration put in front of each value label, for example `Sz:`.
- `useDescriptionField` (boolean, required) — When true, the value label is the value's `description`. When false, it is the raw `value`.
- `isCopy` (boolean, required)
- `copyFrom` (string, required)
- `lockTable` (boolean, required) — Whether values can no longer be added to, renamed in or removed from the table.
- `rowVersion` (string, optional)

## Examples

**Response**

```json
{
  "morePages": true,
  "nextPageKey": "c29tZSBiYXNlNjQgc3RyaW5n",
  "nextPageURL": "https://api.npretail.app/tenant/env/company/inventory/varietytable?type=SIZE&pageKey=c29tZSBiYXNlNjQgc3RyaW5n",
  "data": [
    {
      "id": "7c9e6679-7425-40de-944b-e07fc1f90ae7",
      "type": "SIZE",
      "code": "SIZE-EU",
      "description": "Shoe size",
      "useInVariantDescription": true,
      "preTagInVariantDescription": "",
      "useDescriptionField": false,
      "isCopy": false,
      "copyFrom": "",
      "lockTable": false,
      "rowVersion": "12345678901234567891"
    }
  ]
}
```

**SDK Code**

```python
import requests

url = "https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable"

querystring = {"type":"SIZE","pageSize":"50"}

headers = {"x-np-api-key": "<NaviPartner API Key>"}

response = requests.get(url, headers=headers, params=querystring)

print(response.json())
```

```javascript
const url = 'https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50';
const options = {method: 'GET', headers: {'x-np-api-key': '<NaviPartner API Key>'}};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}
```

```go
package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("x-np-api-key", "<NaviPartner API Key>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["x-np-api-key"] = '<NaviPartner API Key>'

response = http.request(request)
puts response.read_body
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.get("https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50")
  .header("x-np-api-key", "<NaviPartner API Key>")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('GET', 'https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50', [
  'headers' => [
    'x-np-api-key' => '<NaviPartner API Key>',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50");
var request = new RestRequest(Method.GET);
request.AddHeader("x-np-api-key", "<NaviPartner API Key>");
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = ["x-np-api-key": "<NaviPartner API Key>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://api.npretail.app/01234567-89ab-cdef-0123-456789abcdef/production/CRONUS%2520International%2520Ltd./inventory/varietytable?type=SIZE&pageSize=50")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "GET"
request.allHTTPHeaderFields = headers

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```