topic Re: Qlik - Load data from GraphQL API with REST data connector in Connectivity & Data Prep

Qlik - Load data from GraphQL API with REST data connector

elaineng — Wed, 07 Dec 2022 10:25:21 GMT

Hi There,

I am using Qlik Sense Enterprise Aug 2022 version on prem
Qliksense server: 14.78.5

I would like to load data from GraphQL API with REST data connector.

I test using graphQL from this site: https://swop.cx/

This are my settings:

URL: https://swop.cx/graphql
Method: Post

Request Body:
query {
latest {
baseCurrency
quoteCurrency
quote
}
}

Query headers:

Name: Authorization
Value: ApiKey <xxxxx>

I've created the connection successfully.

However, when I try to preview the Metadata. It show that Malformed message body: Invalid JSON

I wonder Qlik support nested JSON format.

Re: Qlik - Load data from GraphQL API with REST data connector

Jay_Brown — Wed, 07 Dec 2022 15:39:41 GMT

Hello @elaineng , some developers have had success doing this so hopefully they can offer some guidance.

One thing I have seen suggested is normalizing the data as discussed here:
https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-convert-nested-JSON-output-into-a-single-table/m-p/1533805

I've also seen workarounds such as importing the JSON data into another database that supports nested JSON and then using Qlik to retrieve the data from that.

Hope that helps!

Re: Qlik - Load data from GraphQL API with REST data connector

elaineng — Thu, 08 Dec 2022 01:40:13 GMT

Thanks @Jay_Brown, in order for me to convert nest JSON to single, the information have to be loaded into fields, however, currently the load data I get is error.

Re: Qlik - Load data from GraphQL API with REST data connector

salonibhatia — Sun, 15 Jan 2023 15:48:08 GMT

Hi @elaineng,

You can add additional query headers as below:

Name: content-type

Value: application/json

Then while extracting the data, click on the drop-down and select the relevant table records and not everything. In the above screenshot, you have selected the main root; unselect it and select the records of the table only.

Am also trying to create a Rest API connection for Graph QL at the moment, have been able to connect and fetch records of a particular table. However, looking to make it dynamic. Have you been able to create one connection and fetch data from different tables using with connector?

Thanks!

Re: Qlik - Load data from GraphQL API with REST data connector

Sivanesan — Tue, 09 Jul 2024 02:59:54 GMT

Hi @elaineng

Were you able to make this work. I am also having the same issue.

Re: Qlik - Load data from GraphQL API with REST data connector

Sivanesan — Tue, 09 Jul 2024 03:11:19 GMT

Hi @salonibhatia

Thanks for your input. I tried adding the content type but still I am having the same issue.