Importjson > malformed

Developer Experience
2

This couldn’t easily be modelled with Swagger (as far as I could see anyway).

The API expects a JSON formatted object, but needs some extra information as per the comment. In particular we need to know the uniqueKeys.

{ 
  uniqueKeys: [col1], 
  rows: [{
    col1: value1
   }]
}

I’d imagine your JSON could be changed to:

{
   "uniqueKeys":[
      "petName"
   ],
   "rows":[
      {
         "petName":"Buffy",
         "ownerName":"Hassum Harrod",
         "aptDate":"2016-06-20 15:30",
         "aptNotes":"This Chihuahua has not eaten for three days and is lethargic"
      },
      {
         "petName":"Spot",
         "ownerName":"Constance Smith",
         "aptDate":"2016-06-24 08:30",
         "aptNotes":"This German Shepherd is having some back pain"
      },
      {
         "petName":"Goldie",
         "ownerName":"Barot Bellingham",
         "aptDate":"2016-06-22 15:50",
         "aptNotes":"This Goldfish has some weird spots in the belly"
      },
      {
         "petName":"Mitten",
         "ownerName":"Hillary Goldwyn",
         "aptDate":"2016-06-21 9:15",
         "aptNotes":"Cat has excessive hairballs"
      }
   ]
}

This assumes you have DataSet columns for:

  • petName
  • ownerName
  • aptDate
  • aptNotes
1 Like