Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
monty24
Contributor II
Contributor II

Error "Sequence contains no elements" from OData 4 JsonV4GetData

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

 

--
Guido Leenders
Invantive BV
Labels (1)
6 Replies
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
Contributor II
Contributor II
Author

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.

--
Guido Leenders
Invantive BV
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
Contributor II
Contributor II
Author

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?

monty24_0-1648023797743.png

 

--
Guido Leenders
Invantive BV
Francisco_Fernandez

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

monty24
Contributor II
Contributor II
Author

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. 

--
Guido Leenders
Invantive BV