I am trying to display Twitter feeds as a list of titles/hyperlinks. Previously,

I am trying to display Twitter feeds as a list of titles/hyperlinks. Previously, this was done very easily by using a Twitter RSS feed, but that is no longer supported. I am able to use the Twitter API to get the feeds in JSON format, but am having difficulty parsing it using readjson, readjsonarray functions. Does anyone have any experience in doing this, or could help me with an expression to parse the data? I have also tried using the function jsontoxml to convert to xml and use xpath, but that also does not return results. Thanks in advance....

OriginalPostID-73475

OriginalPostID-73475

  Discussion posts and replies are publicly visible

Parents
  • I just tested on my Appian Cloud 7.2 environment.. Retrieved the last 100 tweets from the Appian twitter account.. JSON response was 138709 characters.. XML conversion was 179401 characters.. everything worked perfectly.. parsed out the XML using xpathsnippet to retrieve the 100 tweets and twitter IDs into two text arrays using these functions - xpathsnippet(jsontoxml(ac!ResponseBody), "/json/e/text/text()") and xpathsnippet(jsontoxml(ac!ResponseBody), "/json/e/id/text()")

    If you continue to experience this issue, I would suggest opening up a support ticket to help resolve. The primary difference between our environments is the version of Appian.
Reply
  • I just tested on my Appian Cloud 7.2 environment.. Retrieved the last 100 tweets from the Appian twitter account.. JSON response was 138709 characters.. XML conversion was 179401 characters.. everything worked perfectly.. parsed out the XML using xpathsnippet to retrieve the 100 tweets and twitter IDs into two text arrays using these functions - xpathsnippet(jsontoxml(ac!ResponseBody), "/json/e/text/text()") and xpathsnippet(jsontoxml(ac!ResponseBody), "/json/e/id/text()")

    If you continue to experience this issue, I would suggest opening up a support ticket to help resolve. The primary difference between our environments is the version of Appian.
Children
No Data