topic Re: Connect GitHub using API error in Developer

Connect GitHub using API error

Anonymous — Thu, 09 Dec 2021 16:20:32 GMT

Hi!

Need to connect GitHub to Power BI using the API. As Power BI connector doesn't give a lot of information, specifically pull requests reviewers. And I'm wondering if it's or Power BI, or I have not enough rights, or something else?

I'm receiving error:

Web.Contents failed to get contents from 'https://api.github.com/repos/owner/repo/pulls?state=all' (404): Not Found

My source code:

let
Source = Web.Contents("https://api.github.com/repos/owner/repo/pulls?state=all", [ApiKeyName="xxxxxxxx"])
in
Source

Many thanks in advance!

Re: Connect GitHub using API error

lbendlin — Fri, 10 Dec 2021 22:53:46 GMT

This seems to work. Did you specify the owner and repo names?

let Source = Json.Document(Web.Contents("https://api.github.com/repos/migueesc123/PowerBIRESTAPI/pulls?state=all")), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"url", "id", "node_id", "html_url", "diff_url", "patch_url", "issue_url", "number", "state", "locked", "title", "user", "body", "created_at", "updated_at", "closed_at", "merged_at", "merge_commit_sha", "assignee", "assignees", "requested_reviewers", "requested_teams", "labels", "milestone", "draft", "commits_url", "review_comments_url", "review_comment_url", "comments_url", "statuses_url", "head", "base", "_links", "author_association", "auto_merge", "active_lock_reason"}, {"url", "id", "node_id", "html_url", "diff_url", "patch_url", "issue_url", "number", "state", "locked", "title", "user", "body", "created_at", "updated_at", "closed_at", "merged_at", "merge_commit_sha", "assignee", "assignees", "requested_reviewers", "requested_teams", "labels", "milestone", "draft", "commits_url", "review_comments_url", "review_comment_url", "comments_url", "statuses_url", "head", "base", "_links", "author_association", "auto_merge", "active_lock_reason"}) in #"Expanded Column1"

Re: Connect GitHub using API error

Anonymous — Mon, 13 Dec 2021 11:02:01 GMT

Yes, of course, I specified owner and repo.

Can it be caused because of the fact that my owner is organization and repository is private? Maybe there are some other attributes needed to connect to such type of repository?

Re: Connect GitHub using API error

lbendlin — Mon, 13 Dec 2021 13:49:16 GMT

Could be. Most likely anonymous auth wouldn't work in that case. Delete your global permissions and try a different auth method.

Re: Connect GitHub using API error

Anonymous — Mon, 13 Dec 2021 13:54:56 GMT

I was using Web API key method, and as you can see I'm specifying API Key in connection string.

Re: Connect GitHub using API error

lbendlin — Mon, 13 Dec 2021 14:20:39 GMT

Did you go through all these steps?

Basics of authentication - GitHub Docs