idea OData connector to support v4 (JSON) in Suggest an Idea

OData connector to support v4 (JSON)

mlehtola — Wed, 05 May 2021 05:33:40 GMT

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.

Re: OData connector to support v4 (JSON)

chrisbrain — Wed, 05 May 2021 13:21:00 GMT

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/1795818

Re: OData connector to support v4 (JSON) - Status changed to: Open - In Development

P-O_Davidson — Thu, 21 Oct 2021 20:28:05 GMT

Hi,

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

Thank You,
P-O Davidson

Re: OData connector to support v4 (JSON)

Stas_vd_Braber — Mon, 13 Dec 2021 09:57:13 GMT

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?

Re: OData connector to support v4 (JSON)

p_verkooijen — Mon, 13 Dec 2021 10:47:42 GMT

Dec 2021 connectors have been released last week.

No mention of any ODATA v4 functionalities ☹️

https://da3hntz84uekx.cloudfront.net/WebConnectors/2.119.1/0/QlikWebConnectorsDecember2021ReleaseNotes.pdf

Re: OData connector to support v4 (JSON)

P-O_Davidson — Mon, 13 Dec 2021 19:46:02 GMT

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.

Re: OData connector to support v4 (JSON)

monty24 — Tue, 22 Mar 2022 10:00:59 GMT

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.

Re: OData connector to support v4 (JSON) - Status changed to: Delivered

P-O_Davidson — Tue, 22 Mar 2022 12:17:07 GMT

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

Re: OData connector to support v4 (JSON)

monty24 — Tue, 22 Mar 2022 12:21:31 GMT

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-Source-Connectors/OData-Connector.htm

Re: OData connector to support v4 (JSON)

monty24 — Tue, 22 Mar 2022 21:45:18 GMT

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.

Re: OData connector to support v4 (JSON)

P-O_Davidson — Mon, 28 Mar 2022 13:57:11 GMT

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

Re: OData connector to support v4 (JSON)

monty24 — Mon, 28 Mar 2022 15:08:29 GMT

Thank you for the tip. I have tested again, but still run into a (maybe C# LINQ?) error:

Sequence contains no elements

Step 1: connect to a database using OData 4:

Step 2: retrieve metadata of ActiveCampaign in Qlik:

Step 3: Try to retrieve data

This issue is being addressed through a separate topic: https://community.qlik.com/t5/Connectivity-Data-Prep/Error-quot-Sequence-contains-no-elements-quot-from-OData-4/m-p/1908601#M10436