Error "Sequence contains no elements" from OData 4 JsonV4GetData

[monty24]

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"}
,...,
]
}

[Francisco_Fernandez]

Hello @monty24 ,

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

Best regards,

Francisco

[monty24]

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.

[Francisco_Fernandez]

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

[monty24]

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?

[Francisco_Fernandez]

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

[monty24]

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. 

[marvin-d_mmcgh]

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?

[monty24]

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.