ferrybouwman / power-bi-read-only-rest-api Goto Github PK

I have followed all the steps mentioned in the video and when I ran the flow it is erroring out at step "Step 3: Retrieve Data"->"Append to String variable"
The variable 'responseArrayASString' has size of more than '105910233' bytes. This exceeded the maximum size '104857600' allowed.
We have more than 6000 Workspaces.

Hi Ferry,

Receiving an unknown error when trying to import the flow. Tried this on multiple environments and the behavior is the same.

on the call getInfo endpoint I am hitting an error that it cannot parse the json

"message": "Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Guid' because the type requires a JSON primitive value (e.g. string, number, boolean, null) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON primitive value (e.g. string, number, boolean, null) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.\r\nPath 'workspaces[0].id', line 1, position 22.",
"target": "requiredWorkspaces.workspaces[0].id"

the json array is coming out like this:
"workspaces": [{"id":"6c0d5435-11d1-4cb3-83df-0a7d69f781fb",{"id":"699d67ca-416d-46f7-bf2f-c521e4fa28ff",{"id":"047e62c3-8d64-4384-80bc-4e1e5278864e"

I'm not sure where to force something like the jsonobjectattribute and I haven't changed any of the power automate steps. I'm not very familiar with json at all any help would be appreciated.