Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo
Created October 26, 2021 20:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patrickdevivo/8e6c400f8595042a5f5232b8456cb6af to your computer and use it in GitHub Desktop.
Save patrickdevivo/8e6c400f8595042a5f5232b8456cb6af to your computer and use it in GitHub Desktop.
SELECT
repo.name,
github_repo_file_content('Microsoft', repo.name, 'package.json') package
FROM github_org_repos('Microsoft') repo
WHERE package IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment