Clay Icon
Join the Community
02 Support

Maintaining Full XML Values in RSS Feed Output for Accurate Data Parsing

Avatar of Brian S.Brian S.
·
·

Hey, I am on a URL page that is the xml link via an RSS feed. Why does it keep updating the xml values from "<testOrLive>LIVE</testOrLive>" to "LIVE" in the body output. How do I return the exact full xml values so I can build formulas to columns using <testOrLive> as the split value for the cell?

7 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The RSS feed integration in Clay is designed to import feed items into individual rows in a Clay table. It doesn't modify the original XML values. The change you're seeing from "testOrLiveLIVE/testOrLive" to "LIVE" is likely happening during the import process or due to how the data is being displayed in Clay.To get the exact full XML values, you might need to adjust your import settings or use a different method to fetch the raw XML data. The RSS feed integration in Clay is primarily designed for content aggregation, not for preserving the exact XML structure.What specific steps have you taken to import the RSS feed into Clay, and which columns are you seeing in your table after the import? Sources: RSS feed integration overview | Documentation | Clay University Fetch RSS Feed Items with RSS Feeds

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • Avatar of Brian S.
    Brian S.
    ·
    ·

    I keep trying to edit the settings to this: "XML documents but are returning as plaintext, we need to tweak the settings. 1️⃣ Set "Output Fields" to "Text with Tokens" ✅

    • This helps Clay better identify structured sections.

    2️⃣ Keep "Keep Non-Text in Body" Enabled ✅

    • Ensures XML-like data isn't stripped out.

    3️⃣ DO NOT use "Extract Custom Regex" Yet

    • We will add manual parsing after we see how "Text with Tokens" affects the output.

    4️⃣ Enable "JavaScript Rendering" ✅ (if applicable)

    • Ensures the entire document loads correctly before being processed."

    It appears that too is not returning the values desired.

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hi Brian, thanks for reaching out! I see you've submitted another request in your company slack as well so I'm closing this thread to continue the conversation there!

    👍1
  • Avatar of Brian S.
    Brian S.
    ·
    ·

    Thank you

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Brian S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: