ARTIFACTORY: How to Extract and Save Information in Excel

Introduction 

It is possible to extract specific information from JFrog using any of the available REST APIs and save it in Excel or CSV format. While there’s no built-in feature to export data directly, the JSON output from REST APIs can be easily transformed into a format compatible with Excel.

General Approach:

1. Use the relevant REST API to fetch the information you need.
   
2. Once you have the JSON output, tools like jq can extract specific fields and export them to CSV, which can then be opened in Excel.

Example:

1. Fetch repository details using the Get Repository Configuration REST API :
   

   curl -u username:password" https://<ARTIFACTORY_URL>/artifactory/api/repositories/{repoKey}" > repo.json

   
   
2. Extract specific fields and save as CSV:
   

   jq -r '[.key, .packageType,description] | @csv' repo.json > repo.csv

   
   Note: You may adjust the jq command to extract any JSON fields relevant to your use case.