topic Re: Twitter Search using Qlik Rest Connector in Connectivity & Data Prep

Twitter Search using Qlik Rest Connector

kbiesemans — Wed, 09 Dec 2015 10:14:16 GMT

I was trying to load Tweets about a certain subject through the Qlik Rest Connector. Therefor I followed the steps explained in this example http://help.qlik.com/Connectors/en-US/connectors/#../Subsystems/REST_connector_help/Content/1.0/Create-REST-connection/C…

When I test the connection it always gives me tho following error message : HTTP protocol error 400 (Bad Request): {"errors":[{"code":215, "message":""Bad Authentication data."}]}.

This are my settings:

Force basic authentication.

URL : https://api.twitter.com/1.1/search/tweets.json

Method : GET

Query Paramters:

q, qlik

Query Headers:

Authorization, OAuth oauth_consumer_key="...",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1449654560",oauth_nonce="...",oauth_version="1.0",oauth_token="...",oauth_signature="..."

Host, api.twitter.com

X-Target-URI, https://api.twitter.com/

Does someone know what I can try to solve this issue?

Re: Twitter Search using Qlik Rest Connector

reddy-s — Wed, 09 Dec 2015 20:51:47 GMT

Hi Koen,

I faced an issue like this, but solved it by adding the query parameters to the URL itself.

In your case make use of this following URL and remove the query parameters.

https://api.twitter.com/1.1/search/tweets.json?q=%23Qlik

The above URL = searching twitter with #Qlik

Hope this helps!

- Sangram Reddy

Re: Twitter Search using Qlik Rest Connector

mikkeltaylor — Thu, 31 Dec 2015 14:25:56 GMT

Hi Koen, Did you manage to resolve this?

I'm also trying to get the Twitter connection to work and struggling....