topic Using Twitter API in QlikView

Using Twitter API

Fri, 18 Nov 2011 14:46:23 GMT

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

Using Twitter API

rbecher — Fri, 18 Nov 2011 15:00:24 GMT

Hi Paulo,

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

- Ralf

Using Twitter API

Fri, 18 Nov 2011 15:07:17 GMT

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

Using Twitter API

rbecher — Fri, 18 Nov 2011 15:16:37 GMT

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

Using Twitter API

Fri, 18 Nov 2011 15:41:50 GMT

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

Using Twitter API

rbecher — Fri, 18 Nov 2011 15:45:20 GMT

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

Using Twitter API

Sat, 19 Nov 2011 12:38:17 GMT

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

Using Twitter API

rbecher — Sat, 19 Nov 2011 18:03:18 GMT

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

Re: Using Twitter API

mountaindude — Mon, 10 Feb 2014 13:38:15 GMT

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?

Re: Using Twitter API

rbecher — Mon, 10 Feb 2014 14:20:04 GMT

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

Re: Using Twitter API

chrisbrain — Mon, 10 Feb 2014 15:03:50 GMT

Just a quick heads up to QVSource Users that our General JSON/XML/SOAP Web API Connector will support setting the user agent in the next release. Ping me if you need it now.