doc_content

Content: Headless content

All type of content (headless)

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