Difficulties accessing json values in request body of powershell azure function

I have an Powershell Azure function that receives a (json) string as request body. I need to access the values of XMLA_String, WorkspaceId, and DatasetId in order to set them to variables. Please let me know how

The following body is received:

"{\"XMLA_String\":'{\"refresh\":{\"type\":\"full\",\"objects\":[{\"database\":\"<db>\",\"table\":\"<tab>\"}]}}',
\"WorkspaceId\":'<workspaceid>',
\"DatasetId\":'<datasetid>'}"

Solution 1:

Assuming that the line breaks in your sample JSON are just a formatting artifact, it looks like you're getting doubly JSON-encoded data, strangely.

Therefore, try applying ConvertFrom-Json twice (which you've since confirmed solved your problem):

# Sample response received.
$json = @'
"{\"XMLA_String\":'{\"refresh\":{\"type\":\"full\",\"objects\":[{\"database\":\"<db>\",\"table\":\"<tab>\"}]}}',\"WorkspaceId\":'<workspaceid>',\"DatasetId\":'<datasetid>'}"
'@

$json | ConvertFrom-Json | ConvertFrom-Json

The above outputs a [pscustomobject] instance with properties XMLA_String, WorkspaceId, and DatasetId:

XMLA_String                                                                 WorkspaceId   DatasetId
-----------                                                                 -----------   ---------
{"refresh":{"type":"full","objects":[{"database":"<db>","table":"<tab>"}]}} <workspaceid> <datasetid>