Yext REST API Not Returning Data Table

[kellyyaker]

I am attempting to make a connection to Yext's REST API and the results in Power Query are nothing like what should be populating in the table. Below is my process for setting up the connection in PBI (for reference: here are the developer instructions on Yext https://developer.yext.com/docs/api-reference/).

I used the API  call link formatted how they suggested: 

https://api.yext.com/v2/accounts/me/locations?api_key=xxxxxxxxxxxxxxxxxxxxa&v=20201110

I tested it in Postman without errors and saw this returned as some of the data in the API:

 Once confirming the link worked, I went to "Get Data" and selected Web and used the advanced option, filling it in like so:

 I think the above may be the step where I'm missing something because the results in Power Query look like this:

I'm not a developer, just a somewhat tech adept marketing analytics manager, so I'm pretty confident I've missed a step somewhere, but I can't find any documentation on the Yext API in Power BI.

Can someone please offer some suggestions on how I can get this connection working properly? Thanks!

[artemus]

Just click the Record link in the second row, and the data should appear. You may need to further do actions like convert to table or click on more links.

Also note: The recommended way to do this is to change your source to:

= Json.Document(Web.Contents("https://api.yext.com/v2/accounts/me/locations&v=20201110", [ApiKeyName = "api_key"]))

 And then choose the API Key authentication option when you connect.