topic Connect to API via Power Query troubleshot in Developer

Connect to API via Power Query troubleshot

APIRT — Fri, 23 Aug 2024 09:27:53 GMT

Hello guys,

I'm having a little troble connecting to the Hevy app API via Power Query.

I've read the documentation they provide and watched other peoples videos and examples but so far I haven't had any luck.

I also have available the curl in the below link:

Here the documentation: https://api.hevyapp.com/docs/ I would like to use the table "/v1/workouts/events"

Thank you very much!

PS: More info just in case (I should be able to connect using only the information below:)

Curl

curl -X 'GET' \
'https://api.hevyapp.com/v1/workouts/events?page=1&pageSize=5&since=1970-01-01T00%3A00%3A00Z' \
-H 'accept: application/json' \
-H 'api-key: 226b4150-f29f-4a5a-9438-ab91cc39e080'

Request URL

https://api.hevyapp.com/v1/workouts/events?page=1&pageSize=5&since=1970-01-01T00%3A00%3A00Z

Re: Connect to API via Power Query troubleshot

APIRT — Thu, 22 Aug 2024 20:26:11 GMT

Re: Connect to API via Power Query troubleshot

lbendlin — Thu, 22 Aug 2024 20:54:27 GMT

Use Anonymous auth.

let Source = Json.Document(Web.Contents("https://api.hevyapp.com", [RelativePath="v1/workouts",Query=[page="1",pageSize="5"],Headers=[accept="application/json", #"api-key"="do not share on the interwebs"]])), #"Converted to Table" = Table.FromList(Source[workouts], Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "title", "description", "start_time", "end_time", "updated_at", "created_at", "exercises"}), #"Expanded exercises" = Table.ExpandListColumn(#"Expanded Column1", "exercises"), #"Expanded exercises1" = Table.ExpandRecordColumn(#"Expanded exercises", "exercises", {"index", "title", "notes", "exercise_template_id", "superset_id", "sets"}, {"index", "title.1", "notes", "exercise_template_id", "superset_id", "sets"}), #"Expanded sets" = Table.ExpandListColumn(#"Expanded exercises1", "sets"), #"Expanded sets1" = Table.ExpandRecordColumn(#"Expanded sets", "sets", {"index", "set_type", "weight_kg", "reps", "distance_meters", "duration_seconds", "rpe"}, {"index.1", "set_type", "weight_kg", "reps", "distance_meters", "duration_seconds", "rpe"}) in #"Expanded sets1"

Please do not share your API key on the interwebs!

Re: Connect to API via Power Query troubleshot

APIRT — Fri, 23 Aug 2024 09:22:53 GMT

Thanks for the response but it's not working. THe data is associated to a user and an account.

That's why the API

Re: Connect to API via Power Query troubleshot

APIRT — Fri, 23 Aug 2024 09:29:24 GMT

Updated the post with all the information.

Re: Connect to API via Power Query troubleshot

lbendlin — Fri, 23 Aug 2024 11:45:52 GMT

It's working for me, I can see the data. What is your error message?

Re: Connect to API via Power Query troubleshot

Anonymous — Tue, 27 Aug 2024 07:51:16 GMT

Hi @APIRT ,

Here I agree with lbendlin, I can connect to the REST API with his code.
According to your request url, you just need to add a since parameter in Query.

let Source = Json.Document(Web.Contents("https://api.hevyapp.com", [RelativePath="v1/workouts",Query=[page="1",pageSize="5",since="1970-01-01T00:00:00Z"],Headers=[accept="application/json", #"api-key"="..."]])), #"Converted to Table" = Table.FromList(Source[workouts], Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "title", "description", "start_time", "end_time", "updated_at", "created_at", "exercises"}), #"Expanded exercises" = Table.ExpandListColumn(#"Expanded Column1", "exercises"), #"Expanded exercises1" = Table.ExpandRecordColumn(#"Expanded exercises", "exercises", {"index", "title", "notes", "exercise_template_id", "superset_id", "sets"}, {"index", "title.1", "notes", "exercise_template_id", "superset_id", "sets"}), #"Expanded sets" = Table.ExpandListColumn(#"Expanded exercises1", "sets"), #"Expanded sets1" = Table.ExpandRecordColumn(#"Expanded sets", "sets", {"index", "set_type", "weight_kg", "reps", "distance_meters", "duration_seconds", "rpe"}, {"index.1", "set_type", "weight_kg", "reps", "distance_meters", "duration_seconds", "rpe"}) in #"Expanded sets1"

It works well in my test as well.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.