Hi, Over the xmas period (at work) I was really looking forward to trying out the new REST API connector and pulling some simple data from Twitter to be able to put into a Qlik dashboard to show management. Unfortunately, I'm stuck with setting up the connection , so would really appreciate the support of this community .
When it goes through to the next screen I am only given the option of CSV , so when I try to change this to JSON I get an error saying invalid response type. I've tried with and without id=1 (worldwide) and also adding it to the query parameters.
Can anyone help and do you have a simple example I can try to replicate please?
Hi Michael - yes - the response I got back automatically displayed JSON, You can ignore the blanked out one, I did that to avoid confusion. I broke up a query parameter that was not needed and forgot to delete it from the box before taking the screenshot.
Easiest way to troubleshoot this would be to install Fiddler or any other web proxy to check the request/response to/from Twitter. It would then be easy to spot if Content-Type is set to application/json;charset=utf-8 in the response as it looks like you're not getting JSON back
If authentication would be wrong, you would get an authentication error (401) so that doesn't seem to be the issue either:
REST Connector should pick up the response type automatically if "Auto detect response type" is set. If you uncheck "Auto detect response type" you have the option on the next screen to select response type, but there shouldn't be any need for this in general.
See if you can download and run Fiddler. You should find the request in the left pane and in the bottom right pane you will see the response (select Raw to see the pure response being sent back). Check header content-type in the response: