Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update github_team_member table to use GraphQL API #243

Closed
graza-io opened this issue May 4, 2023 · 3 comments
Closed

Update github_team_member table to use GraphQL API #243

graza-io opened this issue May 4, 2023 · 3 comments
Assignees
Labels
enhancement New feature or request

Comments

@graza-io
Copy link
Contributor

graza-io commented May 4, 2023

Is your feature request related to a problem? Please describe.
I'd like to use the GraphQL API when querying the table

Describe the solution you'd like
Update the table to use the GraphQL API

Describe alternatives you've considered
N/A

Additional context

For any fields that have paging, consider implementing that field as another table to avoid excess API calls (as per https://steampipe.io/docs/develop/plugin-release-checklist#data-ingestion).

New columns

  • email
  • created_at
  • updated_at
  • any_pinnable_items
  • bio
  • company
  • estimated_next_sponsors_payout_in_cents
  • has_sponsors_listing
  • interaction_ability
  • is_bounty_hunter
  • is_campus_expert
  • is_developer_program_member
  • is_employee
  • is_following_you
  • is_github_star
  • is_hireable
  • is_site_admin
  • is_sponsoring_you
  • is_you
  • location
  • monthly_estimated_sponsors_income_in_cents
  • pinned_items_remaining
  • projects_url
  • pronouns
  • sponsors_listing
  • status
  • twitter_username
  • can_changed_pinned_items
  • can_create_projects
  • can_follow
  • can_sponsor
  • is_following
  • is_sponsoring
  • website_url

Removed columns

  • gravatar_id doesn't appear to be available.
  • type doesn't appear to be available (albeit, this is probably User).
  • state doesn't appear to be available.
  • html_url would just be a duplicate of url.
  • The following columns were all returning REST API endpoints which aren't available on the GraphQL API
    • events_url -> https://api.github.com/users/graza-io/events{/privacy}
    • followers_url -> https://api.github.com/users/graza-io/followers
    • following_url -> https://api.github.com/users/graza-io/following{/other_user}
    • gists_url -> https://api.github.com/users/graza-io/gists{/gist_id}
    • organizations_url -> https://api.github.com/users/graza-io/orgs
    • received_events_url -> https://api.github.com/users/graza-io/received_events
    • repos_url -> https://api.github.com/users/graza-io/repos
    • starred_url -> https://api.github.com/users/graza-io/starred{/owner}{/repo}
    • subscriptions_url -> https://api.github.com/users/graza-io/subscriptions

Columns with data changes (please include examples of old and new data for each entry)

  • url - now has contents previously in html (the web ui link for the user).
@graza-io graza-io added the enhancement New feature or request label May 4, 2023
@graza-io graza-io self-assigned this May 4, 2023
@graza-io
Copy link
Contributor Author

graza-io commented May 4, 2023

@cbruno10 - I've committed to the associated branch some code with the optional new columns commented out due to adding a few seconds of performance hit, would it be possible for you to test with/without the additional columns and give your thoughts on if they should be included? (If so will update docs to include examples of them).

Thanks!

@graza-io graza-io linked a pull request May 4, 2023 that will close this issue
@graza-io graza-io removed a link to a pull request May 12, 2023
@graza-io
Copy link
Contributor Author

Commit: f304225 on graphql-dev branch.

@cbruno10
Copy link
Contributor

cbruno10 commented Jun 16, 2023

Completed in 42680ef

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants