I am trying to pull items/properties from a SharePoint 2013 List using a REST API call. I cannot use the Power BI built in data source because over 8 GB of data is getting returned because of PDFs being part of the SP list. I would like to use the REST API call to limit which fields that are returned.
I came across this article https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...
And ended up with a Source like
I have tried to parse the results as Json or XML or even CSV but the results do not make sense for what I expect. I do get results I just can't make sense of them.
What am I missing?
Thanks in advance, Scott