I'm trying to use a REST API as a datasource for a grid. It's been a nightmare. I've followed the Spotify example and managed to get that running. However ever other API I've tried simply will not work. The documentation on how to define the schemas is not at all easy to understand. There need to be many more examples of how to do this for other APIs especially ones that have multiple sections and levels.
I have tried to use this very simple REST API: https://jsonplaceholder.typicode.com/users
I created a schema for Address, Company, then User which includes the other fields and those previous schemas as arrays. Created a scheme Users which wraps User as an array and then UserResponse which wraps that.
When it's all said and done the grid will show the column names but no data is displayed. Instead I get this error:
System.Text.Json.JsonException: The JSON value could not be converted to ApiTester.Models.JsonPlaceHolder.UsersResponse. Path: $
Can anyone create a simple product consuming that API and displaying the results in a grid? I would love to see how it's done. In fact, I'd love to see several other examples of how people are defining and using API datasources.