Using Twitter API

[#1]

Hi,

I´m trying to get some informations about a twitter user. When requesting the informations at the browser (http://api.twitter.com/1/users/show.xml?screen_name=@prbscosta), it runs fine but, when trying to get these informations from a QV Script, I receive the following error messages: "Interface not registered" or "The bundled application called an interface to another segment".

What is happening? For my surprise, at home, with my notebook, it runs fine. At my work, I receive these errors.

LOAD

                    id,

              name,

              screen_name,

              description,

              profile_image_url,

              profile_image_url_https,

              url,

              protected,

              followers_count,

              profile_background_color,

              profile_text_color,

              profile_link_color,

              profile_sidebar_fill_color,

              profile_sidebar_border_color,

              friends_count,

              created_at,

              favourites_count,

              profile_background_image_url,

              profile_background_image_url_https,

              profile_background_tile,

              profile_use_background_image,

              geo_enabled,

              verified,

              statuses_count,

              lang,

              contributors_enabled,

              listed_count,

              show_all_inline_media,

              default_profile,

              default_profile_image,

              is_translator,

              [status/created_at],

              [status/id],

              [status/text],

              [status/source],

              [status/truncated],

              [status/favorited],

              [status/retweet_count],

              [status/retweeted],

              [status/possibly_sensitive],

              [status/retweeted_status/created_at] as [retweeted_status/created_at],

              [status/retweeted_status/id] as [retweeted_status/id],

              [status/retweeted_status/text] as [retweeted_status/text],

              [status/retweeted_status/source] as [retweeted_status/source],

              [status/retweeted_status/truncated] as [retweeted_status/truncated],

              [status/retweeted_status/favorited] as [retweeted_status/favorited],

              [status/retweeted_status/retweet_count] as [retweeted_status/retweet_count],

              [status/retweeted_status/retweeted] as [retweeted_status/retweeted],

              [status/retweeted_status/possibly_sensitive] as [retweeted_status/possibly_sensitive]

          FROM

          [http://api.twitter.com/1/users/show.xml?screen_name=@prbscosta]

          (XmlSimple, Table is [user])

[rbecher]

Hi Paulo,

sounds a bit like a network / firewall problem for me.

- Ralf

[#3]

Ralf,

Right, but what ports does Qlikview uses to make this kind of connection? The network administrator is asking me this and I don´t know.

Paulo

[rbecher]

Should be port 80.. Maybe the domain twitter is blocked?

Have you tried without the '@'?:

http://api.twitter.com/1/users/show.xml?screen_name=prbscosta

or just for a try the JSON format:

http://api.twitter.com/1/users/show.json?screen_name=prbscosta

- Ralf

[#5]

What is strange is that it runs fine at the browser. I think QV uses some others ports.

[rbecher]

A firewall could block the application (http header user agent)...

[#7]

Sorry but what mean "(http header user agent)"

[rbecher]

http://en.wikipedia.org/wiki/HTTP_USER_AGENT

You can see the user agent of your browser here:

http://whatsmyuseragent.com/

The http user agent of QlikView is "QlikView" (and not a browser). A firewall can block or allow different user agents (esp. old browser versions).

- Ralf

[mountaindude]

Opening this old thread again..

But is there a way where we can set the user agent that QV use when retrieving data from web APIs?

[rbecher]

I don't guess so. Wouldn't you lose the products credibility?

However a program like our JSON Proxy Server could be used to achieve this..