Suggest an Idea

[mlehtola]

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.

[chrisbrain]

Think this is a duplicate of:
https://community.qlik.com/t5/Suggest-an-Idea/Update-Qlik-Web-Connector-to-support-Odata-4-0/idi-p/1...

[P-O_Davidson]

Hi,

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

Thank You,
P-O Davidson

[Stas_vd_Braber]

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]

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]

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]

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]

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

[monty24]

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]

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]

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