Multi-level JSON Operations

You can perform bulk operations with multi-level JSON formatting. You must format the column headings with a dot (.) to separate upper-level and sub-level multi-layer keys. JSON Formatting Column Headings describes the column headings.

Table 1. JSON Formatting Column Headings
SubscriberId Price Attr.* Attr.subKey1 Attr.subKey2
SubscriberSearchData 42 ExternalAtrr extkey11 extkey12
The following code is an example of a CSV file for multi-level JSON operations.
SubscriberSearchData,Price,Attr.*,Attr.subKey1,Attr.subKey2
SubscriberId+SubId1,42,ExternalAtrr,extkey11,extkey12
JSON Formatting Column Headings yields the following JSON code.
SubscriberSearchData,OfferRequestArray.$,
OfferRequestArray.ProductOfferId,OfferRequestArray.CatalogItemId
ExternalId+SubId1,MtxPurchasedOfferData,1,23
ExternalId+SubId1,MtxPurchasedOfferData,5,22
ExternalId+SubId2,MtxPurchasedOfferData,1,23