Hey there, I'm using pnp/nodejs-commonjs with Azure Functions to add list items using a sharepoint Add-in, but I'm a bit stuck on how to catch exceptions because neither pnp-sp nor Microsoft's sharepoint REST API documentations are helpful here, or I haven't been searching very well
I came up with a hacky way on how to get 400 error messages :
async create(listTitle: string, properties: object): Promise<IItemAddResult> {
try {
const item = await sp.web.lists
.getByTitle(listTitle)
.items.add(properties);
return item;
} catch (error) {
const message = this.getErrorMessage(error);
throw new Error(message);
}
}
private getErrorMessage(error: any): string {
const mixedJson = error.message;
const index = mixedJson.indexOf('{');
return JSON.parse(mixedJson.substring(index))['odata.error'].message.value;
}
I'd like to get rid of the getErrorMessage method and use something more generic if I can
The error object itself returns this
{
"response": {
"size": 0,
"timeout": 0
},
"status": 400,
"statusText": "Bad Request",
"isHttpRequestError": true
}and error.message returns this
Error making HttpClient request in queryable [400] Bad Request ::> {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The property 'Name' does not exist on type 'SP.Data.MattersListItem'. Make sure to only use property names that are defined by the type."}}}
Hi @Anujkmrpal,
Actually this by design. spRootFolder is not used in the mode with metadata filtering. But I see the logic in your case. Please check v2.6.3, the version update should include postfilter conditions after CAML is applied, so only documents located in spRootFolder, if the one provided, are downloaded.
Actually this by design. spRootFolder is not used in the mode with metadata filtering. But I see the logic in your case. Please check v2.6.3, the version update should include postfilter conditions after CAML is applied, so only documents located in spRootFolder, if the one provided, are downloaded.
Hello, I would need to fill up a javascript object with all the site pages and their author information from sharepoint using pnpjs and then will set state in componentDidMount. I would need to use a for statement to get the author for each page in result and this is where i am not sure how to use promise and how to set state. Any guidance would be highly appreciated. I am using react. Thanks
This is the kind of data i am trying to retrieve, the issue is if i use promise to get authors in for loop, state gets set with limited items and gets stuck until page is re-render.
You can easily get all that information in one call. Site Pages is a document library, similar as a list, all items can be requested with the metadata, author is one of the columns.
E.g.
const list = sp.web.lists.getByTitle('Site Pages');
list.items
.select('*,Author/Title,OData__AuthorByline/Title')
.expand('OData__AuthorByline,Author')
.get()
.then(console.log);
In above example i want to enter data in policyNumber but it is not inserted
And can you please describe use of keys in filesMetaData
Good day, @s-KaiNet . I have been using sp-request to scrape pages within a site collections on SP2013 for a couple years now. I now need to update my node code to work with SPO, app-only permissions. I'm able to authenticate to SPO without issue however, the same technique to grab the HTML of a SP page no longer works.
With SP2013, I could simply pass the full URL and the response would return the HTML. When I try the same with SPO I get an authentication error. Here's the current code:
/*jshint esversion: 6 */
const sprequest = require('sp-request');
let spr = sprequest.create({
siteUrl: 'https://tenant.org/sites/dev',
clientId: '1beab0a4-a10d-4a6b-xxxx-b4c247faa95f',
clientSecret: 'SZvu9Gmbxxxx9fHGeZ+KC9QBxxxx1ApHAlLeNAermug='
});
const url = encodeURI('https://tenant.org/sites/dev');
function peek(url) {
url = url.toLowerCase();
return new Promise(function () {
spr(url)
.then(function (response) {
console.log(response.body);
})
.catch(function (err) {
console.log('Something went wrong.... ' + err);
});
});
}
peek(url);
- can't
Hi hi, I am current using SPPP to create a react app on SharePoint 2016 on premise. The SharePoint site is on HTTPS. Can I check is it possible that the react app can be served thru HTTP2 protocol or it is a SharePoint Limitation due to Windows authentication that on application on Sharepoint is defintiely on HTTP1.1? Sorry if my question may be incorrect. Thanks in advance .
Hi @alexleely, can you elaborate? Do you need to start local workbench on HTTPS? Yes, this is possible, internally local server is started using webpack dev server it can be provided with http2, https certs configuration (https://webpack.js.org/configuration/dev-server/#devserverhttp2) (will copy a setup semple below). Regarding HTTP2 do you really reference to SPDY? SPDY won't work in SP with NTLM or Kerberos authentications.
- I was just aware of HTTP2 and HTTP 1/1. If my SharePoint sites is in HTTPS and my app is deployed in the sites, does it automatically serve as HTTP2 or it will be HTTP 1/1? Based on testing, it i still serving as HTTP 1/1 in chrome browser but in Edge some pages are in HTTP 2 and some are in HTTP 1/1.
- The reason for check ing on HTTP2 is that we hope to further improve the performance for pages. It has improved since we use your SPPP as previously was SSOM. But was thinking if HTTP2 will be even faster.
I am able to run local workbench in https
thanks so much
Hi @koltyakov, do you have any example on SPPP deployment thru Azure Dev Ops or I can follow the same as the following for SPFX : https://www.rbaconsulting.com/blog/tutorial-implementing-a-ci-cd-pipeline-for-your-spfx-projects-in-azure-devops/?
Hi @alexleely, how about
npm run build then npm run publish with environment variable for authentication (https://github.com/koltyakov/node-sp-auth-config#environment-variables). Please leave an issue with the request to add Azure DevOps sample in the repository I’ll add a generic sample, but it’s really just binding env vars for auth (making sure prod mode is on) and the ordinary frontend project pipeline actions specifics.
Hello Guys, I am filtering from an object array using multi select dropdown of officeuifabric. Following is the example
universalFilter= AllNews.filter((
{ AuthorName}) =>
selectAuthors.includes(AuthorName))
Now when Selected Authors(Multi Dropdown) is null, It doesnt bring any result but i want all items without filtering on Author when selectAuthor is null.
universalFilter= AllNews.filter((
{ AuthorName}) =>
selectAuthors.includes(AuthorName))
Now when Selected Authors(Multi Dropdown) is null, It doesnt bring any result but i want all items without filtering on Author when selectAuthor is null.