Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

QlikView and Qlik Sense on Synthesio Social Listening Platform

Employee
Employee

QlikView and Qlik Sense on Synthesio Social Listening Platform

Hey there,

I am starting this article to yell out to the community, that I have completed a generic script (suitable for QlikView and Qlik Sense using the Qlik REST Connector) to use the API of Synthesio for loading data.

I am not sure how many folks will search for this combination, so before I document hours of "how to do" here, please ping me a note (reply below or email me at christof.schwarz@gmx.at) that you're interested. I will then share it here. If noone ever asks for this combination, I saved a lot of time ;-)

The idea is the following:

  • Synthesio offers several REST APIs
  • You have to get an accesstoken which is valid for some hours. My script is doing so.
  • You can query Synthesio's Mention API, the one you likely look for are
  • The result is a json object, which unfortunately does not translate automatically into a workable datamodel when using the REST Connector wizard.
  • I had to load the result basically into one cell (one row) and then parse the content accordingly.

Excerpt from the "magic script":

screenshot.2017-05-05 (3).jpg

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎05-05-2017 10:18 AM
Updated by: