Guriddo » Topic: Can JQGrid work with SharePoint result source REST API

Can JQGrid work with SharePoint result source REST API

Guriddo
Using code tag to better see the code
Can JQGrid work with SharePoint result source REST API

Tagged: Using code tag to better see the code

This topic has 15 replies, 2 voices, and was last updated 5 years, 6 months ago by guriddo.support.

Creator

Topic
September 28, 2020 at 9:54 pm #127472
MWAN001
Participant
I tried to see if I can use JQGrid to display SharePoint search results by querying SharePoint result source with REST API.

The code to use REST API to call result source works in browser and Postman:

var apiUrl =_spPageContextInfo.webAbsoluteUrl +/_api/search/query?querytext=’Mike’&rowlimit=100&selectproperties=’RequestNameOWSTEXT, SubmittedByOWSUSER,ExaminiationNameOWSTEXT,PublishedDate1OWSDATE&sourceId=’d90c19xx-7b3x-42bx-8fbx-d1dxxxx543ffa7′, many results are returned.

But when I used it in JQGrid, got an error at line 44: Uncaught TypeError: Cannot read property ‘length’ of undefined

$.ajax({ url: apiUrl,type: “GET”, async: false, headers: { “accept”: “application/json;odata=verbose” }, success: function (data) {

line 44: $.each(data.d.results, function (index, value) { ………………………..

I guess the api call doesn’t return result so the data is undefined. Wondering is something wrong with that api?

A different api like below works to return results:

var apiUrl = _spPageContextInfo.webAbsoluteUrl + “/_api/web/GetFolderByServerRelativeUrl(‘documentrequest’)/Folders?$expand=ListItemAllFields,AuthorID/id&$select=Name,ItemCount,ListItemAllFields/AuthorId,ListItemAllFields/ExaminiationName,ListItemAllFields/PublishedDate1&$filter=Name ne ‘Forms’ and ItemCount gt 0”;
- This topic was modified 5 years, 6 months ago by MWAN001.
Creator

Topic

Viewing 15 replies - 1 through 15 (of 15 total)

Author

Replies

September 29, 2020 at 10:44 am #127474

guriddo.support

Participant

Hello,

In order to see what is happen – can you please send us the response which causes the problem and the Guriddo jqGrid setup.

This way we can see the problem that you have.

Thank you.

Kind Regards,
Will

Guriddo Support Team

October 1, 2020 at 9:51 pm #127475

MWAN001

Participant

Found out need to use results = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results to retrieve data from the search results

https://siteurl/_api/search/query?querytext=’cash flow*’&sourceId=’d90c19*****************a7’&rowlimit=100&selectproperties=’Filename, RequestNameOWSTEXT,SubmittedByOWSUSER,ExaminiationNameOWSTEXT,PublishedDate1OWSDATE’

Two issues:

1. RequestNameOWSTEXT,SubmittedByOWSUSER,ExaminiationNameOWSTEXT,PublishedDate1OWSDATE are searchable managed properties but results are null

2. document set filename are displayed in the JGGrid just fine but the attachments are not displayed in jqgrid. Filename returns both document sets and attachments.

requestArr.push({
Name: getValueByKey(“Filename”, itemResults),
RequestName: getValueByKey(“Filename”, itemResults),…..

})

October 3, 2020 at 3:36 am #127476

MWAN001

Participant

RequestNameOWSTEXT, SubmittedByOWSUSER,ExaminiationNameOWSTEXT,PublishedDate1OWSDATE are managed properties that are queryable but no value returned from the search api call. search api call returns system columns, like contenttypeId, filename, path but not the custom column values.

October 5, 2020 at 9:41 am #127477

guriddo.support

Participant

Hello,

We really want to help you, but without any jqGrid code and the response from the server we really can’t.

As for the second problem. You should manage to make the search response from the server. If something is wrong from the server, check your server api code.

You may refer to this docs

Kind Regards,

Will

Guriddo Support Team

October 6, 2020 at 5:10 am #127478

MWAN001

Participant

Thanks for following up! We have two versions of api code to populate the jqgrid. We are building search results with jqgrid then allow users to select to download.

The 1st approach is to use this api call to get back items

var apiUrl = _spPageContextInfo.webAbsoluteUrl + “/_api/web/GetFolderByServerRelativeUrl(‘documentrequest’)/Folders?$expand=ListItemAllFields,AuthorID/id&$select=Name,ItemCount,ListItemAllFields/AuthorId,ListItemAllFields/ExaminiationName,ListItemAllFields/PublishedDate1,ListItemAllFields/MRAName,ListItemAllFields/RecommendationName&$filter=Name ne ‘Forms’ and ItemCount gt 0”;

This version of code loads the result successfully to jqgrid. Please see the attached working jqgrid txt file and array for the jqgrid loaded successfully screenshot for the array items that are pushed to the array that feeds the jqgrid. Notice the items loaded successfully in jqgrid automatically have an id.

This approach doesn’t meet the requirement to return all the search results, all the fields and attachments.

The 2nd approach uses a SharePoint search api

var apiUrl = _spPageContextInfo.webAbsoluteUrl + “/_api/search/query?querytext='” + txtSearch + “*’&sourceId=’d90c1997-7b33-42be-8fb3-d1dc2543ffa7’&rowlimit=100&selectproperties=’Filename, Path, ContentTypeId'”;

this api doesn’t return meta data fields so we have to use the Filename to run another api call to get back the meta data, then push the meta data to the array that feeds the jqgrid. Jqgrid failed to load the data most of the time, even though the array is populated. I even trimmed down the properties to be the same as the 1st approach. still jqgrid doesn’t display data.

Please see attached jqgrid not loading code in txt file and array for the jqgrid failed to load screen shot.

October 6, 2020 at 5:11 am #127479

MWAN001

Participant

The code jqgrid successfully populated:

function searchLibrary(txtSearch) {

//$.jgrid.gridUnload(&quot;#gridID&quot;);

$(&quot;#requestGrid&quot;).trigger(&quot;reloadGrid&quot;, [{ page: 1, current: true }]);

var requestArr = [];

var apiUrl = _spPageContextInfo.webAbsoluteUrl + &quot;/_api/web/GetFolderByServerRelativeUrl(&#039;documentrequest&#039;)/Folders?$expand=ListItemAllFields,AuthorID/id&amp;$select=Name,ItemCount,ListItemAllFields/AuthorId,ListItemAllFields/ExaminiationName,ListItemAllFields/PublishedDate1,ListItemAllFields/MRAName,ListItemAllFields/RecommendationName&amp;$filter=Name ne &#039;Forms&#039; and ItemCount gt 0&quot;;

$.ajax({

url: apiUrl,

type: &quot;GET&quot;,

async: false,

headers: {

&quot;accept&quot;: &quot;application/json;odata=verbose&quot;

},

success: function (data) {

$.each(data.d.results, function (index, value) {

requestArr.push({

RequestName: value.Name,

Name: value.Name,

ExaminationName: value.ListItemAllFields.ExaminiationName,

Submitter: value.ListItemAllFields.AuthorID,

PublishedDate: value.ListItemAllFields.PublishedDate1,

MRAName: value.ListItemAllFields.MRAName,

RecommendationName: value.ListItemAllFields.RecommendationName,

ItemCount: value.ItemCount

});

});

},

error: function (data) {

console.log(data);

}

});

$(&#039;#requestGrid&#039;).jqGrid({

data: requestArr,

datatype: &quot;local&quot;,

colNames: [&#039;Request Name&#039;, &#039;Docs Name&#039;, &#039;Examination Name&#039;, &#039;Submitter&#039;, &#039;Published Date&#039;, &#039;MRA Name&#039;, &#039;Recommendation Name&#039;, &#039;Item Count&#039;],

colModel: [

{ name: &#039;Name&#039;, index: &#039;Name&#039;, width: 80, formatter: viewLink },

{ name: &#039;RequestName&#039;, index: &#039;RequestName&#039;, width: 80, sortable: true, hidden: true },

{ name: &#039;ExaminationName&#039;, index: &#039;ExaminationName&#039;, width: 100, sortable: true, editable: true },

{ name: &#039;Submitter&#039;, index: &#039;Submitter&#039;, width: 80, sortable: true, editable: true },

{ name: &#039;PublishedDate&#039;, index: &#039;PublishedDate&#039;, width: 60, sorttype: &#039;date&#039;, editable: true, editrules: { date: true }, formatter: &#039;date&#039;, datefmt: &#039;d/m/Y&#039; },

{ name: &#039;MRAName&#039;, index: &#039;MRAName&#039;, width: 80, sortable: true, editable: true },

{ name: &#039;RecommendationName&#039;, index: &#039;RecommendationName&#039;, width: 100, sortable: true, editable: true },

{ name: &#039;ItemCount&#039;, index: &#039;ItemCount&#039;, width: 30, sortable: true, editable: true }

],

localReader: { repeatitems: true },

rowNum: 50,

rowList: [50, 100, 150, 200, 250],

autoload: true,

rownumbers: true,

sortname: &quot;Name&quot;,

sortorder: &quot;asc&quot;,

refresh: true,

gridview: true,

viewrecords: true,

multiselect: true,

rowTotal: 250,

pager: &#039;#gridPager&#039;,

loadonce: false,

height: 1000,

ignoreCase: true,

altRows: true,

shrinkToFit: true,

autowidth: true,

resizable: false,

groupColumnShow: false,

hidegrid: false,

multiboxonly: true,

caption: &quot;Secure Library&quot;,

searchoptions: {

clearSearch: true,

attr: { size: 18, maxlength: 18, style: &quot;width:130px;margin-top:1px;&quot; }

},

onSelectRow: function (a, b, c) {

if (this.p.selarrrow.length === currids.length) {

$(&#039;#cb_&#039; + $.jgrid.jqID(this.p.id), this.grid.hDiv)[this.p.useProp ? &#039;prop&#039; : &#039;attr&#039;](&quot;checked&quot;, true);

}

},

gridComplete: function () {

currids = $(this).jqGrid(&#039;getDataIDs&#039;);

// $(&#039;#count&#039;).html($(&#039;#gridID&#039;).getGridParam(&#039;records&#039;));

var ids = $(this).jqGrid(&#039;getDataIDs&#039;);

if (ids) {

var sortName = $(this).jqGrid(&#039;getGridParam&#039;, &#039;sortname&#039;);

var sortOrder = $(this).jqGrid(&#039;getGridParam&#039;, &#039;sortorder&#039;);

for (var i = 0; i &lt; ids.length; i++) {

$(this).jqGrid(&#039;setCell&#039;, ids<em class="d4pbbc-italic"></em>, sortName, &#039;&#039;, &#039;&#039;,

{

style: (sortOrder === &#039;asc&#039; ? &#039;background:aqua;&#039; :

&#039;background:yellow;&#039;)

});

}

}

}

});

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

function searchLibrary(txtSearch) {

//$.jgrid.gridUnload("#gridID");

$("#requestGrid").trigger("reloadGrid", [{ page: 1, current: true }]);

var requestArr = [];

var apiUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/GetFolderByServerRelativeUrl('documentrequest')/Folders?$expand=ListItemAllFields,AuthorID/id&$select=Name,ItemCount,ListItemAllFields/AuthorId,ListItemAllFields/ExaminiationName,ListItemAllFields/PublishedDate1,ListItemAllFields/MRAName,ListItemAllFields/RecommendationName&$filter=Name ne 'Forms' and ItemCount gt 0";

$.ajax({

url: apiUrl,

type: "GET",

async: false,

headers: {

"accept": "application/json;odata=verbose"

success: function (data) {

$.each(data.d.results, function (index, value) {

requestArr.push({

RequestName: value.Name,

Name: value.Name,

ExaminationName: value.ListItemAllFields.ExaminiationName,

Submitter: value.ListItemAllFields.AuthorID,

PublishedDate: value.ListItemAllFields.PublishedDate1,

MRAName: value.ListItemAllFields.MRAName,

RecommendationName: value.ListItemAllFields.RecommendationName,

ItemCount: value.ItemCount

});

error: function (data) {

console.log(data);

}

});

$('#requestGrid').jqGrid({

data: requestArr,

datatype: "local",

colNames: ['Request Name', 'Docs Name', 'Examination Name', 'Submitter', 'Published Date', 'MRA Name', 'Recommendation Name', 'Item Count'],

colModel: [

{ name: 'Name', index: 'Name', width: 80, formatter: viewLink },

{ name: 'RequestName', index: 'RequestName', width: 80, sortable: true, hidden: true },

{ name: 'ExaminationName', index: 'ExaminationName', width: 100, sortable: true, editable: true },

{ name: 'Submitter', index: 'Submitter', width: 80, sortable: true, editable: true },

{ name: 'PublishedDate', index: 'PublishedDate', width: 60, sorttype: 'date', editable: true, editrules: { date: true }, formatter: 'date', datefmt: 'd/m/Y' },

{ name: 'MRAName', index: 'MRAName', width: 80, sortable: true, editable: true },

{ name: 'RecommendationName', index: 'RecommendationName', width: 100, sortable: true, editable: true },

{ name: 'ItemCount', index: 'ItemCount', width: 30, sortable: true, editable: true }

localReader: { repeatitems: true },

rowNum: 50,

rowList: [50, 100, 150, 200, 250],

autoload: true,

rownumbers: true,

sortname: "Name",

sortorder: "asc",

refresh: true,

gridview: true,

viewrecords: true,

multiselect: true,

rowTotal: 250,

pager: '#gridPager',

loadonce: false,

height: 1000,

ignoreCase: true,

altRows: true,

shrinkToFit: true,

autowidth: true,

resizable: false,

groupColumnShow: false,

hidegrid: false,

multiboxonly: true,

caption: "Secure Library",

searchoptions: {

clearSearch: true,

attr: { size: 18, maxlength: 18, style: "width:130px;margin-top:1px;" }

onSelectRow: function (a, b, c) {

if (this.p.selarrrow.length === currids.length) {

$('#cb_' + $.jgrid.jqID(this.p.id), this.grid.hDiv)[this.p.useProp ? 'prop' : 'attr']("checked", true);

}

gridComplete: function () {

currids = $(this).jqGrid('getDataIDs');

// $('#count').html($('#gridID').getGridParam('records'));

var ids = $(this).jqGrid('getDataIDs');

if (ids) {

var sortName = $(this).jqGrid('getGridParam', 'sortname');

var sortOrder = $(this).jqGrid('getGridParam', 'sortorder');

for (var i = 0; i < ids.length; i++) {

$(this).jqGrid('setCell', ids, sortName, '', '',

{

style: (sortOrder === 'asc' ? 'background:aqua;' :

'background:yellow;')

});

}

});

This reply was modified 5 years, 6 months ago by admin.

October 6, 2020 at 5:13 am #127480

MWAN001

Participant

The code failed to populate jqgrid:

function searchLibrary(txtSearch) {

//$.jgrid.gridUnload(&quot;#gridID&quot;);

$(&quot;#requestGrid&quot;).trigger(&quot;reloadGrid&quot;, [{ page: 1, current: true }]);

var requestArr = []; // document set array

var attachmentArr = []; //attachment array

var requestmetadata = []; //requestmeta data array

var folderLength = 0;

&amp;nbsp;

var apiUrl = _spPageContextInfo.webAbsoluteUrl + &quot;/_api/search/query?querytext=&#039;&quot; + txtSearch + &quot;*&#039;&amp;sourceId=&#039;d90c1997-7b33-42be-8fb3-d1dc2543ffa7&#039;&amp;rowlimit=100&amp;selectproperties=&#039;Filename, Path, ContentTypeId&#039;&quot;;

&amp;nbsp;

$.ajax({

url: apiUrl,

type: &quot;GET&quot;,

async: false,

headers: {

&quot;accept&quot;: &quot;application/json;odata=verbose&quot;

},

&amp;nbsp;

success: function (data) {

var results;

&amp;nbsp;

if (data.d) {

&amp;nbsp;

results = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results;

alert(&#039;length: &#039; + results.length);

&amp;nbsp;

for (i = 0; i &lt; results.length; i++) {

var item = results<em class="d4pbbc-italic"></em>;

var itemCell = item.Cells;

var itemResults = itemCell.results;

//10.3.2020 check content id, if document set, run another api call to get meta data

&amp;nbsp;

var ContentTypeId = getValueByKey(&quot;ContentTypeId&quot;, itemResults);

var Path = getValueByKey(&quot;Path&quot;, itemResults);

var Filename = getValueByKey(&quot;Filename&quot;, itemResults);

&amp;nbsp;

var pathArray = Path.split(&#039;/&#039;);

var period = pathArray[pathArray.length - 1];

&amp;nbsp;

// alert(&#039;Filename: &#039; + Filename);

&amp;nbsp;

if (ContentTypeId.indexOf(&#039;0x0120D5200&#039;) !== -1) { /* If result has docset content type, push the url to the docset array */

&amp;nbsp;

var requestmetadata = getrequestValues(Filename);

var folderLength = fileSizing(Filename);

&amp;nbsp;

if (requestmetadata[5] != null &amp;&amp; requestmetadata[5] != &quot;&quot; &amp;&amp; requestmetadata[5] != &quot;undefined&quot;) {

SubmitterName = getSubmitterName(requestmetadata[5]);

}

else {

SubmitterName = &quot;&quot;;

}

&amp;nbsp;

var ItemCount = requestmetadata[4];

&amp;nbsp;

if (ItemCount &gt; 0) { //only add to requestArr when there is attachment

&amp;nbsp;

requestArr.push({

RequestName: Filename,

Name: Filename,

ExaminationName: requestmetadata[0],

Submitter: SubmitterName,

PublishedDate: requestmetadata[1],

MRAName: requestmetadata[2],

RecommendationName: requestmetadata[3],

ItemCount: ItemCount

});

&amp;nbsp;

}

}

else if (ContentTypeId.indexOf(&#039;0x0120D5200&#039;) == -1 &amp;&amp; period.indexOf(&#039;.&#039;) !== -1 &amp;&amp; period.indexOf(&#039;.aspx&#039;) == -1) {

/* If result is not a docset, contains a period, but not .aspx, push the url to the doc array */

&amp;nbsp;

attachmentArr.push({

Name: Filename,

ContentTypeId: ContentTypeId,

Path: Path,

RequestName: Filename,

ExaminationName: &quot;&quot;,

Submitter: &quot;&quot;,

PublishedDate: &quot;&quot;,

MRAName: &quot;&quot;,

RecommendationName: &quot;&quot;,

ItemCount: 0,

FolderLength: 0

});

&amp;nbsp;

}

&amp;nbsp;

}

}

}, //end of success

&amp;nbsp;

error: function (data) {

console.log(data);

}

});

&amp;nbsp;

function getValueByKey(key, results) {

var postItem = $.grep(results, function (e) {

if (e.Key === key) return e;

})[0].Value;

return postItem;

}

&amp;nbsp;

//10.03.2020 Join requestArr and attachmentArr to a new array

// var allresults = requestArr.concat(attachmentArr);

&amp;nbsp;

$(&#039;#requestGrid&#039;).jqGrid({

// data: allresults,

data: requestArr,

datatype: &quot;local&quot;,

colNames: [&#039;Request Name&#039;, &#039;Docs Name&#039;, &#039;Examination Name&#039;, &#039;Submitter&#039;, &#039;Published Date&#039;, &#039;MRA Name&#039;, &#039;Recommendation Name&#039;, &#039;Item Count&#039;],

colModel: [

{ name: &#039;Name&#039;, index: &#039;Name&#039;, width: 80, formatter: viewLink },

{ name: &#039;RequestName&#039;, index: &#039;RequestName&#039;, width: 80, sortable: true, hidden: true },

{ name: &#039;ExaminationName&#039;, index: &#039;ExaminationName&#039;, width: 100, sortable: true, editable: true },

{ name: &#039;Submitter&#039;, index: &#039;Submitter&#039;, width: 80, sortable: true, editable: true },

{ name: &#039;PublishedDate&#039;, index: &#039;PublishedDate&#039;, width: 60, sorttype: &#039;date&#039;, editable: true, editrules: { date: true }, formatter: &#039;date&#039;, datefmt: &#039;d/m/Y&#039; },

{ name: &#039;MRAName&#039;, index: &#039;MRAName&#039;, width: 80, sortable: true, editable: true },

{ name: &#039;RecommendationName&#039;, index: &#039;RecommendationName&#039;, width: 100, sortable: true, editable: true },

{ name: &#039;ItemCount&#039;, index: &#039;ItemCount&#039;, width: 30, sortable: true, editable: true }

],

&amp;nbsp;

localReader: { repeatitems: true },

rowNum: 50,

rowList: [50, 100, 150, 200, 250],

autoload: true,

rownumbers: true,

sortname: &quot;Name&quot;,

sortorder: &quot;asc&quot;,

refresh: true,

gridview: true,

viewrecords: true,

multiselect: true,

rowTotal: 250,

pager: &#039;#gridPager&#039;,

loadonce: false,

height: 1000,

ignoreCase: true,

altRows: true,

shrinkToFit: true,

autowidth: true,

resizable: false,

groupColumnShow: false,

hidegrid: false,

multiboxonly: true,

caption: &quot;Secure Library Search Results&quot;,

searchoptions: {

clearSearch: true,

attr: { size: 18, maxlength: 18, style: &quot;width:130px;margin-top:1px;&quot; }

},

&amp;nbsp;

onSelectRow: function (a, b, c) {

if (this.p.selarrrow.length === currids.length) {

$(&#039;#cb_&#039; + $.jgrid.jqID(this.p.id), this.grid.hDiv)[this.p.useProp ? &#039;prop&#039; : &#039;attr&#039;](&quot;checked&quot;, true);

}

},

&amp;nbsp;

gridComplete: function () {

currids = $(this).jqGrid(&#039;getDataIDs&#039;);

// $(&#039;#count&#039;).html($(&#039;#gridID&#039;).getGridParam(&#039;records&#039;));

var ids = $(this).jqGrid(&#039;getDataIDs&#039;);

if (ids) {

var sortName = $(this).jqGrid(&#039;getGridParam&#039;, &#039;sortname&#039;);

var sortOrder = $(this).jqGrid(&#039;getGridParam&#039;, &#039;sortorder&#039;);

for (var i = 0; i &lt; ids.length; i++) {

$(this).jqGrid(&#039;setCell&#039;, ids<em class="d4pbbc-italic"></em>, sortName, &#039;&#039;, &#039;&#039;,

{

style: (sortOrder === &#039;asc&#039; ? &#039;background:aqua;&#039; :

&#039;background:yellow;&#039;)

});

}

}

}

});

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

function searchLibrary(txtSearch) {

//$.jgrid.gridUnload("#gridID");

$("#requestGrid").trigger("reloadGrid", [{ page: 1, current: true }]);

var requestArr = []; // document set array

var attachmentArr = []; //attachment array

var requestmetadata = []; //requestmeta data array

var folderLength = 0;

&nbsp;

var apiUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/search/query?querytext='" + txtSearch + "*'&sourceId='d90c1997-7b33-42be-8fb3-d1dc2543ffa7'&rowlimit=100&selectproperties='Filename, Path, ContentTypeId'";

&nbsp;

$.ajax({

url: apiUrl,

type: "GET",

async: false,

headers: {

"accept": "application/json;odata=verbose"

&nbsp;

success: function (data) {

var results;

&nbsp;

if (data.d) {

&nbsp;

results = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results;

alert('length: ' + results.length);

&nbsp;

for (i = 0; i < results.length; i++) {

var item = results;

var itemCell = item.Cells;

var itemResults = itemCell.results;

//10.3.2020 check content id, if document set, run another api call to get meta data

&nbsp;

var ContentTypeId = getValueByKey("ContentTypeId", itemResults);

var Path = getValueByKey("Path", itemResults);

var Filename = getValueByKey("Filename", itemResults);

&nbsp;

var pathArray = Path.split('/');

var period = pathArray[pathArray.length - 1];

&nbsp;

// alert('Filename: ' + Filename);

&nbsp;

if (ContentTypeId.indexOf('0x0120D5200') !== -1) { /* If result has docset content type, push the url to the docset array */

&nbsp;

var requestmetadata = getrequestValues(Filename);

var folderLength = fileSizing(Filename);

&nbsp;

if (requestmetadata[5] != null && requestmetadata[5] != "" && requestmetadata[5] != "undefined") {

SubmitterName = getSubmitterName(requestmetadata[5]);

}

else {

SubmitterName = "";

}

&nbsp;

var ItemCount = requestmetadata[4];

&nbsp;

if (ItemCount > 0) { //only add to requestArr when there is attachment

&nbsp;

requestArr.push({

RequestName: Filename,

Name: Filename,

ExaminationName: requestmetadata[0],

Submitter: SubmitterName,

PublishedDate: requestmetadata[1],

MRAName: requestmetadata[2],

RecommendationName: requestmetadata[3],

ItemCount: ItemCount

});

&nbsp;

}

else if (ContentTypeId.indexOf('0x0120D5200') == -1 && period.indexOf('.') !== -1 && period.indexOf('.aspx') == -1) {

/* If result is not a docset, contains a period, but not .aspx, push the url to the doc array */

&nbsp;

attachmentArr.push({

Name: Filename,

ContentTypeId: ContentTypeId,

Path: Path,

RequestName: Filename,

ExaminationName: "",

Submitter: "",

PublishedDate: "",

MRAName: "",

RecommendationName: "",

ItemCount: 0,

FolderLength: 0

});

&nbsp;

}

&nbsp;

}

}, //end of success

&nbsp;

error: function (data) {

console.log(data);

}

});

&nbsp;

function getValueByKey(key, results) {

var postItem = $.grep(results, function (e) {

if (e.Key === key) return e;

})[0].Value;

return postItem;

}

&nbsp;

//10.03.2020 Join requestArr and attachmentArr to a new array

// var allresults = requestArr.concat(attachmentArr);

&nbsp;

$('#requestGrid').jqGrid({

// data: allresults,