1 Reply Latest reply: Nov 8, 2017 10:55 AM by Steve Dark RSS

    Hashtags Twitter

    Mariam AIT HA

      Hello community;

      I want to follow twitter hashtags with qlik sense and then I do visualizations; please how can I proceed?

      Any ideas plz

      Thank you in advance

        • Re: Hashtags Twitter
          Steve Dark

          Attached is the start of an app I am working on with Twitter.  It uses the https://api.twitter.com/1.1/statuses/user_timeline.json

           

          This endpoint helpfully breaks out hashtags into separate tables, which allows for some analysis.  The results are similar for different endpoints, but may not match exactly.  The renaming of the field suffixes (_u0 etc.) seems to change each time you run the wizard to generate your code.  Presume there is an endpoint where you can enter a hashtag to follow this.

           

          With the mapping of keys into tables it gives the ability to move this to have an incremental load, persisting old records.  I've not got around to writing this yet.

           

          Naturally I have stripped the connection from this app, so you will need to re-insert it.  You will need to ensure you use the correct endpoint when you do this.

           

          Hope that helps.

          Steve