topic Error "Sequence contains no elements" from OData 4 JsonV4GetData in Connectivity & Data Prep

Error "Sequence contains no elements" from OData 4 JsonV4GetData

monty24 — Tue, 07 Jun 2022 17:04:00 GMT

When defining a script with JsonV4GetData and after entry of the URL path to the resource, the selection of the Preview-button raises:

Error Sequence contains no elements

This seems a C# LiNQ error. The OData4 feed is correct and tested with three alternatives to Qlik, C#, Python, Google Functions and https://access-odata.com.

What should be different about this feed to enable use with JsonV4GetData?

Current contents:

{"@odata.context":"https://server.com/invantive-activecampaign/odata4/$metadata#ActiveCampaign.V3.Accounts@acn" ,"value": [ {"id":97,"name":"Group B.V.","accountUrl":"http://www.acme.nl","createdTimestamp":"2020-03-23T20:54:08Z","updatedTimestamp":"2021-10-21T19:52:45Z"} ,..., ] }

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

Francisco_Fernandez — Wed, 23 Mar 2022 08:04:04 GMT

Hello @monty24 ,

I'm going to contact R&D to see if they can provide some feedback on this .

Best regards,

Francisco

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

monty24 — Wed, 23 Mar 2022 08:14:12 GMT

Thank you for the action. In case they need more data for reproduction I will be happy to provide. I can also register an account with pre-defined database etc on Invantive Cloud when that helps and provide you with an OData4 URL and user name/password.

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

Francisco_Fernandez — Wed, 23 Mar 2022 08:18:08 GMT

That would be great @monty24, if you want you can provide that information privately and I will forward it to R&D.

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

monty24 — Wed, 23 Mar 2022 08:23:31 GMT

I will prepare them. I seem incapable of sending a private message: "An Unexpected Error has occurred." What is the correct way to send a private message?

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

Francisco_Fernandez — Wed, 23 Mar 2022 09:00:01 GMT

@monty24 I've sent you a private message, hopefully you can reply without that error message appearing .

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

monty24 — Tue, 06 Sep 2022 18:23:16 GMT

Are we the only ones experiencing this problem with an OData v4 feed in JSON format? The downloads are correctly processed by the OData-feed connectors on Power BI and Azure Data Factory and validate also against the Microsoft odata4 client libraries.

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

marvin-d_mmcgh — Mon, 02 Jun 2025 06:33:32 GMT

I'm experiencing the same issue at the moment. The feed works correctly on Power BI but in Qlik, I'm receiving "Error: Sequence contains no elements" when calling the JsonV4GetData method.
JsonV4ListResources works as expected.

Is there a workaround available?

Re: Error "Sequence contains no elements" from OData 4 JsonV4GetData

monty24 — Mon, 02 Jun 2025 06:47:59 GMT

Not 100% sure, but I think to recall from 2022 that it was a problem with the EDM: we had names with "." in them for entities (which violates the standard, but is often accepted). We have replaced "." by "_".

I have heard no more complaints from the Qlik users of Invantive Cloud since then.