- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @monty24 ,
I'm going to contact R&D to see if they can provide some feedback on this .
Best regards,
Francisco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That would be great @monty24, if you want you can provide that information privately and I will forward it to R&D.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Guido Leenders
Invantive BV
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@monty24 I've sent you a private message, hopefully you can reply without that error message appearing .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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