Get Datasource from Group - help parsing the JSON in PowerShell

bidgeir — Wed, 21 Oct 2020 06:28:39 GMT

Hi all

When quering Get Datasource from Group in PowerShell the response is nested JSON. I´m not very good with PowerShell so I´m having problems picking out the values that I need. What I´m after is the url and the datasourceType. Below is a sample response. If I try to convert it to csv it will create two columns @odata.context and value which does not traverse all the depths of the JSON. I don´t know how to pick out the relevant values. I have tried $MyVariable[0].[value][0].... but it says the array is empty.

What I´m ultimetly trying to do is to grab the url for SharePoint sources, replace parts of the string and update it via the update datasource endpoint

Hope someone can help.

{
"@odata.context":"http://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/groups/WORKSPACEID/$metadata#datasources","value":[
{
"datasourceType":"SharePointList","connectionDetails":{
"url":"https://COMPANY.sharepoint.com/"
},"datasourceId":"DATASOURCEID","gatewayId":"GATEWAYID"
}
]
}

Re: Get Datasource from Group - help parsing the JSON in PowerShell

lbendlin — Thu, 22 Oct 2020 02:00:09 GMT

How is this related to Power BI?

Also, have you tried to do this in Power Query? It guides you through the JSON structure and allows you to pick the fields you need .

topic Re: Get Datasource from Group - help parsing the JSON in PowerShell in Developer

Get Datasource from Group - help parsing the JSON in PowerShell

Re: Get Datasource from Group - help parsing the JSON in PowerShell