Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

OData connector to support v4 (JSON)

mlehtola
Partner - Contributor III
Partner - Contributor III

OData connector to support v4 (JSON)

Current OData connector only supports XML data. OData v4 specification is already in wide use (Microsoft D365 for example) so Qlik OData connector should support JSON data with the v4 spec.

This should be done to both SaaS Odata connector and Web connectors OData connector.

Tags (2)
11 Comments
chrisbrain
Specialist II
Specialist II
P-O_Davidson
Employee
Employee

Hi,

This is currently in development and will be released by end of this year.

Thank You,
P-O Davidson

Status changed to: Open - In Development
clownbassie
Partner - Contributor II
Partner - Contributor II

Hi,

I have also issues with the OData connector as the OData protocol used in the API is 4.0. Any indication when this feature will be released in QS SaaS?

p_verkooijen
Partner - Specialist
Partner - Specialist

Dec 2021 connectors have been released last week.

No mention of any ODATA v4 functionalities ☹️

https://da3hntz84uekx.cloudfront.net/WebConnectors/2.119.1/0/QlikWebConnectorsDecember2021ReleaseNot...

P-O_Davidson
Employee
Employee

I was a bit too optimistic back in October, but the support for OData v4.0, including JSON responses, is now on track for release in February 2022.

monty24
Contributor II
Contributor II

Is there currently a new predicted release date for OData4 connector on basis of JSON (not XML)? It would enable us to use Invantive Cloud with 75 connectors (Yuki, Twinfield, Exact Online) against all Qlik instances.

P-O_Davidson
Employee
Employee

Hi,

The OData Connector is now updated with support for v4 and JSON response messages. The updated connector was made available in Qlik Sense SaaS in February, and in the Qlik Web Connectors standalone release on March 5, 2022.

BR, P-O

Status changed to: Delivered
monty24
Contributor II
Contributor II

Thank you for the update and clarity!

One of your partners pointed out the docs today at https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

monty24
Contributor II
Contributor II

Is there any other documentation or sample script? The OData 4 JSON part seems hard to use, even with knowledge of OData 4.

I want to connect the Invantive Bridge Online of Invantive Cloud to Qlik. It offers OData 4 in JSON-format using the Microsoft OData stack, with Basic authentication and data in streaming format. $filter supported, but no $expand and paging by design.

P-O_Davidson
Employee
Employee

Hi @monty24, please find an example on how to use the updated OData Connector extracting JSON-formatted data in this knowledge base article. It is just a basic use case, but hopefully it provides some guidance for you.

I can see this quickly becoming quite complex, so please don't hesitate letting me know any feedback you may have on how to improve. It is already slightly different in Qlik Sense SaaS, and we are hoping to find ways to simplify and improve in future releases.

/P-O