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