Hi I am trying to use PowerShell to grab JSON data from the following website and export the values to XLS file.

In SharePoint Online, 'Site Pages' library, I have added a 'Category' (dropdown) metadata column for news posts. However, I am unable to get the Category column data using SharePoint REST API query.

Whne content is "En con gés", "En con gés" is written to file.If I use encodeUriComponent "En%20cong%E9s" is written.

I'm having the hardest time trying to parse a nested JSON string.

In short, is there a way to style a multi value lookup column? The data is output together as semicolon separated values. The following code will style for single value. Is it possible with json to do multi value?

Answers 1 Sign in to vote Hi, The following code for your reference:

Mar 22, 2018 · For example, An admin user wants to know what all sites a particular user can access by making a rest api call.

I am using REST API. To resolve cross-domain request I decided to use the SharePoint cross-domain library (SP.RequestExecutor): JavaScript:

I'm getting data from an API using Json.Document (Web.Contents... Everything works perfect with getting the data. But now I would like to recalculate some of the data. For example I am getting Time …

I am hoping to use Powershell to parse json and to import the result into an MSAccess table (or possibly multi tables). There is no ConvertFrom-json, or import from json utility etc within MSAccess. This …