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#dat...":[
{
"datasourceType":"SharePointList","connectionDetails":{
"url":"https://COMPANY.sharepoint.com/"
},"datasourceId":"DATASOURCEID","gatewayId":"GATEWAYID"
}
]
}
