Help: RSS Feed Format does not allow for dot notation access.

Update:

I tried to create a microservice, in Python, which serves a JSON file:

The endpoint looks like this:

@anvil.server.http_endpoint("/rss/events")
def get_events_rss_feed():
    events_rss_url = "https://www.farrago.club/event/rss.xml"
    try:
        req = requests.get(events_rss_url)
        print(f"req: {req}")
    except Exception as e:
        print(f"Error: {e}")
        return
    dict = xmltodict.parse(req.content)
    # pprint(dict)

    items = dict.get('rss').get('channel').get('item')

    pprint(items)
    for item in items:
        item['mediaThumbnailUrl'] = item['media:thumbnail']['@url']

    return json.dumps({"items":items}, indent=4)

It is accessible here: https://farrago-admin.anvil.app/_/api/rss/events

And returns a JSON file formatted as follows:

{
    "items": [
        {
            "title": "Event | Sound of London | Sep 12, 2023",
            "link": "https://www.farrago.club/event/sound-of-london",
            "guid": "https://www.farrago.club/event/sound-of-london",
            "description": "Sound of London is more than a festival, its a story: a first-of-its-kind 4-day event highlighting various corners of the underground music.",
            "pubDate": "Tue, 12 Sep 2023 18:00:00 GMT",
            "media:content": {
                "@url": "https://uploads-ssl.webflow.com/6358e991f1dde90847825b5d/64d66001ad155316398b921c_sol-dp.png",
                "@medium": "image"
            },
            "media:thumbnail": {
                "@url": "https://uploads-ssl.webflow.com/6358e991f1dde90847825b5d/64d66001ad155316398b921c_sol-dp.png"
            },
            "mediaThumbnailUrl": "https://uploads-ssl.webflow.com/6358e991f1dde90847825b5d/64d66001ad155316398b921c_sol-dp.png"
        },
        [......]
}

I’m getting the following error when trying to add the web feed in Klaviyo, without any further explanation as to what the issue is.

I can see that there was a HTTP request made from Klaviyo when trying to add the feed, but this didn’t throw any errors on my server, and looks like the response was a 200

The only issue may be that the server is a little slow, what is the built in timeout from Klaviyo’s side?
 

best,

Pat

SOLVED (Partially)

The issue turned out to be improper formatting on the returned JSON from my endpoint.

The Klaviyo engine expects the RSS metadata not just any JSON blob.
Here is my updated endpoint for anyone wondering:

```
 

@anvil.server.http_endpoint("/rss/events")
def get_events_rss_feed():
    events_rss_url = "https://www.farrago.club/event/rss.xml"
    try:
        req = requests.get(events_rss_url)
        print(f"req: {req}")
    except Exception as e:
        print(f"Error: {e}")
        return
    dict = xmltodict.parse(req.content)

    for item in dict['rss']['channel']['item']:
        item['mediaThumbnailUrl'] = item['media:thumbnail']['@url']

    return json.dumps(dict, indent=4)

```

However, I would still like to avoid doing this if possible - is there any way to index the items in Klaviyo without using dot notation?

best,
Pat

UPDATE #3

The web feed was added to Klaviyo but doesn’t work within the actual templated emails.
Likely because the server is too slow in returning the JSON blob.

This is starting to become a problem now, I don’t know why Klaviyo’s web feed integration is so limited.

Any help is appreciated

Hi @Farrago!

I’m going to run this by Engineering and I’ll get back to the thread ASAP!
 

Best,

Brian