topic Re: Integrate QlikSense & API with Rest Connector in Integration, Extension & APIs

Integrate QlikSense & API with Rest Connector

lil1 — Fri, 08 Dec 2023 13:08:04 GMT

Hi,

what i want is load a excel file from my device to qlik sense and connect to API with Rest connector(this part is ok, i create Rest connection), get analyze data from it. for example ask some question and get response from chatGPT

can anyone guide me please

Re: Integrate QlikSense & API with Rest Connector

jprdonnelly — Fri, 08 Dec 2023 15:13:09 GMT

@lil1 - please review this link as a starting point. It references the Open AI connector in Qlik Cloud that simplifies the REST API part, but it should give you some foundation on how to use your existing REST connectivity to move forward.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/ac-openai-tutorial.htm

Cheers!

Re: Integrate QlikSense & API with Rest Connector

lil1 — Mon, 11 Dec 2023 07:06:44 GMT

Hi @jprdonnelly , Thanks for response. it helps me but i realize my connection is not like it should be. I do not have OpenAI connector like as the page mentioned. in creating connection section i can't see bellow connection type :

Example 1: OpenAI Completions API (GPT-3) - Rows
Example 2: OpenAI Completions API (GPT-3) - JSON Tables
Example 3: OpenAI Chat Completions API (GPT-3.5, GPT-4) - Rows
Interactive example: OpenAI Chat Completions API (GPT-3.5, GPT-4) - Rows

as i understand i have to create one of these connection to move forward.

Re: Integrate QlikSense & API with Rest Connector

jprdonnelly — Tue, 12 Dec 2023 16:53:21 GMT

@lil1 - You will want to replace all those connectors with the actual REST API call/WITH CONNECTION that represents the examples.

These examples use a connector that simplifies the REST API connection to OpenAI, but the same calls can be made "manually" using the normal REST connector. The interaction with the results should be more important on how to integrate the responses with your workload.