Data collection (tables)

Introduction

Basic info on tables:

• Tables are always re-created on Import
• Only values changed since the last Import are processed
• Values of items can be changed individually or in batches through API
• There are pre-defined tables Products and Categories that have their specific pre-defined fields and have additional calculated fields.
• Custom tables can have any fields, only id is required as a unique identifier.
• Each table exists in two versions – in Test Environment and Production Environment.
  Persoo is accessing the corresponding table depending on your current Environment.
• Available formats are JSON, CSV and XML
• Imports run by default every 4 hours on Production Environment and once a day on Test Environment.
• Schedule can be changed for Production Imports
• Supported encoding is UTF-8

Data import

XML specifics

Element attributes such as id in <item id="XY123"> cannot be accessed. Provide all necessary information as values of their respective elements.

JSON specifics

Make use of newlines when generating the JSON file, it makes it’s inspection easier.

Passing on multiple values of the same field.

In the JSON format, pass an array of items (e.g. colors: ['white','red']).

In an XML format, pass the same field multiple times. For example:

In CSV import, use any valid separator.

Important notes

Make sure, that the values are identical to the values given by the site’s data layer, so they can be easily paired in our system.

We recommend consulting feed’s fields also with your personalization consultant and marketing representative, as these data directly impact what scenarios can be implemented.