Desde Excel, creamos una nueva Query vacía y insertamos la llamada a la API de SharePoint en la fórmula: = (querytext as text, fields as text, tenanturl as text) as list => let Source = OData.Feed(tenanturl & "/_api/search/query?querytext='" & querytext & "'&trimduplicates=false&typedobject=true&selectproperties='" & fields & "'&rowlimit=500"), PrimaryQueryResult = Source[PrimaryQueryResult], ReturnTable = PrimaryQueryResult[RelevantResults][Table][Rows] in ReturnTable Podemos […]
Este fragmento de código nos permite hacer una llamada a un Web Service REST mediante la librería RestSharp. var client = new RestClient("REST_SERVICE_URL"); client.Authenticator = new HttpBasicAuthenticator("USER", "PASSWORD"); var request = new RestRequest(Method.GET); request.RequestFormat = DataFormat.Json; IRestResponse response = client.Execute(request); var content = response.Content;