Generic JSON Import Simple Example

The following is an example of an import document and template that uses most of the features present in a Generic JSON template. This example uses the Import Manager (here), but an IIEP (here) can also be configured with the same input and template.

Input Document

Copy the following text to a new file and save it as a JSON file. Open the Import Manager and select the file as the Data Source Filename and click 'Next.'

Copy

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
{
  "Products": [
      {
        "Name": "Pilot Pen",
        "Markets": [
          {
            "MarketID": "USA",
            "Priority": "Low",
            "Attributes": [
                 {
                    "AttributeID": "42",
                    "UnitID": "Pounds",
                    "Value": 3.068
                 },
                 {
                    "AttributeID": "84",
                    "UnitID": "Dollars",
                    "Value": 12.499
                  }				
              ]
           },
           {
            "MarketID": "EU",
            "Priority": "High",
            "Attributes": [
                 {
                    "AttributeID": "42",
                    "UnitID": "Kg",
                    "Value": 1534
                 },
                 {
                    "AttributeID": "84",
                    "UnitID": "Euro",
                    "Value": 22.995
                 }				
              ]
            }
        ],
        "Colors": [
            "Red",
            "Green",
            "Blue"
          ]
      },
      {
        "Name": "Parker Pen",
        "Markets": [
          {
            "MarketID": "USA",
            "Priority": "Low",
            "Attributes": [
                 {
                    "AttributeID": "42",
                    "UnitID": "Pounds",
                    "Value": 3.728
                 },
                 {
                    "AttributeID": "1864",
                    "UnitID": "Dollars",
                    "Value": 12.499
                 }				
              ]
            },
			{
            "MarketID": "EU",
            "Priority": "Extreme",
            "Attributes": [
                 {
                    "AttributeID": "42",
                    "UnitID": "Kg",
                    "Value": 1534
                 },
                 {
                    "AttributeID": "84",
                    "UnitID": "Euro",
                    "Value": 22.995
                 }				
              ]
            }
        ],
        "Colors": [
            "Gold",
            "Silver"
          ]
      }
    ]
}

Template

Copy the following text and paste it in the Import Manager Select Format step (refer to the image in the Conversion Preview section below), Sample field.

Copy

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
{
  "Products": [
      {
        "[?Instruction?]": "[?Record?]",
        "Name": "[?Source?]",
        "Markets": [
          {
            "[?Instruction?]": "[?Repeated?]",
            "MarketID": "[?SourceID?]",
            "Priority": "[?Source?]",
            "Attributes": [
                 {
                    "AttributeID": "[?MultiSource?]",
                    "UnitID": "[?MultiSource?]",
                    "Value": "[?MultiSource?]"
                 }			
              ]
            }
        ],
        "Colors": "[?MultiSource?]"
      }
    ]
}

Conversion Preview

Click the Sample reload button . The Conversion Preview area displays the results of the input document against the provided template.

The Map Data step (defined in the Inbound Map Data - Map topic here) presents the Generic JSON data for further mapping, if necessary, as well as transformations. To learn more about inbound transformations, refer to the Inbound Map Data - Transform documentation here.