Who Needs a Data View Web Part? SharePoint REST and DataTables

[@arifasyraf3535]

hey mark! I know I'm late but just wanna say that this is a great video. Your explanations are easy to comprehend and I learnt a lot from this video. Thanks again. Keep on teaching...

[@sadguruspiritual]

Thank you for sharing Mark. I got the URL working on google chrome but when I try the same URL on other browser does not display the xml. And when I upload the code to the content editor does not work. Any ideas?

[@K6TJO]

Where did you get the data from?

[@kokilarajendran3577]

Great video. Really useful

[@androidgeeking]

I was trying to the do the query by placing the call at the end of my url in the browser but it didn't work. "('ZipCodes')/items" Is this pulling from the default view or should I address the view I'm pulling from? I really want to get this working. :)

[@sverreherland5574]

Great video! Two questions though: Is it possible to get the query to work with HTTPS? And are there any security issues with this solution?

[@sverreherland5574]

Update: Figured it out. Just store the jQueries on your site and update the references. Yes; I'm new to this.

[@allan.adimoolah]

Hi Mark can you give me some more info on how to get the query to work in the browser, I am having trouble with firstly getting the query to run in the url

[@androidgeeking]

Same here

[@robertkocher3534]

Great video Mark! Thanks. Shows the functionality, then the build and back to the functionality. I don't know js, json, xml. I know of them, but I don't know how to interpret the code. This was helpful. You referenced cdn. What is that exactly. I know there are different versions as well. Which version of cdn are these files located? Thanks.

[@MarkRackley]

+Robert Kocher CDN stands for "content delivery network" it basically means the files are hosted by someone else. I've used the latest version of databases which can be found on there site and it works great. Some of the older versions won't work though.

[@akugoms7736]

Is there a way to keep the column data types as they are in the SharePoint list when they are brought to the data table?

[@MarkRackley]

It's using the results of the REST query and how the data is returned from that query to display t the data. If you have field types like people pickers and date fields you may have to write additional code for them to display the way you want.

[@newabyuser]

i missed your monthly videos JQuery and Reset

[@zevsawyer7457]

pro tip : you can watch movies at kaldrostream. I've been using them for watching all kinds of movies recently.

[@geralddamien4887]

@Zev Sawyer yup, I have been watching on Kaldrostream for years myself =)

[@KalsangDorjee]

I have been trying to implement this solution for a while but it's just not working out for me. I have only 2 columns App ID and App Name and the list name is Test. Please help me.

[@randyd7644]

I was able to get this to work using the SP2010 REST API but it will only pull 1000 items. The list I'm using has 4500 total items. Even using the $top=5000 parameter, it will only pull 1000 total items. Is there a threshold setting somewhere?

[@MarkRackley]

+Randy D I believe this is a limitation of SharePoint 2010 REST. You can use the next link provided in the results to retrieve the next set of 1000 though.. not ideal