topic Re: Foursquare/Swarm Connection in QlikView

Foursquare/Swarm Connection

ieuyar — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have collected my last 10 years data and I am preparing my personal dashboard. I would like to get my check-in history from FourSquare/Swarm and demonstrate it on my dashboard, too.

I have already researched about exporting data from mentioned app and I get it in JSON format. But if possible, I'd like to connect that database in order to get live history.

Is it possible? Did anyone connect to such applications? I have already checked List Of Connectors For QlikView & Qlik Sense but could not find an appropriate connector there.

Thanks,

Ibrahim

Re: Foursquare/Swarm Connection

Clever_Anjos — Mon, 27 Nov 2017 11:21:59 GMT

Not sure, but maybe the REST connector could help you

Get Check-Ins for a User - Foursquare Developer

Re: Foursquare/Swarm Connection

ieuyar — Mon, 27 Nov 2017 11:37:39 GMT

Thanks for your response.

I have already tried that but could not get a result. (It asks me to enter a specific date as a parameter and even if I enter a specific date, it returns with errors.)

Re: Foursquare/Swarm Connection

Clever_Anjos — Mon, 27 Nov 2017 13:12:04 GMT

Maybe wrong date format? Did you check documentation?

Re: Foursquare/Swarm Connection

Clever_Anjos — Mon, 27 Nov 2017 13:12:47 GMT

It asks for a "timestamp" into unix epoch format, how are you passing it?

Re: Foursquare/Swarm Connection

ieuyar — Mon, 27 Nov 2017 13:36:37 GMT

I'm testing my request on apigee console https://apigee.com/console/foursquare and it asks date in YYYYMMDD format. And after I send request, I get "HTTP/1.1 429 Too Many Requests" error.