Message Boards Message Boards

How to use `Interpreter` on a nested input to Data Drop

Posted 3 months ago

I'm attempting to set up a Databin and want to specify the Interpretation property, but the objects that will be posted have nested properties and I can't figure out how to structure the Interpretation value to ensure things import as desired.

This is an example object; it's a web hook from the Swarm app by Foursquare (the location is "fuzzed" by the application, meaning if you go there you'll end up in a swamp, not my apartment ;-)). You can see that several parts have sub properties that I want to have interpreted.

<|"Timestamp" -> DateObject[{2024, 8, 1, 7, 17, 38}, "Instant", "Gregorian", 
    -4.], "id" -> "66ab6ed232bdf611d2e695ef", "createdAt" -> 1722511058, 
  "type" -> "checkin", "visibility" -> "closeFriends", 
  "timeZoneOffset" -> -240, "editableUntil" -> 1722597458000, 
  "venue" -> <|"id" -> "65949b558dc8ae0ff3d196fa", 
    "name" -> "Steven Buehler's Apartment", "location" -> 
     <|"isFuzzed" -> True, "lat" -> 28.35522101686996, 
      "lng" -> -81.68568083681541, "cc" -> "US", "neighborhood" -> 
       "Cagan Crossings", "city" -> "Clermont", "state" -> "FL", 
      "country" -> "United States", "formattedAddress" -> 
       {"Clermont, FL 34714"}|>, "categories" -> 
     {<|"id" -> "4bf58dd8d48988d103941735", "name" -> "Home (private)", 
       "pluralName" -> "Homes (private)", "shortName" -> "Home (private)", 
       "icon" -> <|"prefix" -> 
          "https://ss3.4sqi.net/img/categories_v2/building/home_", 
         "suffix" -> ".png"|>, "categoryCode" -> 12123, 
       "mapIcon" -> "fsq-default", "primary" -> True|>}, "private" -> True, 
    "createdAt" -> 1704237910|>, "likes" -> <|"count" -> 0, "groups" -> {}|>, 
  "like" -> False, "isMayor" -> True, 
  "photos" -> <|"count" -> 0, "items" -> {}|>, 
  "posts" -> <|"count" -> 0, "textCount" -> 0|>, 
  "comments" -> <|"count" -> 0|>, 
  "source" -> <|"name" -> "Steven Buehler's Project"|>|>
POSTED BY: Steven Buehler
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract