Silverstripe: Convert twitter JSON string to Dataobject to loop though in template

Question

I'm using the twitter API to get a timeline which I want to output through my template. I'm getting the feed like so:

public static function getTwitterFeed(){
    $settings = array(
        'oauth_access_token' => "xxx",
        'oauth_access_token_secret' => "xxx",
        'consumer_key' => "xxx",
        'consumer_secret' => "xxx"
    );

    $url = 'https://api.twitter.com/1.1/statuses/user_timeline.json';
    $getfield = '?screen_name=xxx&count=5';
    $requestMethod = 'GET';
    $twitter = new TwitterAPIExchange($settings);
    $returnTwitter = $twitter->setGetfield($getfield)
                 ->buildOauth($url, $requestMethod)
                 ->performRequest();
    return json_decode($returnTwitter);

}

This returns an array of objects (the tweet is the object) and I want to be able to loop through it in my template like so:

<% loop TwitterFeed %>
    <h4>$created_at</h4>
    <p>$text</p>
<% end_loop %>

As I have it above, the loop is entered once but no values are recognised. How can I achieve this?

score 4 · Answer 1 · edited May 23 '17 at 11:54

4

DataObjects in SilverStripe represent a record from the database, in your case you wound use a ArrayData.
Use $array = Convert::json2array($returnTwitter) or $array = json_decode($returnTwitter, true) instead.
and see https://stackoverflow.com/a/17922260/1119263 for how to use ArrayData

edited May 23 '17 at 11:54

Community

1
1

answered Nov 10 '13 at 10:52

Zauberfisch

3,870
18
25

Awesome. Thank you! You got me in the right direction. I've added my solution. Cheers – Fraser Nov 10 '13 at 12:12
glad you solved it, please mark an answer as the solution to "close" this question – Zauberfisch Nov 10 '13 at 12:18

score 1 · Accepted Answer · answered Nov 10 '13 at 12:11

Thanks to Zauberfisch for pointing me in the right direction. I solved it like so:

public static function getTwitterFeed(){
    $settings = array(
        'oauth_access_token' => "xxx",
        'oauth_access_token_secret' => "xxx",
        'consumer_key' => "xxx",
        'consumer_secret' => "xxx"
    );

    $url = 'https://api.twitter.com/1.1/statuses/user_timeline.json';
    $getfield = '?screen_name=xxx&count=5';
    $requestMethod = 'GET';
    $twitter = new TwitterAPIExchange($settings);
    $returnTwitter = $twitter->setGetfield($getfield)
                 ->buildOauth($url, $requestMethod)
                 ->performRequest();

    $returnTwitter = Convert::json2array($returnTwitter);

            $tweets = array();
            foreach ($returnTwitter as $key => $value) {
                $tweets[] = new ArrayData(array('created_at' => $value['created_at'], 'text' => $value['text']));


            }
                return new ArrayList($tweets);

    }

Silverstripe: Convert twitter JSON string to Dataobject to loop though in template

2 Answers2

Linked