Connect to API via Power Query troubleshot

[APIRT]

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

[lbendlin · Accepted solution]

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!

[lbendlin · Accepted solution]

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!

[APIRT]

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

That's why the API

[Anonymous · Accepted solution]

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.

[lbendlin]

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

[APIRT]

up

[APIRT]

Updated the post with all the information.