Tag: query

Error: { "error": { "code": "BadRequest", "message": "Syntax error: character '*' is not valid at position 0 in '*'.", "innerError": { "request-id": "aa4dd443-8100-46d4-8d3d-da83ac969266", "date": "2018-10-02T08:41:03" } } Posible Motivo: Estamos utilizando una de las variables que aparece en la documentacion, por ejemplo ‘search’ de este modo: https://graph.microsoft.com/v1.0/sites?$search=* Solución: Utilizar la variable directamente mediante su nombre, […]
A través de una aplicación de consola podemos crear items en una lista utilizando la librería cliente de SharePoint: string siteUrl = "https://mytenant.sharepoint.com/sites/mysite"; using (ClientContext clientContext = new ClientContext(siteUrl)) { SecureString passWord = new SecureString(); foreach (char c in "myPassword".ToCharArray()) passWord.AppendChar(c); clientContext.Credentials = new SharePointOnlineCredentials("myMail@myDomain.com", passWord); List oList = clientContext.Web.Lists.GetByTitle("myList"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); […]
Para obtener items usando la busqueda de SharePoint y posteriormente mostrar una tabla de resultados debemos seguir dos pasos: Hacer la query y procesar los resultados. Para realizar la query podéis utilizar una funcion explicada en este post: http://www.idttechblog.com/powerquery-crear-query-para-usar-la-busqueda-de-sharepoint-con-rest-api/ Una vez creada la función para hacer la query, debemos obtener los resultados y procesar los […]
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 […]
1. Execute your Query with “Results to Grid” option selected (You can select this option with its icon or by menu “Query – Results To – Results to grid”). 2. Once your Query has finished, right-click on the results grid and select the option “Save results As…“. 3. Save as Type: CSV.
This is a function in order to create a CAML Query specified for Filters. Once we have the filters, we’ve to create the parameters for the function, following this template: Parameters Template Name1|Type1|Operation1|Value1,Name2|Type2|Operation2|Value2... [Operation property can only be "Equal" or "Contains", 'cause that's what I need, but it can be modified] Example Title|Text|Contains|Document,Category|Choice|Equal|Docs [Filter items […]
You can configure your Search Application Topology through your servers and manage all its parts separately, or (like in my case) you only need to configure it all in one server. Using PowerShell I’ve only need to run this following commands: 1. Get the Search Service Instance of my server into a variable (The second […]