Overview

In this Data Type, you can define all the data about any type of headless content (blog, magazin, etc.)

Example

In this example, we provide a simple attribute definition.

Here is the example for the first case above (make sure to format it in JSONL before loading to BigQuery: Newline delimited JSON : https://en.wikipedia.org/wiki/JSON_streaming).

{
  "id": "1234",
  "type": "blog",
  "creation": "2020-10-20 00:00:00",
  "title": [
    {
      "language": "de",
      "value": "Last Minute Halloween Looks zum Nachmachen"
    }
  ],
  "short_description": [
    {
      "language": "de",
      "value": "Diese Halloween Looks sind einfacher, als sie aussehen und die Produkte haben Sie sicher bereits in Ihrem Schminktäschchen!"
    }
  ],
  "description": [
    {
      "language": "de",
      "value": "Diese Halloween Looks sind einfacher, als sie aussehen und die Produkte haben Sie sicher bereits in Ihrem Schminktäschchen!<br/>Hier finden Sie 4 Last Minute Make-ups für Halloween, die nicht viel Zeit benötigen und welche Sie bestimmt auch auf den letzten Drücker hinbekommen:..."
    }
  ],
  "images": [
    {
      "value": {
        "language": "de",
        "value": "https://www.asdf.ch/media/catalog/product/9/1/91064e7c-3a8c-4d66-8d9a-06f1216a28fb.1042256.jpg"
      }
    }
  ],
  "link": [
    {
      "language": "de",
      "value": "https://www.asdf.ch/de/blog/detail/sCategory/175/blogArticle/5335"
    }
  ],
  "creation_tm": "2020-10-20 00:00:00",
  "client_id": 1,
  "src_sys_id": 1
}

Properties

Field name	Type	Mode	Description

Field name	Type	Mode	Description
id	STRING	REQUIRED	the unique id of the content
type	STRING	REQUIRED	the type of content: 'blog', 'magazin', 'page', ...
creation	DATETIME	NULLABLE	the creation date time of the content
last_update	DATETIME	NULLABLE	the last update date time of the content
persona_type	STRING	NULLABLE	the persona type who created this content
persona_id	STRING	NULLABLE	the persona who created this content
parent_content_ids	STRING	REPEATED	the parent contents related to this content (e.g.: rating of themost helpful customer review / comments)
products	PRODUCT	REPEATED	connections to products
contents	CONTENT	REPEATED	relations to other contents
customers	CUSTOMER	REPEATED	relations to other customers
stores	STRING	REPEATED	the stores
title	LOCALIZED	REPEATED	the title of the attribute value
short_description	LOCALIZED	REPEATED	the short description of the product group
description	LOCALIZED	REPEATED	the description of the attribute value
images	LIST	REPEATED	the images of the attribute value
link	LOCALIZED	REPEATED	the link of the attribute value
tags	TAG	REPEATED	the tags , e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]
labels	LABEL	REPEATED	the labels of the product line, e.g.: [STRUCT('symbol', 'delivery', '24h', [STRUCT('de', '24-H Versand')])]
status	BOOLEAN	NULLABLE	the content status
periods	PERIOD	REPEATED	information about the activity periods of the ugc
string_attributes	MAP	REPEATED	additional string (not localized) attributes of the product line (MAP type: STRING)
localized_string_attributes	MAP	REPEATED	additional localized string attributes (MAP type: LOCALIZED in STRING)
numeric_attributes	MAP	REPEATED	additional numeric (not localized) attributes (MAP type: NUMERIC)
localized_numeric_attributes	MAP	REPEATED	additional localized numeric attributes (MAP type: LOCALIZED in NUMERIC)
datetime_attributes	MAP	REPEATED	additional datetime (not localized) attributes (MAP type: DATETIME)
localized_datetime_attributes	MAP	REPEATED	additional localized datetime attributes (MAP type: LOCALIZED inDATETIME)
creation_tm	DATETIME	REQUIRED	technical field
client_id	INTEGER	REQUIRED	technical field
src_sys_id	INTEGER	REQUIRED	technical field

Resources

BigQuery JSON Schema

https://github.com/boxalino/data-integration-doc-schema/blob/master/doc/doc_content.json

BigQuery DDL

https://github.com/boxalino/data-integration-doc-schema/blob/master/ddl/doc_content.sql