Skip to content

Update github_organization table to use GraphQL API #258

Closed

Description

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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions