Solved: Places connector doesnt read opening hours

Support
#1

Does somebody has an idea, how to read opening hours with Places Connector?

Current state - it reads only "open now: true/false".

Got it:

add to GooglePlaces.xml at the end, before lines

   </JsonPath>
 </Parse>
 </RestConnector>

following line:

<JsonPath Expr="opening_hours.weekday_text" Id="opening_hours" Title="opening_hours" Converter="String" DefaultValue=""/>
#2

I have updated the connector and included the entire raw json string as a new field, does this help? Not sure how to make it "Excel-friendly":

"opening_hours":
        {
          "open_now": false,
          "periods":
            [
              {
                "close": { "day": 1, "time": "1700" },
                "open": { "day": 1, "time": "0900" },
              },
              {
                "close": { "day": 2, "time": "1700" },
                "open": { "day": 2, "time": "0900" },
              },
              {
                "close": { "day": 3, "time": "1700" },
                "open": { "day": 3, "time": "0900" },
              },
              {
                "close": { "day": 4, "time": "1700" },
                "open": { "day": 4, "time": "0900" },
              },
              {
                "close": { "day": 5, "time": "1700" },
                "open": { "day": 5, "time": "0900" },
              },
            ],
          "weekday_text":
            [
              "Monday: 9:00 AM – 5:00 PM",
              "Tuesday: 9:00 AM – 5:00 PM",
              "Wednesday: 9:00 AM – 5:00 PM",
              "Thursday: 9:00 AM – 5:00 PM",
              "Friday: 9:00 AM – 5:00 PM",
              "Saturday: Closed",
              "Sunday: Closed",
            ],
        }
1 Like
#3

To make it more Excel-friendly, I go for opening_hours.weekday_text and use normalize whitespace and strip line breaks.

#4

Updated with the following output syntax:
Monday: 9:00 AM – 5:00 PM, Tuesday: 9:00 AM – 5:00 PM, Wednesday: 9:00 AM – 5:00 PM, Thursday: 9:00 AM – 5:00 PM, Friday: 9:00 AM – 5:00 PM, Saturday: Closed, Sunday: Closed

1 Like