SharePoint Online, 2013 and 2016 – Display list data in grid using Rest API

Hey Everyone!

Today, in this post i will show you how can we display list data in a grid using Rest API in SharePoint Online, 2013 and 2016.
In this example, i will create a table – Cars – with 4 columns:

– Make
– Model
– Price
– Color

http://span%20style=

$(function(){
    $("#btnClick").click(function(){
        var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Cars')/items";
           $.ajax({
              url: requestUri,
              type: "GET",
              headers: {
                  "accept":"application/json; odata=verbose"
              },
              success: onSuccess,
              error: onError
});

  function onSuccess(data) {
     var objItems = data.d.results;
     var tableContent = '' + '' + '' + '' + '';
  
     for (var i = 0; i '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
 }
   $('#carsGrid').append(tableContent);
   }
    function onError(error) {
        alert('Error');
   }
  });
});


<input type="button" id="btnClick" value="Get All Cars"/>
CustomerPanel">
MakeModelPriceColor
' + objItems[i].Make + '' + objItems[i].Model + '' + objItems[i].Price + '' + objItems[i].Color + '
tableCars' style="width: 100%;" border="1 px">
carsGrid" style="width: 100%">
</td> </tr> </table> </div>

You just need to copy the code and past in a script editor webpart, if you press the button  – Get All Cars –  the result it’s a the following table:

Mark Model Price Color
Mercedes A180 22.000.00€ Red
Jaguar X-Type 72.000.00€ Green
Fiat 500 20.000.00€ Blue
Bmw 320d 32.000.00€ Black

If you are interested to read more, i recommend the following links:
https://msdn.microsoft.com/en-us/library/office/jj860569.aspx
https://msdn.microsoft.com/en-us/library/office/jj164022.aspx

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

Advertisements

Sharepoint Framework – Channel 9

Watch the introduction to Sharepoint Framework at Channel 9.

https://channel9.msdn.com/Blogs/MVP-Office-Servers-and-Services/Introduccion-al-Sharepoint-Framework/player#autoplay

Office 365: Download multiple selected files arrives to ODFB and SPO!

Read the full post from the author’s blog. Finally a long requested feature is arriving to OneDrive for Business (ODFB) and SharePoint Online (SPO): Download multiple selected files and folders using the UI: In ODFB, we can select several files and folders to get them downloaded: And the same happens with modern document libraries:

Source: Office 365: Download multiple selected files arrives to ODFB and SPO!

Feature Pack 1 for SharePoint Server 2016 now available

Today’s post was written by Bill Baer, senior product manager for the SharePoint team. When we launched SharePoint Server 2016, we shared our vision that it would be a foundational release, born in the cloud and built for continuous innovation.

Source: Feature Pack 1 for SharePoint Server 2016 now available

Google URL Shortener for SharePoint items

You can shorten URLs to make them easier to share using the Google URL shortener. For example, the short URLhttp://goo.gl/l6MS

This is a good way to share and generate short links to share documents.

1) you need to get the API Key for: https://developers.google.com/url-shortener/

2) Install Google APIs Client Library, using NuGet

googleapi

3) Check all References

shorten

4) Use the following method to generate ShortLink

public static string UrlShorter(string largeUrl)
  {
     var finalUrl = string.Empty;
     var key = "API KEY GOOGLE"
     var post = "{\"longUrl\": \"" + largeUrl + "\"}";
     var request = (HttpWebRequest)WebRequest.Create(
             "https://www.googleapis.com/urlshortener/v1/url?key=" + key);
            try
            {
             request.ServicePoint.Expect100Continue = false;
                request.Method = "POST";
                request.ContentLength = post.Length;
                request.ContentType = "application/json";
                request.Headers.Add("Cache-Control", "no-cache");
                using (var requestStream = request.GetRequestStream())
                {
                    byte[] postBuffer = Encoding.ASCII.GetBytes(post);
                    requestStream.Write(postBuffer, 0, postBuffer.Length);
                }
                using (var response = (HttpWebResponse)request.GetResponse())
                {
                  using (var responseStream = response.GetResponseStream())
                  {
                    if (responseStream != null)
                      using (var responseReader = new StreamReader(responseStream))
                      {
                        var json = responseReader.ReadToEnd();
                        var jss = new JavaScriptSerializer();
                     var dict = jss.Deserialize<Dictionary<string, string>>(json);
                        finalUrl = dict["id"]; 
                      }
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
                System.Diagnostics.Debug.WriteLine(ex.StackTrace);
            }
            return finalUrl;
        }

Thanks

Failed to Register SharePoint Services in PSConfig (Fix)

Unfortunately this happens on Stand Alone servers more often than you would think. Good news is that there is a really quick way to fix this.

Resultado de imagem para Failed to Register SharePoint Services in PSConfig sharepoint 2016

Open up Regedit and browse to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\15\LauncherSettings 
Create the following key:Type: DWORD
Name: AcknowledgedRunningOnAppServer 
Value: 1

Then do the same thin in the following registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\15\LoadBalancerSettings

No need to restart, just rerun PSConfig and you should be good to go.

Original: http://sharepoint-community.net/profiles/blogs/failed-to-register-sharepoint-services-in-psconfig

The Future of SharePoint

SharePoint 2016 – The Future Starts Now!!

The new Promo video about SharePoint 2016!!!

Global Azure Bootcamp 2016 – Is happening on April 16th!

Global Azure Bootcamp () is back!!! With a total of 163 confirmed event locations, and 26 pending. That’s 189 events in total! Check the different locations worldwide and register for an event near you! The big date is getting close…

http://global.azurebootcamp.net/

Office 365 – Delve Analytics

 

It’s an interesting application that is included in the Office E5 plan launched on December 1. Delve Analytics is also available as an add-on for the E1 and E3 plans for $4/month per user. It’s an attempt to bring big data analysis to the world of the office to understand how people interact with each other and use tools such as email.

Another description often trotted out positions Delve Analytics as the equivalent of “Fitbit for the office” because like a health tracker, you gain if you pay attention to what to what you learn. I guess “Microsoft Band 2 for the office” does not trip off the tongue quite so smoothly. Let’s discuss what Microsoft has done in Delve Analytics to gather and analyze data gathered from the activities of Office 365 users.

Take back your time with Delve Analytics 1

 

For more info:

https://blogs.office.com/2016/04/06/take-back-your-time-with-delve-analytics/#79qGogvuZRlU6Lw0.97

Thanks