Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lil1
Contributor
Contributor

Integrate QlikSense & API with Rest Connector

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

 

 

 

Labels (1)
  • API

3 Replies
jprdonnelly
Employee
Employee

@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-tutor...

Cheers!

- @jprdonnelly
lil1
Contributor
Contributor
Author

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. 

 

jprdonnelly
Employee
Employee

@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.

- @jprdonnelly