1. Exporting Tool Directory to Excel
Data AnalystBackground
The team maintains a list of software tools in a remote database accessed via a REST API.
Problem
Manually copying JSON data into Excel is error-prone and slow.
How to use
Set the API URL, define the data path as 'tools', and use the field mapping to select specific attributes like ID, name, and category.
{"id":"id","name":"name","category":"category","result_type":"resultType"}Outcome
A clean Excel file containing all tool records, ready for team review.