Versions Compared

Old Version 6

changes.mady.by.user Sylvain Paillard

Saved on

compared with

New Version 7

changes.mady.by.user Sylvain Paillard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titlesee example in JSON

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).

Code Block
languagejson
{
  "persona_id": "82474",
  "prefix": "Herr",
  "firstname": "Marco",
  "lastname": "XXX",
  "street": "Amselweg 3",
  "zipcode": "4538",
  "city": "Oberbipp",
  "phone": "079947xxxx",
  "email": "xxx@hotmail.com",
  "countryID": "CH",
  "creation_tm": "2020-10-20 00:00:00",
  "client_id": 1,
  "src_sys_id": 1
}

Properties

Field name

Type

Mode

Description

*

CONTACT

REQUIRED

All the properties of the CONTACT defined type are also main parameters of the doc_user type

contacts

CONTACT

REPEATED

default contacts like for billing and shipping

creation_tm

DATETIME

REQUIRED

technical field

client_id

INTEGER

REQUIRED

technical field

src_sys_id

INTEGER

REQUIRED

technical field

...