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.

Sign up for GitHub

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

Jump to bottom

Update github_organization table to use GraphQL API #258

Closed
graza-io opened this issue May 17, 2023 · 2 comments
Closed

Update github_organization table to use GraphQL API #258

graza-io opened this issue May 17, 2023 · 2 comments
Assignees
@graza-io
Labels
enhancement New feature or request

Comments

@graza-io
Copy link
Contributor

graza-io commented May 17, 2023 •
edited
Loading

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

  • announcement
  • announcement_expires_at
  • announcement_user_dismissible
  • any_pinnable_items
  • estimated_next_sponsors_payout_in_cents
  • has_sponsors_listing
  • interaction_ability
  • is_sponsoring_you
  • monthly_estimated_sponsors_income_in_cents
  • new_team_url
  • pinned_items_remaining
  • projects_url
  • saml_identity_provider
  • sponsors_listing
  • teams_url
  • total_sponsorship_amount_as_sponsor_in_cents
  • can_administer
  • can_changed_pinned_items
  • can_create_projects
  • can_create_repositories
  • can_create_teams
  • can_sponsor
  • is_a_member
  • is_following
  • is_sponsoring
  • members_with_role_total_count
  • packages_total_count
  • pending_members_total_count
  • pinnable_items_total_count
  • pinned_items_total_count
  • projects_total_count
  • projects_v2_total_count
  • repositories_total_count
  • sponsoring_total_count
  • sponsors_total_count
  • teams_total_count
  • web_commit_signoff_required

Renamed columns

  • blog => website_url
  • disk_usage => repositories_total_disk_usage
  • public_repos => public_repositories_total_count
  • total_private_repos => private_repositories_total_count

Removed columns

  • company
  • html_url - replaced by url
  • events_url - rest api endpoint
  • hooks_url - rest api endpoint
  • issues_url - rest api endpoint
  • members - moved to github_organization_member table
  • member_logins
  • members_url - rest api endpoint
  • owned_private_repos
  • private_gists
  • public_gists
  • public_members_url - rest api endpoint
  • repos_url - rest api endpoint

Columns with data changes

  • url now contains what was formerly in html_url (web url) instead of previous REST API endpoint.
@graza-io graza-io added the enhancement New feature or request label May 17, 2023
@graza-io graza-io self-assigned this May 17, 2023
@graza-io
Copy link
Contributor Author

af6bab8 on graphql-dev branch

@cbruno10
Copy link
Contributor

cbruno10 commented Jun 16, 2023 •
edited
Loading

Completed in 42680ef

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@graza-io graza-io

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@cbruno10 @graza-io