Import Data Format | PDX Syndication

When importing data directly into a channel using the API, the structure should look like the following example:

{ 
    "products": [{ 
    //Specific category from the vendor’s MDM system 
    "myCategory": "Wire Cutter", 
    //Unique product ID 
    "__ID": "00012345678905", 
    //Product name  
    "__NAME": "Automatically Adjustable Wire Stripper", 
    //Value saved in a LOV field 
    "Handle Color": "White", 
    //True value as a "Y"  
    "Rust Coating": "Y", 
    //Complete public URL to asset with correct contentType 
         "Product Image":
         "http://www.imageurl.com/subfolder/00012345678905.jpg", 
    //Integer 
    "Number of Uses": "5", 
    //Double 
    "Shipping Weight (oz)": "5.4", 
    //String 
    "Model Number": "PQ3-8B9", 
    //Date in ISO 8601 format 
    "Sell Online Start": "2019-04-05T17:42:00.000Z", 
    //GTIN 
    "GTIN": "00012345678905", 
    //Multi-value 
    "Not Sold in States":[“AK”,”HI”,”GU”,”PR”,”VI”], 
    //Alternate Multi-value 
    " Not Sold in States ":"AK|HI|GU|PR|VI", 
    //Deleting existing Values 
    "Bullet10":"", 
    //Null Values 
    "UL Listed":null, 
  }] 
}

For each product, the user needs to specify the __ID and __NAME attributes at minimum. These are special attributes indicated by prefixing a double underscore "__".

Note that by default, all values are represented in PDX master data as strings. The ensures formatting is maintained and no alignment is necessary if upstream attribution base types change.

Sample of sending multiple products:

{ 
 "products": [{ 
  "__ID":"123456 " 
  ,"__NAME":"Product Name 1" 
  ,"Product Description":"Product Description 1" 
  ,"Product Image":"https://www.mydomain.com/subfolder/123456.jpg" 
 } 
 ,{ 
  "__ID":"234567 " 
  ,"__NAME":"Product Name 2" 
  ,"Product Description":"Product Description 2" 
  ,"Product Image":" https://www.mydomain.com/subfolder/234567.jpg " 
 }] 
}