{"id":276,"date":"2017-08-21T19:10:14","date_gmt":"2017-08-21T22:10:14","guid":{"rendered":"http:\/\/www.ctasoftware.com.br\/blog\/?p=276"},"modified":"2017-08-20T19:12:49","modified_gmt":"2017-08-20T22:12:49","slug":"consultar-lista-caml-query-sharepoint","status":"publish","type":"post","link":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/","title":{"rendered":"Consultar Lista CAML Query SharePoint"},"content":{"rendered":"<p>Consultando em outra lista no SharePoint atrav\u00e9s de CAML Query e JQuery<\/p>\n<p>[js]<br \/>\nfunction ConsultaListaTarefas() {<br \/>\n\tvar urlSite = _spPageContextInfo.siteAbsoluteUrl;<br \/>\n    var clientContext = new SP.ClientContext(urlSite);<br \/>\n    var oList = clientContext.get_web().get_lists().getByTitle(&#8216;Tasks&#8217;);<br \/>\n    var itemId = &#8216;123&#8217;<\/p>\n<p>\tvar urlParaCaml = _spPageContextInfo.webServerRelativeUrl + &#8220;\/Lists\/campanhas\/DispForm.aspx?ID=&#8221; + itemId;<br \/>\n    var camlQuery = new SP.CamlQuery();<\/p>\n<p>\tvar queryXml = &#8220;<View><Query><Where><Eq><FieldRef Name='WorkflowLink' \/><Value Type='URL'>&#8221; + urlParaCaml + &#8220;<\/Value><\/Eq><\/Where><\/Query><\/View>&#8220;;<\/p>\n<p>    camlQuery.set_viewXml(queryXml);<\/p>\n<p>    this.collListItem = oList.getItems(camlQuery);<\/p>\n<p>    clientContext.load(collListItem);<\/p>\n<p>    clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceededAprovadores), Function.createDelegate(this, this.onQueryFailed));        <\/p>\n<p>}<\/p>\n<p>function onQuerySucceededAprovadores(sender, args) {<\/p>\n<p>    var listItemInfo = &#8221;;<\/p>\n<p>    var listItemEnumerator = collListItem.getEnumerator();<\/p>\n<p>    while (listItemEnumerator.moveNext()) {<br \/>\n        var oListItem = listItemEnumerator.get_current();<\/p>\n<p>        listItemInfo += &#8216;\\nID: &#8216; + oListItem.get_id() +<br \/>\n            &#8216;\\nTitle: &#8216; + oListItem.get_item(&#8216;Title&#8217;) +<br \/>\n            &#8216;\\nStatus: &#8216; + oListItem.get_item(&#8216;Status&#8217;) +<br \/>\n            &#8216;\\nAprovador: &#8216; + oListItem.get_item(&#8216;AssignedTo&#8217;).get_lookupValue() +<br \/>\n            &#8216;\\nBody: &#8216; + oListItem.get_item(&#8216;Body&#8217;);<br \/>\n    }<\/p>\n<p>    console.log(listItemInfo.toString());<br \/>\n}<\/p>\n<p>\/\/ Caso erro<br \/>\nfunction onQueryFailed(sender, args) {<br \/>\n    alert(&#8216;Request failed. &#8216; + args.get_message() + &#8216;\\n&#8217; + args.get_stackTrace());<br \/>\n}<br \/>\n[\/js]<\/p>\n<p>At\u00e9 a pr\u00f3xima!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Consultando em outra lista no SharePoint atrav\u00e9s de CAML Query e JQuery [js] function ConsultaListaTarefas() { var urlSite = _spPageContextInfo.siteAbsoluteUrl; var clientContext = new SP.ClientContext(urlSite); var oList = clientContext.get_web().get_lists().getByTitle(&#8216;Tasks&#8217;); var itemId = &#8216;123&#8217; var urlParaCaml = _spPageContextInfo.webServerRelativeUrl + &#8220;\/Lists\/campanhas\/DispForm.aspx?ID=&#8221; + itemId; var camlQuery = new SP.CamlQuery(); var queryXml = &#8220;&#8221; + urlParaCaml + &#8220;&#8220;; camlQuery.set_viewXml(queryXml); [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[26],"tags":[72,73,29,44,54],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Consultar Lista CAML Query SharePoint - CTASoftware Blog<\/title>\n<meta name=\"description\" content=\"CTASoftware Blog Consultar Lista CAML Query SharePoint\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Consultar Lista CAML Query SharePoint - CTASoftware Blog\" \/>\n<meta property=\"og:description\" content=\"CTASoftware Blog Consultar Lista CAML Query SharePoint\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"CTASoftware Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-21T22:10:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-20T22:12:49+00:00\" \/>\n<meta name=\"author\" content=\"Everton Gon\u00e7alves\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Everton Gon\u00e7alves\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\"},\"author\":{\"name\":\"Everton Gon\u00e7alves\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/34f7fa2c76834d8410f6dd43e26fd3e4\"},\"headline\":\"Consultar Lista CAML Query SharePoint\",\"datePublished\":\"2017-08-21T22:10:14+00:00\",\"dateModified\":\"2017-08-20T22:12:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#organization\"},\"keywords\":[\"CAML Query\",\"CAML SharePoint\",\"Jquery\",\"SharePoint\",\"SharePoint 2013\"],\"articleSection\":[\"SharePoint\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\",\"url\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\",\"name\":\"Consultar Lista CAML Query SharePoint - CTASoftware Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#website\"},\"datePublished\":\"2017-08-21T22:10:14+00:00\",\"dateModified\":\"2017-08-20T22:12:49+00:00\",\"description\":\"CTASoftware Blog Consultar Lista CAML Query SharePoint\",\"breadcrumb\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/www.ctasoftware.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Consultar Lista CAML Query SharePoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#website\",\"url\":\"https:\/\/www.ctasoftware.com.br\/blog\/\",\"name\":\"CTASoftware Blog\",\"description\":\"Para Desenvolvedores De Software\",\"publisher\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ctasoftware.com.br\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#organization\",\"name\":\"CTASoftware\",\"url\":\"https:\/\/www.ctasoftware.com.br\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.ctasoftware.com.br\/blog\/wp-content\/uploads\/2023\/06\/logocta.png?fit=225%2C44&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.ctasoftware.com.br\/blog\/wp-content\/uploads\/2023\/06\/logocta.png?fit=225%2C44&ssl=1\",\"width\":225,\"height\":44,\"caption\":\"CTASoftware\"},\"image\":{\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/34f7fa2c76834d8410f6dd43e26fd3e4\",\"name\":\"Everton Gon\u00e7alves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e5e7fe964521f618a2b09d3fbb7800f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e5e7fe964521f618a2b09d3fbb7800f?s=96&d=mm&r=g\",\"caption\":\"Everton Gon\u00e7alves\"},\"description\":\"http:\/\/www.ctasoftware.com.br\",\"sameAs\":[\"http:\/\/www.ctasoftware.com.br\"],\"url\":\"https:\/\/www.ctasoftware.com.br\/blog\/author\/everton-goncalves\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Consultar Lista CAML Query SharePoint - CTASoftware Blog","description":"CTASoftware Blog Consultar Lista CAML Query SharePoint","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/","og_locale":"pt_BR","og_type":"article","og_title":"Consultar Lista CAML Query SharePoint - CTASoftware Blog","og_description":"CTASoftware Blog Consultar Lista CAML Query SharePoint","og_url":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/","og_site_name":"CTASoftware Blog","article_published_time":"2017-08-21T22:10:14+00:00","article_modified_time":"2017-08-20T22:12:49+00:00","author":"Everton Gon\u00e7alves","twitter_misc":{"Escrito por":"Everton Gon\u00e7alves","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#article","isPartOf":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/"},"author":{"name":"Everton Gon\u00e7alves","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/34f7fa2c76834d8410f6dd43e26fd3e4"},"headline":"Consultar Lista CAML Query SharePoint","datePublished":"2017-08-21T22:10:14+00:00","dateModified":"2017-08-20T22:12:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/#organization"},"keywords":["CAML Query","CAML SharePoint","Jquery","SharePoint","SharePoint 2013"],"articleSection":["SharePoint"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/","url":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/","name":"Consultar Lista CAML Query SharePoint - CTASoftware Blog","isPartOf":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/#website"},"datePublished":"2017-08-21T22:10:14+00:00","dateModified":"2017-08-20T22:12:49+00:00","description":"CTASoftware Blog Consultar Lista CAML Query SharePoint","breadcrumb":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.ctasoftware.com.br\/blog\/consultar-lista-caml-query-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.ctasoftware.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Consultar Lista CAML Query SharePoint"}]},{"@type":"WebSite","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#website","url":"https:\/\/www.ctasoftware.com.br\/blog\/","name":"CTASoftware Blog","description":"Para Desenvolvedores De Software","publisher":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ctasoftware.com.br\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#organization","name":"CTASoftware","url":"https:\/\/www.ctasoftware.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.ctasoftware.com.br\/blog\/wp-content\/uploads\/2023\/06\/logocta.png?fit=225%2C44&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.ctasoftware.com.br\/blog\/wp-content\/uploads\/2023\/06\/logocta.png?fit=225%2C44&ssl=1","width":225,"height":44,"caption":"CTASoftware"},"image":{"@id":"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/34f7fa2c76834d8410f6dd43e26fd3e4","name":"Everton Gon\u00e7alves","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.ctasoftware.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3e5e7fe964521f618a2b09d3fbb7800f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e5e7fe964521f618a2b09d3fbb7800f?s=96&d=mm&r=g","caption":"Everton Gon\u00e7alves"},"description":"http:\/\/www.ctasoftware.com.br","sameAs":["http:\/\/www.ctasoftware.com.br"],"url":"https:\/\/www.ctasoftware.com.br\/blog\/author\/everton-goncalves\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6ACmG-4s","jetpack-related-posts":[{"id":300,"url":"https:\/\/www.ctasoftware.com.br\/blog\/obter-itens-de-lista-sharepoint-jquery\/","url_meta":{"origin":276,"position":0},"title":"Obter Itens de Lista SharePoint JQuery","author":"Everton Gon\u00e7alves","date":"17 de setembro de 2017","format":false,"excerpt":"Obt\u00e9m os itens da lista no SharePoint AJAX. [js] function AtualizaFinalizaTarefa() { var urlSite = _spPageContextInfo.siteAbsoluteUrl; var tituloSolicitacao = $('[id^=\"Title_\"]').val(); var idSolicitacao = parseInt(GetUrlKeyValue('ID')); var listaSiteProjetos = \"\/_api\/Web\/Lists\/getbytitle('Tarefas')\/items?$filter=IdSolicitacao eq '\" + idSolicitacao + \"'\"; var url = urlSite + listaSiteProjetos; $.ajax({ url: url, type: \"GET\", headers: {\"accept\": \"application\/json;odata=verbose\"}, success: function(data){\u2026","rel":"","context":"Em &quot;SharePoint&quot;","block_context":{"text":"SharePoint","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/sharepoint\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":296,"url":"https:\/\/www.ctasoftware.com.br\/blog\/obtem-anexos-de-lista-sharepoint\/","url_meta":{"origin":276,"position":1},"title":"Obt\u00e9m anexos de Lista SharePoint","author":"Everton Gon\u00e7alves","date":"12 de setembro de 2017","format":false,"excerpt":"Function para obter a lista de anexos de uma lista no SharePoint. [js] function ObtemAnexos(listItem) { var ctx = listItem.get_context(); var attachmentFolderUrl = String.format('{0}\/Attachments\/{1}',listItem.get_fieldValues()['FileDirRef'],listItem.get_fieldValues()['ID']); var folder = ctx.get_web().getFolderByServerRelativeUrl(attachmentFolderUrl); var files = folder.get_files(); ctx.load(files); ctx.executeQueryAsync( function () { var attachments = []; for (var i = 0; file = files.get_item(i) ;\u2026","rel":"","context":"Em &quot;JavaScript&quot;","block_context":{"text":"JavaScript","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/javascript\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":279,"url":"https:\/\/www.ctasoftware.com.br\/blog\/consulta-outra-lista-ajax-sharepoint\/","url_meta":{"origin":276,"position":2},"title":"Consulta Outra Lista Ajax SharePoint","author":"Everton Gon\u00e7alves","date":"22 de agosto de 2017","format":false,"excerpt":"Consultando em outra lista e montando uma tabela atrav\u00e9s de AJAX\/Jquery SharePoint. No exemplo abaixo mostro como pesquisar na lista Projetos e exibir em uma div HTML. Filtro pelo status \"Em andamento\" e ordeno pela data de cria\u00e7\u00e3o do item. [js] function Projetos(){ var urlSite = _spPageContextInfo.siteAbsoluteUrl; var obj; var\u2026","rel":"","context":"Em &quot;SharePoint&quot;","block_context":{"text":"SharePoint","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/sharepoint\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":298,"url":"https:\/\/www.ctasoftware.com.br\/blog\/atualizar-list-item-sharepoint\/","url_meta":{"origin":276,"position":3},"title":"Atualizar List Item SharePoint","author":"Everton Gon\u00e7alves","date":"16 de setembro de 2017","format":false,"excerpt":"Fun\u00e7\u00e3o para atualizar item em uma lista no SharePoint. [js] function updateMetadata(id) { var url = _spPageContextInfo.webAbsoluteUrl + \"\/_api\/Web\/Lists\/getByTitle('Tarefas')\/Items(\" + id + \")\"; var dfd = $.Deferred(); var campo1 = 'Dados novos'; var campo2 = 'Dados novos 2'; $.ajax({ 'url': url, 'method': 'POST', 'data': JSON.stringify({ '__metadata': {'type':'SP.ListItem'}, 'Status': campo1, 'campo2':\u2026","rel":"","context":"Em &quot;JavaScript&quot;","block_context":{"text":"JavaScript","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/javascript\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":292,"url":"https:\/\/www.ctasoftware.com.br\/blog\/obter-dados-usuario-logado-sharepoint-jquery-ajax\/","url_meta":{"origin":276,"position":4},"title":"Obter Dados Usu\u00e1rio Logado SharePoint Jquery Ajax","author":"Everton Gon\u00e7alves","date":"7 de setembro de 2017","format":false,"excerpt":"M\u00e9todo \u00fatil para obter os dados do usu\u00e1rio autenticado no SharePoint. [js] var currentUserDetails = Array(); function getCurrentUserWithDetails() { var endpointUrl = _spPageContextInfo.webAbsoluteUrl + '\/_api\/web\/currentuser\/?$expand=groups&$select=groups\/LoginName, LoginName,Title,Email'; $.ajax({ url: endpointUrl, method: \"GET\", contentType: \"application\/json;odata=verbose\", headers: { \"Accept\": \"application\/json;odata=verbose\" }, async:true, success: function(data){ var groups =[]; $.each(data.d.Groups.results, function (key, value) { groups.push(value.LoginName);\u2026","rel":"","context":"Em &quot;JavaScript&quot;","block_context":{"text":"JavaScript","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/javascript\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":294,"url":"https:\/\/www.ctasoftware.com.br\/blog\/obter-usuario-por-id-sharepoint\/","url_meta":{"origin":276,"position":5},"title":"Obter Usu\u00e1rio Por Id SharePoint","author":"Everton Gon\u00e7alves","date":"8 de setembro de 2017","format":false,"excerpt":"Obt\u00eam o usu\u00e1rio pelo ID no SharePoint atrav\u00e9s do JQuery. [js] function getUserById(ID) { var context = new SP.ClientContext.get_current(); var user = context.get_web().get_siteUsers().getById(ID); context.load(user); context.executeQueryAsync( Function.createDelegate(null, ensureUserSuccess), Function.createDelegate(null, onFail) ); function ensureUserSuccess() { login = user.get_loginName(); nome = user.get_title(); } function onFail() { console.log('error'); } } [\/js] At\u00e9 a pr\u00f3xima","rel":"","context":"Em &quot;JavaScript&quot;","block_context":{"text":"JavaScript","link":"https:\/\/www.ctasoftware.com.br\/blog\/category\/javascript\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/posts\/276"}],"collection":[{"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/comments?post=276"}],"version-history":[{"count":1,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/posts\/276\/revisions"}],"predecessor-version":[{"id":277,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/posts\/276\/revisions\/277"}],"wp:attachment":[{"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/media?parent=276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/categories?post=276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ctasoftware.com.br\/blog\/wp-json\/wp\/v2\/tags?post=276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}