Content Management Tables API

The Tables API is in phase and is not yet available to users. You can contact the Product-Live team at contact@product-live.com if you want more details and get an early access.

Introduction

A table is used to store different types of data. For example you can store products, orders, offers, suppliers...

The Tables API Swagger definition is available on our Product-Live API portal here.

General information

• Rate limit: 50 requests per minute

Get Table by id

Request URL

Path path

Parameter	Type	Description
tableId	string	A table id

Request parameters

None

Request headers

Header	Type	Description
accept	string	*/*
X-Api-Key	string	Your account API key
X-Context	number	The account id of your partner in order to search its shared tables

Request Body

None

Request Example

curl -X 'GET' \
  'GET https://api-next.product-live.com/v1/tables/1554' \
  -H 'accept: */*' \
  -H 'X-Api-Key: <REDACTED>'
  -H 'X-Context: 4013'

Response example

{
    "id": "1554",
    "updatedAt": "2025-01-24T14:24:33.000Z",
    "createdAt": "2025-01-14T13:40:42.000Z",
    "title": "Produits",
    "titleLocal": {
        "eng": "Products"
    },
    "key": "PRODUCTS_RETAILX",
    "accountId": "4013",
    "status": "ACTIVE"
}

List Tables

Request URL

Path parameters

None

Request parameters

Parameter	Type	Description
page	integer	Optional The page number to retrieve. Default value if missing : 0
size	integer	Optional The number of items per page. Default value if missing : 10

Request headers

Header	Type	Description
accept	string	*/*
X-Api-Key	string	Your account API key
X-Context	number	The account id of your partner in order to search its shared tables

Request Body

None

Example

curl -X 'GET' \
  'https://api-next.product-live.com/v1/tables?page=0&size=1' \
  -H 'accept: */*' \
  -H 'X-Api-Key: <REDACTED>'
  -H 'X-Context: 4013'

Response example

{
    "object": "list",
    "data": [
        {
            "id": "1554",
            "updatedAt": "2025-01-24T14:24:33.000Z",
            "createdAt": "2025-01-14T13:40:42.000Z",
            "title": "Produits",
            "titleLocal": {
                "eng": "Products"
            },
            "key": "PRODUCTS_RETAILX",
            "accountId": "4013",
            "status": "ACTIVE"
        }
    ],
    "totalElements": 1
}

Find Tables

Request URL

Path parameters

None

Request parameters

Parameter	Type	Description
page	integer	Optional The page number to retrieve. Default value if missing : 0
size	integer	Optional The number of items per page. Default value if missing : 10

Request headers

Header	Type	Value
accept	string	application/json
X-Api-Key	string	Your account API key
X-Context	number	The account id of your partner in order to search its shared tables

Request Body

See more details on the find request body in the dedicated page Find request.

Single parameter research

{
    "type": "search",
    "caseSensitive": true,
    "field": "name",
    "value": "PRODUCTS%"
}

Multiple parameters research

{
  "type": "and",
  "queries": [
    {
        "type": "eq",
        "caseSensitive": true,
        "field": "name",
        "value": "PRODUCTS%"
    },
    {
        "type": "greaterOrEqual",
        "caseSensitive": true,
        "field": "createdAt",
        "value": "2023-01-24T09:47:16.000Z"
    }
  ]
}

Request Example

curl

curl -X 'POST' \
  'https://api.product-live.com/v1/tables/find?page=0&size=1' \
  -H 'accept: */*' \
  -H 'X-Api-Key: <REDACTED>'
  -H 'X-Context: 4013'
  -d '{
  "type": "and",
  "queries": [
        {
        "type": "search",
        "caseSensitive": true,
        "field": "key",
        "value": "PRODUCTS%"
    },
    {
        "type": "greaterOrEqual",
        "caseSensitive": true,
        "field": "createdAt",
        "value": "2023-01-24T09:47:16.000Z"
    }
  ]
}'

Response example

{
    "object": "list",
    "data": [
        {
            "id": "1554",
            "updatedAt": "2025-01-24T14:24:33.000Z",
            "createdAt": "2025-01-14T13:40:42.000Z",
            "title": "Produits",
            "titleLocal": {
                "eng": "Products"
            },
            "key": "PRODUCTS_RETAILX",
            "accountId": "4013",
            "status": "ACTIVE"
        }
    ],
    "totalElements": 1
}