Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Using Twitter API

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])

10 Replies
MVP
MVP

Using Twitter API

Hi Paulo,

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

- Ralf

Not applicable

Using Twitter API

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

MVP
MVP

Using Twitter API

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

Not applicable

Using Twitter API

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

MVP
MVP

Using Twitter API

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

Not applicable

Using Twitter API

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

MVP
MVP

Using Twitter API

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

Luminary
Luminary

Re: Using Twitter API

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?

MVP
MVP

Re: Using Twitter API

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..

Community Browser