Using the Qlik REST Connector - Pagination and Multiple JSON Schemas

Blog and Resources: community.qlik... - this video shows how to use the Qlik REST Connector to access a freely available REST API www.swapi.co/a... - and covers how to link multiple JSON schemas together so you can analyze the data in Qlik Sense. The media box extension can be found here: branch.qlik.com...

[@francescopuppini]

Nice! You actually do not need 4 tables. You can remove the table Species, because it does not have any role in the data model: if you remove it, you will have the same identical dashboard with the same identical relations. The table Results-1 should be renamed Species, because each row is a distinct Species. The table Results should be renamed People, because each row is a distinct individual. The table People should be renamed LINK, because it is a link. If you follow this naming logic, the table People will have 87 rows, because there are 87 people. The table Species will have 37 rows because there are 37 species. Sounds more logical to me! :-) Thanks a lot Mike, this was very useful!

[@pauljohansson4809]

Tarallo for the win!

[@GuyInaQ]

HAHAH Thanks for that Paul - that was awesome - hope the video was helpful.

[@satisha8850]

Thanks it is very useful. But, I have requirement to call many API's, so ending up with creating many connection, I would like to know any way to call pagination using WITH clause

[@QlikOfficial]

Hi - it is best to post these types of questions in the Qlik Community - or if you are able - open a support ticket.

[@igormarchalik5468]

well done, thanks

[@qliksensebi-5008]

Nice

[@cristiansan]

how can I use Google instead of Bing? I was trying but the gramer doesnt work :(

[@GuyInaQ]

Hi Cinic - I'll try an example - can you also post this question on the qlik community? We are better equipped to address questions there. You can open a discussion thread and type @michael_tarallo, select mto and I will be notified of the post.

[@cristiansan]

Ill already does, thank you. (waiting for response in community yet)

[@zorzamanmakinesi2472]

Hi,
Thanks for the explaination. The script for connecting to Twitter API at 7:19 (
th-cam.com/video/n1Gx8eM4QOk/w-d-xo.html) is not familiar to me. Can you inform which connector is this? (It says Qlik Connector but i could not find a match on the Internet) I need to pass custom request bodies in my Elasticsearch queries like you did with some sql style where statements here.