Using the Dynatrace usersession API to pull user session data

[AMC3112]

Hi All,

I'm attempting to pull user session information from Dynatrace into Qlik Sense Cloud using the REST data gateway and Dynatract Usersession API however, I'm not able to get the data and it seems its due to the JSON format.  Has anyone successfully pulled user session data out of Dynatrace with this API that could provide some guidance?  Below is additional explanation.

1. I've setup my Dynatrace API Token and successfully connected and pulled data back using Postman so there is no issue with the token or api connection

2. I've used the URL from Postman to setup the Rest Data gateway connector and applied my token there and have successfully connected.

3. When selecting data using the connector and inserting the auto-generated script it automatically is showing errors.  screenshot below.

4. I then removed all the other tables and only tried the main SQL select which also failed.  screenshot below.

5. However, if I comment out the value sections of the SQL load it will successfully load the column names from Dynatrace so it seems that the overall API and connection are working. screenshot below

6. When I try to get the values is where I run into errors. 

Does anyone have experience with scripting for this specific Dynatrace API? I've used other Dynatrace APIs successfully in Qlik like the Entity API or Metrics API, however, those seem to have different JSON structure.  Any guidance on how to get this working is appreciated.  Thanks!