4

How do I do to consume a REST DataSet using only something like JQuery?

For example, if I have the items in a list\library and retrieve them as follows:

https://[sharepoint]/_api/web/GetFolderByServerRelativeUrl('/Shared%20Documents')?$expand=Files

I want to display the files on an HTML/jQuery grid.

Also, what is the best JavaScript/HTML5 way to create an upload form to upload a file to that list?

2 Answers 2

1

In the question, you have mentioned a REST API endpoint. It seems to me that your environment SharePoint 2013. So SharePoint Add-ins can solve your purpose.

Also have a look on following GitHub Repository for some useful samples.

https://github.com/OfficeDev

1
1

To retrieve data from SharePoint using REST you can use below link as reference:

http://www.codeproject.com/Articles/990131/CRUD-Operation-to-List-Using-SharePoint-Rest-API

To display data in Tabular Format, You can go with jQuery DataTable. You just need to pass JSON format data from Rest API to jQuery DataTable.

https://www.datatables.net/

For Example:

<table id="Table_Div" class="display">
<thead>
    <tr>
        <th>Column1</th>
        <th>Column2</th>
    </tr>
</thead>
<tfoot>
    <tr>
        <th>Column1</th>
        <th>Column2</th>
    </tr>
</tfoot>
</table>
<Script>
var call = $.ajax({
    url: Url + "_api/Web/Lists/GetByTitle('ListName')/Items",
    type: "GET",
    dataType: "json",
    headers: {
        Accept: "application/json;odata=verbose"
    }
});
$.when(callProject).done(function(data) {
    $('#Table_Div').DataTable({
        "destroy": true,
        "data": data.d.results,
        "columns": [{
            "data": "Column1"
        }, {
            "data": "Column2"
        }]
    });
});
</Script>
1
  • jQuery & Data table is not the issue! OP needs this from outside of the SharePoint. Commented Jan 11, 2016 at 4:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.